Future value calculator
This future value calculator shows what a starting amount plus regular contributions grows to at a given interest rate – or, the other way round, the present value: what a future sum is worth today. $10,000 plus $100 a month at 4% grows to 29,633.31 after 10 years.
Source: Microsoft Support – FV function (future value): equation with present value, payment and type 0/1. Updated: .
How it is calculated
Future value: the formula
Future value = starting amount × (1 + i)n + payment × ((1 + i)n − 1) ÷ i. Here i is the interest rate per period (annual rate ÷ periods per year) and n is the number of periods (years × periods per year). The first term is the starting amount compounded, the second is the future value of the regular payments.
- 10,000 at 4% for 10 years, compounded yearly: 14,802.44
- 5,000 at 5% for 20 years: 13,266.49
- 10,000 plus 100 a month at 4%, 10 years: 29,633.31 (of which 22,000 is your own money)
Present value: what a future sum is worth today
Present value = future amount ÷ (1 + i)n. This is called discounting: 10,000 in 10 years is worth 6,755.64 today at 4%, but only 6,139.13 at 5%. The higher the rate and the longer the term, the smaller the present value. Regular payments are discounted with the annuity factor (1 − (1 + i)−n) ÷ i: 100 a year for 10 years at 4% has a present value of 811.09.
Payment at the start or end of the period
Payments at the start of a period earn interest for one period longer – the annuity factor is multiplied by (1 + i). This matches the “type” argument of the Excel functions FV and PV.
What is it used for?
Future and present value make payments at different times comparable – for savings plans, settlements, pensions or investment decisions. For taxes, inflation and costs, look at your own case separately: this calculator is deliberately kept to the pure math.
Honest limits
The calculator assumes a constant interest rate and ignores taxes, fees and inflation. The result is a model calculation, not a forecast or investment advice.
Frequently asked questions
How do you calculate future value?
Starting amount × (1 + i)^n, plus for regular payments payment × ((1 + i)^n − 1) ÷ i. 10,000 at 4% for 10 years is 14,802.44.
What is the difference between future value and present value?
Future value says what an amount will be worth later; present value says what a future amount is worth today. The interest rate connects the two.
How do I calculate present value?
Divide the future amount by (1 + i)^n: 10,000 in 10 years at 4% gives 6,755.64.
Which interest rate should I use for present value?
The return you could earn on an alternative, or a rate that reflects the risk of the payment. There is no official figure, so it pays to compare several rates.
How do I calculate future value in Excel?
With the function FV(rate, nper, pmt, pv, type), for example =FV(4%/12, 120, −100, −10000). The result matches this calculator.
Sources and legal basis
- Microsoft Support – FV function (future value): equation with present value, payment and type 0/1
- Wikipedia – Time value of money (present value, future value, annuity formulas)
As of:
Related tools
- Compound interest calculatorCompound interest calculator with monthly contributions, yearly increases and annual, quarterly or monthly compounding – plus a year-by-year growth table.
- Savings goal calculatorSavings goal calculator: find out how much to save each month to reach your target, or how long it takes at your monthly amount – with interest.
- Inflation calculator – value of a dollar over timeInflation calculator using official annual CPI data from the BLS since 1913: what a dollar amount is worth in another year, plus total and average inflation.
- APR calculatorWork out the APR of a loan from the interest rate, term and fees: US APR (Regulation Z) and UK/EU APR side by side, with monthly payment and total cost.
- CAGR Calculator – Average Annual ReturnCAGR calculator: average annual return from a beginning and ending value, or from yearly returns – geometric, not arithmetic, with a year-by-year table.
- Loan calculatorLoan calculator for monthly payment, total interest and payoff time on personal, car or home loans – with extra payments and an amortization schedule.