Savings Goal vs Future Value: Working Backwards to a Monthly Deposit
Two directions
Future value starts with deposits and finds the balance. A goal calculator starts with the balance and solves for the deposit using PMT = FV x r / ((1+r)^n - 1), where r is the monthly rate and n the number of months.
Worked table
| Goal $50,000, 5% | Monthly deposit needed | Total contributed |
|---|---|---|
| 5 years | $735.23 | $44,114 |
| 10 years | $321.99 | $38,639 |
| 15 years | $187.06 | $33,671 |
| 20 years | $121.64 | $29,195 |
What it leaves out
Taxes, fees, inflation and rate changes. Over 10 years $50,000 buys less than today; see the inflation-adjusted guide. Treat the result as a planning figure. Microsoft's FV function documents the forward form of the same formula.
Common mistakes and how to avoid them
Choose the goal in today's money, then inflate it. If you want $50,000 of purchasing power in 10 years and prices rise 3% a year, the nominal target is $67,196, and the monthly deposit rises from $321.99 to $432.73. Also test a lower return: at 3% instead of 5% the required deposit becomes $357.80. Because the answer is sensitive to the rate you assume, use a conservative one for goals that matter. Review the plan once a year, and if you are behind, either raise the deposit or extend the horizon: both are shown in the table above, where longer horizons sharply reduce the monthly amount. To verify any figure on this page yourself, use the formula FV = P(1+r/n)^(nt) for a lump sum, where P is the starting amount, r the annual rate as a decimal, n the compounding periods per year and t the years. For regular deposits add the term PMT x ((1+r/n)^(nt) - 1) / (r/n). Every table here was produced by code that implements exactly these formulas and is the same code the calculator uses, so entering the stated inputs should reproduce the numbers to the dollar. If your own result differs, the usual causes are a different compounding frequency, deposits made at the start rather than the end of each month, or a rate entered as a whole number where a decimal was expected. Rounding in the middle of a calculation can also move the last digits, so keep full precision until the end and round only the figure you report.
Try it
Use the forward calculator to confirm.
Sources
Related
Educational estimate, not financial advice. Found an error? Tell us.