One equation, four unknowns
An investment with regular contributions is described by a single equation. The end balance is the starting amount grown at the rate of return, plus every contribution grown for the time it has been invested.
FV = P × (1 + i)n + C × ((1 + i)n − 1) ÷ i
FV is the end balance, P is the starting amount, C is the contribution made at the end of each period, n is the number of contribution periods and i is the rate of return for one period. This calculator treats the rate you enter as the growth over a whole year, so the period rate is found by taking a root, not by dividing:
i = (1 + r)1 ÷ p − 1 and n = p × t
Here r is the yearly rate of return as a decimal, p is the number of contributions a year and t is the time in years. If contributions are made at the start of each period, each one is invested for one period longer and the contribution term is multiplied by (1 + i). When the rate is 0%, the balance is simply P + C × n.
The same equation answers the other three questions once it is rearranged:
Contribution: C = (FV − P × (1 + i)n) × i ÷ ((1 + i)n − 1)
Time: n = ln((FV + C ÷ i) ÷ (P + C ÷ i)) ÷ ln(1 + i)
ln is the natural logarithm. The rate of return is the exception. It appears both inside a power and as a divisor, and no rearrangement isolates it, so the calculator finds it numerically: it tries a rate, checks whether the end balance is above or below the target, and halves the search range until the two agree.
Worked example: $10,000 plus $500 a month at 7% for 20 years
- Monthly rate. 1.071 ÷ 12 − 1 = 0.0056541454, a little under 0.57% a month.
- Number of periods. 12 × 20 = 240 months.
- Growth factor. 240 months at the monthly rate is the same as 20 years at 7%: 1.0720 = 3.86968446.
- Starting amount. $10,000 × 3.86968446 = $38,696.84.
- Contributions. (3.86968446 − 1) ÷ 0.0056541454 = 507.53638, and $500 × 507.53638 = $253,768.19.
- End balance. $38,696.84 + $253,768.19 = $292,465.03. You paid in $10,000 + 240 × $500 = $130,000, so growth supplied the other $162,465.03.
The factors are shown to more places than usual on purpose. Over 240 periods, rounding the monthly rate to four or five figures is enough to move the answer by a few dollars.
Now turn the question around with a target of $500,000 and everything else unchanged. The contribution needed is ($500,000 − $38,696.84) ÷ 507.53638 = $908.91 a month. Keeping $500 a month for 20 years, the return needed is 11.24% a year. Keeping $500 a month and 7%, the time formula gives 317.14 months, so the target is passed with the 318th contribution, after 26 years and 6 months, when the balance is $502,859.47.
How to read the result
Use the solved rate as a reality check
Solving for the rate of return tells you what the plan demands, not what an investment will deliver. If the answer is far above the long-run return you could reasonably expect, the target needs more time or larger contributions. That is the most useful thing this mode can tell you.
Small changes in the rate are large changes in the result
Enter the return after fees. In the example, 6% instead of 7% gives $258,790.67, which is $33,674.36 less from a single percentage point. Growth also arrives late: the same plan is worth $105,197.38 after 10 years, so the second decade adds $187,267.65, far more than the first.
Check which kind of rate you have
A rate quoted as “7% compounded monthly” is not the same as 7% a year. It is an effective rate of 7.229% a year, and would turn the example into $300,850.72. Convert a quoted nominal rate to its effective annual rate before entering it here.
Allow for inflation
The end balance is in future dollars. To see it in today’s buying power, enter a real rate of return in place of the nominal one: (1 + return) ÷ (1 + inflation) − 1. A 7% return with 2.5% inflation is a real return of 4.39%, not 4.5%.
Limits of the method
The formula assumes the same return in every period. Real returns vary from year to year and can be negative, and the order in which good and bad years arrive changes the outcome when you are contributing along the way. Tax on earnings is not modelled. Treat the result as an illustration of how the four quantities trade off against each other, not as a forecast.