Future Value Formula Explained (With Excel Examples)

Published 15 November 2026 · Investing

Try it nowFuture Value Calculator →

Future value (FV) tells you what money invested today, plus any regular payments, will be worth later. Try it in the future value calculator.

Lump sum

FV = PV × (1 + r)n

$5,000 at 6% for 10 years: 5,000 × 1.06¹⁰ = $8,954.

Regular payments (ordinary annuity)

FV = PMT × [((1 + r)n − 1) ÷ r]

$300 a month at 0.5% per month for 120 months ≈ $49,164.

Annuity due

If payments are made at the start of each period, multiply by (1 + r). It earns slightly more because each payment has one extra period of interest.

In Excel or Google Sheets

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

Enter payments and present value as negatives (money you pay out) to get a positive FV. Type 0 = end of period, 1 = start.

Match your periods

Monthly payments need a monthly rate (annual ÷ 12) and the number of months.

Keep reading