Chapter 8 · Planning a Financial Life

8.1 Goal Planning: Education, Retirement and Withdrawals

Turn life goals into numbers: state a goal in future rupees, find the SIP that funds it, size a retirement corpus with a growing annuity, test withdrawals against sequence-of-returns risk by Monte Carlo, plan an SWP, and set the safety nets — an emergency fund and the right life cover, with term and endowment compared by IRR.

📍 The situation

Vikram (36) and Neha (34) live in Hyderabad with their daughter Ira, who is three. Together they take home about ₹1,80,000 a month, about ₹1,15,000 of it Vikram's. Household spending, including the ₹30,000 home-loan EMI (about ₹30 lakh still owed), is about ₹1,25,000, so they can save roughly ₹55,000 a month. They have three goals and a worry. Ira's higher studies in 15 years: a course that costs ₹20 lakh today. Retirement when Vikram is 60, 24 years from now, on ₹50,000 a month in today's money (the loan will be repaid and Ira independent by then). Safety: what if one of them loses a job, or Vikram dies young? An insurance agent has offered them an endowment policy — "₹1 lakh a year for 20 years, ₹32 lakh at maturity, plus life cover" — and a colleague says "just keep 25 times your annual expenses and withdraw 4% a year".

Each question is a calculation you already know how to do. A goal in future rupees is compound growth with inflation (§1.1, Time Value of Money); the SIP that funds it is an annuity (§1.2, EMIs, SIPs and Annuities); a retirement corpus is the present value of a growing annuity; whether withdrawals survive real markets is a Monte Carlo question (§3.3, Random Walks and Monte Carlo); comparing an endowment with "term insurance plus investing the rest" is an IRR (§1.3, Measuring Returns); and moving money to safer assets as a goal approaches is the glide path of §4.2 (CAPM, Factors, Asset Allocation and Rebalancing). This closing chapter puts the course to work on one family's life.

⚠️ About the numbers on this page

Every return, inflation rate, premium, bonus and maturity value on this page is illustrative. An "assumed 11% return" is a planning input, not a forecast or promise; market-linked returns vary from year to year and can be negative for long stretches. Insurance premiums and benefits depend on the insurer, the policy terms, age and health; tax treatment of insurance, mutual funds and withdrawals changes — check the policy documents, the insurance regulator (IRDAI), AMFI and the Income Tax Department for the current position. The family, the products and the agent are hypothetical; nothing here is investment, insurance or tax advice.

Goals in Future Rupees and the SIP That Funds Them

The first planning mistake is to aim at today's price. A course, a wedding or a house costs more every year, often faster than general inflation, so a goal must be stated in the rupees of the year you will pay.

📘 Definition 8.1 — Financial goal, goal inflation and required SIP

A financial goal is a future spending need described by its present cost $C_0$ (what it would cost today), its horizon $T$ years, and its goal inflation $\pi_g$ (the expected yearly rise in its cost, which may differ from general inflation). Its future cost is $G=C_0(1+\pi_g)^T$.

Given an assumed annual return $R$ on the money set aside for the goal and existing savings $S$ already earmarked for it, the required SIP is the monthly amount which, invested at the start of each month for $n=12T$ months, makes the savings plus the SIP corpus equal $G$ at the horizon. We use the monthly rate $i=(1+R)^{1/12}-1$ of §1.2.

📐 Theorem 8.1 (Formula) — Future cost of a goal and the SIP that funds it

With the notation of Definition 8.1, the shortfall to be funded by the SIP is $$G_{\text{net}}=C_0(1+\pi_g)^T-S(1+R)^T.$$ If $G_{\text{net}}\gt0$, the required flat SIP is $$A=\frac{G_{\text{net}}}{\dfrac{(1+i)^n-1}{i}\,(1+i)},$$ and the required starting amount of a step-up SIP (raised by $g$ once a year, $R_1=(1+i)^{12}=1+R$) is $$A_0=\frac{G_{\text{net}}}{s\,\dfrac{R_1^{\,T}-(1+g)^T}{R_1-(1+g)}},\qquad s=\frac{(1+i)^{12}-1}{i}(1+i),$$ with the denominator replaced by $s\,T R_1^{\,T-1}$ when $1+g=R_1$. Both are proportional to $G_{\text{net}}$.

Why. The savings $S$ grow to $S(1+R)^T$, so the SIP must supply the rest. The SIP and step-up SIP corpus formulas of §1.2 (EMIs, SIPs and Annuities) are "amount × factor", so each required amount is the shortfall divided by the factor. ∎ Two consequences are worth saying aloud. The required SIP is linear in the goal: double the goal, double the SIP. And the factor grows faster than linearly in $n$, so starting later costs more than proportionally — this is compounding working against you.

✏️ Example 1 — Ira's education fund
Ira's course costs ₹20 lakh today. Assume education costs rise 8% a year (illustrative) and the goal money earns an assumed 11% a year. Find (a) the future cost in 15 years, (b) the flat monthly SIP needed with no savings, (c) the SIP needed if ₹3 lakh already saved for Ira is earmarked for the goal and earns the same return.
(a) $G=20{,}00{,}000\times1.08^{15}\approx$ ₹63,44,338 — more than three times today's price.
(b) $i=1.11^{1/12}-1\approx0.8735\%$, $n=180$; the factor $\frac{(1+i)^{180}-1}{i}(1+i)\approx437.07$, so $$A=\frac{63{,}44{,}338}{437.07}\approx\text{₹}\,14{,}516\text{ a month.}$$
(c) The ₹3 lakh grows to $3{,}00{,}000\times1.11^{15}\approx$ ₹14,35,377, leaving $G_{\text{net}}\approx$ ₹49,08,961, so $A\approx$ ₹11,231 a month.
Check Using a 12% assumption instead would lower (b) to about ₹13,330; using 9% would raise it to about ₹17,180. A plan should always be read as "under these assumptions" — Example 5 and Interactive 2 show how to put a probability on it.
✏️ Example 2 — A step-up SIP, and the cost of waiting three years
For the ₹49.09 lakh shortfall of Example 1(c): (a) what starting SIP is needed if it is raised by 10% every year? (b) If Vikram and Neha wait three years before starting a flat SIP (the ₹3 lakh still invested from today), what SIP is needed? Compare with Example 1(c).
(a) $s=\frac{1.11-1}{i}(1+i)\approx12.7036$, $R_1=1.11$, $1+g=1.10$: the denominator is $12.7036\times\dfrac{1.11^{15}-1.10^{15}}{0.01}\approx771.5$, so $A_0\approx49{,}08{,}961/771.5\approx$ ₹6,363 in year 1, rising to about ₹24,200 in year 15.
(b) The savings still grow for 15 years, so $G_{\text{net}}$ is unchanged, but only $n=144$ instalments remain. The factor falls to about 288.5 and $A\approx$ ₹17,013.
Compare Waiting 3 of the 15 years (20% of the time) raises the SIP by about 51% (₹11,231 → ₹17,013). The first instalments are the ones that compound longest.
Step-up logic A step-up SIP fits a rising salary and starts at little more than half the flat SIP; the price is a larger total contribution (about ₹24.3 lakh versus ₹20.2 lakh for the flat SIP), because later rupees have less time to grow.
🧭 How to plan any goal
  1. Write the goal down: what, when, and what it would cost today. Separate goals with different dates.
  2. Inflate it: $G=C_0(1+\pi_g)^T$ with a goal-specific inflation (education and health costs often rise faster than the general price level).
  3. Subtract what is already earmarked, grown at the assumed return: $G_{\text{net}}=G-S(1+R)^T$.
  4. Choose the return assumption to match the horizon and the allocation. Money needed within about three years cannot sit through a large equity fall (§3.1), so it belongs mostly in low-volatility assets with a lower assumed return; long goals can hold more equity (§4.2).
  5. Solve for the SIP with Theorem 8.1 — flat or step-up.
  6. Stress-test: recompute with a return 2–3 points lower, and estimate the probability of reaching the goal by simulation (§3.3).
  7. Follow a glide path: shift the goal's money from equity to debt over the last few years, so a late crash cannot wreck it (§4.2), and review every year, re-solving with the actual balance.
