My Retirement Planner

Master Inputs · Forward Projection · Reverse Calculator · Multi-currency

Blank master template loadedAll Master input values start blank or zero. Auto-save turns on after the first change.
Mobile tip: Scroll left/right inside tables to see all columns. Use desktop for the best editing experience. All tabs and inputs are fully editable here.
Dashboard
All calculations now flow from the Master Inputs tab. Dashboard cards show monthly expense today, annual expense today, and total annual spend today.

Planner logic

Alerts and checks

Year-by-year review monthly first, then annual
Master Inputs
Single source of truth. Enter everything here. Forward Planner and Reverse Calculator are read-only outputs. Real estate is entered in the Asset Register; rent goes in the Income Register; maintenance and all expenses go in the Expense Register; one-time costs and inflows go in the Event Register.
Profile & Assumptions
Recommended defaults are pre-filled below (equity 50%, returns 8%/6%, inflation 6%/12%, phases 70/80). Adjust for your situation. ↺ Restore Defaults in the toolbar performs a full reset — all data cleared, defaults restored. Back up first.
Currency Assumptions FX to INR

FX today is used for current net worth. FX at retirement is used for retirement and future projections. The six standard currencies (INR, USD, AED, GBP, EUR, SGD) are always shown. Use the + Add currency button to add any other currency — JPY, CHF, CAD, AUD, or any other. Type the 3-letter currency code and enter the FX rates.

CurrencyFX Today (1 unit = ₹ how much)FX at RetirementStatus
Add a custom currency — JPY, CHF, CAD, AUD, or any other
Asset Register assets and properties separated

Financial assets are grouped together below. Real estate properties are captured in a separate property register so rent, maintenance and sale-year links are easier to follow.

Use this for investments, debt, equity, mutual funds, bank cash, emergency cash, gold, insurance maturity values, pension corpus and other non-property assets.

ReferenceAsset nameAsset typeCurrencyAmountUnitGrowth / return %Tax rate %Sale / maturity yearTreatmentNotesValue todayValue at retirementAction
Add or delete financial / non-property asset rows

Use this for real estate properties only. A property name entered here will appear in linked income, expense and event dropdowns. Sale year 0 means the property is retained and counted as net worth only.

ReferenceProperty nameAsset typeCurrencyProperty valueUnitAppreciation %Capital Gains Tax %Sale yearTreatmentNotesValue todayValue at retirementAction
Add or delete property rows
Income Register rent, salary, pension

Choose a clear income type from the dropdown. For savings or income streams, start year and end year are used directly. Rent can be linked to a property so it stops from that property’s sale year.

ReferenceIncome or saving nameIncome typeCurrencyLinked assetMonthly amountUnitStart yearEnd yearGrowth / increase %Tax rate %TreatmentNotesYearsCalculated value / impactAction
Add or delete income / savings rows
Expense Register monthly and annual expenses

Choose a clear expense type from the original planner list. Lifestyle inflation applies to lifestyle rows. Medical inflation applies only to healthcare and insurance premium rows. If an expense is linked to a property, it stops from that property’s sale year.

Use this table for monthly household and lifestyle spending.

ReferenceExpense typeOptional descriptionCurrencyMonthly amountUnitStart yearEnd yearInflation typePhase reduction applies?Linked assetUse in Reverse Calculator?NotesRetirement year costAction
Add or delete monthly expense rows

Use this table for annual travel, healthcare, insurance, repairs, subscriptions, professional fees and other yearly costs.

ReferenceExpense typeOptional descriptionCurrencyAnnual amountUnitStart yearEnd yearInflation typePhase reduction applies?Linked assetUse in Reverse Calculator?NotesRetirement year costAction
Add or delete annual expense rows
One-time Event Register costs and inflows

Use this for car purchase, home repairs, liabilities, gifts, asset sales not already captured in the Asset Register, inheritance, or other one-time events.

