The Sharma family, start to finish
First meet the family and what they want. Then see, section by section, how the plan solves it. Everything here is illustrative and the figures are hypothetical.
From ₹1.68 Cr today to ₹13.4 Cr at financial freedom
Net worth across Mr. Sharma’s life, from today at 32 to age 93, with every goal the plan funds marked along the way. Run the line, or tap it, to read any year. The case below shows how.
Meet the Sharma family
A young family of four, early in their journey, with a long road ahead and a clear wish: to plan it properly, together, from the start.
Where the money comes from, and where it goes
Two incomes support the household. After everyday living, the loan EMIs and the insurance premiums, what is left over is what builds the family’s future.
Money in ₹2.30 L / mo
Money out ₹1.52 L / mo
The family’s portfolio today
Beyond the home they live in, the family has built an invested portfolio of about ₹68 L, spread across four kinds of assets.
A home loan and a car loan
The family carries about ₹32 L of debt today. Clearing it, and sooner rather than later, is one of the things they want the plan to take on.
The family’s financial goals
Their goals run through both chapters of life: 8 to reach while they are earning, and 5 more that live inside retirement itself. Some are one-time, some recur year after year.
Financial Freedom: two chapters
The plan spans two long chapters, each with its own shape: the earning years to 55, and the retired years to 90.
Earning Years
- Two salaries building the corpus, surplus rising as the loans clear.
- The pre-retirement goals met one by one along the way.
Retired Years
- Consulting and business income, about ₹85k a month at first, easing the early draw on the corpus.
- Everyday living and the retirement goals, all funded by the corpus.
- Extra healthcare costs that step up from age 75 onward.
- Health cover that has to keep pace with medical inflation.
This is what the Sharma family brought to us
A young dual-income family, a home and a portfolio, loans to clear, goals in both chapters of life, and a long retirement to secure.
How did we solve it?
Here is the plan we built for the family, section by section. Pick any part on the left, or step through in order. Every screen is from the plan itself; fund names are shown as asset-class labels.
Where the family stands, and the assumptions behind the plan
Before a single recommendation is made, the plan documents the starting point in full, and sets out the assumptions every projection rests on, so nothing is hidden inside a black box.
A single page that captures where the family stands today and where the plan takes them: net worth, income, the goals on record, and the cover in place.

Inflation, the returns expected from each asset class, life expectancy and the planning horizon. Every number later in the plan is built on these, and they are written down where you can see them.

A structured read of the strengths, gaps, opportunities and risks in the current position, the considerations that shape the recommendations that follow.

Every goal, costed and funded
Each goal is quantified twice, in today’s money and in the year it falls due, and then matched to the money meant to fund it: existing assets, ongoing contributions, and any new investment required.
Every goal with its present cost, the amount needed in its target year, and how far along it is today, grouped by theme, for the years up to retirement.

The same view switches to the retirement phase, summarising the goals to fund once Mr. Sharma stops earning, for 2049 onward.

Open any goal to see exactly how it reaches its target: the earmarked assets, the monthly SIP, and the return it actually earns. Notice the SIP is written as a range, for example ₹10,788 rising to ₹28,215, because it steps up over time rather than staying flat.

The Lifetime Ledger
The plan projects the family’s finances year by year across their whole lifetime, so it reads as one connected picture rather than a set of separate calculations.
A multi-dimensional view of any year of your life
The Lifetime Ledger lays out every year from today to the end of the plan on a single timeline. For any year you can open, it shows what comes in, every category of what goes out, what is saved and invested, how each goal is progressing, and the resulting net worth, all at once.
Because it is one model rather than many, a change in an early year flows through every year after it. That is what lets the plan answer “what does this year actually look like” for any point across a lifetime.
Income, expenses, savings, goal funding and net worth across the length of the plan, with any single year openable in full detail.