Interactive 1 — Goal Planner: Future Cost, Required SIP and the Cost of Waiting

The amber dashed curve is the goal's cost if you bought it in year $t$ — it rises with goal inflation. The blue curve is your savings plus a flat SIP, and the green curve the same with a step-up SIP; both are sized to meet the goal exactly at the horizon (grey: money put in, flat SIP). Delay the start and watch the required SIP jump. Play builds the plan month by month. All returns are assumptions, not forecasts.

₹20 lakh8.0%15
11.0%₹3 lakh0 y
goal in future rupees—
savings grow to—
flat SIP needed—
step-up SIP, year 1—
flat SIP if you wait 3 more years—
money put in: flat / step-up—

Retirement: How Big a Corpus, and How Much Can You Withdraw?

Retirement is two goals in one. Before it you accumulate a corpus; after it you withdraw from that corpus for perhaps 25–35 years, while prices keep rising and the remaining money stays invested. The size of the corpus is therefore the present value of a stream of withdrawals that grows with inflation — a growing annuity.

📘 Definition 8.2 — Retirement corpus, withdrawal rate and corpus factor

Let $E_0$ be the annual spending one wants in today's rupees and $T$ the years until retirement. With general inflation $\pi$, the first-year retirement spending is $E_R=E_0(1+\pi)^T$. An inflation-indexed withdrawal plan takes $E_R$ at the start of the first retirement year, $E_R(1+\pi)$ at the start of the second, and so on, for $N$ years.

The retirement corpus $C$ is the amount that funds this plan exactly at an assumed return $R$ after retirement. The initial withdrawal rate is $w=E_R/C$, and the corpus factor is $F=C/E_R=1/w$: "corpus = first-year spending × factor".

📐 Theorem 8.2 (Formula) — Present value of a growing annuity; the corpus factor

Payments $W,\,Wq,\,Wq^2,\dots,Wq^{N-1}$ made at the start of each of $N$ periods, valued at rate $R$ per period, have present value $$PV=W\,\frac{1-x^N}{1-x},\qquad x=\frac{q}{1+R}\ (x\ne1),$$ and $PV=NW$ if $x=1$. (For payments at the end of each period, divide by $1+R$.) With $q=1+\pi$ and the real return $r=\frac{1+R}{1+\pi}-1$ (the Fisher relation of §1.1), $x=\frac1{1+r}$ and the retirement corpus factor is $$F=\frac{C}{E_R}=(1+r)\,\frac{1-(1+r)^{-N}}{r}\quad(r\ne0),\qquad F=N\ \ (r=0).$$ If $r\gt0$ and the plan has no end date ($N\to\infty$), $F\to\frac{1+r}{r}$: a withdrawal rate of $w=\frac{r}{1+r}$ can be kept up for ever.

Derivation. The payment at the start of period $k+1$ is $Wq^k$ and is discounted by $(1+R)^k$, so $PV=W\sum_{k=0}^{N-1}x^k$, a geometric progression — Theorem 1.6's trick from §1.2 again (multiply by $x$ and subtract). Substituting $x=1/(1+r)$ gives $1-x=r/(1+r)$ and the formula for $F$, which is exactly the annuity-due factor of §1.2 at the real rate. As $N\to\infty$, $x^N\to0$ when $r\gt0$. ∎ Reading it: in a plan indexed to inflation, only the real return matters. A nominal 8% with 6% inflation is a real return of just under 1.9%.

✏️ Example 3 — Vikram and Neha's retirement corpus
They want ₹50,000 a month (₹6 lakh a year) in today's rupees, starting in 24 years and lasting 30 years (to Vikram's age 90). Assume (illustratively) 6% inflation throughout, an 8% return after retirement, and an 11% return before it. They already have ₹10 lakh earmarked for retirement. Find (a) the first-year spending, (b) the corpus factor and corpus, (c) the initial withdrawal rate, (d) the flat SIP and the 10% step-up starting SIP needed, (e) what the colleague's "25 times your annual expenses" gives.
(a) $E_R=6{,}00{,}000\times1.06^{24}\approx$ ₹24,29,361 a year — about ₹2,02,447 a month in the rupees of year 24.
(b) $r=1.08/1.06-1\approx1.8868\%$. $$F=1.018868\times\frac{1-1.018868^{-30}}{0.018868}\approx23.18,$$ so $C\approx24.29\text{ lakh}\times23.18\approx$ ₹5.63 crore.
(c) $w=1/F\approx4.31\%$ — close to the colleague's "4%", but only because of these particular assumptions.
(d) The ₹10 lakh grows to $10{,}00{,}000\times1.11^{24}\approx$ ₹1.22 crore, leaving ₹4.41 crore. With $i=1.11^{1/12}-1$ and $n=288$ the flat SIP is about ₹33,952 a month; a 10% step-up SIP starts at about ₹14,518.
(e) 25 × today's ₹6 lakh = ₹1.5 crore, about a quarter of the ₹5.63 crore needed. "25 times expenses" (a 4% withdrawal rate) can only be applied to the spending in the year retirement starts, ₹24.29 lakh, and even then it assumes a real return and horizon that may not hold.

The "4% rule". The widely quoted rule of thumb — withdraw 4% of the corpus in the first year, then raise the rupee amount with inflation — came from studies of historical returns in another country's markets over 30-year retirements. It is not a law. Theorem 8.2 shows that the sustainable rate depends on the real return and the horizon; Example 5 below shows that it also depends on volatility and the order of returns. For a plan with no end date at a 1.89% real return, the deterministic rate is only $r/(1+r)\approx1.85\%$.

