There is no shortage of retirement calculators. There is a shortage of ones that show their working. This page is the working: four inputs, three formulas, one check, and arithmetic you can reproduce on paper.
Key takeaways
- Four inputs: years to retirement, current spending, inflation, withdrawal rate.
- Expenses at retirement = today's annual spend x (1 + inflation)^years.
- Corpus = expenses at retirement / withdrawal rate.
- Projected corpus minus target is the gap worth acting on.
The four inputs
The inputs, in the order they matter
Every other number on this page is derived. Change one input and you can predict which way the answer moves before re-running anything.
Formula 1: expenses at retirement
E_ret = E_now x (1 + inflation) ^ years
With ₹50,000 a month, 20 years and 6%: annual spend today is ₹6,00,000, and 1.06^20 = 3.207, so:
Formula 2: corpus from a withdrawal rate
Corpus = E_ret / withdrawal rate At 4%: ₹19,24,281 / 0.04 = ₹4.81 crore
The same relation as a multiple: at 4% you need 25 times the first-year expense; at 3.5%, 28.6 times; at 5%, 20 times.
Formula 3: what you will actually accumulate
F = P x (1 + r)^n + SIP x [((1 + r/12)^m - 1) / (r/12)] x (1 + r/12) P = corpus today SIP = monthly contribution r = assumed annual return n = years, m = months
The first term is what existing money grows to; the second is what the monthly contributions build. The trailing (1 + r/12) exists because a contribution made at the start of the month earns for that whole month.
Inputs: ₹10,00,000 today, ₹25,000 a month, 20 years, 9% assumed return.
- Existing corpus: ₹10,00,000 x 1.09^20 = ₹56,04,411
- Contributions: ₹25,000 x 240 months at 0.75% a month = ₹1,68,22,401
- Projected corpus: ₹2.24 crore
- Target from Formula 2: ₹4.81 crore
- Gap: ₹2.57 crore
The gap is not a verdict. It is the size of the decision in front of you.
Projected corpus, year by year (₹10,00,000 today + ₹25,000 a month at 9%)
Year 0: ₹10 lakh, Year 4: ₹28.6 lakh, Year 8: ₹55.15 lakh, Year 12: ₹93.04 lakh, … Year 20: ₹224.27 lakh
Target versus projected (₹4.81 crore needed)
Target corpus: ₹4.81 crore - at a 4% withdrawal rate; Projected corpus: ₹2.24 crore - at a 9% assumed return; Gap: ₹2.57 crore is not yet funded
The check that catches bad plans
Running the corpus backwards gives you a target. Running it forwards tells you whether the target survives:
Forward check (what the engine does)
Doing that once in a spreadsheet is possible. Doing it for four scenarios - retire at 58, spend 10% less, save 5% more, assume lower returns - is where a spreadsheet starts to lie to you, and where the projection engine earns its place.
Common arithmetic mistakes
- Using today's expenses as tomorrow's retirement expenses.
- Forgetting that inflation continues after retirement.
- Mixing monthly and annual figures in the same formula.
- Assuming one return for both accumulation and retirement.
- Ignoring tax on withdrawal and on gains.
These illustrate a method; they are not forecasts of your future. The return you assume is the biggest lever and the one nobody can know. If a plan only works at 12%, the plan is the assumption.
Run this with your own inputs
Questions readers ask
Should I use 9% or something else?
Use a number you would defend if returns disappointed for a decade, then re-run two points lower and see whether the plan still works.
Why 240 months and not 20 annual contributions?
Contributions arrive monthly and earn for part of the year. Annual compounding on monthly deposits overstates the result.
Can I do this in Excel?
Yes - and you should, once, to see the formula behave. A tool earns its place by running five scenarios without rebuilding the sheet.
Turn this into your own numbers
LifePlanner projects your retirement month by month, funds each goal beside it, and writes the result into a report. Free to start.