Final answer:
The correct FV functions to calculate future value are FV(rate, nper, pmt, pv, type), FV(rate, nper, pmt, pv), and FV(rate, nper, pmt), with the most comprehensive being the first one that includes the 'type' argument.
Step-by-step explanation:
The FV function in spreadsheets is used to calculate the future value of an investment based on a series of constant payments and a constant interest rate. The correct FV spreadsheet functions to display the future worth values from the options provided are:
- FV(rate, nper, pmt, pv, type)
- FV(rate, nper, pmt, pv)
- FV(rate, nper, pmt)
The function FV(rate, nper, pmt, pv, type) is the most comprehensive as it allows you to specify all the variables associated with the investment including the interest rate (rate), the number of periods (nper), the periodic payment (pmt), the present value (pv), and when the payments are made with the type argument (0 for end of the period or 1 for beginning).
The function FV(rate, nper, pmt, pv) assumes payments are made at the end of the period as it omits the type argument.
The FV(rate, nper, pmt) function assumes both payments at the end of periods and that the present value is zero.
The FV(rate, nper) function is incorrect as it does not include the payment argument which is required for calculating future value in this context.