FV ​

Calculates the future value of an investment based on constant payments and a constant interest rate.

FV(rate, nper, pmt, pv, type)

FV(rate, nper, pmt, pv, type)

Parameters ​

• rate - The interest rate per period.
• nper - The total number of payments.
• pmt - The payment made each period; payments are assumed to be made at the end of each period.
• pv - The present value, or the total amount that a series of future payments is worth now. If not provided, it is assumed to be 0. (optional)
• type - When payments are due: 0 for end of period, or 1 for beginning of period. If not provided, it is assumed to be 0. (optional)

Examples ​

FV(0.05 / 12, 120, -100, 1000)

FV(0.05 / 12, 120, -100, 1000)

Result: 13881.22

Note: Calculates the future value of an investment with an initial deposit of $100, and a series of monthly payments of $1,000, for a total of 10 years (120 months), with a 5% annual interest rate compounded monthly.