FV Function

The Excel FV function is a financial function that returns the future value of an investment. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate.

April 14, 2025 · 1 min · 28 words · Deborah Johnson

Units forrateandnpermust be consistent.

The RATE function calculates by iteration.

FVSCHEDULE can be used to find the future value of an investment with a variable or adjustable rate.

Excel formula: Payment for annuity

Excel formula: Present value of annuity

Excel formula: Calculate compound interest

Excel formula: Compare effect of compounding periods

Excel formula: Simple investing worksheet

Excel formula: Future value of annuity

Excel formula: Future value vs. Present value

Excel formula: Calculate periods for annuity

Excel formula: Bond valuation example

Excel formula: Estimate mortgage payment

Excel formula: Annual compound interest schedule

Excel PV function

Excel RATE function

Excel NPER function

Excel PMT function

Excel PPMT function

Excel IPMT function

Excel CUMPRINC function

Excel CUMIPMT function

Excel FVSCHEDULE function