Future value formulas
Future value is what money becomes when interest is added to it and then earns interest itself. For a single amount:
FV = PV × (1 + r ÷ m)m × t
FV is the future value, PV the amount today, r the yearly interest rate as a decimal, m the number of times interest is compounded in a year and t the time in years. A series of equal deposits is handled by the future value of an annuity formula:
FV of deposits = D × ((1 + i)n − 1) ÷ i
D is the deposit, n the number of deposits and i the interest rate for one deposit period. This assumes each deposit is made at the end of its period. Deposits made at the start earn one extra period of interest each, so the result is multiplied by (1 + i). At a rate of 0% the deposits simply add up to D × n. The total future value is the two parts added together.
If the compounding frequency differs from the deposit frequency, the calculator converts the quoted rate to an effective annual rate, (1 + r ÷ m)m − 1, and then to the equivalent rate for one deposit period. When deposits rise each year there is no single tidy formula for mixed frequencies, so the balance is built up period by period, which is also how the yearly table is produced.
Today’s money
Value in today’s money = future amount ÷ (1 + π)t
π is the yearly inflation rate as a decimal. This is the same discounting arithmetic, with inflation in place of interest. It answers a different question from the future value: not how many dollars there will be, but what they will buy.
Worked example
Start with $5,000 and add $200 at the end of every month for 10 years, at 6% a year compounded monthly.
- Rate per month. i = 0.06 ÷ 12 = 0.005.
- Number of months. n = 12 × 10 = 120.
- Growth factor. 1.005120 = 1.819397.
- Starting amount. $5,000 × 1.819397 = $9,096.98.
- Deposits. (1.819397 − 1) ÷ 0.005 = 163.879347, and $200 × 163.879347 = $32,775.87.
- Future value. $9,096.98 + $32,775.87 = $41,872.85.
- Contributions against growth. Deposits total 120 × $200 = $24,000. With the $5,000 start, $29,000 was paid in, so interest supplied $12,872.85.
- In today’s money at 2.5% inflation. 1.02510 = 1.280085, and $41,872.85 ÷ 1.280085 = $32,711.01.
Three variations show what each setting does. Depositing at the start of each month gives $42,036.73. Compounding yearly instead of monthly gives $41,448.93. Raising the deposit by 3% each year, so that it reaches $260.95 in the final year, lifts total deposits to $27,513.31 and the future value to $46,128.06.
The reverse question
What will $100,000 received in 20 years buy, if prices rise 3% a year? 1.0320 = 1.806111, and $100,000 ÷ 1.806111 = $55,367.58 in today’s money. Read the other way, it would take $100,000 × 1.806111 = $180,611.12 in 20 years to match what $100,000 buys now. The answer is sensitive to the assumption: at 2% the $100,000 is worth $67,297.13 today, and at 4% only $45,638.69.
How to read the yearly table
In the early years most of each year’s increase comes from deposits. Interest takes over later, because it is earned on a balance that keeps getting larger. In the example, interest in the first year is $375.50 against $2,400 deposited; by the tenth year it is $2,356.38, almost as much as the deposits. The final column restates each balance in today’s buying power, and it can rise much more slowly than the balance itself.
Common mistakes and limits
Confusing the two rates. A rate “compounded monthly” is a nominal rate; the effective yearly growth is higher. 6% compounded monthly is an effective 6.168%. Counting inflation twice. If the interest rate you enter is already a real, after-inflation rate, set inflation to zero. Treating the projection as a promise. The method assumes one constant rate for the whole period, deposits that are never missed, and no tax, fees or withdrawals. Real returns vary from year to year. Part periods. When the time is not a whole number of deposit periods, deposits stop after the last whole period and the remainder earns interest only.