3.1 Return, Volatility, Fat Tails and Drawdowns
How much does a fund really swing? Daily returns and volatility, the square-root-of-time rule, histograms, skewness and fat tails, maximum drawdown and recovery maths, and why the compound return is the average minus about $\sigma^2/2$.
📍 The situation
Rohan, 26, works in Bengaluru and runs two SIPs: one in "Fund A — Large Cap Index, Direct Growth" and one in "Fund B — Small Cap, Direct Growth" (both hypothetical). One Tuesday Fund B's NAV falls 4.2% in a single day and his office group chat fills with opinions. One friend says: "Relax — the factsheet says Fund B's volatility is 27%, so the most it can lose in a year is 27%." Another says: "Fund B has averaged 17% a year, Fund A only 13%, so B will make you far richer — it doubles every four years." A third forwards a chart showing that a fund like B once took years to get back to an old high.
Each claim is a statement about the statistics of returns, and each is partly or wholly wrong. To judge them Rohan needs four tools, which are the four parts of this section. How much do returns swing? — volatility, and how to convert a daily figure into a yearly one with the square-root-of-time rule. How often do big days happen? — histograms, skewness, kurtosis and the "fat tails" that make a 4% day far more common than the bell curve suggests. How far can it fall, and how long to recover? — maximum drawdown and the recovery arithmetic in which −50% needs +100%. And why does the average return overstate what you actually earn? — volatility drag, the gap of about $\sigma^2/2$ between the average return and the compound return. The mathematics is school statistics (mean, standard deviation, the normal curve) plus one inequality and one Taylor expansion.
Every price, NAV and return on this page is either a small hypothetical data set chosen to make the arithmetic clear or simulated in your browser by a seeded random-number generator. None of it is the history of a real index, fund or share, and nothing here is a forecast or a recommendation. The funds and companies are hypothetical; the 252-trading-days-a-year figure is a convention. When you apply these tools to a real fund, use its published NAV history (see 🛠️ Do it yourself) and remember that past volatility and drawdowns describe the past only.
Returns and Volatility: from Days to Years
A price series is converted into a return series before anything else is done with it, because returns are comparable across shares of different prices and across time. Rohan's Fund A NAV moving from ₹100 to ₹101 and a share moving from ₹2,000 to ₹2,020 are the same event: a 1% return.
Let $P_0,P_1,\dots,P_n$ be closing prices (or NAVs) at the ends of equal periods — trading days, weeks or months — with dividends reinvested. The period return is $$r_t=\frac{P_t}{P_{t-1}}-1,\qquad t=1,\dots,n.$$ The mean return is $\bar r=\frac1n\sum_{t=1}^n r_t$, and the volatility is the sample standard deviation of the returns, $$s=\sqrt{\frac{1}{n-1}\sum_{t=1}^n\left(r_t-\bar r\right)^2}.$$ Volatility is quoted per period ("daily volatility 1.1%") or, more often, annualised (Theorem 3.1). Its square $s^2$ is the variance.
Finance theory often uses the log return $\log(P_t/P_{t-1})$ instead (§1.3 Measuring Returns); for daily data the two differ by a few hundredths of a percent and everything on this page works for either.
The divisor $n-1$ (not $n$) makes $s^2$ an unbiased estimate of the true variance — spreadsheets call this STDEV.S. With hundreds of daily returns the difference is negligible.
Suppose the returns of successive periods are independent with the same mean $\mu$ and standard deviation $\sigma$, and there are $m$ periods in a year ($m\approx252$ trading days, $52$ weeks or $12$ months). Then, to first order (ignoring compounding within the year), $$\mu_{\text{ann}}\approx m\,\mu,\qquad \sigma_{\text{ann}}=\sigma\sqrt m .$$ More generally, over a horizon of $h$ periods the mean scales like $h$ and the volatility like $\sqrt h$. For daily data, $\sigma_{\text{ann}}=\sigma_{\text{day}}\sqrt{252}\approx15.87\,\sigma_{\text{day}}$; conversely $\sigma_{\text{day}}=\sigma_{\text{ann}}/\sqrt{252}$.
Why $\sqrt{\ }$? Use log returns, which add over time: the log return of the year is the sum $X_1+\cdots+X_m$ of the period log returns. Means always add, so the mean of the sum is $m\mu$. For independent variables the variances add too, $\operatorname{Var}(X_1+\cdots+X_m)=m\sigma^2$, so the standard deviation is $\sigma\sqrt m$. (For simple returns the same holds to first order, since the year's simple return is close to the sum of the period returns.) ∎ The key word is independent: if good days tend to follow good days (momentum) the yearly volatility is larger than $\sigma\sqrt m$; if markets tend to reverse (mean reversion) it is smaller. The 252 is a convention for the number of trading days in a year, not a law.
How well can we know the mean and the volatility? Example 1 hinted at something important: from the same data, volatility is estimated far more precisely than the mean. This is why risk models trust volatility estimates while good analysts are humble about expected returns.
Let $r_1,\dots,r_n$ be independent returns with mean $\mu$ and standard deviation $\sigma$.
- The sample mean $\bar r$ has standard error $\operatorname{SE}(\bar r)=\sigma/\sqrt n$. If the data cover $T$ years, the annualised mean has standard error $$\operatorname{SE}(\text{annual mean})\approx\frac{\sigma_{\text{ann}}}{\sqrt T},$$ whatever the sampling frequency — daily data do not pin the mean down better than yearly data over the same $T$ years.
- For roughly normal returns the sample volatility has standard error $\operatorname{SE}(s)\approx\sigma/\sqrt{2(n-1)}$, which does shrink as the sampling frequency rises.
An approximate 95% interval for a quantity is its estimate $\pm1.96$ standard errors.
Why (part 1). $\operatorname{Var}(\bar r)=\frac1{n^2}\operatorname{Var}(r_1+\cdots+r_n)=\frac1{n^2}\,n\sigma^2=\frac{\sigma^2}n$ by independence. With $m$ periods a year and $T$ years, $n=mT$; the annualised mean $m\bar r$ has standard error $m\sigma/\sqrt{mT}=\sigma\sqrt m/\sqrt T=\sigma_{\text{ann}}/\sqrt T$ — the $m$'s cancel. Part 2 is a standard large-sample result for normal data, which we quote without proof. ∎
The Shape of Returns: Histograms, Skewness and Fat Tails
Mean and volatility describe the centre and the spread of the returns. A histogram — the number of days whose return falls in each small interval — shows the whole shape. The benchmark shape is the normal (bell) curve, under which about 68% of days lie within one standard deviation of the mean, 95% within two and 99.7% within three. Two numbers measure how a real histogram departs from it.
For returns $r_1,\dots,r_n$ with mean $\bar r$, let $m_k=\frac1n\sum_{t=1}^n(r_t-\bar r)^k$ be the $k$-th central moment ($m_2$ is the variance with divisor $n$). Then
- skewness $=\dfrac{m_3}{m_2^{3/2}}$ — negative when the left tail is longer (occasional large falls, many small gains), positive when the right tail is longer;
- kurtosis $=\dfrac{m_4}{m_2^{2}}$, and excess kurtosis $=$ kurtosis $-\,3$.
Both are unit-free. A normal distribution has skewness $0$ and kurtosis $3$ (excess kurtosis $0$). Spreadsheet functions SKEW and KURT use small-sample corrections, and KURT already reports the excess kurtosis; for long series the corrections are negligible.
A return distribution has fat tails (is leptokurtic) if its excess kurtosis is positive: compared with a normal distribution of the same mean and volatility, very large moves (beyond about 3σ) are much more frequent, and the centre is usually taller and narrower, so moderate moves are a little rarer. Daily returns of shares, indices and funds are typically fat-tailed, and share-index returns are often negatively skewed.
Because kurtosis uses fourth powers, a single extreme day can dominate it — which is exactly what it is designed to detect, and also why it is unstable in short samples.
SKEW and KURT give about $-2.54$ and $7.05$ because of their small-sample corrections.)(a) Any distribution (Chebyshev). If a return $X$ has mean $\mu$ and finite standard deviation $\sigma$, then for every $k\gt0$ $$P\big(|X-\mu|\ge k\sigma\big)\le\frac1{k^2}.$$ (b) Normal distribution. If $X$ is normal, the two-sided probabilities $P(|X-\mu|\gt k\sigma)$ and the expected number of such days in 10 years ($2{,}520$ trading days) are:
| $k$ | normal probability | days in 10 years (normal) | Chebyshev bound | fat-tailed model* |
|---|---|---|---|---|
| 1 | 31.7% | 800 | 100% | 580 days |
| 2 | 4.55% | 115 | 25% | 120 days |
| 3 | 0.27% | 6.8 | 11.1% | 33 days |
| 4 | 0.0063% | 0.16 | 6.25% | 12 days |
| 5 | 0.000057% | 0.0014 | 4% | 5.3 days |
*A common fat-tailed model: Student's $t$ distribution with 4 degrees of freedom, rescaled to the same volatility. It is an illustration, not a fitted model of any real market.
Why Chebyshev holds. Let $A$ be the event $|X-\mu|\ge k\sigma$. Then $$\sigma^2=E\big[(X-\mu)^2\big]\ge E\big[(X-\mu)^2\,\mathbf 1_A\big]\ge k^2\sigma^2\,P(A),$$ because the squared deviation is non-negative everywhere and at least $k^2\sigma^2$ on $A$. Divide by $k^2\sigma^2$. ∎ Chebyshev is a guaranteed ceiling for any distribution; real markets sit between the normal row and that ceiling. The table's last column shows the practical point: under fat tails a 4σ day is not a once-in-sixty-years event but something to expect about once a year.
Drawdowns: How Far It Falls and How Long It Takes to Recover
Volatility treats a +2% day and a −2% day alike and says nothing about order. Investors, however, experience risk as the fall from the highest value they have seen — "my ₹5 lakh became ₹3.5 lakh". That is the drawdown, and it is what makes people sell at the bottom.
For a value (NAV) series $V_0,V_1,\dots,V_n$ define the running peak $M_t=\max_{s\le t}V_s$ and the drawdown $$D_t=\frac{V_t}{M_t}-1\ \le 0 .$$ The maximum drawdown is $\text{MDD}=-\min_t D_t$, the largest percentage fall from a peak to a later trough (reported as a positive number, "a 24% drawdown"). A stretch of time with $D_t\lt0$ is a period under water; the recovery time of a drawdown is the time from its trough until the old peak is regained.
- After a fall of $d$ ($0\lt d\lt1$), the gain needed to get back to the peak is $$g=\frac{1}{1-d}-1=\frac{d}{1-d},$$ which is larger than $d$ and tends to infinity as $d\to1$: −10% needs +11.1%, −30% needs +42.9%, −50% needs +100%, −75% needs +300%.
- Growing at a constant $c$ a year from the trough, the recovery takes $\displaystyle T=\frac{\log\frac{1}{1-d}}{\log(1+c)}$ years.
- A gain and a loss of the same percentage $x$, in either order, leave $(1+x)(1-x)=1-x^2\lt1$: you end below where you started.
Why. After the fall the value is $(1-d)M$; to return to $M$ it must be multiplied by $1/(1-d)$, a gain of $1/(1-d)-1=d/(1-d)$. Since $1-d\lt1$, $g=d/(1-d)\gt d$. Part 2 solves $(1+c)^T=1/(1-d)$ by logarithms, exactly as for doubling times (§1.1). Part 3 multiplies growth factors, which is how returns combine. ∎
Volatility Drag: Why the Average Return Overstates Growth
In §1.3 (Measuring Returns) we saw that the arithmetic mean of yearly returns is not the CAGR: a +50% year followed by a −50% year averages 0% but loses 25%. The gap is not an accident of that example; it is driven by volatility, and its size can be estimated.
For period returns $r_1,\dots,r_n$ (each $\gt-1$) let $A=\frac1n\sum r_t$ be the arithmetic mean and $G=\left[\prod(1+r_t)\right]^{1/n}-1$ the geometric mean (the compound growth rate per period, i.e. the CAGR for yearly returns). The volatility drag is $A-G$: the part of the average return that is lost to the ups and downs.
With $A$, $G$ as in Definition 3.5 and $\sigma^2=\frac1n\sum(r_t-A)^2$:
- $G\le A$, with equality only when all the returns are equal;
- when the returns are small (a few percent per period, or moderate yearly returns), $$G\approx A-\frac{\sigma^2}{2}.$$ So doubling the volatility quadruples the drag. At $A=12\%$ a year, volatility $15\%$ costs about $1.1\%$ a year, $25\%$ costs about $3.1\%$, and $40\%$ costs $8\%$.
Why. (1) is the AM–GM inequality applied to the growth factors $1+r_t\gt0$: their geometric mean $1+G$ is at most their arithmetic mean $1+A$ — the result of §1.3 that the average return is never below the CAGR. (2) Take logarithms and use the Taylor expansion $\log(1+r)\approx r-\frac{r^2}{2}$ (the calculus link): $$\log(1+G)=\frac1n\sum\log(1+r_t)\approx A-\frac{1}{2n}\sum r_t^2=A-\frac{\sigma^2+A^2}{2},$$ using $\frac1n\sum r_t^2=\sigma^2+A^2$. Exponentiating, $1+G\approx1+L+\frac{L^2}{2}$ with $L=A-\frac{\sigma^2+A^2}{2}$, and keeping terms up to second order, $G\approx A-\frac{\sigma^2+A^2}{2}+\frac{A^2}{2}=A-\frac{\sigma^2}{2}$. ∎ §3.3 meets the same $\sigma^2/2$ as the drift correction of geometric Brownian motion.
- "Volatility 27% means I can lose at most 27% in a year." Volatility is a standard deviation, not a limit. Even under the normal model a two-sigma bad year is $17\%-2\times27\%=-37\%$, roughly a 1-in-40 event, and drawdowns within a year can be deeper still.
- Annualising volatility by multiplying by 252 (or 12). Volatility scales with $\sqrt{252}$ (or $\sqrt{12}$); only the mean scales with 252. A 1% daily volatility is about 16% a year, not 252%.
- Treating the $\sqrt{\text{time}}$ rule as exact. It needs independent returns; momentum, mean reversion and changing volatility all break it.
- "The normal curve says this crash should happen once in 10,000 years." Then the normal curve is the wrong model. Real return series have fat tails; a 4σ or 5σ day is rare, not impossible (Example 5).
- Trusting skewness and kurtosis from a short sample. One extreme month can create — or its absence can hide — almost all of the kurtosis (Example 4).
- "−30% then +30% gets me back." $0.7\times1.3=0.91$. A fall of $d$ needs a gain of $d/(1-d)$: −50% needs +100%.
- "Average return 17% means my money grows at 17%." The compound growth is about $A-\sigma^2/2$; with 27% volatility that is about 13.4%, not 17% (Theorem 3.5).
- "Its volatility was low last year, so it is safe." Volatility clusters — calm periods are followed by turbulent ones — and a short calm sample says little about the next crisis.
- "This fund has never had a big drawdown." Maximum drawdown depends on the period examined; a young fund may simply never have been tested by a bad market.
- "Past volatility or past average return is a forecast." They are descriptions of the past. The mean in particular is estimated very imprecisely (Theorem 3.2).
A risk report for Rohan's two funds, computed from ten years of simulated monthly data, gives: Fund A (large-cap index) average return $A=13\%$ a year, volatility $16\%$; Fund B (small cap) $A=17\%$, volatility $27\%$. He works through his friends' claims.
- Daily swings. $16\%/\sqrt{252}\approx1.01\%$ and $27\%/\sqrt{252}\approx1.70\%$ a day. Fund B's −4.2% day was $4.2/1.70\approx2.5$ of its daily sigmas: under the normal model about $0.7\%$ of days (one-sided), so one or two days a year, and more often with fat tails. Unpleasant, but not a sign that anything is broken.
- "At most 27% a year?" No. A one-in-forty bad year under the normal model is $17\%-2\times27\%=-37\%$ for B and $13\%-2\times16\%=-19\%$ for A, and peak-to-trough drawdowns can exceed one calendar year's loss.
- Growth, not average. By Theorem 3.5 the compound rates are about $13-0.16^2/2\times100=11.7\%$ for A and $17-0.27^2/2\times100\approx13.4\%$ for B. ₹10 lakh would grow over 10 years to about ₹30.3 lakh and ₹35.0 lakh. B's advantage is 1.7 points a year, not 4 — and "doubles every four years" (17%) is really about every $72/13.4\approx5.4$ years.
- Is B's higher average even real? Standard errors over 10 years (Theorem 3.2): $16/\sqrt{10}\approx5.1\%$ for A and $27/\sqrt{10}\approx8.5\%$ for B. The 4-point gap between the averages is well inside the noise; ten years cannot prove B's expected return is higher.
- The drawdown test. Suppose B falls 45% from a peak — a fall well within what a fund this volatile can suffer. It then needs $0.45/0.55\approx81.8\%$ to recover, which at B's estimated 13.4% compound rate takes $\log(1/0.55)/\log1.134\approx4.8$ years. Rohan asks himself whether he would keep his SIP running through that.
What he learns. The mathematics does not say which fund to hold; it turns vague worries into numbers. B's extra expected growth (if any) is smaller than its average suggests, uncertain, and comes with much deeper falls. How much of each to hold depends on his horizon and his ability to sit through a drawdown — a portfolio question for Chapter 4 and a planning question for §8.1. Interactive 2 lets him see what a 27% volatility path can look like.
Exercises
All data are hypothetical or simulated. Use 252 trading days, 52 weeks or 12 months a year; volatility uses the divisor $n-1$ unless a part says otherwise; give percentages to two decimals.
- 1 A share closes at ₹200, 204, 201, 207 and 205 on five days. Find the four daily returns, their mean and the daily volatility.
- 2 Annualise a daily volatility of 0.9% and a monthly volatility of 6%.
- 3 A fund's annualised volatility is 22%. Find its daily and weekly volatility.
- 4 A ₹5,00,000 portfolio has annual volatility 15%. How large, in rupees, is a one-sigma day? A two-sigma day?
- 5 Using the data of part 1, someone annualises the mean daily return by multiplying by 252. Explain, using a standard error, why the result is meaningless.
- 6 A fund's 5-year average return is 15% a year with volatility 20%. Give an approximate 95% interval for its true mean return.
- 7 How many years of data are needed for the standard error of the mean annual return to be 2% when the volatility is 18%? Does switching from monthly to daily data help?
- 1 Five monthly returns are $1,\,3,\,-1,\,2,\,-5$ (%). Compute $m_2$, the skewness and the kurtosis (divisor $n$).
- 2 Nine months return exactly 0% and the tenth returns 10%. Compute the skewness and kurtosis. What does this show about kurtosis?
- 3 If daily returns are normal with mean 0 and volatility 1.2%, on how many days a year should the move exceed ±2.4%?
- 4 In the same model, how often should a fall of 3.6% or more occur?
- 5 For any return distribution, at most what fraction of days can lie 4 or more standard deviations from the mean? Prove it.
- 6 A simulated 10-year daily series shows 19 days beyond ±3σ. Compare with the normal expectation and say what it suggests.
- 7 A strategy earns a small profit on most days and occasionally loses heavily. What sign of skewness would you expect, and why is "a high average return and low volatility" not enough to judge it?
- 1 NAVs are 100, 110, 99, 105, 88, 96, 112. Find the running peak, each drawdown and the maximum drawdown.
- 2 What gain is needed to recover from a 30% fall? From a 60% fall?
- 3 After a 40% fall, how many years does recovery take at a steady 11% a year?
- 4 A fund falls 25% and then rises 25%. What is the net result?
- 5 Funds X and Y both gained 20% over three years. X's maximum drawdown was 10%, Y's 45%. Which would most investors have found easier to hold, and why does the end-to-end return hide the difference?
- 6 Show that $g(d)=d/(1-d)$ is increasing and convex on $0\lt d\lt1$ by computing $g'(d)$ and $g''(d)$. What does $g''\gt0$ mean for an investor?
- 1 Yearly returns are +30%, −20%, +30%, −20%. Find the arithmetic mean and the CAGR.
- 2 For the returns of part 1 compute $\sigma$ (divisor $n$) and the estimate $A-\sigma^2/2$. Compare with the exact CAGR.
- 3 Estimate the compound growth rate of a fund with average return 14% and volatility 25%.
- 4 A fund's average return is 8%. At roughly what volatility does its compound growth rate fall to zero?
- 5 An index rises 10% one day and falls back exactly to its starting level the next. A product that delivers twice the index's daily return does what over the two days? Explain using volatility drag.
- 6 Monthly returns have mean 1% and volatility 5%. Estimate the monthly geometric mean and the annual CAGR, and compare with the CAGR if every month returned exactly 1%.
E1. NISM-style A fund's daily standard deviation of returns is 1.2%. Assuming 252 trading days and independent returns, its annualised standard deviation is closest to (A) 302% (B) 19.0% (C) 14.4% (D) 1.2%.
E2. NISM-style An investor's portfolio falls by 40%. The return needed to recover the original value is (A) 40% (B) 60% (C) 66.7% (D) 140%.
E3. NISM-style A return distribution that has more extreme observations than a normal distribution with the same standard deviation is best described as having (A) a high mean (B) negative skewness (C) positive excess kurtosis (D) low volatility.
E4. Case study A hypothetical share closes on seven consecutive Fridays at ₹500, 520, 494, 470, 488, 515 and 530. (a) Find the six weekly returns, their mean and the weekly volatility. (b) Annualise the volatility (52 weeks). (c) Find the maximum drawdown and the gain that was needed to recover from it. (d) Is the annualised mean $52\times\bar r$ a sensible estimate of the share's expected return?
E5. Case study ₹10,00,000 is invested for five years. Fund X returns +25%, −15%, +30%, −20%, +20% in successive years; Fund Y returns 8% every year. (a) Find each fund's arithmetic mean return and CAGR. (b) Compute the final values. (c) Compare X's CAGR with $A-\sigma^2/2$ (divisor $n$). (d) Find X's maximum drawdown on the year-end values.
E6. Interview A stock rises 10% on one day and falls 10% the next, alternating for a whole year of 252 trading days. Without a calculator, roughly what happens to ₹100? Its average daily return is zero — why is the result not ₹100?
Suggested plan — 2 lectures × 60 min.
- Volatility and tails. Open with the 📍 situation and take a vote on the three friends' claims. Returns and volatility (Definition 3.1) with Example 1 worked on the board; the $\sqrt{\text{time}}$ rule (Theorem 3.1) as "variances add"; Example 2. Then the honesty point of Theorem 3.2 and Example 3: the mean is hard to know. Project Interactive 1: start with the normal model, switch to fat-tailed, then switch the scale to log and ask the class what the straight-sided tent means. Skewness and kurtosis (Definitions 3.2–3.3) with Example 4; Chebyshev and the tail table (Theorem 3.3), Example 5.
- Drawdowns and drag. Drawdowns (Definition 3.4) with Example 6 drawn as a running-peak picture; the recovery arithmetic (Theorem 3.4) and Example 7. Volatility drag (Theorem 3.5) from AM–GM and $\log(1+r)\approx r-r^2/2$, Example 8. Project Interactive 2: hold the shocks fixed and move volatility from 10% to 40% while the class predicts the CAGR with $A-\sigma^2/2$. Finish with the 📈 Market case and Practice corner E6.
Class activity. Give each group a different 🎲 sample in Interactive 1 (fat-tailed model) and ask them to record the excess kurtosis and the number of ±3σ days; collect the results on the board to show how much these statistics vary between samples of the same model — a live lesson in sampling error.
Misconceptions to watch for. Volatility as a maximum loss; annualising by 252 instead of $\sqrt{252}$; trusting a short-sample mean; believing the normal curve's "once in 10,000 years"; symmetric thinking about gains and losses; quoting the average return as the growth rate.
Suggested homework. I(1, 3, 6, 7), II(1, 2, 5, 6), III(1, 3, 5, 6), IV(1, 2, 5); Practice corner E1, E4, E5.
Project. Build a "risk report" for one mutual fund from its published daily NAV history: daily returns, annualised volatility, a histogram with the normal curve, skewness, excess kurtosis, a count of 3σ days, the drawdown chart and the volatility drag.
Why it matters. A factsheet gives one standard deviation. Your own sheet shows the whole shape — the tails and the drawdowns that the single number hides — and lets you check the factsheet.
What to do.
- Download several years of daily NAVs for any one scheme from the AMC's website or AMFI's NAV history page. Put dates in column A and NAVs in column B (oldest first, rows 2 onwards).
- Returns in C3 (copy down):
=B3/B2-1. Statistics:=AVERAGE(C:C),=STDEV.S(C:C), annualised volatility=STDEV.S(C:C)*SQRT(252),=SKEW(C:C),=KURT(C:C)(already excess kurtosis). - 3σ days:
=COUNTIF(C:C,">"&(m+3*s))+COUNTIF(C:C,"<"&(m-3*s))withm,sthe cells holding the mean and volatility; compare with=0.0027*COUNT(C:C). - Histogram: bins from −5% to +5% in steps of 0.25% in column E, counts with
=FREQUENCY(C:C,E2:E42); normal expectation in G:=COUNT(C:C)*0.0025*NORM.DIST(E2,m,s,FALSE). Chart both; then repeat with a logarithmic vertical axis. - Drawdown: running peak in D2
=B2, D3=MAX(D2,B3); drawdown in F3=B3/D3-1; maximum drawdown=-MIN(F:F). Chart column F as an area chart. - Drag: from month-end NAVs compute monthly returns, their mean $A$ and volatility, the actual CAGR
=(last/first)^(1/years)-1, and compare with $(1+A-\sigma^2/2)^{12}-1$.
Python version: r = nav.pct_change().dropna(); r.std()*252**0.5; r.skew(); r.kurt(); dd = nav/nav.cummax()-1; dd.min() (pandas).
Hand in: the histogram on both scales, the drawdown chart, a table of your statistics next to the factsheet's standard deviation, and three sentences on what the tails and the maximum drawdown tell an investor that the volatility does not.
Going further. Compute a rolling one-year volatility (=STDEV.S over the previous 252 returns, times SQRT(252)) and chart it: is volatility constant? Then standardise each return by the rolling volatility at the time and recompute the kurtosis — how much of the fat tail was just changing volatility?
SKEW/KURT include small-sample corrections and KURT subtracts 3 — a frequent source of "my kurtosis is 3 lower than yours". Standardising by rolling volatility usually removes a good part, but not all, of the excess kurtosis.🧪 Self-check quiz
Q1. A fund's daily volatility is 1%. With 252 trading days and independent returns, its annual volatility is about
Q2. After a 50% fall, the gain needed to get back to the previous peak is
Q3. A return series with large positive excess kurtosis has
Q4. A fund has an average annual return of 10% and an annual volatility of 20%. Its long-run compound growth rate is approximately
Q5. You want to estimate a fund's expected annual return more precisely. Which helps?