Returns the future value (FV) of an initial investment, based on a constant interest rate and payment amount for the number of periods in months.
FV ( payment ; interestRate ; periods )
payment
- payment to be made per period
interestRate
- interest rate per period
periods
- number of periods
number
6.0 or earlier
Use this function to calculate FV. For example, you can calculate how much you’ll earn on an investment in which you pay $50 a month for 60 months at a 6 percent annual interest rate.
•When interestRate
is 0, this function returns the result of payment * periods
.
•The FV function doesn’t account for the present value of your investment, and it assumes that payment is made at the end of each period.
FV(50;.11/12;5 * 12)
returns 3975.90398429....
FV(2000;.12;30) + 5000 * (.12 + 1) ^ 30
returns 632464.97928640....
FV(500;.11/5;60)
returns 61141.65130790....