ReferenceEvent nameEvent typeCurrencyAmountUnitEvent yearLinked assetTreatmentNotesRetirement impactAction
Add or delete one-time event rows
Insurance Register

Premiums are treated as expenses. Maturity/surrender values can become investable corpus, cash, emergency reserve, or remain excluded. Term insurance death benefit should not be counted as retirement corpus.

ReferencePolicy namePolicy typeCurrencyAnnual premiumPremium unitPremium inflationMaturity yearMaturity valueMaturity unitTreatmentNotesPremium at retirementMaturity impactAction
Add or delete insurance rows
Forward Planner

Forward calculation explanation

Forward Projection monthly first, then annual
Monte Carlo Stress Test geopolitical & macro scenarios
Each scenario runs 2,000 simulations with randomised equity returns, inflation, and income shocks calibrated to that macro regime. Results show how your corpus behaves under each environment — from severe geopolitical crisis to a bull-market tailwind.
🎓 First time here? What is this test, what does it show, and how do you use it?   tap to expand

🎲 What is a Monte Carlo simulation?

Your Forward Planner shows one version of your retirement — the most likely path if markets behave roughly as you assumed. But the real world does not follow a straight line. Some years markets crash. Some years inflation spikes. Some years your rent income falls. A good retirement plan should survive not just the average future — but a wide range of futures.

A Monte Carlo simulation runs your retirement plan 2,000 times, each time with a different random combination of returns, inflation, and income shocks. Some runs are lucky. Some are unlucky. Some are terrible. At the end, it counts: in how many of these 2,000 futures did your money last?

Think of it like a flight simulator for your retirement. A pilot does not just plan for clear skies — they train for turbulence, storms, and engine failures. This test does the same for your finances. The goal is not to scare you — it is to show you how much buffer your plan has, and where it is thin.

📊 What do the results actually tell you?

After running the simulation you will see three key outputs. Here is how to read them:

Stress case (10th %)
₹X Cr
Your corpus in the worst 1-in-10 future. 90% of simulations ended better than this. This is your floor — how bad can it realistically get?
Most likely (median)
₹Y Cr
The middle outcome — half the simulations ended above this, half below. This is your single best-guess number for this scenario.
Good case (90th %)
₹Z Cr
Your corpus in the best 1-in-10 future. Markets cooperated, inflation stayed low. Upside, not the plan.

The survival rate (e.g. "82% survived") means: in 82 out of 100 simulated futures, your corpus lasted all the way to your planned age without running out. Higher is better. Above 85% is comfortable. Below 60% means the plan needs attention.

The "corpus hit zero" count is how many simulations ran out completely. If you see this number and feel panic — read on. It is not what it looks like.

⚠️ "Corpus hit zero" does NOT mean you will go broke

This is the number that causes heart attacks. Here is the honest context:

The simulation models a robot version of you — one that spends exactly the same amount every single year for 25–30 years, never adjusts, never sells a property, never reduces discretionary spending, never asks children for support, never does anything different even as the situation changes.

Real people are not robots. In real life, if markets are bad for 3 years running, you would notice and adapt. You would skip the international holiday. Delay the new car. Reduce dining out. These small adjustments — invisible to the simulation — have an enormous effect on corpus survival. The model cannot simulate your judgement. You can.

So treat "corpus hit zero in X% of simulations" as: "if I never adapted at all, X% of futures would have been painful." Not as a prediction.

🌍 What are the five scenarios?

🔴
Severe Geopolitical Crisis

The worst-case fire drill. Active wars, major sanctions, supply-chain collapse. Equity markets crash 30–50%, inflation surges to 13–15%, rental income is disrupted. This is not a forecast — it is a stress test of your plan's worst-case resilience.

🟠
High Geopolitical Unrest

The world as it largely is today. Trade wars, INR under pressure, regional tensions. Equity returns subdued, inflation 2–4pp above normal, rental yields soften. The most relevant scenario for current planning.