Sequence-of-Returns Risk and Testing a Plan by Simulation

Theorem 8.2 assumes the same return every year. Real portfolios rise and fall, and once money is flowing in or out, when the good and bad years arrive matters as much as their average.

📘 Definition 8.3 — Sequence-of-returns risk and plan success probability

Sequence-of-returns risk is the risk that the order of returns, not just their average, determines whether a plan with regular contributions or withdrawals succeeds. For a withdrawal plan, the success probability is the probability, under a stated model of returns, that every planned withdrawal is paid in full for the whole horizon.

📐 Theorem 8.3 — When the order of returns matters

Let a balance $B_0$ face yearly growth factors $g_1,\dots,g_N$ (with $g_k=1+R_k\gt0$), with a cash flow $F_k$ added at the start of year $k$ ($F_k\gt0$ a contribution, $F_k\lt0$ a withdrawal), and suppose the balance stays positive. Then the final balance is $$B_N=B_0\prod_{j=1}^{N}g_j+\sum_{k=1}^{N}F_k\prod_{j=k}^{N}g_j .$$

  1. With no cash flows, $B_N=B_0\prod g_j$ does not depend on the order of the returns.
  2. Swapping the returns of two consecutive years $k$, $k+1$ with $g_k\lt g_{k+1}$ (so the bad year comes first) changes $B_N$ by $F_{k+1}(g_{k+1}-g_k)\prod_{j\gt k+1}g_j$ compared with putting the good year first. So a bad year early hurts a withdrawal plan ($F_{k+1}\lt0$) and helps a SIP ($F_{k+1}\gt0$).

Proof. The formula follows by induction from $B_k=(B_{k-1}+F_k)g_k$: each flow is multiplied by the growth of every year after it is made. For (1), a product does not depend on the order of its factors. For (2), only years $k$ and $k+1$ change. Entering year $k$ with balance $X$, the balance after year $k+1$ is $(X+F_k)g_kg_{k+1}+F_{k+1}g_{k+1}$ with the original order and $(X+F_k)g_{k+1}g_k+F_{k+1}g_k$ after the swap; the difference is $F_{k+1}(g_{k+1}-g_k)$, and the later years multiply it by the positive factor $\prod_{j\gt k+1}g_j$. ∎ In words: a withdrawal plan is largest at the start, so early returns act on the most money; a SIP is largest at the end, so late returns matter most.

✏️ Example 4 — The same three returns in opposite orders
A retiree starts with ₹1 crore and withdraws ₹8 lakh at the start of each year. Over three years the portfolio returns are either (A) −20%, +10%, +30% or (B) +30%, +10%, −20%. Find the balance after three years in each case. Then repeat for an investor with no initial balance who puts ₹8 lakh in at the start of each year, and for a lump sum of ₹1 crore with no flows.
Withdrawals A $(100-8)\times0.8=73.6$; $(73.6-8)\times1.1=72.16$; $(72.16-8)\times1.3=83.41$ lakh.
Withdrawals B $92\times1.3=119.6$; $111.6\times1.1=122.76$; $114.76\times0.8=91.81$ lakh — ₹8.4 lakh more, from the same three returns.
Contributions A: $8\times0.8=6.4$; $14.4\times1.1=15.84$; $23.84\times1.3=30.99$ lakh. B: $8\times1.3=10.4$; $18.4\times1.1=20.24$; $28.24\times0.8=22.59$ lakh. Now the bad-year-first order A is ₹8.4 lakh better: early losses were suffered by little money, and the SIP bought cheaply.
Lump sum $100\times0.8\times1.1\times1.3=100\times1.3\times1.1\times0.8=114.4$ lakh either way, exactly as Theorem 8.3(1) says. The average return (6.67%) and the CAGR (4.59%) are identical in all cases — neither measure can see sequence risk.

To judge a real plan we need many possible sequences, not two. That is a job for the Monte Carlo method of §3.3 (Random Walks and Monte Carlo): simulate thousands of plausible return paths, run the plan on each, and count.

📐 Theorem 8.4 (Rule) — Estimating a plan's success probability by simulation

Model the yearly growth factors as independent lognormal, $g_k=e^{\nu+\sigma Z_k}$ with $Z_k\sim N(0,1)$ — geometric Brownian motion sampled once a year (§3.3), with median yearly growth $e^\nu$ and volatility $\sigma$. Simulate $M$ independent paths; on each, run the plan (withdraw, then grow) and record whether every withdrawal was paid. If $K$ paths succeed, $$\hat p=\frac KM,\qquad \text{SE}(\hat p)=\sqrt{\frac{\hat p(1-\hat p)}{M}},$$ and $\hat p\pm1.96\,\text{SE}$ is an approximate 95% interval for the model's success probability.

Why. Each path is an independent trial with the same success probability $p$, so $K$ is binomial and $\hat p$ has mean $p$ and variance $p(1-p)/M$ — the Monte Carlo accuracy rule of §3.3. ∎ The standard error measures simulation noise only. It cannot tell you whether $\nu$, $\sigma$, inflation or independence are right; that is why a plan is tested under several models, not one.

🧭 How to test a withdrawal plan by simulation
  1. Fix the plan: corpus $C$, first withdrawal $W_1=wC$, inflation $\pi$, horizon $N$ years, withdrawals at the start of each year.
  2. Fix the model: median return $e^\nu-1$ and volatility $\sigma$ of the whole portfolio (which depend on its allocation, §4.1–§4.2), and a seed.
  3. For each path: set $B=C$, $W=W_1$; for $k=1,\dots,N$: if $B\lt W$ the plan fails in year $k$; else $B\leftarrow(B-W)\,e^{\nu+\sigma z_k}$ and $W\leftarrow W(1+\pi)$.
  4. Count successes, compute $\hat p$ and its SE, and record the failure year and the final balance in today's rupees ($B/(1+\pi)^N$).
  5. Vary the inputs one at a time — withdrawal rate, return, volatility, horizon — and report a table, not a single number.
