FV
Returns the future value of an investment.
FinancialFinance & Accounting
What it does
Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.
Syntax
FV(rate, nper, pmt, [pv], [type])
Arguments
rate(number) — Interest rate per period.nper(number) — Total number of periods.pmt(number) — Payment per period.
Examples
Savings Growth
FV of saving $100/mo for 1 year at 5% annual.
FORMULA
=FV(0.05/12, 12, -100, 0, 0)
RESULT
1227.89
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 1227.89 |