Function reference

FV in Excel & Google Sheets

FV is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 intermediateBuild a custom FV formula →

When to use FV

Model retirement savings, compound interest on a deposit, or the future balance of a recurring investment plan.

Worked examples (1)

Financialintermediate

Calculate future value of savings with FV

=FV(B1/12,B2*12,-B3)

Open formula FV reference

Common errors with FV

FV returns a negative number

FV returns a negative result when payments are positive. Negate your payment input (-B3) or wrap the result in ABS() to get a positive future balance.

Rate and periods are mismatched

Use the same time unit for rate and nper. Monthly contributions need a monthly rate (annual/12) and total months (years×12).

Frequently asked questions

How do I model a lump-sum investment with no ongoing contributions?

Set pmt to 0 and use the pv argument — =FV(rate, nper, 0, -lump_sum) — to grow a one-time deposit at compound interest.

Need a custom variation?

Describe your specific FV problem and get a formula written for your exact data.

Open generator with FV