✏️ Example 5 — How safe is a 4% withdrawal?
Model a retirement portfolio with a median return of 8% a year ($\nu=\log1.08$), volatility $\sigma=10\%$, inflation 6%, a 30-year horizon and withdrawals at the start of each year rising with inflation. Using $M=2{,}00{,}000$ simulated paths, estimate the success probability for initial withdrawal rates of 3%, 4%, 4.31% (the rate of Example 3) and 5%, and the effect of volatility on the 4% plan.
Without volatility With $\sigma=0$ the return is 8% every year, and Theorem 8.2 says a 4.31% plan lasts exactly 30 years; any lower rate always succeeds.
Simulation Our seeded simulation gives success probabilities of about 88% (3%), 75% (3.5%), 58% (4%), 48% (4.31%), 28% (5%) and 10% (6%); with $M=2{,}00{,}000$ the SE is about 0.1 percentage point.
Volatility For the 4% plan, raising $\sigma$ from 0 to 5%, 10%, 15% and 20% (with the median return held at 8%) moves the success probability from 100% to about 69%, 58%, 54% and 51%.
Read it A plan that "exactly works" at the typical return succeeds only about half the time once returns vary — half the paths have a worse sequence than the typical one. In this model 4% is far from "safe"; the real inputs (allocation, costs, taxes, the true volatility) can move these numbers a lot, and the model ignores inflation shocks and spending flexibility. The method is the lesson, not the table.
Interactive 2 — Will the Corpus Last? Monte Carlo Withdrawals and Sequence Risk

Each faint line is one simulated retirement (seeded lognormal yearly returns), starting from a corpus of 100 and withdrawing the chosen rate in year 1, then raising the withdrawal with inflation. Balances are in today's rupees. The blue lines are the 10th, 50th and 90th percentiles. The red path is the one with the worst first five years; the green path uses exactly the same returns in reverse order. Play adds paths and shows the success estimate settling.