The Asset Registry
The plan keeps a complete, living record of everything the family owns, and ties each holding to the goal it is working toward.
Every holding, mapped to a goal
The Asset Registry is the single source of truth for what the family owns: each holding grouped by asset class, with its current value, the rate it is expected to grow at, and the goal it is presently allocated toward.
Mapping assets to goals is what makes the rest of the plan honest. Nothing is counted twice, every goal knows which money is backing it, and at each review the registry is simply updated to the current values.
The full registry, grouped by asset class, with value, expected growth and goal mapping.

How the money is invested
This is where the plan sets out what to invest, and why: the risk that suits the family, the mix that shifts over time, and contributions that grow as incomes grow.
A structured questionnaire establishes how much investment risk suits the family, both the capacity to take it and the temperament for it. The recommended mix is then built to match.

The mix shifts from growth to safety as a goal nears
Money for a goal fifteen years away can sit mostly in equity and ride out the ups and downs. The same money two years before the goal cannot. The glide path moves each goal’s mix gradually from growth assets toward safer ones as its target year approaches, so the gains made early are protected just when they are needed.
Contributions that step up over time, not a flat number
A flat SIP ignores a simple fact: incomes rise. A Dynamic SIP starts lower and steps up on a set schedule, so the early years stay affordable and the plan still reaches its targets. It is why each goal’s contribution is shown as a range, for example ₹10,788 rising to ₹28,215 a month, rather than a single figure.
The recommended monthly contributions for the year ahead, shown here by asset class. The plan also breaks this down to named funds in a client’s own copy.

Clearing the debt
A loan is a claim on future income, so the plan treats clearing it as a goal in its own right, and lays out the road to debt-free year by year.
Each loan with its outstanding balance, rate, instalment and payoff year, alongside the interest still to pay. The home loan is pre-closed about two years early by a small extra part-payment each month, bringing debt-free forward to 2033.

Retirement: the Bucket Strategy
A 37-year retirement, from age 55 to 90, is planned in detail: the corpus it needs, how that corpus is organised, and how spending is expected to change along the way.
The corpus split by when the money is needed
Rather than hold one undifferentiated pot, the retirement corpus is divided into three buckets. Bucket 1 holds the near-term money in safe, steady assets so a market fall never forces a sale at the wrong time. Bucket 2 is balanced for the middle years. Bucket 3 stays growth-oriented for the long horizon, because money not needed for a decade or more should keep working.
As the years pass, the buckets are topped up and rebalanced, so there is always a safe bucket to draw from while the rest keeps compounding.
The required corpus split across the three buckets, and how everyday spending steps up over retirement, including the senior-years healthcare uplift from age 75.

The year-by-year approach to keeping near-term money safe and longer-dated money invested, so the strategy is a plan to follow, not a one-time setup.

Retirement Readiness
A plan is only as good as its resilience when life does not go to script. This is where the family can model their own life events and stress-test the plan against the things outside their control.
Model your life events, and stress-test the plan
Readiness lets you change the things that matter and watch the plan respond: retire a few years early, take a break year, step into a lighter job on less pay, or face higher inflation and weaker returns than assumed. For each, it shows whether retirement still holds, and if not, exactly what it would take to get back on track.
Move the levers, see if retirement still holds
A simplified illustration. Adjust the levers to see how the corpus and how long the money lasts respond. In the plan, these are modelled together using the family’s own figures.
Illustrative only. In the plan, Retirement Readiness models these together and can solve for what it would take to stay on track.
Stress-testing the plan: What if?
Beyond retirement timing, the plan is examined against a set of realistic circumstances, so the family can see what each would mean before it ever happens.
Earlier retirement, weaker markets, higher inflation, a career break, an unplanned expense and others, each showing how the requirement and the funding position shift, with a plain explanation of what it would take to absorb.