🟡
Stagflation / Recession

Growth stalls but inflation stays high — the 1970s playbook. Equities deliver poor real returns, fixed income gets eroded, costs creep up steadily. A realistic bad-decade scenario, not a catastrophe.

🟢
Base Case

Your own plan's assumptions with normal market volatility. No extra stress, no extra tailwind. Run this first — if your survival rate here is below 85%, revisit your Master Inputs before looking at stress scenarios.

💚
Bull Market / Strong Growth

Everything goes better than planned. Equity outperforms, inflation is tame, rental income grows above expectation. Your upside case. Do not plan your spending to this level.

💡
How to use all five together

Run all five scenarios one by one, then look at the comparison bar at the bottom. The gap between Crisis and Bull tells you how much your plan depends on market luck vs your own expense discipline. A plan that survives well even in Stagflation is a robust plan.

🔢 What are the four input fields?

Simulations — how many futures to simulate
2,000 is a good balance of speed and accuracy. 5,000 is more precise but takes longer. 1,000 is fine for a quick check. The survival rate becomes more reliable with more simulations.
Minimum legacy corpus — the "pass mark" for survival
This is how much you want to have left at the end of your projection. Setting it to ₹0 means "just don't run out completely." Setting it to ₹5 Cr means "end with at least ₹5 Cr — for children, charity, or a safety buffer." The survival rate counts simulations that ended at or above this number. This field auto-fills from your "Desired Final Corpus" in Master Inputs, or defaults to ₹1 Cr if blank.
Income shock probability — chance of a bad income year
The % chance that any given simulation experiences an income disruption — a tenant vacating, dividend cuts, pension delay. 15% means roughly 1 in 7 simulations has a shock. The shock hits for 1–3 years then recovers.
If shocked — income drops by (%)
How severely income falls during a shock. 30% means your rent, pension or dividends drop to 70% of planned for the shock period. After that they recover to the planned level.

✅ Step-by-step: how to actually use this tab

1

Go to Master Inputs first and make sure your assets, expenses, income streams, and retirement year are all filled in correctly. The MC uses your actual planner data — garbage in, garbage out.

2

Start with the Base Case scenario (green card). Click it, then hit Run. If your survival rate here is below 85%, your inputs or assumptions need reviewing before looking at stress scenarios.

3

Run High Unrest next (orange card) — this is closest to current real-world conditions. This result is your most actionable number.

4

Run Stagflation and Crisis to understand your downside range. If Crisis wipes out survival rate, that is fine — it is designed to be severe. What matters is whether Stagflation and Base Case look healthy.

5

Read the commentary that appears below the results. It explains in plain English what the numbers mean for your specific situation and what — if anything — you should do about it.

6

Run Bull Market last to see the upside. The difference between your Bull and Crisis median corpus is the range of outcomes your plan faces — and your job is to make sure even the bad end of that range is acceptable.

❓ Frequently asked questions