4.0%8.0%10%
6.0%
success probability—
paths simulated—
median end balance (today's ₹)—
1 in 10 plans fails by—
steady median return: lasts—
red vs green (same returns)—

SWP Income, Emergency Funds and Insurance

In practice a retiree's withdrawals usually come monthly, for example through a systematic withdrawal plan (SWP) from a mutual fund (§2.2, Mutual Funds by the Numbers). The arithmetic is an EMI in reverse.

📘 Definition 8.4 — Sustainable SWP and the bucket approach

The sustainable SWP for a corpus $C$, horizon $n$ months and assumed monthly return $i$ is the largest withdrawal (flat, or rising by a factor $q$ each month) that the corpus can pay at the end of each month for $n$ months under that return.

A bucket approach holds the next one to three years of withdrawals in low-volatility assets (bucket 1) and the rest in a growth portfolio (bucket 2), refilling bucket 1 from bucket 2 by periodic rebalancing (§4.2). It reduces the need to sell growth assets right after a fall — a practical defence against sequence risk, paid for by a lower expected return on bucket 1.

📐 Theorem 8.5 (Formula) — Sustainable SWP

With end-of-month withdrawals for $n$ months at monthly rate $i\gt0$:

  1. Flat: $$W=\frac{C\,i}{1-(1+i)^{-n}},$$ the EMI formula of §1.2 with the corpus as the "loan". If $W\le iC$ the corpus never falls.
  2. Rising by the factor $q$ each month, $x=q/(1+i)\ne1$: the first withdrawal is $$W_1=C\,(1+i)\,\frac{1-x}{1-x^n}.$$

Why. The corpus must equal the present value of the withdrawals. For (1) this is the annuity of §1.2; for (2) it is Theorem 8.2 with end-of-period payments: $C=\frac{W_1}{1+i}\cdot\frac{1-x^n}{1-x}$. The rule "$W\le iC$ never falls" is the SWP-duration result of §2.2. ∎

✏️ Example 6 — A ₹1.5 crore SWP: flat or rising?
A retiree moves ₹1.5 crore into a conservative hybrid portfolio with an assumed 7% a year ($i=1.07^{1/12}-1$) and wants income for 25 years. Find (a) the sustainable flat monthly SWP, (b) the sustainable SWP if it rises 5% a year (take $q=1.05^{1/12}$ every month), and its size in the last month, (c) the flat SWP that leaves the corpus intact for ever.
(a) $i\approx0.56541\%$, $n=300$: $W=\dfrac{1{,}50{,}00{,}000\times0.0056541}{1-1.0056541^{-300}}\approx$ ₹1,03,968 a month.
(b) $x=1.05^{1/12}/1.0056541\approx0.998429$: $W_1=1{,}50{,}00{,}000\times1.0056541\times\dfrac{1-x}{1-x^{300}}\approx$ ₹63,022, rising to $63{,}022\times1.05^{299/12}\approx$ ₹2,12,547 in month 300. (Check: running the balance recursion month by month ends at ₹0.)
(c) $iC\approx$ ₹84,812 a month: only the return is spent.
Choose The flat ₹1.04 lakh looks generous, but after 12 years of 5% inflation it buys what about ₹58,000 buys today, and much less by year 25. The rising SWP starts 40% lower but keeps its purchasing power. Neither survives every market — both should be stress-tested as in Example 5.

Safety nets come first. A goal plan assumes the SIPs continue. Two events can stop them: losing an income for some months, and losing an earner for good. The first is met by an emergency fund, the second by life insurance.

📘 Definition 8.5 — Emergency fund

An emergency fund is money set aside, in assets that can be withdrawn quickly with little risk of loss (for example a savings account, a sweep FD or a liquid fund), to cover $m$ months of essential spending — food, rent or EMI, school fees, insurance premiums — during a loss of income or an unexpected large expense. Its purpose is not return but to avoid selling long-term investments, or borrowing at high rates, at a bad time.

📐 Theorem 8.6 (Rule) — Sizing an emergency fund with a geometric model

Suppose that after losing a job, each month independently brings a new job with probability $q$. Then the number of months without income, $D$, is geometric: $$P(D\gt m)=(1-q)^m,\qquad E[D]=\frac1q.$$ A fund of $m$ months of essential spending is enough with probability $1-(1-q)^m$, and the smallest $m$ that is enough with probability at least $1-\alpha$ is $$m=\left\lceil\frac{\log\alpha}{\log(1-q)}\right\rceil.$$

Why. $D\gt m$ means "no job in each of the first $m$ months", probability $(1-q)^m$ by independence. Solve $(1-q)^m\le\alpha$ by taking logarithms; $\log(1-q)\lt0$ reverses the inequality. ∎ The model is deliberately simple: the real chance of finding work changes with the economy and the length of the search, and in a downturn $q$ falls for everyone at once — which is exactly when the fund is needed.

✏️ Example 7 — How many months for Vikram and Neha?
Their essential monthly spending, including the EMI, is about ₹75,000. Model a job search with $q=0.2$ (an illustrative 20% chance of a new job each month). (a) What is the expected search length? (b) What is the chance that a 6-month fund runs out? (c) How many months are needed to be 90% sure? (d) Why might a two-income family still hold several months?
(a) $E[D]=1/0.2=5$ months.
(b) $P(D\gt6)=0.8^6\approx26.2\%$ — about one chance in four, although 6 months exceeds the average.
(c) $m=\lceil\log0.1/\log0.8\rceil=\lceil10.3\rceil=11$ months, i.e. about ₹8.25 lakh. (At $q=0.25$ it would be 9 months.)
(d) If only one income stops, the other covers part of the essentials, so fewer months of full essential spending are needed. But both incomes can be hit together (same industry, same city, a health emergency), and medical bills or a large repair are emergencies too. A common compromise is 6 months of essentials (₹4.5 lakh) plus adequate health insurance; the geometric model shows what that choice leaves uncovered.
📘 Definition 8.6 — Human life value, term insurance and endowment
  • The human life value (HLV) of an earner is the present value of the income he or she would have contributed to the family (income minus taxes and own consumption) until retirement. A needs-based estimate instead adds liabilities and goals (loans, children's education, the family's living costs) and subtracts existing assets. Either gives a rough target for life cover.
  • A term insurance plan pays the sum assured only if the insured dies during the term; nothing is paid on survival, so its premium is the price of cover alone.
  • An endowment (or money-back) plan pays the sum assured on death during the term and a maturity benefit (sum assured plus any bonuses) on survival. Its premium buys cover and savings together.
📐 Theorem 8.7 (Formula) — Human life value as a growing annuity

If the net contribution is $I$ in the coming year (paid at the year's end), grows by $g$ a year for $N$ years, and is discounted at $d\ne g$, then $$\text{HLV}=I\,\frac{1-\left(\frac{1+g}{1+d}\right)^N}{d-g}.$$

Why. This is Theorem 8.2 with end-of-year payments: $\frac{I}{1+d}\cdot\frac{1-x^N}{1-x}$ with $x=\frac{1+g}{1+d}$, and $(1+d)(1-x)=d-g$. ∎

📐 Theorem 8.8 — An endowment is term cover plus savings

Let an endowment with sum assured $SA$ cost a premium $P_e$ at the start of each of $n$ years and pay $M$ at maturity, and let a term plan with the same cover and term cost $P_t$. Holding the endowment is equivalent to buying the term plan and saving $P_e-P_t$ a year in a "savings account" whose survival-case return is the IRR $x$ solving $$(P_e-P_t)\,\frac{(1+x)^n-1}{x}\,(1+x)=M .$$ "Buy term and invest the rest" at a return $y$ gives a larger maturity amount than the endowment if and only if $y\gt x$, and in the death case it pays $SA$ plus the fund built so far, against $SA$ plus the bonus accrued so far.

Why. In both routes the family receives $SA$ on death, so the cover cancels and what is left is a stream of savings $P_e-P_t$ that becomes $M$: its IRR (§1.3, Measuring Returns) is $x$. The annuity-due factor increases with the rate, so the invested route beats $M$ exactly when $y\gt x$. ∎ This is the "fair comparison" that §1.3 promised: a policy's return should be measured after separating out the price of its cover.

✏️ Example 8 — The agent's endowment versus term plus investing the rest
The endowment: premium ₹1,00,000 at the start of each year for 20 years, sum assured ₹20 lakh, illustrated maturity value ₹32 lakh (guaranteed amount plus projected bonuses). A term plan for ₹20 lakh over 20 years costs an illustrative ₹4,000 a year. Find (a) the IRR of the endowment in the survival case, (b) the IRR of its savings part, (c) the maturity amount if the ₹96,000 difference is invested at an assumed 6% or 7%, (d) the payout if Vikram dies at the end of year 10, assuming the endowment's bonus accrues evenly (₹6 lakh by then) and the invested route earns 7%. (e) Compare the cover with his HLV.
(a) Solve $1{,}00{,}000\,\frac{(1+x)^{20}-1}{x}(1+x)=32{,}00{,}000$ numerically: $x\approx4.29\%$ a year on ₹20 lakh of premiums.
(b) With $96{,}000$ in place of $1{,}00{,}000$: $x\approx4.65\%$ (Theorem 8.8).
(c) $96{,}000\,\frac{1.07^{20}-1}{0.07}\times1.07\approx$ ₹42.11 lakh at 7%; at 6%, ₹37.43 lakh — both above ₹32 lakh, because $6\%\gt4.65\%$.
(d) Endowment: $20+6=$ ₹26 lakh. Term + invest: ₹20 lakh cover plus $96{,}000\,\frac{1.07^{10}-1}{0.07}\times1.07\approx$ ₹14.19 lakh, ₹34.19 lakh in all.
(e) HLV (Market case below) ≈ ₹2.17 crore; ₹20 lakh is under a tenth of it. Ten times the endowment cover would need about ₹10 lakh a year of premiums — more than the family's entire yearly savings of about ₹6.6 lakh. The same cover as pure term insurance would cost a small fraction of that.
Fair caveats The endowment's guaranteed part has no market risk and enforces discipline; the invested route's 6–7% is an assumption, not a guarantee. Surrender charges, the tax treatment of each route (check the current rules) and the investor's own behaviour all matter. The IRR makes the trade-off visible; it does not make the decision.
⚠️ Common mistakes and myths
  1. Planning in today's prices. ₹20 lakh of education today is ₹63 lakh in 15 years at 8% (Example 1). Always state goals in future rupees — or do everything consistently in real terms.
  2. "25 times expenses" with today's expenses. For a retirement 24 years away it gave ₹1.5 crore against ₹5.63 crore needed (Example 3).
  3. "The 4% rule is safe." It is a rule of thumb from one set of historical data. In our model it succeeds about 58% of the time (Example 5); the answer depends on real returns, volatility, horizon and costs.
  4. "Only the average return matters." With withdrawals the order matters: the same returns gave ₹83 lakh or ₹92 lakh (Example 4). Average return and CAGR cannot see the sequence.
  5. "A plan that works at the assumed return is safe." If the assumption is the median, the plan fails on about half the paths (Example 5).
  6. A flat SWP as a lifetime income. A fixed ₹1 lakh a month loses most of its purchasing power over 25 years (Example 6).
  7. Keeping the emergency fund in equity. A job loss and a market fall often come together; the fund must be there when needed.
  8. "Insurance should give returns." Cover and savings are different jobs. Separate them (Theorem 8.8) and judge each on its own — the savings part of Example 8 earned about 4.65%.
  9. Under-insuring. Cover of ₹20 lakh against an HLV of about ₹2 crore protects the family for a year or two, not until the children are grown.
  10. Starting late "with a bigger SIP". Three years' delay raised the education SIP by about 51% (Example 2).
📈 Market case — Vikram and Neha's plan on one page

Illustrative assumptions throughout: inflation 6% (education 8%), 11% on long-term growth money, 8% after retirement; all numbers are from Examples 1–8 or follow from them.

  1. Emergency fund first. Six months of essentials, ₹4.5 lakh, in a liquid form (Example 7). If they have only ₹2 lakh, they build the rest from the monthly surplus before starting new SIPs.
  2. Life cover. Vikram's take-home pay is about ₹13.8 lakh a year; after his own personal spending, about ₹12 lakh of it goes to the family. Expect it to grow 6% a year for 24 years. Discounting at 8% (Theorem 8.7): $$\text{HLV}=12\text{ lakh}\times\frac{1-(1.06/1.08)^{24}}{0.02}\approx\text{₹}\,2.17\text{ crore}.$$ A needs-based check (₹30 lakh home loan + Ira's education + the family's spending gap) gives a figure of the same order. They choose pure term cover for each earner and decline the endowment (Example 8): at 4.65%, its savings part is below their planning return, and its cover is far too small.
  3. Ira's education. A 10% step-up SIP starting at about ₹6,363 a month, plus the ₹3 lakh already saved (Example 2), moving gradually to debt in the last 3–4 years (glide path, §4.2).
  4. Retirement. A 10% step-up SIP starting at about ₹14,518 (Example 3) plus the existing ₹10 lakh, in a diversified allocation that is rebalanced yearly (§4.2).
  5. Budget check. Year 1: $6{,}363+14{,}518\approx$ ₹20,900 a month in SIPs, plus term premiums and the emergency-fund top-up — well within ₹55,000. The step-ups assume income also rises about 10% a year; if it does not, they re-solve with the actual numbers.
  6. Stress test. Lowering the pre-retirement return to 9% raises the retirement step-up SIP to about ₹19,800; the post-retirement plan has only about a 48% success probability in the model of Example 5. Levers that raise it: a lower withdrawal rate (a larger corpus, or spending 10% less), retiring two years later, keeping costs low (§2.2 and §8.2), a bucket for the first years of withdrawals, and spending flexibly after bad years.

The mathematics, not a recommendation. The plan is a set of linked calculations, each from an earlier chapter, and its value is that every assumption is visible and can be changed. A real plan would add health insurance, taxes, other goals and the family's own preferences, and would be reviewed every year with the actual balances — the XIRR of §1.3 tells them whether they are on track.

Exercises

All rates are illustrative assumptions. SIPs are invested at the start of each month with $i=(1+R)^{1/12}-1$; retirement withdrawals are at the start of each year and rise with inflation unless stated otherwise; SWPs are at the end of each month. Round rupee answers sensibly.

I
Goals and the SIPs that fund them.
  • 1 A wedding that costs ₹12 lakh today is planned in 10 years; its cost rises 7% a year. What is its future cost?
  • 2 Find the flat monthly SIP for part 1 at an assumed 10% a year.
  • 3 Repeat part 2 if ₹2 lakh is already saved for the goal and earns 10%.
  • 4 Find the starting SIP for part 2 if it is raised by 10% every year (no existing savings). Which case of Theorem 8.1 applies?
  • 5 A goal costs ₹10 lakh today, is 8 years away, and its cost rises 6% a year. What lump sum invested today at 9% meets it? Show that discounting today's cost at the real rate gives the same answer.
  • 6 Find the flat SIP to reach ₹50 lakh in 20 years at 11%, and the SIP if the start is delayed by 5 years (same goal date). By what factor does the SIP rise?
  • 7 Explain why the assumed return for a goal three years away should be lower than for a goal twenty years away.
1 $12\times1.07^{10}\approx$ ₹23.61 lakh.
2 $i=1.1^{1/12}-1$, $n=120$, factor $\approx201.46$: $A\approx$ ₹11,718 a month.
3 ₹2 lakh grows to ₹5,18,748; shortfall ≈ ₹18,41,833; $A\approx$ ₹9,143.
4 Here $1+g=1.1=R_1$, the special case: denominator $s\,T R_1^{\,T-1}$ with $s\approx12.6405$, $T=10$: $A_0=\dfrac{23{,}60{,}582}{12.6405\times10\times1.1^{9}}\approx$ ₹7,920 to start.
5 $G=10\times1.06^8\approx15.94$ lakh; $PV=15.94/1.09^8\approx$ ₹8.00 lakh. With $r=1.09/1.06-1\approx2.83\%$: $10/1.0283^8\approx$ ₹8.00 lakh — the same, because $(1.06/1.09)^8=1/(1+r)^8$.
6 $i=1.11^{1/12}-1$: 240 months → ₹6,130; 180 months → ₹11,440, a factor of about 1.87 for a 25% shorter period.
7 A short goal cannot wait for a recovery: an equity-heavy portfolio can fall 20–30% in a year (§3.1), so short-horizon money is held mostly in low-volatility assets, whose expected return is lower. Using a high equity-like assumption for a short goal under-saves and over-risks at the same time.
II
Retirement corpus and withdrawal rates. Inflation 6% and post-retirement return 8% unless stated.
  • 1 Spending today is ₹40,000 a month and retirement is 25 years away. Find the first-year retirement spending (annual and monthly).
  • 2 Find the corpus factor for a 25-year retirement.
  • 3 Find the corpus for parts 1–2.
  • 4 What is the plan's initial withdrawal rate?
  • 5 At what initial withdrawal rate could the inflation-indexed plan run for ever?
  • 6 A retiree with ₹2 crore wants ₹10 lakh in year 1, rising 6% a year. How many full years of withdrawals does the corpus pay?
  • 7 Compare part 3 with "25 times today's annual spending". Why is the rule-of-thumb figure so different?
1 $4{,}80{,}000\times1.06^{25}\approx$ ₹20,60,098 a year (≈ ₹1,71,675 a month).
2 $r\approx1.8868\%$: $F=1.018868\times\dfrac{1-1.018868^{-25}}{0.018868}\approx20.16$.
3 $20.60\text{ lakh}\times20.16\approx$ ₹4.15 crore.
4 $w=1/F\approx4.96\%$.
5 $r/(1+r)=0.018868/1.018868\approx1.85\%$ (Theorem 8.2, $N\to\infty$).
6 $x=1.06/1.08$; $C=W\frac{1-x^n}{1-x}$ gives $x^n=1-\frac{C(1-x)}{W}\approx0.6296$, so $n=\dfrac{\log0.6296}{\log x}\approx24.7$: 24 full withdrawals, then about ₹30 lakh is left against a 25th withdrawal of about ₹40 lakh.
7 $25\times4.8$ lakh = ₹1.2 crore, about 3.5 times too small. The rule (a 4% withdrawal rate) must be applied to spending in the first year of retirement, after 25 years of inflation; and with a real return of only 1.89%, even that gives a factor of 20.2, not 25, for a 25-year retirement.
III
Sequence risk and simulation.
  • 1 A corpus of ₹50 lakh pays ₹5 lakh at the start of each year. Find the balance after 3 years if the returns are +15%, −10%, +5% in that order, and in the reverse order.
  • 2 With no withdrawals, show that both orders in part 1 give the same balance.
  • 3 An investor puts ₹1 lakh in at the start of each year with the same two orders. Which order is better now, and why?
  • 4 A simulation of 2,500 retirement paths has 1,900 successes. Estimate the success probability and a 95% interval.
  • 5 How many paths are needed for an SE of at most 0.5 percentage points when $p\approx0.8$?
  • 6 Using Theorem 8.3, explain why the first five years of retirement are the most dangerous, and how a bucket approach responds.
1 Given order: $45\times1.15=51.75$; $46.75\times0.9=42.075$; $37.075\times1.05\approx38.93$ lakh. Reverse: $45\times1.05=47.25$; $42.25\times0.9=38.025$; $33.025\times1.15\approx37.98$ lakh. The order with the good year first is ₹0.95 lakh better.
2 $50\times1.15\times0.9\times1.05=50\times1.05\times0.9\times1.15\approx54.34$ lakh: multiplication is commutative.
3 Given order: $1.15$; $2.15\times0.9=1.935$; $2.935\times1.05\approx3.08$ lakh. Reverse: $1.05$; $2.05\times0.9=1.845$; $2.845\times1.15\approx3.27$ lakh. Now the low-return-first order is better: the later, larger balance gets the +15%.
4 $\hat p=0.76$, $\text{SE}=\sqrt{0.76\times0.24/2500}\approx0.0085$; 95% interval ≈ 74.3%–77.7%.
5 $\sqrt{0.8\times0.2/M}\le0.005$ gives $M\ge0.16/0.000025=6{,}400$ paths.
6 In Theorem 8.3, a swap matters by the size of the flows after it and by the balance the returns act on. Early in retirement the balance is largest and every later withdrawal depends on it, so a fall then forces selling more units at low prices, and the loss is never recovered by later returns. A bucket of 1–3 years' withdrawals in low-volatility assets lets the retiree avoid selling growth assets right after a fall.
IV
SWP, emergency fund and insurance.
  • 1 A corpus of ₹80 lakh earns an assumed 6% a year. Find the flat monthly SWP that lasts exactly 20 years.
  • 2 If instead ₹60,000 is withdrawn every month, how long does the corpus last? What monthly SWP would never reduce it?
  • 3 With $q=0.25$ in Theorem 8.6, find the chance that a 6-month emergency fund runs out, and the months needed for 95% confidence.
  • 4 Give two reasons why an emergency fund is kept in low-risk, liquid assets even though their return is low.
  • 5 An earner's net contribution is ₹8 lakh next year, growing 5% a year for 30 years. Find the HLV at a 7% discount rate.
  • 6 An endowment costs ₹50,000 at the start of each year for 15 years and pays ₹10 lakh at maturity. Find its survival-case IRR.
  • 7 A term plan with the same cover costs ₹3,000 a year. Find the IRR of the endowment's savings part, and the maturity amount if the ₹47,000 difference is invested at an assumed 7%.
1 $i=1.06^{1/12}-1\approx0.48676\%$, $n=240$: $W=\dfrac{80{,}00{,}000\,i}{1-(1+i)^{-240}}\approx$ ₹56,583.
2 $iC\approx$ ₹38,940 $\lt$ ₹60,000, so the corpus runs out after $n=\dfrac{-\log(1-38{,}940/60{,}000)}{\log(1+i)}\approx215.6$ months (about 18 years). Up to ₹38,940 a month would leave it intact.
3 $0.75^6\approx17.8\%$; $m=\lceil\log0.05/\log0.75\rceil=\lceil10.4\rceil=11$ months.
4 (i) Emergencies are often correlated with bad markets (job losses in a downturn), so a risky fund may be down just when it is needed. (ii) It must be available within days, without exit loads, lock-ins or forced sales. Its job is insurance, not return.
5 $8\text{ lakh}\times\dfrac{1-(1.05/1.07)^{30}}{0.02}\approx$ ₹1.73 crore.
6 Solve $50{,}000\,\frac{(1+x)^{15}-1}{x}(1+x)=10{,}00{,}000$: $x\approx3.52\%$.
7 With ₹47,000: $x\approx4.26\%$. Invested at 7%: $47{,}000\,\frac{1.07^{15}-1}{0.07}\times1.07\approx$ ₹12.64 lakh, versus ₹10 lakh (Theorem 8.8: $7\%\gt4.26\%$).
🎯 Practice corner NISM-styleCase studyInterview

E1. NISM-style A goal costs ₹10 lakh today. If its cost rises at 6% a year, compounded annually, its cost after 12 years is closest to (A) ₹17.2 lakh (B) ₹20.1 lakh (C) ₹17.9 lakh (D) ₹16.0 lakh.

Compute $10\times1.06^{12}\approx20.12$ lakh.
Distractors (A) is simple growth $10(1+12\times0.06)$; (C) compounds at 5%; (D) is a guess at "60% more".
Answer (B).

E2. NISM-style For a given premium, the type of life insurance that generally provides the largest sum assured is (A) an endowment plan (B) a money-back plan (C) a pure term plan (D) a whole-life endowment with bonus.

Reason A term plan's premium pays only for cover; the others also buy a savings element, so most of their premium is not cover (Theorem 8.8).
Answer (C).

E3. NISM-style Sequence-of-returns risk matters most for (A) a lump sum held for 10 years with no flows (B) a retiree making regular withdrawals in the early years of retirement (C) a T-bill held to maturity (D) a fixed deposit with interest reinvested.

Reason Order matters only when there are cash flows (Theorem 8.3), and most when the balance is large and withdrawals are being made. (A) has no flows; (C) and (D) have fixed returns.
Answer (B).

E4. Case study Asha, 45, spends ₹50,000 a month today and plans to retire at 60 for 25 years. Assume 6% inflation, 8% after retirement and 10% before, and ₹40 lakh already saved for retirement. Find (a) her first-year retirement spending, (b) the corpus, (c) the flat monthly SIP needed for 15 years, (d) her initial withdrawal rate.

(a) $6{,}00{,}000\times1.06^{15}\approx$ ₹14.38 lakh a year.
(b) The factor for 25 years at $r\approx1.8868\%$ is about 20.16 (Exercise II.2): $C\approx14.38\times20.16\approx$ ₹2.90 crore.
(c) ₹40 lakh grows to $40\times1.1^{15}\approx$ ₹1.67 crore, leaving ≈ ₹1.23 crore. With $i=1.1^{1/12}-1$, $n=180$ (factor ≈ 401.6), $A\approx$ ₹30,571 a month.
(d) $w=1/20.16\approx4.96\%$ — above the 4.3% of Example 3 because the horizon is 5 years shorter; a simulation like Example 5 (σ = 10%, median 8%) gives a success probability of only about 48%, because the plan exactly uses up the corpus at the median return.

E5. Case study A retiree has ₹1 crore and withdraws ₹6 lakh at the start of year 1, rising 6% a year. Count the full years of withdrawals if the portfolio returns (a) 8% every year, (b) −25% in year 1 and 8% every year after, (c) 8% every year except −25% in year 15. Explain the result.

Method Recursion $B\leftarrow(B-W)(1+R_k)$, $W\leftarrow1.06W$; stop when $B\lt W$.
(a) 19 full withdrawals (about ₹13.6 lakh is left, less than the 20th withdrawal).
(b) 13 full withdrawals — the crash in year 1 costs 6 years of income.
(c) 18 full withdrawals — the same crash in year 15 costs only 1 year.
Why Theorem 8.3: in year 1 the −25% hits ₹94 lakh and every later withdrawal depends on it; by year 15 the balance is small, so the same percentage loss is a small rupee loss. A 6% initial rate with a 1.9% real return was never sustainable for 25+ years (Theorem 8.2 gives about 19.7 years even with steady returns).

E6. Interview "Instead of a fixed rupee amount, I will withdraw 5% of whatever my corpus is worth at the start of each year. Then I can never run out." Is that true? What is the catch? (Use median growth 8% a year and 6% inflation.)

True part The balance after year $k$ is $B_k=B_{k-1}\times0.95\,g_k$, so $B_k=B_0\,0.95^k\prod g_j\gt0$ for ever: a percentage rule can never hit zero.
The catch The income is $0.05B_{k-1}$, so it moves with the market: a 30% fall cuts next year's income by 30%. Sequence risk has been moved from the corpus to the income.
The trend Income grows by the factor $0.95\,g_k$ a year, with median $0.95\times1.08=1.026$, i.e. 2.6% nominal — about 3.2% a year less than inflation. In real terms the typical income halves in about 21 years.
Interview answer "You cannot run out of money, but you can run out of enough money. Fixed-amount and fixed-percentage rules are two ends of a spectrum; practical plans use guardrails — spend a fixed real amount but cut it after bad years and raise it after good ones."
🧑‍🏫 For the teacher

Suggested plan — 2 lectures × 60 min.

  1. Goals and retirement. Open with the 📍 situation and ask: "How much should they save for Ira?" — most answers use today's ₹20 lakh. Theorem 8.1 and Examples 1–2; project Interactive 1 and move the delay slider. Then Definition 8.2, Theorem 8.2 (derive it as a geometric series in real terms) and Example 3, ending with the "25 times expenses" trap.
  2. Risk and safety nets. Example 4 on the board (same returns, opposite orders), then Theorem 8.3 with the two-year swap proof. Theorem 8.4 and Example 5 with Interactive 2: start at σ = 0 (the red and green paths coincide), then raise σ; reverse a bad path. Finish with SWP (Example 6), the emergency fund (Example 7), HLV and term vs endowment by IRR (Example 8) and the 📈 Market case.

Class activity. Each student writes one personal goal (a bike, a course, a trip, a down payment), states it in future rupees, and computes a flat and a step-up SIP under two return assumptions; then pairs swap and check with Interactive 1. In the second lecture, groups are given a corpus and must choose a withdrawal rate that reaches 80% success in Interactive 2 under a model the teacher announces.

Misconceptions to watch for. Goals in today's prices; "25× expenses" with today's expenses; average return decides everything; the 4% rule as a law; Monte Carlo SE as model accuracy; insurance as investment; equity for an emergency fund.

Suggested homework. I(1–4, 6), II(1–6), III(1, 3–5), IV(1–3, 5–7); Practice corner E4, E5, E6.

🛠️ Do it yourselfSpreadsheet or Python mini-project · about 90 minutes

Project. Build a one-sheet plan for one goal and one retirement, then stress-test the retirement with your own Monte Carlo simulation.

Why it matters. Online calculators give one number under one assumption. A sheet you built yourself shows every assumption, lets you change them, and turns "will it work?" into "how often does it work, and what would make it work more often?"

What to do.

  1. Goal sheet. Inputs: cost today B1, goal inflation B2, years B3, assumed return B4, savings B5. Future cost =B1*(1+B2)^B3; monthly rate =(1+B4)^(1/12)-1; shortfall =B1*(1+B2)^B3-B5*(1+B4)^B3; flat SIP =PMT(rate,12*B3,0,-shortfall,1) (the final 1 means start-of-month). Check it against Theorem 8.1.
  2. Corpus. Real rate =(1+R)/(1+pi)-1; corpus =PV(real,N,-E_R,0,1), which is Theorem 8.2's annuity-due factor at the real rate.
  3. Simulation sheet. Row = one path, column = one year. Return cell =EXP(LN(1+median)+sigma*NORM.S.INV(RAND()))-1. Balance column: =MAX(0,(prev-W)*(1+ret)) with W=W1*(1+pi)^(year-1), and a "failed" flag when prev<W. Fill 1,000 rows; success rate =COUNTIF(flags,0)/1000.
  4. Python version. rng=np.random.default_rng(8); G=np.exp(nu+sigma*rng.standard_normal((M,N))); loop over years: B=B-W; dead|=B<0; B=np.where(dead,0,B*G[:,k]); W*=1+pi; then p=1-dead.mean(), se=np.sqrt(p*(1-p)/M).
  5. Sequence test. Pick the path that fails earliest, reverse its returns (G[j,::-1]) and rerun it. Then make a table of success probability against withdrawal rate (3%–6%) and volatility (5%–20%).

Hand in: the goal SIP (flat and step-up), the corpus and withdrawal rate, the success table with SEs, one failing path and its reversed twin on a chart, and three sentences on which lever (spending, retirement age, allocation, costs) moves the success probability most.

Going further. Add a "guardrail" rule (cut the withdrawal by 10% after any year the portfolio falls, restore it after recovery) and measure both the success probability and the worst real income; or add a bucket of two years' spending held at a fixed low return.

Instructor note: with median 8%, σ = 10%, inflation 6%, 30 years and withdrawals at the start of each year, success rates near 88% (3%), 58% (4%), 48% (4.31%) and 28% (5%) are expected, within about ±3 points for 1,000 paths. Spreadsheet RAND() recalculates on every edit; copy the returns as values before comparing scenarios, so that all scenarios use the same paths.

🧪 Self-check quiz

0/5 correct

Q1. A goal costs $C_0$ today, its cost rises at $\pi_g$ a year, and it is $T$ years away. The amount to plan for is

Q2. For an inflation-indexed withdrawal plan, the corpus factor $C/E_R$ depends on

Q3. The same set of yearly returns is applied in two different orders. The final values are equal for

Q4. A Monte Carlo test of a retirement plan with 1,600 paths gives a success rate of 80%. The simulation standard error is about

Q5. An endowment's savings part (premium minus the cost of equal term cover) has an IRR of 4.6%. "Buy term and invest the rest" gives more at maturity exactly when the invested money earns