2.2 Mutual Funds by the Numbers: NAV, SIP, Costs and ETFs
A mutual fund is a shared portfolio priced once a day: how NAV and units work, what a SIP actually buys (the harmonic mean), how much a 1% expense ratio costs over 20 years, growth vs IDCW, exit loads, index funds and ETFs, tracking difference and tracking error, and STP/SWP calculations.
📍 The situation
Meera, 32, works in Hyderabad and wants to start a ₹10,000 monthly SIP. A relative who is a mutual-fund distributor suggests "Fund A — Flexi Cap, Regular Growth"; a colleague says she should buy the "Direct" plan of the same fund because it is "about 1% cheaper", and adds that "Fund B has a NAV of only ₹14, so it is cheaper than Fund A at ₹480". Her brother prefers a Nifty 50 index fund and wonders whether an ETF would be better, and why his index fund earned a little less than the index last year. Her father, who has just retired, wants to know whether he can withdraw ₹30,000 a month from ₹40 lakh, and whether the "IDCW" option gives him a regular income.
Every one of these questions has a precise numerical answer once we know how a mutual fund keeps its books. What is a NAV and how many units does ₹10,000 buy? What average price does a SIP pay? What does a 1% difference in expense ratio cost over 10, 20 or 30 years? How closely does an index fund follow its index, and how do we measure "closely"? How long does a monthly withdrawal last? The tools are the geometric series of §1.2, a classical inequality between means, the exponential function and a standard deviation.
All funds, NAVs, returns, expense ratios, loads and tax rates on this page are hypothetical or illustrative. An "assumed 12% return" is an input to a calculation, not a forecast — market-linked returns vary and can be negative, and past NAV performance does not predict future returns. Expense-ratio limits, exit loads, cut-off times, stamp duty, the riskometer, fund categories and the taxation of mutual funds are set by SEBI, the Government and each scheme's documents and change from time to time — check the scheme information document, AMFI and SEBI and the Income Tax Department for the current rules. Nothing here recommends any fund, plan or distributor.
NAV, Units, Purchases and Redemptions
A mutual fund pools money from many investors and invests it in a portfolio — shares, bonds, money-market instruments — managed by an asset management company (AMC) under SEBI regulation. Instead of owning shares directly, each investor owns units of the fund, and every unit is a claim on an equal slice of the portfolio. The price of one slice is the NAV.
At the end of each business day a fund values everything it owns at market prices. Its net assets are $$\text{net assets}=\text{investments}+\text{cash}+\text{receivables}-\text{liabilities},$$ where liabilities include amounts payable and expenses accrued but not yet paid. If $U$ units are outstanding, the net asset value per unit is $$\text{NAV}=\frac{\text{net assets}}{U}.$$
Investors buy units from the fund, and sell them back to it (redemption), at the NAV of the applicable day. Which day's NAV applies depends on when the money or the request reaches the fund relative to a cut-off time set by SEBI's rules. Units are usually allotted to three decimal places.
- Purchase. An investment of $X$ rupees at NAV $N$ buys $u=X(1-s)/N$ units, where $s$ is any stamp duty or transaction charge deducted (an illustrative $s=0.005\%$ below; $s=0$ if none).
- Redemption. Redeeming $u$ units at NAV $N$ pays $uN(1-\ell)$, where $\ell$ is the exit load rate applicable to those units (often zero after a stated holding period). Units are redeemed first in, first out (FIFO): the oldest units go first.
- No dilution. A purchase or redemption at the NAV does not change the NAV: if net assets are $A=NU$ and $X$ rupees come in, the new NAV is $\dfrac{A+X}{U+X/N}=N$.
- Return. An investor's return between two dates is $N_1/N_0-1$, whatever the NAV's level: a fund with NAV ₹14 and one with NAV ₹480 that both rise 10% give the same 10%.
Why no dilution. Since $A=NU$, $$\frac{A+X}{U+X/N}=\frac{NU+X}{U+X/N}=\frac{N(U+X/N)}{U+X/N}=N.$$ New investors pay exactly the value of what they get, so existing unit-holders gain or lose nothing when money flows in or out. (In practice large flows force the fund to trade, and those trading costs are shared by all — one reason for exit loads.) Part 4 is the reason that a "low NAV" is not "cheap": the NAV's level only reflects when the fund started and what it has earned since, and for the same money you simply get more units of smaller size. ∎
- In the growth option the fund keeps all its income and gains invested; the NAV rises and falls, and the investor realises gains only by redeeming units.
- In the IDCW option (income distribution cum capital withdrawal) the fund pays out amounts per unit from time to time, and the NAV falls by the amount distributed. The name is a reminder that the payout may come partly from the investor's own capital. With IDCW reinvestment, the payout buys new units at the ex-distribution NAV.
- An exit load is a charge, as a percentage of the redemption value, on units redeemed within a stated period after purchase; it is credited back to the scheme.
The growth and IDCW options (and direct and regular plans) of a scheme hold the same portfolio; they differ only in what happens to the returns.
If a distribution of $\delta$ per unit is declared when the NAV is $N$, the NAV falls to $N-\delta$ and an investor with $u$ units receives $u\delta$: her wealth $u(N-\delta)+u\delta=uN$ is unchanged before tax. With reinvestment she receives $u\delta/(N-\delta)$ new units and her wealth is again $uN$. After tax, if distributions are taxed at a rate $\tau$ when paid (illustrative), she keeps $u\delta(1-\tau)$ — so the IDCW option is worse than the growth option by the tax paid early, unless the growth option's eventual tax on redemption is higher.
SIP Units and Rupee-Cost Averaging
A SIP invests a fixed amount $A$ every month (§1.2 projects its value under an assumed return). Here we look inside: because the amount is fixed and the NAV varies, the SIP buys more units when the NAV is low and fewer when it is high. That simple fact has a precise mathematical consequence.
A SIP of $A$ rupees at NAVs $N_1,\dots,N_n\gt0$ buys $u=A\sum_{k=1}^n\dfrac1{N_k}$ units, at an average cost per unit $$\bar c=\frac{nA}{u}=\frac{n}{\sum_{k=1}^n 1/N_k}=H(N_1,\dots,N_n),$$ the harmonic mean of the NAVs. Always $$H\le\bar N=\frac{N_1+\dots+N_n}{n},$$ with equality if and only if all the NAVs are equal. For two NAVs $x,y$: $\bar N-H=\dfrac{(x-y)^2}{2(x+y)}$.
Proof. Month $k$ buys $A/N_k$ units, so the units and the average cost are as stated. By the Cauchy–Schwarz inequality applied to the vectors $(\sqrt{N_k})$ and $(1/\sqrt{N_k})$, $$n^2=\Big(\sum_k\sqrt{N_k}\cdot\tfrac{1}{\sqrt{N_k}}\Big)^2\le\Big(\sum_kN_k\Big)\Big(\sum_k\tfrac1{N_k}\Big),$$ which rearranges to $H\le\bar N$; equality in Cauchy–Schwarz holds exactly when the vectors are proportional, i.e. all $N_k$ equal. For two NAVs, $\bar N-H=\frac{x+y}2-\frac{2xy}{x+y}=\frac{(x+y)^2-4xy}{2(x+y)}=\frac{(x-y)^2}{2(x+y)}$. ∎
This is rupee-cost averaging: an investor who puts the same rupees in every month pays less per unit, on average, than one who buys the same number of units every month — and the more the NAV fluctuates, the bigger the gap. Note carefully what the theorem does not say: it does not say a SIP beats investing a lump sum, or that a SIP cannot lose money. If the NAV rises steadily, money invested earlier does better; if it falls and stays down, the SIP loses too.
Costs: Expense Ratio, Direct vs Regular Plans
A fund pays for its management, operations and distribution out of the investors' money. Nobody sends you a bill: the costs are taken out of the fund's assets a little every day, so they show up only as a slightly lower NAV. Small percentages, applied every day for decades, compound into large sums.
The total expense ratio (TER) $c$ is the annual percentage of net assets that a scheme charges for its expenses. It is accrued daily — roughly $c/365$ of net assets each calendar day — and the published NAV is always after expenses. SEBI sets maximum TERs, which depend on the type and size of the scheme; each fund discloses its actual TER.
Every scheme has a direct plan, bought straight from the AMC, and a regular plan, bought through a distributor. Both hold the same portfolio; the regular plan's TER is higher because it includes the distributor's commission, so the two plans have different NAVs. Whether a distributor's service is worth its cost is a personal decision; the mathematics below measures the cost.
Model the fund day by day: on day $d$ the portfolio earns a gross return $g_d$ and the day's expense $c/365$ of assets is deducted, so $\text{NAV}_d=\text{NAV}_{d-1}(1+g_d)(1-c/365)$. Then over $T$ years ($365T$ days) $$\frac{\text{NAV}_T}{\text{NAV}_0}=\prod_d(1+g_d)\cdot\Big(1-\frac{c}{365}\Big)^{365T}\approx G_T\,e^{-cT},$$ where $G_T$ is the gross growth factor of the portfolio. Consequently:
- Two plans of the same portfolio with TERs $c_1\lt c_2$ end in the ratio $$\frac{V_2}{V_1}\approx e^{-(c_2-c_1)T},$$ whatever the market does — the path cancels out.
- With an assumed gross annual return $g$, the net annual return is $(1+g)e^{-c}-1\approx g-c$.
- For a SIP, the instalment invested $t_k$ years before the end is reduced by the factor $e^{-\Delta c\,t_k}$; the whole corpus's ratio is a weighted average of these factors, so it lies between $e^{-\Delta c\,T}$ and $1$.
Why. Multiplying the daily factors gives the product formula. Since $(1-c/365)^{365}$ is within a millionth or so of $e^{-c}$ for realistic $c$ (this is the limit of §1.1's continuous compounding, run in reverse), the cost factor is $e^{-cT}$. The gross factor $G_T$ is the same for both plans, so it cancels in the ratio. For a SIP, each instalment is a separate "lump sum" held for its own time $t_k\le T$. ∎ The key lesson: a cost difference compounds like a negative return. A 1 percentage point difference costs about $1-e^{-0.01T}$ of a lump sum's final value: 9.5% after 10 years, 18.1% after 20 and 25.9% after 30.
Meera compares the two plans of the same flexi-cap fund for her ₹10,000 monthly SIP, invested at the start of each month. For illustration she assumes a gross portfolio return of 12% a year and TERs of 0.6% (direct) and 1.6% (regular). Net annual returns are 11.33% and 10.22% (Example 5); she converts each to a monthly rate $i=(1+r)^{1/12}-1$ and uses the SIP formula of §1.2, $FV=A\frac{(1+i)^n-1}{i}(1+i)$.
| years | invested (₹) | direct (₹) | regular (₹) | gap (₹) | gap % |
|---|---|---|---|---|---|
| 10 | 12,00,000 | 21,61,881 | 20,38,432 | 1,23,449 | 5.7% |
| 20 | 24,00,000 | 84,85,336 | 74,33,406 | 10,51,930 | 12.4% |
| 30 | 36,00,000 | 2,69,81,301 | 2,17,11,902 | 52,69,399 | 19.5% |
- The gap grows faster than time. Doubling the horizon from 10 to 20 years multiplies the rupee gap by about 8.5; by 30 years it exceeds ₹52 lakh — more than everything she will have invested.
- A SIP loses less, in percentage terms, than a lump sum. The SIP gaps (5.7%, 12.4%, 19.5%) lie between 0 and the lump-sum gaps $1-e^{-0.01T}$ (9.5%, 18.1%, 25.9%), as Theorem 2.9(3) says: recent instalments have had little time to suffer the drag.
- The assumption matters less than it seems. If the gross return is lower, both values shrink, but the lump-sum ratio is still $e^{-0.01T}$; the cost is a fixed fraction of whatever the market gives.
- What she decides is not arithmetic. If she needs help choosing funds and staying invested through bad years, a distributor may be worth the cost; if she is confident doing it herself, the direct plan keeps the difference. Switching an existing holding from regular to direct is a redemption, which may attract exit load and tax (see Practice corner E4).
Interactive 1 shows why the SIP's average cost is low in volatile markets; this table shows why that advantage is small compared with a cost that is charged every single day.
Index Funds, ETFs and Tracking
An index fund does not try to beat the market: it holds the stocks of an index in index weights (§2.1) and aims to earn the index's total return minus as little as possible. That makes it the cleanest test of how costs and practical frictions show up in returns.
- An index fund is a mutual fund that replicates an index; it is bought from and sold to the AMC at the day's NAV, like any other fund.
- An exchange-traded fund (ETF) is also an index-replicating fund, but its units are listed and traded on the stock exchange during market hours through a broker and a demat account, at a market price set in an order book (§2.1). Large investors and designated market makers can create or redeem ETF units with the AMC in big blocks (a "creation unit") by exchanging the underlying basket, which keeps the market price close to the value of the holdings.
- The indicative NAV (iNAV) is an estimate of the ETF's NAV per unit published during the trading day. The ETF trades at a premium if its price $P$ exceeds the iNAV and at a discount if below: premium $=(P-\text{iNAV})/\text{iNAV}$.
Let $R_F$ and $R_I$ be the returns of a fund and of its benchmark's total return index over a period, and $d_t=r_{F,t}-r_{I,t}$ the difference of their daily returns.
- The tracking difference is $\text{TD}=R_F-R_I$: by how much the fund lagged (or led) the index — usually negative, roughly the costs.
- The tracking error is the annualised standard deviation of the daily differences: $\text{TE}=s_d\sqrt{252}$, where $s_d$ is the sample standard deviation of the $d_t$ and 252 is the conventional number of trading days in a year.
TD measures the average shortfall; TE measures how erratically the fund follows the index. A fund can have a large TD and a tiny TE (a steady, expensive fund) or the reverse. Indian index funds and ETFs disclose both.
Suppose a fund keeps a fraction $w$ of its assets in cash earning $R_c$ and the rest exactly in the index, pays TER $c$ and incurs trading costs $\kappa$ over a year. Then, to first order, $$R_F\approx(1-w)R_I+wR_c-c-\kappa,$$ so $$\text{TD}\approx-c-\kappa-w\,(R_I-R_c).$$ The term $w(R_I-R_c)$ is the cash drag: it costs return in rising markets and helps in falling ones. The tracking error comes from the parts that vary day to day — cash, imperfect replication, the timing of dividends and of trades — not from the TER, which is charged smoothly.
Why. A portfolio's return is the weighted average of its parts' returns (the same fact as Theorem 2.2), and the expenses and costs are subtracted. A constant daily deduction shifts every $d_t$ by the same amount; it changes the mean of the differences (TD) but not their standard deviation (TE). ∎
| day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| index | 0.620 | −0.350 | 1.100 | 0.050 | −0.800 | 0.480 | 0.270 | −0.120 | 0.950 | −0.400 |
| fund | 0.612 | −0.344 | 1.093 | 0.047 | −0.806 | 0.478 | 0.262 | −0.121 | 0.946 | −0.408 |
Fund Categories, the Riskometer, STP and SWP
Categories. SEBI groups open-ended schemes into broad families with defined mandates, so that funds with the same label invest in a comparable way. Equity schemes include large-cap, mid-cap, small-cap, flexi-cap and multi-cap funds (defined by the market-cap ranks of §2.1), ELSS (tax-saving) funds and sectoral or thematic funds. Debt schemes are defined mainly by the maturity or quality of what they hold — overnight, liquid, short- and medium-duration, corporate bond, gilt and credit-risk funds (their interest-rate sensitivity is studied in §2.3). Hybrid schemes mix equity and debt in stated proportions (conservative, aggressive, balanced-advantage, multi-asset, arbitrage). Index funds, ETFs and funds of funds form another group. The exact category definitions are in SEBI's circulars and change occasionally.
The riskometer. Every scheme displays a riskometer, a dial that currently has six levels from "Low" to "Very High", based on the risk of the scheme's portfolio (for example its equity share, volatility, credit quality and interest-rate sensitivity), and it is reviewed regularly. It ranks risk, not return: "Very High" does not mean high returns are likely, and "Low" does not mean the NAV cannot fall. It describes the product, not whether the product suits a particular investor.
- A systematic transfer plan (STP) redeems a fixed amount $A$ every month from one scheme (often a liquid fund holding a lump sum) and invests it in another (often an equity fund): it turns a lump sum into a SIP. Month $k$ redeems $A/N^{\text{src}}_k$ units of the source and buys $A/N^{\text{dst}}_k$ units of the destination.
- A systematic withdrawal plan (SWP) redeems a fixed amount $W$ every month from a scheme to provide a regular income; month $k$ redeems $W/N_k$ units.
A corpus $C$ earns an assumed constant monthly return $i\gt0$, and $W$ is withdrawn at the end of every month. The balance after $k$ withdrawals is $$B_k=C(1+i)^k-W\,\frac{(1+i)^k-1}{i}.$$ If $W\le iC$ the balance never falls (the withdrawal is at most the monthly return). If $W\gt iC$ the corpus is exhausted after $$n=\frac{-\log\left(1-iC/W\right)}{\log(1+i)}\ \text{months.}$$ Because $W$ is fixed in rupees, an SWP redeems more units when the NAV is low — rupee-cost averaging in reverse.
Why. An SWP is a loan in reverse: the investor "lends" $C$ to the fund and receives "EMIs" of $W$. The balance formula is the outstanding-balance formula of §1.2, and setting $B_n=0$ gives $(1+i)^n=\frac{W}{W-iC}$, which is the stated $n$ (it needs $W\gt iC$). If $W\le iC$, each month's return $iB\ge iC\ge W$ covers the withdrawal. ∎ Real NAVs do not grow at a constant rate: a fall early in the withdrawal period forces more units to be sold at low prices, which shortens the life of the corpus even if the average return is unchanged. This sequence-of-returns risk is simulated in §8.1.
- "A ₹14 NAV fund is cheaper than a ₹480 NAV fund." Only percentage changes matter (Theorem 2.6); a low NAV just means more, smaller units.
- "Past NAV performance shows what the fund will earn." Past returns depend on the period chosen (point-to-point bias, §1.3) and on markets that will not repeat; they are not a forecast.
- "IDCW is extra income on top of my investment." It is paid out of the fund's assets, and the NAV falls by the same amount (Theorem 2.7); it may also be taxed earlier.
- "SIPs cannot lose money" / "SIPs always beat lump sums." Rupee-cost averaging only guarantees an average cost at or below the average NAV (Theorem 2.8). In a steadily rising market a lump sum does better; in a market that falls and stays down, a SIP loses.
- "1% a year is too small to matter." Over 20 years it removes about 18% of a lump sum's final value (Theorem 2.9) — lakhs of rupees on a typical SIP.
- "Direct plans are a different, riskier fund." The portfolio is identical; only the expense ratio, and hence the NAV, differ.
- "An index fund earns exactly the index." It earns the total return index minus costs, cash drag and frictions; compare it with the TRI, not the price index (§2.1).
- "Tracking error is how much the fund lagged." That is the tracking difference; tracking error is the variability of the daily gap.
- "An ETF always trades at its NAV." It trades at a market price that can be at a premium or discount to the iNAV, plus a bid–ask spread (Example 7).
- "A Low riskometer means no risk." It ranks risk; even low-risk categories can see their NAVs fall.
Exercises
All funds and numbers are hypothetical and all rates illustrative. Units to three decimals, NAVs to four, rupees to the nearest rupee unless stated.
- 1 A fund holds investments worth ₹845.60 crore, cash ₹12.40 crore and accrued income ₹0.90 crore; its liabilities are ₹3.10 crore and 31.2 crore units are outstanding. Find the NAV.
- 2 How many units does ₹25,000 buy at a NAV of ₹27.45, ignoring charges?
- 3 Repeat part 2 with an illustrative stamp duty of 0.005% deducted from the amount.
- 4 In part 1, ₹50 crore of new money comes in at the NAV. Show that the NAV is unchanged.
- 5 You hold 500 units bought 400 days ago and 300 units bought 100 days ago; the exit load is an illustrative 1% within 365 days. Redeeming 650 units at NAV ₹36, find the proceeds and the load (FIFO).
- 6 An IDCW of ₹1.50 per unit is declared when the NAV is ₹18.20. For 2,000 units, find the ex-NAV, the payout, and the number of units held under IDCW reinvestment (ignore tax).
- 7 A friend says Fund X (NAV ₹12) "has more room to grow" than Fund Y (NAV ₹480). Explain why this is wrong.
- 1 A ₹5,000 SIP buys at NAVs ₹20, ₹25, ₹16, ₹20. Find the total units and the average cost, and compare with the average NAV.
- 2 For two NAVs ₹20 and ₹30, compute the harmonic and arithmetic means and verify $\bar N-H=(x-y)^2/(2(x+y))$.
- 3 When is a SIP's average cost exactly equal to the average NAV? Give the reason.
- 4 In part 1 the NAV is ₹22 after the fourth instalment. Find the value and the percentage gain on the amount invested.
- 5 NAVs rise steadily: ₹10, 11, 12, 13, 14, 15 in six months. Compare a ₹6,000 SIP with ₹36,000 invested in month 1, both valued at ₹15.
- 6 "Rupee-cost averaging guarantees a profit." Disprove this with a simple NAV sequence.
- 1 A ₹500 crore scheme has a TER of 1.2%. Roughly how much is accrued as expenses each calendar day?
- 2 ₹5,00,000 is invested for 15 years at an assumed gross 11%, in plans with TERs 0.5% and 1.5%. Find both values and their ratio.
- 3 Explain why the ratio in part 2 would be the same if the market had fallen over the 15 years.
- 4 An ₹8,000 monthly SIP (start of month) runs for 25 years at an assumed gross 12%, TERs 0.7% and 1.7%. Find both corpuses and the percentage gap.
- 5 After how many years does a 1 percentage point TER difference cost a lump sum 25% of its final value?
- 6 Compare an exit load of 1% with a TER difference of 1%: which costs more over 10 years, and why?
- 1 In a year an index fund returned 9.62% and its benchmark TRI 10.05%; its TER is 0.30%. Find the TD and say what might explain the rest of it.
- 2 The daily differences (fund minus index, in %) on six days are +0.01, −0.02, 0.00, −0.01, +0.02, −0.01. Find their sample standard deviation and the annualised tracking error.
- 3 A fund keeps 3% in cash earning 6% while the index returns 15%. Estimate the cash drag. What happens if the index returns −10%?
- 4 An ETF trades at ₹112.40 with iNAV ₹112.10. Find the premium and roughly how much extra a ₹50,000 purchase pays.
- 5 ₹6,00,000 is placed in a liquid fund at NAV ₹3,000 and moved by an STP of ₹1,00,000 a month for six months into an equity fund. The liquid NAVs on the transfer dates are ₹3,000, 3,015, 3,030.1, 3,045.2, 3,060.4, 3,075.7 and the equity NAVs ₹80, 76, 79, 83, 81, 85. Find the liquid units redeemed, the equity units bought and the average cost of the equity units.
- 6 An SWP withdraws ₹20,000 a month from ₹30,00,000 at an assumed 6% a year (effective). Is it sustainable for ever? If not, how long does it last?
- 7 What does a fund's riskometer tell an investor, and what does it not tell her?
E1. NISM-style A scheme's assets are worth ₹520 crore and its liabilities ₹8 crore; 16 crore units are outstanding. Its NAV is (A) ₹32.50 (B) ₹32.00 (C) ₹33.00 (D) ₹31.50.
E2. NISM-style An investor's monthly SIP of ₹6,000 buys units at NAVs of ₹30, ₹20 and ₹24. Her average cost per unit is (A) ₹24.67 (B) ₹24.00 (C) ₹24.33 (D) ₹25.00.
E3. NISM-style The tracking error of an index fund is best described as (A) the difference between the fund's return and the index's return over a year (B) the annualised standard deviation of the differences between the fund's and the index's daily returns (C) the fund's total expense ratio (D) the fund's beta with respect to the index.
E4. Case study An investor holds ₹15,00,000 in the regular plan (TER 1.8%) of a fund, bought more than a year ago, with an unrealised gain of ₹5,00,000. Switching to the direct plan (TER 0.8%) is a redemption plus a purchase. Assume no exit load and an illustrative tax of 12.5% on the gain (ignore any exemption). (a) How much is invested in the direct plan after the switch? (b) Ignoring the tax the regular plan would pay later, after how many years does the direct plan catch up? (c) Why does part (b) overstate the break-even time?
E5. Case study A retiree has ₹60,00,000 and needs ₹40,000 a month through an SWP. Assume a steady 8% a year (effective). (a) Is the SWP sustainable for ever? (b) How long does it last? (c) Suppose instead that markets fall 20% just after he starts, so the corpus becomes ₹48,00,000, and then returns 8% a year. How long does it last now?
E6. Interview You invest equal rupee amounts on two days at NAVs $x$ and $y$; a friend buys equal numbers of units on the same two days. Who has the lower average cost, by exactly how much, and what does this say about volatility?
Suggested plan — 2 lectures × 60 min.
- NAV, units and SIPs. Open with the 📍 situation and ask: "Which is cheaper, a ₹14 NAV or a ₹480 NAV?" NAV and units (Definition 2.7, Theorem 2.6, Example 1); FIFO and exit loads (Example 2); growth vs IDCW (Theorem 2.7, Example 3). Then the SIP's harmonic mean (Theorem 2.8) with Example 4 on the board, and project Interactive 1: first "fall, then recovery" (the SIP shines), then "steady rise" (the lump sum wins).
- Costs and tracking. Expense drag (Theorem 2.9) with Example 5 and the 📈 Market case table — ask the class to guess the 30-year gap before revealing it. Index funds, ETFs and tracking (Definitions 2.10–2.11, Theorem 2.10, Examples 6–7); project Interactive 2 and change one slider at a time (TER moves the purple line, noise makes the amber line wobble, cash drag follows the market). End with SWP (Theorem 2.11, Example 8) and Practice corner E5.
Class activity. Give each pair a printed factsheet of a (hypothetical) fund with its direct and regular TERs. Each pair computes the 20-year cost of the TER difference on a ₹5,000 SIP under two different return assumptions and shows that the lump-sum ratio does not depend on the assumption.
Misconceptions to watch for. Low NAV = cheap; IDCW = extra income; SIP = guaranteed profit; "1% doesn't matter"; tracking error confused with tracking difference; comparing an index fund with the price index.
Suggested homework. I(1, 4, 5, 6), II(1, 2, 5, 6), III(2, 3, 4, 5), IV(1, 2, 3, 6); Practice corner E2, E4, E6.
Project. Download the NAV history of the direct and regular plans of one index fund, and of its benchmark's total return index, and measure the cost of the regular plan, the fund's tracking difference and its tracking error — then replay a SIP through the history.
Why it matters. Factsheets quote these numbers; computing them yourself shows exactly what they mean and how sensitive they are to the period chosen.
What to do.
- From the AMFI website (historical NAVs) download two years of daily NAVs of both plans of an index fund; from the index provider's website download the same dates of its TRI. Put dates in A, direct NAV in B, regular NAV in C, TRI in D, aligned by date.
- Daily returns: E2
=B3/B2-1, F2=C3/C2-1, G2=D3/D2-1; differences H2=E2-G2, I2=F2-G2. - Over the last 252 rows: TD of each plan
=PRODUCT(1+E2:E253)-PRODUCT(1+G2:G253)(array formula) and TE=STDEV.S(H2:H253)*SQRT(252). Compare the TD gap between plans with their TER difference. - Check Theorem 2.9:
=(C_last/C_first)/(B_last/B_first)against=EXP(-(TER_reg-TER_dir)*years). - SIP replay: pick the first trading day of each month, put ₹5,000 in column K, units
=K2/B2in L; average cost=SUM(K:K)/SUM(L:L)and the harmonic mean=COUNT(L:L)/SUMPRODUCT(1/B_dates); compare with=AVERAGE(B_dates).
Python version: d=fund.pct_change()-tri.pct_change(); TD=(1+fund.pct_change()).prod()-(1+tri.pct_change()).prod(); TE=d.std()*252**0.5; units=(5000/nav_monthly).sum().
Hand in: a one-page note with each plan's TD and TE, the measured cost ratio vs $e^{-\Delta c\,T}$, and your SIP's average cost vs the average NAV.
Going further. Do the same for an ETF on the same index, using its exchange closing price instead of its NAV: how much of its tracking error comes from premiums and discounts?
🧪 Self-check quiz
Q1. Fund P has NAV ₹20 and fund Q has NAV ₹200; both hold similar portfolios. Which statement is right?
Q2. The average cost per unit of a SIP of a fixed rupee amount is
Q3. Two plans of the same fund differ in TER by 1 percentage point. After 25 years a lump sum in the costlier plan is worth about
Q4. A fund declares an IDCW of ₹2 per unit when its NAV is ₹30. Immediately afterwards
Q5. Index fund A has tracking difference −0.20% and tracking error 0.05%; index fund B has tracking difference −0.20% and tracking error 0.60%. Which statement is right?