Chapter 1 · Money, Time and Returns

1.3 Measuring Returns: CAGR, XIRR, NPV and Rolling Returns

Did your investment do well? Absolute return, CAGR, the gap between average return and CAGR, log returns, NPV and IRR for decisions, XIRR for a SIP with redemptions (solved by Newton's method), and rolling returns that expose the point-to-point trap.

📍 The situation

Meera, 34, has run a ₹10,000 monthly SIP in a hypothetical "Fund A — Flexi Cap, Direct Growth" for two years. Midway she redeemed ₹50,000 for a medical bill. Her statement says: invested ₹2,40,000, redeemed ₹50,000, current value ₹2,29,187. Her colleague divides the ₹39,187 gain by ₹2,40,000 and calls it "16% in two years, so 8% a year — no better than an FD". Her brother says his own fund "averaged 10% a year" over five years, although ₹1 lakh in it has grown only to ₹1.41 lakh. Her father is wondering whether ₹2.4 lakh of rooftop solar panels "pays", and a factsheet for another fund advertises a three-year return of 22.6% a year. Which of these numbers mean what they seem to?

All of them are questions about measuring a return. A single number has to summarise money that went in and came out at different dates, in years that were good and bad. In this section we build the honest measures: CAGR for a lump sum, the geometric (not arithmetic) mean for a sequence of yearly returns, log returns that add up over time, NPV and IRR for decisions, XIRR for real SIPs (found with Newton's method from calculus), and rolling returns that show a fund's whole record rather than one flattering start date.

⚠️ About the numbers on this page

NAVs, prices, fund returns and interest rates on this page are hypothetical or simulated, chosen to make the arithmetic realistic. They are not the record of any real fund or index, and they are not forecasts. Past returns, however measured, do not predict future returns. Rules on how funds must report performance, and the tax on gains, are set by SEBI, AMFI and the Income Tax Department and can change; check the current position. People, funds and products are hypothetical, and nothing here is investment advice.

Absolute Return, CAGR and Annualising

Start with the simplest case: one amount invested on one date and valued on another. A mutual-fund unit bought at an NAV of ₹45.20 and worth ₹78.60 later has clearly gained — but "73.9%" means very different things over two years and over ten. To compare investments held for different lengths of time, we convert every return to a rate per year, using the compound growth of §1.1.

📘 Definition 1.10 — Absolute return, CAGR and annualised return

Suppose a value $V_0\gt0$ becomes $V_1\ge0$ after $t\gt0$ years (for dates, $t=\text{days}/365$), with no money added or withdrawn in between.

  • The absolute (holding-period) return is $R=\dfrac{V_1}{V_0}-1$.
  • The compound annual growth rate (CAGR) is the constant yearly rate $g$ that turns $V_0$ into $V_1$ in $t$ years with annual compounding: $V_0(1+g)^t=V_1$.
  • Annualising a return $R$ earned over $t$ years means converting it to the equivalent CAGR; de-annualising a yearly rate $g$ means finding the total return over $t$ years.
📐 Theorem 1.12 (Formula) — CAGR, annualising and de-annualising

Under the conditions of Definition 1.10, $$g=\left(\frac{V_1}{V_0}\right)^{1/t}-1=(1+R)^{1/t}-1,$$ and a yearly rate $g$ held for $t$ years gives the total return $$R=(1+g)^t-1.$$ For a fund, $V_1/V_0$ is simply the ratio of the NAVs on the two dates (in a growth option, where no payouts are made).

Why. Solve $V_0(1+g)^t=V_1$: divide by $V_0$ and take the $t$-th root. The two formulas are inverse functions of each other. Note that $g$ is not $R/t$: dividing by $t$ ignores compounding, exactly the simple-interest mistake of §1.1. ∎

✏️ Example 1 — From two NAVs to a CAGR
A unit of Fund A had an NAV of ₹45.20 on 12 March 2021 and ₹78.60 on 20 June 2025 (hypothetical NAVs). Find the absolute return and the CAGR. Compare with the "simple average" $R/t$.
Time From 12 Mar 2021 to 20 Jun 2025 is 1,561 days, so $t=1561/365\approx4.2767$ years.
Absolute $R=78.60/45.20-1\approx0.7389$, a gain of 73.89%.
CAGR $g=1.7389^{1/4.2767}-1\approx0.1381$, i.e. about 13.81% a year.
Compare $R/t\approx17.28\%$ overstates the yearly rate, because it ignores that each year's gain builds on the previous ones. Check: $1.1381^{4.2767}\approx1.739$. ✓
✏️ Example 2 — When annualising helps, and when it misleads
(a) A debt fund returned 4% in three months. What is that per year, with compounding? (b) A share rose 3% in 10 days; annualise it. (c) A fund's three-year CAGR is 12%: what is its total three-year return? (d) A bond fund gained 15% in 18 months: what CAGR is that?
(a) $t=0.25$: $g=1.04^{4}-1\approx16.99\%$ (not $4\times4\%=16\%$).
(b) $t=10/365$: $g=1.03^{36.5}-1\approx194\%$ a year. The arithmetic is correct, but the answer is meaningless: it assumes the next 355 days repeat the best 10. Short-period returns of risky assets are mostly noise.
(c) $R=1.12^3-1\approx40.49\%$ over three years (not 36%).
(d) $g=1.15^{1/1.5}-1\approx9.77\%$ a year.
Convention This is why fund factsheets commonly show absolute returns for periods under one year and annualised (CAGR) returns for longer periods. Check the current SEBI/AMFI format for performance disclosure.

Average Return vs CAGR, and Log Returns

A fund's yearly returns over five years were +40%, −25%, +30%, −10% and +15%. Their average is exactly 10%, so a salesperson might say "10% a year". But ₹1,00,000 at 10% a year for five years would become ₹1,61,051, while the fund actually turned it into ₹1,41,278. The average is the wrong kind of mean for growth.

📘 Definition 1.11 — Arithmetic and geometric mean returns

For period returns $R_1,\dots,R_n$, each greater than $-1$:

  • the arithmetic mean return is $A=\dfrac{R_1+\cdots+R_n}{n}$;
  • the geometric mean return is $$G=\big[(1+R_1)(1+R_2)\cdots(1+R_n)\big]^{1/n}-1.$$

Since the value is multiplied by $(1+R_1)\cdots(1+R_n)$ over the $n$ periods, $G$ is exactly the CAGR over those periods (Theorem 1.12). $A$ is the right number to forecast a single typical year; $G$ is the right number to describe growth over many years.

📐 Theorem 1.13 — The average return is never below the CAGR

For returns $R_1,\dots,R_n\gt-1$, $$G\le A,$$ with equality if and only if all the $R_k$ are equal. For returns of moderate size, with $\sigma$ the standard deviation of the $R_k$ (population formula), $$G\approx A-\frac{\sigma^2}{2}.$$ The gap $\sigma^2/2$ is called volatility drag: more variable returns compound to less.

Proof. Put $x_k=1+R_k\gt0$ and let $M=\frac1n\sum x_k=1+A$. We use a fact from calculus: $\log y\le y-1$ for all $y\gt0$, with equality only at $y=1$ (the line $y-1$ is the tangent to the concave curve $\log y$ at $y=1$). Apply it to $y=x_k/M$ and add: $$\sum_{k=1}^n\log\frac{x_k}{M}\le\sum_{k=1}^n\Big(\frac{x_k}{M}-1\Big)=\frac{nM}{M}-n=0.$$ So $\sum\log x_k\le n\log M$, i.e. $(x_1\cdots x_n)^{1/n}\le M$, which is $1+G\le1+A$. Equality needs every $x_k/M=1$, i.e. all returns equal. (This is the AM–GM inequality.)

The approximation. For small $R$, $\log(1+R)\approx R-\frac{R^2}{2}$. Averaging over the $n$ periods, $\log(1+G)=\frac1n\sum\log(1+R_k)\approx A-\frac{A^2+\sigma^2}{2}$, because the mean of $R_k^2$ is $A^2+\sigma^2$. The left side is also $\approx G-\frac{G^2}{2}$, and with $G\approx A$ the squared terms cancel, leaving $G\approx A-\frac{\sigma^2}2$. ∎

✏️ Example 3 — "It averaged 10% a year"
For the yearly returns +40%, −25%, +30%, −10%, +15%, find the arithmetic mean, the CAGR, the standard deviation and the approximation $A-\sigma^2/2$. What did ₹1 lakh become?
Average $A=(40-25+30-10+15)/5=10\%$.
Growth $1.40\times0.75\times1.30\times0.90\times1.15=1.412775$, so ₹1,00,000 became ₹1,41,278 and $$G=1.412775^{1/5}-1\approx7.16\%.$$
Spread Mean of squares $=(0.16+0.0625+0.09+0.01+0.0225)/5=0.069$, so $\sigma^2=0.069-0.01=0.059$, $\sigma\approx24.3\%$, and $A-\sigma^2/2=10\%-2.95\%=7.05\%$ — close to the true 7.16%.
Moral "Averaged 10%" is arithmetically true and economically misleading: the investor's money grew at about 7.2% a year. Compounding ₹1 lakh at the average, 10%, would claim ₹1,61,051.

Log returns. Simple returns multiply over time: $(1+R_1)(1+R_2)\cdots$. Taking logarithms turns that product into a sum, which is why analysts and finance theory often work with log returns (the continuous compounding of §1.1 in reverse).

📘 Definition 1.12 — Log return (continuously compounded return)

If a price moves from $P_0\gt0$ to $P_1\gt0$, the log return is $r=\log\dfrac{P_1}{P_0}=\log(1+R)$, where $\log$ is the natural logarithm (LN in a spreadsheet) and $R$ is the simple return. Equivalently $P_1=P_0e^{r}$: $r$ is the continuously compounded rate over the period.

📐 Theorem 1.14 (Formula) — Log returns add over time
  1. For prices $P_0,P_1,\dots,P_n\gt0$ with period log returns $r_k=\log(P_k/P_{k-1})$, $$\log\frac{P_n}{P_0}=r_1+r_2+\cdots+r_n.$$
  2. Conversions: $R=e^r-1$ and $r=\log(1+R)\le R$, with equality only when $R=0$.
  3. $\log(1+\text{CAGR})$ is the average yearly log return; a mean daily log return $\bar r$ corresponds to an annual log return of about $252\,\bar r$ (using the convention of 252 trading days a year).
  4. Across assets it is the other way round: a portfolio's simple return is the weighted average of its holdings' simple returns, but its log return is not the weighted average of their log returns.

Why. (1) $\log\frac{P_n}{P_0}=\log\Big(\frac{P_1}{P_0}\cdot\frac{P_2}{P_1}\cdots\frac{P_n}{P_{n-1}}\Big)$, and the log of a product is the sum of the logs — the product "telescopes". (2) is $\log y\le y-1$ with $y=1+R$. (3) follows from (1) applied to yearly or daily periods. (4) A portfolio with weights $w_j$ (summing to 1) in assets with simple returns $R_j$ grows by $\sum w_j(1+R_j)=1+\sum w_jR_j$; the log of a sum is not the sum of the logs. ∎

✏️ Example 4 — Five closing prices of Alpha Bank Ltd
A (hypothetical) share closes at ₹500, ₹520, ₹494, ₹510 and ₹535 on five trading days. (a) Find the four daily simple and log returns. (b) Show that the log returns add to the log of the total move, while the simple returns do not add to the total return. (c) A portfolio holds 60% in one stock that returns +10% and 40% in another that returns −5%. Find its simple and log return.
(a) Simple: +4.00%, −5.00%, +3.24%, +4.90%. Log: $\log1.04\approx0.03922$, $\log0.95\approx-0.05129$, $\log(510/494)\approx0.03188$, $\log(535/510)\approx0.04786$.
(b) Log returns sum to $0.06766=\log(535/500)=\log1.07$ ✓. The simple returns sum to 7.14%, but the true total return is 7.00%: simple returns compound, they do not add.
(c) Simple: $0.6\times10\%+0.4\times(-5\%)=4.00\%$ exactly. Its log return is $\log1.04\approx3.92\%$, while the weighted average of the log returns is $0.6\log1.1+0.4\log0.95\approx3.67\%$ — wrong.
Rule Add log returns across time; average simple returns across assets. A loss of 50% followed by a gain of 50% has log returns $\log0.5+\log1.5=\log0.75$: the investor is down 25%.

NPV, IRR and XIRR: Irregular Cash Flows and Decisions

CAGR needs one amount in and one amount out. Real life is messier: a SIP puts money in every month and a redemption takes some out; a rooftop solar system costs money now and saves money for fifteen years. The tool is the present value of §1.1, applied to every cash flow and added up.

📘 Definition 1.13 — Net present value and internal rate of return

A project has cash flows $C_0,C_1,\dots,C_n$ at the ends of periods $0,1,\dots,n$ (money paid out is negative, money received positive). At a rate $x\gt-1$ per period its net present value is $$\text{NPV}(x)=\sum_{k=0}^{n}\frac{C_k}{(1+x)^k}.$$ An internal rate of return (IRR) is a rate $x^*\gt-1$ with $\text{NPV}(x^*)=0$. The discount rate (hurdle rate, cost of capital) $k$ is the return available elsewhere on money of similar risk — what the money could earn, or what it costs to borrow.

📘 Definition 1.14 — XIRR

For cash flows $C_0,\dots,C_m$ on dates $d_0\le d_1\le\cdots\le d_m$, put $t_k=(d_k-d_0)/365$ years. The XIRR is the annual rate $x$ that solves $$f(x)=\sum_{k=0}^{m}C_k\,(1+x)^{-t_k}=0.$$ For an investor, every purchase or SIP instalment is negative, every redemption or dividend received is positive, and the current value is entered as a final positive flow on the valuation date. This is what a spreadsheet's XIRR(values, dates) computes.

📐 Theorem 1.15 — The NPV rule, and when the IRR is unique

Suppose every outflow ($C_k\lt0$) happens no later than a time $a$, every inflow ($C_k\gt0$) happens after $a$, and there is at least one of each. Then $f$ (the NPV or XIRR function) has exactly one root $x^*\gt-1$, with $f(x)\gt0$ for $x\lt x^*$ and $f(x)\lt0$ for $x\gt x^*$. Consequently, at a discount rate $k\gt-1$: $$\text{NPV}(k)\gt0\iff x^*\gt k.$$ NPV rule: a project is worth doing if its NPV at the discount rate is positive; among mutually exclusive projects choose the one with the largest NPV. If outflows and inflows alternate, $f$ may have several roots or none, and only the NPV rule is reliable.

Proof. Multiplying $f$ by the positive number $(1+x)^{a}$ does not change its roots or signs, so study $g(x)=(1+x)^a f(x)=\sum C_k(1+x)^{a-t_k}$. An outflow term $-|C_k|(1+x)^{a-t_k}$ has exponent $\ge0$, so it is non-increasing in $x$. An inflow term $C_k(1+x)^{a-t_k}$ has a negative exponent, so it is strictly decreasing. Hence $g$ is strictly decreasing on $(-1,\infty)$. As $x\to-1^+$ the inflow terms tend to $+\infty$, so $g\to+\infty$; as $x\to\infty$ the inflow terms tend to 0, while for $x\ge0$ each outflow term is at most $-|C_k|$ (its exponent is $\ge0$), so $g$ is eventually negative. A continuous, strictly decreasing function that goes from positive to negative crosses zero exactly once (intermediate value theorem). ∎

✏️ Example 5 — Does rooftop solar pay?
Meera's father can install rooftop solar panels for ₹2,40,000 (an illustrative net cost). He estimates electricity savings of ₹42,000 in the first year, rising 3% a year with tariffs, for 15 years (savings received at each year's end; ignore maintenance and panel ageing). His alternative is a deposit at an illustrative 8%. Find the NPV at 8% and at 12%, the IRR and the payback year.
Set-up $C_0=-2{,}40{,}000$ and $C_k=42{,}000\times1.03^{\,k-1}$ for $k=1,\dots,15$.
PV of savings A geometric series with ratio $q=1.03/1.08$ (§1.2): $$\text{PV}=\frac{42{,}000}{1.08}\cdot\frac{1-q^{15}}{1-q}=\frac{42{,}000\,(1-q^{15})}{0.08-0.03}\approx4{,}27{,}446.$$
NPV At 8%: $4{,}27{,}446-2{,}40{,}000\approx$ ₹1,87,446 > 0. At 12%: ≈ ₹93,837, still positive.
IRR Solving $\text{NPV}(x)=0$ numerically gives $x^*\approx18.3\%$ a year — well above the 8% alternative, as Theorem 1.15 says it must be when the NPV at 8% is positive (one outflow, then only inflows).
Payback Cumulative savings after 5 years are ₹2,22,984, short of ₹2,40,000; after 6 years ₹2,71,673. So the cost is recovered during year 6. Payback ignores the time value of money and everything after it, so use it only as a rough guide.
Limits The answer rests on assumptions — the savings, tariff growth, panel life, maintenance — so a careful buyer recomputes the NPV under pessimistic ones too.

Finding the IRR or XIRR. Except in special cases (Exercises III), $f(x)=0$ cannot be solved by algebra, so a spreadsheet solves it numerically. The standard method comes from calculus: replace the curve by its tangent line and see where the tangent crosses zero.

📐 Theorem 1.16 (Formula) — Newton's method for XIRR

With $f(x)=\sum_k C_k(1+x)^{-t_k}$, its derivative is $$f'(x)=-\sum_{k}t_k\,C_k\,(1+x)^{-t_k-1},$$ and Newton's iteration from a starting guess $x_0\gt-1$ is $$x_{j+1}=x_j-\frac{f(x_j)}{f'(x_j)}.$$ If $f'(x^*)\ne0$ and $x_0$ is close enough to the root $x^*$, the iterates converge to $x^*$ and the number of correct digits roughly doubles at each step.

Why. Differentiate term by term: $\frac{d}{dx}(1+x)^{-t}=-t(1+x)^{-t-1}$. The tangent at $x_j$ is $y=f(x_j)+f'(x_j)(x-x_j)$, which is zero at $x_{j+1}$. Near the root, $f$ is almost a straight line, so the tangent's zero is a much better guess; the error after a step is roughly proportional to the square of the error before it (the proof uses Taylor's theorem). Far from the root, or where $f'(x)\approx0$, a step can overshoot wildly — try it in Interactive 1. When the only outflow is the first one, $f$ is decreasing and convex, and Newton started below the root climbs steadily to it. ∎

🧭 How to compute the XIRR of your own SIP
  1. List every cash flow with its date: each instalment as a negative amount, each redemption or payout received as a positive amount.
  2. Add one final positive flow: the current value of the units still held, on the valuation date.
  3. Convert dates to years from the first date: $t_k=(d_k-d_0)/365$.
  4. Start from a guess such as $x_0=10\%$ and iterate $x_{j+1}=x_j-f(x_j)/f'(x_j)$ until $f(x_j)$ is within a rupee of 0 (or use =XIRR(values, dates, 0.1)).
  5. Check: discount every flow at the answer and confirm that they sum to about zero. If the method fails, try a different guess, and look for alternating outflows and inflows (Theorem 1.15).
✏️ Example 6 — XIRR with Newton's method by hand
An investor puts ₹50,000 into a fund on 1 Jan 2024 and ₹30,000 on 1 Jul 2024, redeems ₹20,000 on 1 Apr 2025, and holds units worth ₹75,000 on 1 Jan 2026 (hypothetical). Find the XIRR with Newton's method from $x_0=10\%$.
Times Days from 1 Jan 2024: 0, 182, 456, 731, so $t=0,\ 0.49863,\ 1.24932,\ 2.00274$ years.
Function $$f(x)=-50{,}000-\frac{30{,}000}{(1+x)^{0.49863}}+\frac{20{,}000}{(1+x)^{1.24932}}+\frac{75{,}000}{(1+x)^{2.00274}}.$$
Iterate
$j$$x_j$$f(x_j)$ (₹)$f'(x_j)$ (₹)
010.0000%1,114.55−1,20,019
110.9286%14.14−1,16,992
210.9407%0.00−1,16,953
For instance $x_1=0.10-\dfrac{1{,}114.55}{-1{,}20{,}019}\approx0.109286$.
Answer XIRR ≈ 10.94% a year. Two steps were enough: the error went from about $10^{-2}$ to $10^{-4}$ to $10^{-8}$, the "doubling of digits" of Theorem 1.16.
Compare The simple gain is $(20{,}000+75{,}000-80{,}000)/80{,}000=18.75\%$ — a number with no time scale. The XIRR accounts for when each rupee went in and came out.
Interactive 1 — XIRR by Newton's Method: Following the Tangent

The thick curve is $f(x)$, the present value of all the cash flows at annual rate $x$; the XIRR is where it crosses zero (green). From the current guess (red) Newton's method follows the blue tangent down to the axis to get the next guess. Choose a case and a starting guess, then Step or Play. In the "two IRRs" case, try starting at 0%, 15% and 30%. Cash flows are hypothetical.

10%
step $j$—
guess $x_j$—
$f(x_j)$—
slope $f'(x_j)$—
next guess $x_{j+1}$—
root(s) of $f$—
✏️ Example 7 — When IRR and NPV disagree, and when IRR is not unique
(a) Project S costs ₹1,00,000 and returns ₹1,30,000 after one year. Project L costs ₹10,00,000 and returns ₹4,00,000 at the end of each of the next three years. Only one can be done, and money costs 8%. Compare their IRRs and NPVs. (b) A project has cash flows −100, +230, −132 (in ₹ thousand) at years 0, 1, 2. Find all its IRRs and its NPV at 8%.
(a) S IRR: $1{,}30{,}000/1{,}00{,}000-1=30\%$. NPV at 8%: $1{,}30{,}000/1.08-1{,}00{,}000\approx$ ₹20,370.
(a) L NPV at 8%: $4{,}00{,}000\times\dfrac{1-1.08^{-3}}{0.08}-10{,}00{,}000\approx$ ₹30,839. IRR (numerically) ≈ 9.70%.
(a) Decide IRR ranks S first, NPV ranks L first. NPV is the right criterion: L adds about ₹30,800 of value today, S about ₹20,400. IRR ignores scale — 30% on ₹1 lakh is less money than 9.7% on ₹10 lakh when the rest of the money can earn only 8%. (The rankings agree only for discount rates above about 8.6%.)
(b) With $y=1/(1+x)$: $-100+230y-132y^2=0$, i.e. $132y^2-230y+100=0$, so $y=\dfrac{230\pm\sqrt{52{,}900-52{,}800}}{264}=\dfrac{230\pm10}{264}$, giving $y=10/11$ or $y=5/6$: IRR = 10% and 20%. The cash flows change sign twice, so Theorem 1.15 does not apply.
(b) NPV At 8%: $-100+230/1.08-132/1.08^2\approx-0.21$ (₹ thousand), negative; the NPV is positive only for rates between 10% and 20%. "The IRR is 10%" or "20%" is meaningless here — use the NPV.
📈 Market case — Meera's SIP: 8%, 16% or 16.6%?

Meera invested ₹10,000 on the 5th of every month from January 2023 to December 2024 (24 instalments, ₹2,40,000). The hypothetical NAV of Fund A started at ₹50.00, dipped to about ₹45 in mid-2023 and recovered to ₹59.10 by the last instalment. She bought 4,693.616 units in all (an average cost of about ₹51.13 per unit — the harmonic mean of §2.2). On 12 August 2024 she redeemed ₹50,000 at an NAV of ₹56.40 (886.525 units). On 31 December 2024 the NAV is ₹60.20, so her 3,807.091 remaining units are worth ₹2,29,187.

  1. Absolute return. Gain $=2{,}29{,}187+50{,}000-2{,}40{,}000=$ ₹39,187, i.e. 16.33% of the money invested. But over what period? The first rupee was invested for two years, the last for less than a month.
  2. The colleague's "CAGR". Treating all ₹2,40,000 as invested on 5 Jan 2023 (1.989 years earlier): $(2{,}79{,}187/2{,}40{,}000)^{1/1.989}-1\approx7.90\%$. This understates the return, because most of the money was invested for much less than two years.
  3. XIRR. 24 outflows of ₹10,000, an inflow of ₹50,000 on 12 Aug 2024 and a final inflow of ₹2,29,187 on 31 Dec 2024. Newton from 10% gives 15.943% → 16.564% → 16.570%: XIRR ≈ 16.57% a year (Interactive 1, first case). Check: had each of her instalments instead earned an illustrative 7.25% a year in a deposit, with the same ₹50,000 withdrawal, she would have about ₹2,06,813 now — ₹22,000 less.
  4. XIRR vs the fund's own return. The fund's NAV went from ₹50.00 to ₹60.20 over the same 1.989 years: a point-to-point CAGR of only 9.78%. Meera's XIRR is higher because her SIP happened to buy many units during the 2023 dip. XIRR is a money-weighted return: it measures the investor's experience, including the timing of her flows. The fund's CAGR is time-weighted: it measures the fund. Another investor in the same fund, with different dates, would get a different XIRR.

The mathematics, not a recommendation. The honest summary is "my money earned about 16.6% a year over these two years, helped by a dip early on; the fund itself returned about 9.8% a year over the period, before tax". Neither number is a forecast, and both are pre-tax: gains on redemption may be taxed (check the current rules).

Rolling Returns and the Point-to-Point Trap

A factsheet's "3-year return" is computed from one start date to one end date. Move either date by a few months, across a crash or a rally, and the number can change completely. Rolling returns replace that single number by the whole distribution of returns over every window of the same length.

📘 Definition 1.15 — Trailing (point-to-point) and rolling returns

Let $N_s$ be a fund's NAV at date $s$. The point-to-point return over $w$ years ending at date $s$ is the CAGR $$\rho_w(s)=\left(\frac{N_s}{N_{s-w}}\right)^{1/w}-1.$$ When $s$ is today it is called the trailing $w$-year return. The rolling $w$-year returns are the values $\rho_w(s)$ for every end date $s$ in the history (daily, monthly or yearly steps), summarised by their minimum, median, maximum and the share of windows with a loss or above a chosen rate.

Rolling returns answer the question an investor actually faces: "if I had invested for $w$ years starting at a random date, what range of outcomes did this fund deliver?" A trailing return answers only "what happened from one particular date to today?" — and that date may have been chosen, consciously or not, because it flatters.

✏️ Example 8 — One fund, eight three-year returns
Fund B (hypothetical) had year-end NAVs (₹) of 10.00, 12.10, 13.80, 11.00, 8.25, 10.90, 13.40, 15.20, 14.10, 17.60, 21.00 at the ends of Years 0 to 10. (a) Find the yearly returns, their average and the 10-year CAGR. (b) Find all eight rolling 3-year CAGRs and summarise them. (c) A factsheet at the end of Year 7 reported "3-year return: 22.6% a year". Comment.
(a) Yearly returns: +21.0, +14.0, −20.3, −25.0, +32.1, +22.9, +13.4, −7.2, +24.8, +19.3 (%). Average 9.52%, but the 10-year CAGR is $(21.00/10.00)^{1/10}-1\approx7.70\%$ (Theorem 1.13).
(b) $\rho_3$ at the ends of Years 3–10:
end of Year345678910
3-y CAGR %3.23−11.99−7.566.8022.598.969.5111.38
Worst −12.0%, median 7.9%, best 22.6%; 2 of the 8 windows lost money, and only 2 beat 10% a year.
(c) The Year-7 figure is $(15.20/8.25)^{1/3}-1\approx22.6\%$, measured from the very bottom of the fall (Year 4). It is the best of the eight windows. It was arithmetically correct, but taken alone it is a poor guide: an investor who started at a random year-end got anything from −12% to +22.6% a year, with a median near 8%.
Also At the end of Year 10 the trailing 1-, 3- and 5-year returns are 19.3%, 11.4% and 14.0% a year; one year earlier they were 24.8%, 9.5% and 16.4%. Trailing returns change every day as the window slides — which is exactly what the rolling-return chart displays.
Interactive 2 — Point-to-Point vs Rolling Returns on a Simulated NAV

Top: a simulated 15-year NAV history (random, not a real fund). The amber stretch is one $w$-year window ending at the cursor; its CAGR is what a factsheet dated that month would print. Bottom: the blue curve is the rolling $w$-year CAGR for every end month; the dashed line is its median and the red band marks losses. Slide the end date (or press Play) and watch the "3-year return" swing. Change the window length or the simulated history.

year 15.0
point-to-point CAGR at cursor—
worst window—
median window—
best window—
windows with a loss—
15-y CAGR vs average yearly return—
⚠️ Common mistakes and myths
  1. "Average return = CAGR." The arithmetic mean is always at least the CAGR, by roughly $\sigma^2/2$ (Theorem 1.13). +40%, −25%, +30%, −10%, +15% "averages" 10% but compounds at 7.2% (Example 3).
  2. "Down 50%, up 50%, so I'm back to even." $0.5\times1.5=0.75$: you are down 25%. A 50% fall needs a 100% gain to recover; a 40% fall needs 66.7%.
  3. Annualising a short return. 3% in 10 days "is" 194% a year only if the luck repeats 36 times (Example 2). Report short-period returns as absolute returns.
  4. Judging a SIP by its absolute return, or by a CAGR on the total invested. Money entered at different dates; only the XIRR accounts for that (Market case: 7.9% "CAGR" vs 16.6% XIRR).
  5. "My XIRR beat the fund's return, so I picked well." XIRR is money-weighted: it reflects the timing of your flows (luck, here), not the fund's quality. Compare funds by time-weighted returns over the same period.
  6. "Higher IRR = better project." IRR ignores scale and can be non-unique when cash flows change sign more than once (Example 7). Use NPV at the right discount rate.
  7. Adding simple returns over time, or averaging log returns across stocks. Log returns add across time; simple returns average across assets (Theorem 1.14).
  8. Trusting one point-to-point number. A trailing return depends on its start date; a window that starts at a market bottom flatters (Example 8). Look at rolling returns — and remember that past performance, rolling or not, is not a forecast.
  9. Comparing returns that are not comparable. Different periods, pre-tax vs post-tax, before vs after costs, or a high-risk fund vs a deposit: a return number means little without its period, costs, taxes and risk (Chapters 3 and 8).

Exercises

All data are hypothetical. Use $t=\text{days}/365$ for dates, annual compounding for CAGR and XIRR, and $\log$ for the natural logarithm. Give rates to two decimal places.

I
Absolute return, CAGR and annualising.
  • 1 An NAV rises from ₹120 to ₹186 in exactly 3 years. Find the absolute return and the CAGR.
  • 2 ₹2,50,000 invested on 1 April 2019 is worth ₹4,10,000 on 15 September 2024. Find the CAGR.
  • 3 A fund returned 5% in six months. Annualise it with compounding and without. How should a factsheet show it?
  • 4 A 5-year CAGR of 11% corresponds to what total return?
  • 5 An advertisement says a fund "doubled investors' money in 6 years". What CAGR is that?
  • 6 What CAGR turns ₹5 lakh into ₹15 lakh in 12 years?
  • 7 A share gains 4% in two weeks (14 days). Compute its annualised return and explain why the number should not be quoted.
1 $R=186/120-1=55\%$; $g=1.55^{1/3}-1\approx15.73\%$.
2 1,994 days, $t\approx5.4630$; $g=1.64^{1/5.4630}-1\approx9.48\%$ (absolute 64%).
3 Compounded: $1.05^2-1=10.25\%$; simple: 10%. Since the period is under a year, the factsheet convention is to show the absolute 5%, not an annualised figure.
4 $1.11^5-1\approx68.51\%$.
5 $2^{1/6}-1\approx12.25\%$ a year (the rule of 72 of §1.1 gives $72/6=12\%$).
6 $3^{1/12}-1\approx9.59\%$.
7 $1.04^{365/14}-1\approx178\%$ a year. It assumes the same two-week gain repeats 26 times in a row; short-term price moves are mostly noise, so the annualised figure says nothing about the next year.
II
Average returns, volatility drag and log returns.
  • 1 Returns of +25% and −20% in two years: find the arithmetic mean, the CAGR and what ₹1 lakh became.
  • 2 For yearly returns 12%, 8%, −6%, 18%, find $A$, $G$, $\sigma$ (population) and the approximation $A-\sigma^2/2$.
  • 3 After a 40% fall, what gain is needed to get back to the starting value?
  • 4 Closing prices ₹250, ₹262, ₹255, ₹270: find the three log returns and check that they add to $\log(270/250)$.
  • 5 A stock's mean daily log return is 0.05%. Using 252 trading days, find the annual log return and the equivalent simple annual return.
  • 6 A fund's log returns are 0.15 in Year 1 and −0.08 in Year 2. What is its simple return over the two years?
  • 7 A portfolio is 50% in a stock that returns +30% and 50% in one that returns −10%. Compute the portfolio's simple return, its log return, and the (incorrect) weighted average of the two log returns.
1 $A=2.5\%$; $1.25\times0.80=1$, so $G=0\%$ and ₹1 lakh is still ₹1 lakh.
2 $A=8.00\%$; $G=(1.12\times1.08\times0.94\times1.18)^{1/4}-1\approx7.62\%$; $\sigma\approx8.83\%$; $A-\sigma^2/2\approx8\%-0.39\%=7.61\%$.
3 $1/0.6-1\approx66.67\%$.
4 $\log(262/250)\approx0.04688$, $\log(255/262)\approx-0.02708$, $\log(270/255)\approx0.05716$; sum $0.07696=\log1.08$ ✓.
5 $252\times0.0005=0.126$; simple $e^{0.126}-1\approx13.43\%$.
6 Log returns add: $0.15-0.08=0.07$, so $R=e^{0.07}-1\approx7.25\%$.
7 Simple: $0.5\times30\%+0.5\times(-10\%)=10\%$; log: $\log1.1\approx9.53\%$; weighted logs: $0.5\log1.3+0.5\log0.9\approx7.85\%$ — wrong, as Theorem 1.14(4) warns.
III
NPV, IRR and XIRR.
  • 1 Find the NPV at 10% of the cash flows −₹1,00,000 now, then ₹40,000, ₹50,000 and ₹30,000 at the ends of Years 1–3. Its IRR is about 10.13%; verify the sign of the NPV is consistent with this.
  • 2 Should the project of part 1 be accepted if the discount rate is 12%? Compute the NPV.
  • 3 Find the IRR of investing ₹80,000 now to receive ₹1,00,000 in exactly 2 years, by algebra.
  • 4 ₹1,00,000 invested on 1 Jan 2025 is worth ₹1,08,000 on 1 Oct 2025. Find the XIRR.
  • 5 For cash flows −100, +60, +60 at years 0, 1, 2, carry out one Newton step from $x_0=10\%$. (The IRR is about 13.07%.)
  • 6 Find both IRRs of the cash flows −₹1,000, +₹2,500, −₹1,540 at years 0, 1, 2.
  • 7 For the project of part 6, is the NPV at 8% positive or negative? Explain why "its IRR is 10%" is not a useful summary.
1 $-1{,}00{,}000+\dfrac{40{,}000}{1.1}+\dfrac{50{,}000}{1.1^2}+\dfrac{30{,}000}{1.1^3}\approx$ ₹225. Positive, and indeed IRR 10.13% > 10% (Theorem 1.15: one outflow, then inflows).
2 NPV at 12% ≈ −₹3,073 < 0 — reject: the IRR is below the 12% hurdle.
3 $80{,}000(1+x)^2=1{,}00{,}000$, so $x=\sqrt{1.25}-1\approx11.80\%$.
4 273 days: $x=1.08^{365/273}-1\approx10.84\%$.
5 $f(0.1)=-100+60/1.1+60/1.21\approx4.132$; $f'(x)=-\dfrac{60}{(1+x)^2}-\dfrac{120}{(1+x)^3}$, so $f'(0.1)\approx-139.74$; $x_1=0.1+4.132/139.74\approx12.96\%$, already close to 13.07%.
6 With $y=1/(1+x)$: $1540y^2-2500y+1000=0$, $y=\dfrac{2500\pm300}{3080}$, so $y=10/11$ or $5/7$: IRRs of 10% and 40%.
7 $-1000+2500/1.08-1540/1.08^2\approx-5.49$: negative. The NPV is positive only for rates between 10% and 40%. With two IRRs, neither tells you whether the project is worth doing at 8%; the NPV does.
IV
Rolling returns. Fund E (hypothetical) had year-end NAVs (₹) 20.0, 23.0, 26.5, 21.2, 19.0, 24.7, 28.4, 27.0, 31.5 at the ends of Years 0–8.
  • 1 Find the yearly returns, their average, and the 8-year CAGR.
  • 2 Find the six rolling 3-year CAGRs and their worst, median and best values.
  • 3 Find the trailing 5-year CAGR at the end of Year 6 and at the end of Year 8.
  • 4 A leaflet at the end of Year 6 shows "2-year return: 22.3% a year". Verify it and explain what makes it flattering.
  • 5 In how many of the six 3-year windows did Fund E beat 8% a year?
  • 6 Two funds have the same trailing 5-year return. Name three statistics from their rolling returns that would help you compare them, and say why.
1 +15.0, +15.2, −20.0, −10.4, +30.0, +15.0, −4.9, +16.7 (%); average 7.07%; CAGR $(31.5/20)^{1/8}-1\approx5.84\%$.
2 Windows ending Years 3–8: 1.96, −6.17, −2.32, 10.24, 12.43, 8.44 (%). Worst −6.17%, median ≈ 5.20%, best 12.43%.
3 End of Year 6: $(28.4/23.0)^{1/5}-1\approx4.31\%$. End of Year 8: $(31.5/21.2)^{1/5}-1\approx8.24\%$.
4 $(28.4/19.0)^{1/2}-1\approx22.26\%$ ✓. It starts at Year 4, the lowest NAV in the history; over the two years before that, the fund lost about 15.3% a year.
5 3 of 6 (windows ending Years 6, 7 and 8).
6 For example: (i) the median rolling return — the typical outcome, not one endpoint; (ii) the worst rolling return and the share of windows with a loss — the downside an investor could have suffered; (iii) the spread between best and worst windows — consistency. All should be computed over the same dates for both funds, and they describe the past, not the future.
🎯 Practice corner NISM-styleCase studyInterview

E1. NISM-style The NAV of a growth option rises from ₹20 to ₹32 in exactly 4 years. Its compound annual growth rate is closest to (A) 15.00% (B) 12.47% (C) 60.00% (D) 11.75%.

Compute $(32/20)^{1/4}-1=1.6^{0.25}-1\approx12.47\%$.
Distractors (A) divides the 60% absolute return by 4 (no compounding); (C) is the absolute return; (D) is the yearly log return $\log(1.6)/4$, not the CAGR.
Answer (B).

E2. NISM-style An investor has made monthly SIP instalments for three years, with two partial redemptions in between. The most appropriate measure of the return she earned is (A) the absolute return (B) the CAGR from the first instalment date (C) the XIRR (D) the average of the fund's three calendar-year returns.

Reason The cash flows are on many dates and in both directions; only XIRR discounts each flow for its own time. (A) has no time scale, (B) treats all money as invested at the start, (D) describes the fund, not her flows, and is an arithmetic mean.
Answer (C).

E3. NISM-style A portfolio gains 20% in one year and loses 20% the next. Over the two years the investor has (A) broken even (B) lost 4% (C) gained 4% (D) lost 20%.

Compute $1.2\times0.8=0.96$: a 4% loss. The arithmetic mean is 0%, the CAGR is $\sqrt{0.96}-1\approx-2.02\%$ (Theorem 1.13).
Answer (B).

E4. Case study A savings-cum-insurance plan (hypothetical) asks for ₹1,00,000 at the start of each of 5 years (Years 0–4) and pays ₹6,50,000 at the end of Year 10. (a) Find its IRR. (b) Find its NPV at an illustrative deposit rate of 7%. (c) What would the same five payments have grown to by Year 10 at 7%? (d) What else must be considered before comparing the two?

(a) Solve $-1{,}00{,}000\sum_{k=0}^{4}(1+x)^{-k}+6{,}50{,}000\,(1+x)^{-10}=0$ numerically (one sign change, so a unique root): $x^*\approx3.32\%$ a year.
(b) NPV at 7% ≈ −₹1,08,294: negative, consistent with IRR < 7%.
(c) $1{,}00{,}000\,(1.07^{10}+1.07^{9}+\cdots+1.07^{6})\approx$ ₹8,63,031 — about ₹2.1 lakh more than the plan pays.
(d) The plan includes life cover, which has value; the fair comparison is a pure term-insurance premium plus investing the rest (§8.1). Taxes on each route (check the current rules), lock-in and liquidity also matter. The IRR makes the comparison concrete; it does not make the decision.

E5. Case study Two hypothetical funds had these yearly returns over the same six years. Fund C: +30, −15, +25, −5, +20, +10 (%). Fund D: +12, +8, +14, +6, +11, +9 (%). (a) Find each fund's average return and CAGR. (b) Find each fund's four rolling 3-year CAGRs. (c) Which fund turned ₹1 lakh into more, and what does that illustrate?

(a) C: average 10.83%, CAGR $(1.3\times0.85\times1.25\times0.95\times1.2\times1.1)^{1/6}-1\approx9.59\%$. D: average 10.00%, CAGR ≈ 9.97%.
(b) C: 11.37, 0.31, 12.53, 7.84 (%). D: 11.31, 9.28, 10.28, 8.65 (%).
(c) D: ₹1,76,849; C: ₹1,73,209. C had the higher average but the lower CAGR — volatility drag, about $\sigma^2/2$ with $\sigma_C\approx16.2\%$ vs $\sigma_D\approx2.6\%$. C's rolling returns also ranged from 0.3% to 12.5%, D's only from 8.7% to 11.3%. (This describes the past six years only.)

E6. Interview A fund's NAV is ₹100 today, falls to ₹50 after one year and returns to ₹100 after two years, so its point-to-point return is 0%. An investor puts ₹100 in today and ₹100 after one year. What is her XIRR after two years, and why is it not 0%?

Units She buys 1 unit, then 2 units at ₹50: 3 units worth ₹300 at the end, for ₹200 invested.
XIRR $-100(1+x)^2-100(1+x)+300=0$. With $u=1+x$: $u^2+u-3=0$, $u=\dfrac{-1+\sqrt{13}}{2}\approx1.3028$, so XIRR ≈ 30.3% a year.
Why XIRR is money-weighted: the second instalment bought twice as many units at the low price. The fund's time-weighted return is 0%. This is the "rupee-cost averaging" effect of a SIP (§2.2) — and it works in reverse if prices rise first and fall later, so it is not a free lunch.
🧑‍🏫 For the teacher

Suggested plan — 2 lectures × 60 min.

  1. One number for a return. Open with the 📍 situation and take a show of hands: "Is Meera's return 8%, 16% or something else?" Do Examples 1–2 (CAGR, annualising), then Example 3 on the board: ask the class for the "average return" first, then compute what ₹1 lakh became. Prove Theorem 1.13 with the tangent-line inequality $\log y\le y-1$ — a two-line proof students remember. Log returns and Example 4: emphasise "across time add logs, across assets average simple returns".
  2. Cash flows, decisions and track records. NPV/IRR with the solar case (Example 5) and Theorem 1.15. Project Interactive 1: Example 6 case first, then Meera's case, then the two-IRR case started at 0%, 15% and 30%. Walk through the 📈 Market case. Finish with rolling returns: Example 8, then project Interactive 2 and let a student "choose the factsheet date" that makes the fund look best.

Class activity. Give each group a different (hypothetical) set of SIP dates, amounts and a final value. Each group computes the absolute return, the naive CAGR on the total and the XIRR (by two Newton steps and then with a spreadsheet), and explains on one slide which number to quote and why.

Misconceptions to watch for. Average return = CAGR; annualising a week's gain; "16% in two years = 8% a year" for a SIP; higher IRR always better; an XIRR above the fund's CAGR proves skill; a trailing return describes the fund's typical behaviour.

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

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

Project. (1) Build an XIRR sheet for a SIP — your own, a family member's, or an invented one — and check the spreadsheet's answer with your own Newton iteration. (2) Download a fund's or index fund's NAV history and compute its rolling returns.

Why it matters. Statements and apps show many different "returns". Once you can compute XIRR and rolling returns yourself, you can check any claim and compare funds on the same dates, instead of relying on whichever number is printed largest.

What to do.

  1. Cash-flow sheet. Column A dates, column B amounts (instalments negative, redemptions positive), last row = valuation date and current value (positive). Then =XIRR(B2:B30,A2:A30,0.1).
  2. Your own Newton. In C2 put =(A2-$A$2)/365 (years $t_k$). Put a guess in F1 (say 0.1). In D2 =B2*(1+$F$1)^(-C2) and in E2 =-C2*B2*(1+$F$1)^(-C2-1); copy down. Then =F1-SUM(D:D)/SUM(E:E) in F2 is the next guess; copy the guess into F1 and repeat three or four times. Compare with XIRR.
  3. NAV history. Download daily NAVs of one growth-option fund from the AMFI website or the fund house's website, and keep one NAV per month-end (column A dates, column B NAV).
  4. Rolling returns. For 3-year windows with monthly data, in C38 put =(B38/B2)^(1/3)-1 and copy down. Summarise with =MIN(C:C), =MEDIAN(C:C), =MAX(C:C) and =COUNTIF(C:C,"<0")/COUNT(C:C); chart column C against the dates.
  5. Averages. From the calendar-year-end NAVs compute the yearly returns, their =AVERAGE(), the CAGR and =AVERAGE()-VAR.P()/2; compare (Theorem 1.13).

Python version: nav = df.set_index('date')['nav'].resample('M').last(), then roll3 = (nav / nav.shift(36))**(1/3) - 1 and roll3.describe(); for XIRR, use scipy.optimize.brentq on lambda x: sum(c*(1+x)**(-t) for c,t in flows).

Hand in: your cash-flow table with the XIRR from the spreadsheet and from your Newton steps; the rolling-return chart with min/median/max; and one paragraph on how different the fund looks from its trailing 3-year return.

Going further. Compute the fund's time-weighted return over your SIP period from its NAVs and compare it with your XIRR (Market case). Then compute rolling returns on log returns, $\log(N_s/N_{s-36})/3$, and check that they convert back with $e^r-1$.

Instructor note: for Example 6 the sheet should give XIRR 10.94%, and for the 📈 Market case (24 flows, the ₹50,000 redemption and ₹2,29,187 at the end) 16.57%. Spreadsheet XIRR uses actual days/365, exactly as Definition 1.14. A #NUM! error usually means the signs are wrong (all flows of one sign) or a poor guess; some downloaded NAV files have gaps on holidays — use the last available NAV of each month.

🧪 Self-check quiz

0/5 correct

Q1. A fund returns +50% in one year and −50% in the next. Its CAGR over the two years is about

Q2. XIRR is the rate $x$ that

Q3. Daily log returns of a share over a month are useful because

Q4. Two mutually exclusive projects: A has IRR 25% and NPV ₹40,000 at a 9% discount rate; B has IRR 15% and NPV ₹90,000. Following the NPV rule you choose

Q5. A fund's trailing 3-year return is 24% a year, measured from a market low. Rolling 3-year returns would