All functions / Financial

FV

The future value of an investment with regular payments.

Syntax

=FV(rate, nper, pmt, [pv], [type])

Arguments

• rate: Interest rate per period, e.g. 5%/12 for monthly payments at 5% a year.
• nper: Total number of payments.
• pmt: The payment each period (negative for money you pay in).
• pv (optional): Starting amount (default 0).
• type (optional): 0 (default) = payments at the end of each period, 1 = at the start.

Example

=FV(5%/12, 120, -200) → 31,056.46 after 10 years

Practise it

• Loan payments and savings growth
• Payoff time, true rates and savings targets