👨👩👧👦 Family Financial Plan
Every member, every rupee coming in and going out, every goal — and the part no other
tool here does: each existing investment mapped to the goal it will actually pay for, so the
conversation starts from what the family already has.
This states what the numbers do. It does not say what anybody should do about them.
Every figure below is an illustration built from the assumptions you enter. What a client is put into
follows from their goals, horizon and risk profile — and that is a conversation between them and you,
not an output of this page.
1Family members
Everyone in the household, earning or not. Ages drive nothing on their own — they are here
so the plan reads like a family, and so goals can be tied to a person.
2Earning members · income
Annual, net of tax — what actually reaches the bank.
3Family expenses
Enter each head at the frequency it is actually paid — monthly, quarterly, half-yearly
or yearly. Property tax, school fees and the motor premium are yearly, and a household that has to divide
them by twelve in its head usually leaves them out instead. Loans are listed separately below because their
EMI and their outstanding balance do different jobs — the EMI eats surplus, the balance eats net worth.
Rises % / yr is what that head goes up by — school fees and the electricity bill do not move
together, and a plan that never inflates the outgo is quietly saying this family will spend today's
rupees twenty years from now.
LOANS & EMIs
4Family goals
Cost in today's rupees — the plan inflates each one at its own rate, because
school fees and a car do not rise alike.
5Investments, savings & insurance
Everything they already own. "For which goals" is where this tool earns its keep —
tick one goal and the asset funds that goal; leave it blank and the plan maps it to the nearest goal that still
has a gap, and says so on the card. Tick several and the money is walked forward, not counted twice:
the nearest of them takes what it still needs, and only the balance keeps growing to the next.
"How often" is the real frequency of what they are adding — a quarterly SIP or an annual PPF deposit
compounds differently from a monthly one, and is worked out as what it is.
INSURANCE COVER & PREMIUMS
% p.a.
% / yr
The return is used only for money not yet invested — each existing asset grows at its own rate,
entered above. Leave the step-up at 0 and every figure is what it was before this field existed.
A family whose income rises and whose SIP never does is being shown a shortfall they would not have.
Monthly SIPs: monthly rate = annual rate ÷ 12, a step-up once every 12 months. A running SIP grows as on
AMFI’s SIP calculator, instalment at the start of each month; the SIP a goal needs is worked out as on
AMFI’s Goal SIP calculator, instalment at the end of each month — so that SIP, entered in the SIP
calculator, slightly over-reaches the goal (by one month’s growth).
6Goals mapped to what they already own
Each goal is funded first from earmarked assets, then from what is left of the monthly
surplus — essential goals first, and within each, the nearest first, because a goal two years
away cannot wait for a SIP to grow and a holiday should not be funded ahead of a retirement merely
for being sooner.
existing assets
future surplus
shortfall
7Where the monthly surplus goes
The same arithmetic as above, read as a ledger: every claim on this month's surplus,
in the order the plan applied them — nearest goal first — and what is left over, named as left over.
It says what the surplus is already spoken for. Which of these actually gets funded, in what order,
and through what, is your conversation with the client — this page does not decide any of it.
Illustration only. Every figure on this page is produced by applying the assumed rates you entered to every single year. Real markets do not repeat a return, and real expenses do not inflate evenly, so no year will happen exactly as shown. Existing investment values are as you entered them, not as verified from any statement — the client's CAS, policy documents and account statements are the record. Mutual Fund investments are subject to market risks, read all scheme related documents carefully. Past performance may or may not be sustained in future and is not a guarantee of any future returns. This is not investment advice, not a guarantee of any return, and not a recommendation of any scheme or product.