Beyond the goals: the Wealth Account
Once every goal and retirement are fully funded, the surplus each year is not left to drift. It is directed into a single strategic pool that compounds quietly across a lifetime.
A smart home for surplus, windfalls and bonuses
The Wealth Account is money with no specific goal attached: the leftover monthly surplus, an annual bonus, a windfall. Kept separate from the goal corpus and the retirement corpus, it becomes the family’s cushion, their legacy, and their freedom to change their mind, rather than being quietly absorbed into day-to-day spending.
How the Wealth Account builds over time, and how each year’s surplus is deployed as a single strategic mix.

Protection: need-based insurance
Protection comes first, because a plan that works only if nothing goes wrong is not a plan. The cover is sized to what the family actually needs, not to a round number.
Cover sized to the real need, not a rule of thumb
Instead of a generic multiple of income, the plan works out the family’s actual need: the money required to replace the earner’s income, clear the liabilities, and fund the goals and living costs for the dependents, all in present-value terms. The existing cover is then measured against that need, so any gap is made visible and specific.
Existing life and health cover and the emergency reserve, weighed against the level the family’s circumstances call for, so gaps are flagged plainly.

Keeping the plan on track
A plan is a living thing. At each review the family updates where they actually are, and the plan shows how every goal and the whole portfolio have moved since last time.
At review time, the family refreshes the current value of each holding, by hand or by importing a statement, and the plan re-reads the position from there.

Across reviews, the portfolio total at each check-in and a breakdown by asset group, with any group openable to the holdings inside it, so progress is visible at a glance.

Your action plan, for every year
All of the above resolves into something simple: a clear list of what to do, and in what order, not just at the start but for every year of the plan.
Pick a year, see exactly what to do that year
The action plan is not a one-time snapshot. Choose any year and it shows that year’s moves: the SIPs to run, the one-time steps to set up, and the to-do checklist. As incomes rise and goals are met, the actions change, and the plan always has the current year ready.
The year picker switches the whole plan to any year, so the family always knows the next concrete step, with the one-time setup moves listed separately.

Everything, as a downloadable Excel
The plan is not a sealed PDF. Every schedule and calculation behind it is yours to open, examine and play with.
All working sheets are downloadable Excel workbooks
Every number in this plan comes from an editable Excel workbook, and you get all of them. The lifetime ledger, the goal funding schedules, the retirement drawdown, the buckets, the loan amortisation, the readiness model.
Lifetime ledgerGoal fundingRetirement drawdownBucket rebalancingLoan amortisationReadiness modelThe workbooks are available from the plan itself, and a Download Excel button sits on the interactive screens throughout, so you can take any working sheet with you for your own analysis.

The result: a problem solved
Mr. Sharma came to us with a full life to plan. This is the scorecard, every requirement he brought and exactly how the plan meets it.
Achievable. A ₹9.29 Cr corpus, built across three buckets, funds retirement from 2049 to age 90 with no salary coming in.
Covered. All four education goals, undergrad and post-grad for Arjun and Arthi, funded from earmarked assets and dynamic SIPs.
Debt-free by 2033. The home loan is pre-closed about two years early with a small monthly top-up, saving roughly ₹2.65 L in interest.
Funded for life. ₹1 L a year, through the earning years and into retirement, met from cash-flow surplus and the corpus.
Planned. ₹3 L every four years through retirement, funded by the corpus.
Planned. ₹15 L every ten years in retirement, funded by the corpus.
Funded. ₹15 L earmarked for the business goal, on track to 100% by its target year.
Stress-tested. Earlier retirement, a break year, higher inflation or weaker returns, the Readiness analysis shows what each would take to stay on track.
Ready to build yours?
Every plan is prepared individually, on a fee-only basis, and reviewed with you across several conversations before it is finalised.
Schedule a Meeting →This sample is entirely hypothetical and provided for illustration only. It does not represent a real client and is not advice, a recommendation, an offer, or a guarantee of any outcome. Figures depend on assumptions that differ for every individual. Throughout, fund names are shown only as generic asset-class labels; in a client’s own plan every fund is named in full. AK Rao Personal Finance Advisory is a SEBI-Registered Investment Adviser (INA000022534). Investments in securities markets are subject to market risks.