FV function in Google Sheets
Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
=FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])FV syntax and parameters
Five arguments, three required.
- ratenumberRequired
The interest rate.
- number_of_periodsnumberRequired
The number of payments to be made.
- payment_amountnumberRequired
The amount per period to be paid.
- present_valuenumberOptional
[ OPTIONAL - 0 by default ] - The current value of the annuity.
- end_or_beginningnumberOptional
[ OPTIONAL - 0 by default ] - Whether payments are due at the end (0) or beginning (1) of each period.
FV examples
Formulas you'll actually reuse.
What $200 a month grows to over 10 years at 5%:
=FV(5%/12, 120, -200)Result
31056.46A single $10,000 deposit after 10 years at 4%, no further payments:
=FV(4%, 10, 0, -10000)Result
14802.44
FV in Excel
Same name — your formula ports as-is.
Try FV in the playground
Edit the example — nothing to install.
Preloaded with the FV formula from Example 1 — change anything and watch it respond.
Related functions
More ways Google Sheets gets this done.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel