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
$5,000 at 6% for 10 years: 5,000 × 1.06¹⁰ = $8,954.
Regular payments (ordinary annuity)
$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
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
Ohio is unusual: hundreds of cities and villages charge their own income tax. Here is how it works.
16 Nov 2026New Jersey has eight tax brackets and several small payroll insurance deductions. Here is the full picture.
16 Nov 2026Almost every Pennsylvania worker pays a local tax as well as the 3.07% state tax. Here is how it works.
16 Nov 2026