Why does the Crisis scenario show such scary numbers?
Because it is designed to. Crisis stacks -18pp equity return shift, +7pp extra inflation, and -18% income disruption — all at once, for the entire retirement period. It is the "everything goes wrong for 30 years" scenario. No financial plan survives that without adaptation. Use it as a fire drill, not a forecast.
My corpus "hit zero" in 400 out of 2,000 runs. Should I panic?
Only if you plan to never adjust your spending, never sell any asset, and never respond to any signal over 25–30 years. If you are a normal human being who will notice if your portfolio drops 40% and act accordingly — no. Check which scenario produced that number. Crisis showing 400/2000 is expected. Base Case showing 400/2000 needs attention.
What survival rate should I be aiming for?
Base Case: 90%+ is excellent, 80–90% is comfortable, below 75% needs a rethink. High Unrest: 75%+ is good. Stagflation: 65%+ is acceptable. Crisis: Even 50% is not bad — this is an extreme scenario. Bull Market: Should be 95%+; if not, something is wrong with the inputs.
Does this replace my financial advisor?
No. This is a planning tool, not advice. It helps you ask better questions and understand the range of outcomes your plan faces. A financial advisor can help you act on those insights — adjusting your asset allocation, income strategy, or expense plan. Use this to inform that conversation.
What does the dotted teal line in the chart mean?
That is your planner's own deterministic forecast — the single straight-line projection from your Forward Planner tab with no randomness. The burgundy line (median MC) shows how the median of 2,000 random futures compares to that plan. If the MC median tracks close to your plan line, the scenario is not deviating much. If it diverges sharply downward, the scenario is putting real pressure on your plan.
Select macro scenario
🔴
Critical
Severe Geopolitical Crisis
Active conflict, major sanctions, supply-chain collapse. Equity markets down 30–50%, inflation surges 10–15%, income disruption likely.
🟠
Severe
High Geopolitical Unrest
Trade wars, sanctions risk, regional tensions. Elevated volatility, equity drag of 10–20%, inflation at 8–12%, currency pressure on INR.
🟡
Moderate
Stagflation / Recession
Slowing growth with persistent inflation. Equity returns 0–5%, inflation 7–10%, real returns compressed, income uncertain.
🟢
Base Case
Normal / Base Case
Stable macro environment. Equity returns 8–12%, inflation 5–7%, income streams intact. Your plan assumptions hold.
💚
Upside
Bull Market / Strong Growth
Global expansion, low inflation, strong equity. Equity returns 14–20%, inflation 3–5%, income grows above expectation.
Inputs used — pulled live from your planner
Run a simulation to see which values were used.
Results

Corpus distribution at end of projection (₹ Cr)

Corpus trajectory — median, 25th & 75th percentile

How does your plan hold up across all 5 scenarios?
Run each scenario one by one — this table fills in as you go. Once all 5 are done, read the verdict at the bottom to understand what it all means together.
Scenario assumptions & inflation impact
ParameterCrisisHigh UnrestStagflationBase CaseBull Market
Reverse Calculator
What is this? The Forward Planner asks "I have ₹X Cr — how long will it last?" The Reverse Calculator asks the opposite: "Given what I plan to spend, how much corpus do I actually need on Day 1 of retirement?" That answer is the Recommended Corpus.
Understanding the Recommended Corpus plain English
Step 1 — Your annual gap
For each year of retirement: Total expenses − Offset income (rent, pension, dividends). This is what your corpus must fund each year.
Step 2 — Present value of all gaps
All future gaps discounted back to your retirement date at your blended post-tax return. This tells you: what lump sum today, invested at your return, funds every year's gap exactly?
Step 3 — Add legacy target
Your Desired Final Corpus (from Master Inputs) is discounted back and added. So the Recommended Corpus funds both your spending AND leaves your legacy.

Two methods — the higher one wins

Income-basis method

Year-1 gap ÷ your post-tax return. Assumes the corpus lives forever on returns alone — a conservative perpetuity estimate. Good if you want to never touch principal.

PV drawdown method

Present value of all gaps across your full projection. More precise — accounts for inflation, phase reductions, income streams ending, and your legacy target.

The Recommended Corpus is whichever of these two is higher — giving you the more conservative, safer number.

📊 How to use this number

Run the planner with your inputs to see your personalised verdict here.

Reverse calculation details

Year-by-year gap requirement

Each row shows what your corpus must cover that year — expenses after offset income. The PV column shows how much of your Day-1 corpus is allocated to that year's gap.

Sensitivity Analysis what-if scenarios
How to use: Adjust one or more levers below and click Run Analysis. The table shows how your final corpus and survival change across every combination — so you can see which lever moves the needle most.
Adjust the levers
Health Check is your plan complete?
What is this? A traffic-light check of every register. Green means the data looks complete and consistent. Amber means something is filled but may need review. Red means something important is missing or looks off.
Register-by-register checks
Action items things to fix or review