ƒx

Excel FV Formula

finance Difficulty:

One-Click Copy

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

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Calculates the future value of an investment based on a constant interest rate and periodic payments.

Determine how much an investment will be worth in the future.

Calculate Investment Growth

Determine how much an investment will be worth in the future.

Inputs

rate Interest rate per period (e.g., 5%/12 for monthly).
nper Total number of payment periods.
pmt Payment made each period.

Practical Example

=FV(5%/12, 60, -100, 0)

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.