Every investment decision balances two questions: how much might I earn? and how much could it hurt? This guide builds both answers from first principles—starting with a single rupee and ending with the ratios professionals use to compare portfolio managers.
One small dataset runs through most of the guide, so you can check every number yourself in Excel or Python.
The running example
| Year | Equity fund A | Bond fund B | Market index M |
|---|---|---|---|
| 1 | 20% | 4% | 15% |
| 2 | −10% | 9% | −8% |
| 3 | 25% | 5% | 20% |
| 4 | −5% | 8% | −2% |
| 5 | 15% | 6% | 12% |
Fictional annual returns chosen for clarity. Bond fund B is deliberately built to rise when equities fall, to make diversification visible.
What is a return?
A return measures what you gained (or lost) per rupee invested over a period. It has two parts: the change in price and any income received.
You buy a share at ₹100, receive a ₹2 dividend and sell at ₹110.
HPR = (110 − 100 + 2) / 100 = 12% — of which 10% is capital gain and 2% is dividend yield.
Watch the period. A 12% return over three months and 12% over three years are very different achievements. Always state the horizon, and annualise before comparing (section 05).
Arithmetic mean return
The arithmetic mean is the simple average of periodic returns. It answers: what is a typical one-year return?
(20% − 10% + 25% − 5% + 15%) / 5 = 45% / 5 = 9.00%
The arithmetic mean is the right input for forecasting a single future period and for most portfolio mathematics. But it overstates what a buy-and-hold investor actually earned over several periods—as the next section shows.
Geometric mean return and CAGR
Returns compound: each year’s return applies to a different starting amount. The geometric mean is the constant rate that would produce the same ending wealth. When applied to start and end values, it is called the compound annual growth rate (CAGR).
CAGR = (Ending value / Beginning value)^(1/n) − 1
| Year | Return | Value of ₹1,00,000 |
|---|---|---|
| Start | — | ₹1,00,000 |
| 1 | +20% | ₹1,20,000 |
| 2 | −10% | ₹1,08,000 |
| 3 | +25% | ₹1,35,000 |
| 4 | −5% | ₹1,28,250 |
| 5 | +15% | ₹1,47,488 |
CAGR = (1,47,488 / 1,00,000)^(1/5) − 1 = 8.08% a year — almost a full percentage point below the 9.00% arithmetic mean.
Why the geometric mean is lower: volatility drag
Losses hurt more than equal gains help. A useful approximation links the two averages:
For fund A: 9.00% − 2.43%/2 ≈ 7.79%, close to the exact 8.08%. Bond fund B, with tiny volatility, has almost no gap (6.40% vs 6.38%).
Log (continuously compounded) returns
A log return converts a simple return into its continuously compounded equivalent. Its great advantage: log returns add up over time.
| Year | Simple return | Log return |
|---|---|---|
| 1 | 20.00% | 18.23% |
| 2 | −10.00% | −10.54% |
| 3 | 25.00% | 22.31% |
| 4 | −5.00% | −5.13% |
| 5 | 15.00% | 13.98% |
| Total | — | 38.86% |
e^0.3886 − 1 = 47.49% — exactly the five-year growth from ₹1,00,000 to ₹1,47,488. Divide by 5 for an average log return of 7.77% a year; e^0.0777 − 1 = 8.08%, the CAGR again.
| Use simple returns when… | Use log returns when… |
|---|---|
| Combining assets in a portfolio (simple returns are weighted averages across assets) | Adding returns across time periods |
| Reporting performance to clients | Statistical modelling, volatility estimation, option pricing |
| Returns are small and periods short — the two are nearly equal | Returns are large, or you need time-additivity |
Annualising returns and risk
Data often comes monthly or daily, but decisions are annual. Means scale with time; standard deviations scale with the square root of time (assuming independent periods).
| From | Annual mean (approx.) | Annual volatility |
|---|---|---|
| Monthly | × 12 (or (1 + r)¹² − 1 compounded) | × √12 |
| Weekly | × 52 | × √52 |
| Daily (trading days) | × 252 | × √252 |
A fund averages 1% a month with 4% monthly volatility.
Annual mean ≈ 12% (compounded: 1.01¹² − 1 = 12.68%). Annual volatility = 4% × √12 = 13.86%, not 48%.
Risk of a single asset: variance and standard deviation
Risk is the uncertainty of outcomes. The most common measure is how widely returns scatter around their mean.
| Year | Return | Deviation from 9% | Squared deviation |
|---|---|---|---|
| 1 | 20% | +11% | 0.0121 |
| 2 | −10% | −19% | 0.0361 |
| 3 | 25% | +16% | 0.0256 |
| 4 | −5% | −14% | 0.0196 |
| 5 | 15% | +6% | 0.0036 |
| Sum | 0.0970 |
Variance = 0.0970 / (5 − 1) = 0.02425. Standard deviation = √0.02425 = 15.57%.
Bond fund B: standard deviation 2.07%. Market M: 11.87%.
Reading the number: if returns were roughly normal, about two years in three would fall within one standard deviation of the mean—for fund A, between about −6.6% and +24.6%. Real markets have fatter tails, so treat this as a rough guide.
Why n − 1? With a sample, dividing by n − 1 corrects the tendency to underestimate the true variance. Excel’s VAR.S and STDEV.S do this; VAR.P and STDEV.P divide by n.
Beyond standard deviation
- Downside deviation: counts only returns below a target (e.g., 0%). Investors fear losses, not upside surprises.
- Maximum drawdown: the largest peak-to-trough fall. Fund A’s worst was −10% (₹1,20,000 → ₹1,08,000).
- Value at Risk: a loss threshold at a confidence level — see our VaR & Expected Shortfall guide.
Two assets: covariance, correlation and portfolio risk
Once you hold two assets, what matters is not only how risky each one is, but how they move together.
Correlation ρ = Cov(A,B) / (σA σB), always between −1 and +1
| Year | A deviation | B deviation | Product |
|---|---|---|---|
| 1 | +0.11 | −0.024 | −0.00264 |
| 2 | −0.19 | +0.026 | −0.00494 |
| 3 | +0.16 | −0.014 | −0.00224 |
| 4 | −0.14 | +0.016 | −0.00224 |
| 5 | +0.06 | −0.004 | −0.00024 |
| Sum | −0.01230 |
Covariance = −0.01230 / 4 = −0.003075. Correlation = −0.003075 / (0.1557 × 0.0207) = −0.95: when A has a good year, B tends to have a weak one.
| Correlation | Meaning |
|---|---|
| +1 | Perfectly in step — no diversification benefit |
| 0 | No linear relationship — meaningful risk reduction |
| −1 | Perfect mirror images — risk can, in theory, be eliminated |
Portfolio return and risk
σ²p = wA² σA² + wB² σB² + 2 wA wB Cov(A,B) = wA² σA² + wB² σB² + 2 wA wB ρ σA σB
Expected return = 0.6 × 9.00% + 0.4 × 6.40% = 7.96%.
Variance = 0.36 × 0.02425 + 0.16 × 0.00043 + 2 × 0.6 × 0.4 × (−0.003075) = 0.00733 → σp = 8.56%.
That is far below the weighted average of the two volatilities (0.6 × 15.57% + 0.4 × 2.07% = 10.17%). The difference is the diversification benefit.
The general pattern (σA = 20%, σB = 8%, weights 60/40):
| Correlation ρ | +1 | +0.5 | 0 | −0.5 | −1 |
|---|---|---|---|---|---|
| Portfolio σ | 15.2% | 13.9% | 12.4% | 10.8% | 8.8% |
Multiple assets: weighted returns and the covariance matrix
With n assets, the portfolio return is still a weighted average. Risk needs every pairwise covariance, which is neatly organised in a covariance matrix Σ.
Illustration: 50% equity, 30% bonds, 20% gold.
| Asset | Weight | Expected return | Volatility |
|---|---|---|---|
| Equity | 50% | 12% | 18% |
| Bonds | 30% | 7% | 6% |
| Gold | 20% | 9% | 15% |
| Correlations | Equity | Bonds | Gold |
|---|---|---|---|
| Equity | 1 | 0.1 | −0.1 |
| Bonds | 0.1 | 1 | 0.2 |
| Gold | −0.1 | 0.2 | 1 |
| Covariance matrix Σ | Equity | Bonds | Gold |
|---|---|---|---|
| Equity | 0.03240 | 0.00108 | −0.00270 |
| Bonds | 0.00108 | 0.00360 | 0.00180 |
| Gold | −0.00270 | 0.00180 | 0.02250 |
Expected return = 0.5 × 12% + 0.3 × 7% + 0.2 × 9% = 9.90%.
Variance = wᵀΣw = 0.009324 → σp = 9.66%, versus a weighted-average volatility of 13.80%.
Why this matters: as you add assets, the individual variances matter less and the covariances matter more. In a large portfolio, risk is driven mostly by how assets co-move—which is why the market-wide component cannot be diversified away.
Systematic risk and beta
Total risk has two parts. Unsystematic (specific) risk—a factory fire, a failed product—can be diversified away. Systematic (market) risk—interest rates, recessions—cannot. Investors are rewarded mainly for bearing systematic risk.
Cov(A, M) = 0.018425; Var(M) = 0.014080. β = 0.018425 / 0.014080 = 1.31.
Fund A tends to move about 1.31% for every 1% move in the market—amplifying both rallies and falls.
| Beta | Interpretation |
|---|---|
| β > 1 | Aggressive: more sensitive than the market |
| β = 1 | Moves with the market |
| 0 < β < 1 | Defensive: less sensitive |
| β < 0 | Tends to move against the market (rare) |
CAPM: the required return
With a 6.5% risk-free rate and a 12% expected market return, a fund with β = 1.2 must earn 6.5% + 1.2 × 5.5% = 13.1% just to compensate for its market risk.
Risk-adjusted performance: Sharpe, Treynor, Jensen’s alpha and more
A higher return is not impressive if it came with much higher risk. Risk-adjusted measures put funds on a common footing.
| Measure | Formula | Risk used | Best when… |
|---|---|---|---|
| Sharpe ratio | (Rp − Rf) / σp | Total risk | The fund is most of your wealth |
| Treynor ratio | (Rp − Rf) / βp | Market risk | The fund is one part of a diversified portfolio |
| Jensen’s alpha | Rp − [Rf + βp(Rm − Rf)] | Market risk | Asking whether the manager added value above CAPM |
| Sortino ratio | (Rp − target) / downside deviation | Downside risk | You care mainly about losses |
| Information ratio | (Rp − Rb) / tracking error | Active risk | Judging consistency of outperformance vs a benchmark |
| M² (Modigliani) | Rf + Sharpe × σm | Total risk | Expressing Sharpe as a return comparable to the market |
Illustration: which fund is best?
Assume Rf = 6.5%, market return 12%, market volatility 16%.
| Fund | Return | σ | β | Sharpe | Treynor | CAPM required | Jensen’s α | M² |
|---|---|---|---|---|---|---|---|---|
| X | 15% | 20% | 1.20 | 0.425 | 7.08% | 13.10% | +1.90% | 13.30% |
| Y | 13% | 14% | 0.90 | 0.464 | 7.22% | 11.45% | +1.55% | 13.93% |
| Z | 18% | 28% | 1.50 | 0.411 | 7.67% | 14.75% | +3.25% | 13.07% |
| Market | 12% | 16% | 1.00 | 0.344 | 5.50% | 12.00% | 0.00% | 12.00% |
- Sharpe and M² pick Y: it delivers the most excess return per unit of total volatility.
- Treynor and Jensen pick Z: after adjusting only for market risk, Z adds the most. But Z carries a lot of non-market risk (σ = 28%), which matters if you hold it alone.
- All three beat the market on every measure here—in practice, many funds do not.
Downside deviation = √[(0.10² + 0.05²) / 5] = 5.0%. Sortino = (9.0% − 6.5%) / 5.0% = 0.50. (Conventions for the denominator vary; state yours.)
Excel and Python toolkit
| Calculation | Excel formula (returns in B2:B6, market in D2:D6) |
|---|---|
| Arithmetic mean | =AVERAGE(B2:B6) |
| Geometric mean / CAGR | =GEOMEAN(1+B2:B6)-1 or =(End/Start)^(1/n)-1 |
| Log return | =LN(1+B2) |
| Sample variance / std dev | =VAR.S(B2:B6) / =STDEV.S(B2:B6) |
| Covariance / correlation | =COVARIANCE.S(B2:B6,C2:C6) / =CORREL(B2:B6,C2:C6) |
| Beta | =SLOPE(B2:B6,D2:D6) |
| Portfolio variance (matrix) | =MMULT(TRANSPOSE(w),MMULT(Sigma,w)) |
| Sharpe ratio | =(AVERAGE(B2:B6)-Rf)/STDEV.S(B2:B6) |
import numpy as np
A = np.array([0.20, -0.10, 0.25, -0.05, 0.15]) # equity fund
B = np.array([0.04, 0.09, 0.05, 0.08, 0.06]) # bond fund
M = np.array([0.15, -0.08, 0.20, -0.02, 0.12]) # market
arith = A.mean() # 0.0900
geo = np.prod(1 + A) ** (1 / len(A)) - 1 # 0.0808
logr = np.log(1 + A) # sums to 0.3886
sd = A.std(ddof=1) # 0.1557
corr = np.corrcoef(A, B)[0, 1] # -0.95
beta = np.cov(A, M, ddof=1)[0, 1] / M.var(ddof=1) # 1.31
w = np.array([0.6, 0.4])
cov = np.cov(np.vstack([A, B]), ddof=1)
sd_p = np.sqrt(w @ cov @ w) # 0.0856
rf = 0.065
sharpe = (arith - rf) / sd # 0.16Common mistakes to avoid
- Quoting the arithmetic mean as the return an investor actually earned over many years.
- Annualising volatility by multiplying by 12 instead of √12.
- Averaging log returns across assets to get a portfolio return (use simple returns across assets).
- Treating correlation as stable—correlations often rise towards +1 in a crisis, exactly when diversification is needed. See Copulas & Tail Dependence.
- Mixing periods: monthly returns with an annual risk-free rate in a Sharpe ratio.
- Ranking funds on one ratio over one short period, or against the wrong benchmark.
- Forgetting that beta and correlation describe linear co-movement only.
Frequently asked questions
What is the difference between arithmetic and geometric returns?
The arithmetic mean is the simple average of periodic returns and estimates a typical single-period return. The geometric mean is the compound rate that turns the starting value into the ending value. With any volatility, the geometric mean is lower.
Is CAGR the same as the geometric mean return?
Yes, for a buy-and-hold investment with no cash flows. CAGR = (ending value / beginning value)^(1/n) − 1, which equals the geometric mean of the periodic returns.
Why do analysts use log returns?
Log returns add up across time, which simplifies multi-period calculations and statistical modelling. Convert back with eᵡ − 1. For combining assets in a portfolio, use simple returns.
Why is standard deviation used as a measure of risk?
It measures how widely returns scatter around the average, in the same units as returns. It treats upside and downside surprises equally, so downside measures such as downside deviation or drawdown are useful complements.
What is the difference between covariance and correlation?
Covariance shows whether two assets move together but depends on their units and volatility. Correlation divides covariance by both standard deviations, giving a standardised number between −1 and +1.
How does diversification reduce risk?
Portfolio return is a weighted average, but portfolio volatility is lower than the weighted average of volatilities whenever correlation is below +1, because some movements offset each other.
What does a beta of 1.3 mean?
The asset has historically moved about 1.3% for every 1% move in the market, so it amplifies both rises and falls. Beta measures systematic risk only.
When should I use the Sharpe ratio versus the Treynor ratio?
Use Sharpe when the investment is a standalone or dominant holding, because total risk matters. Use Treynor (or Jensen’s alpha) when it is one part of a well-diversified portfolio, where only market risk matters.
What does a positive Jensen’s alpha mean?
The portfolio earned more than CAPM required for its level of market risk. Whether that reflects skill or luck needs a long track record and statistical testing.
How do I annualise monthly volatility?
Multiply by √12, assuming monthly returns are independent. Monthly mean returns are annualised by multiplying by 12, or compounding as (1 + r)¹² − 1.
Further reading
- Bodie, Kane and Marcus, Investments (McGraw Hill) — returns, risk and portfolio theory
- Markowitz, H. (1952), “Portfolio Selection”, Journal of Finance
- Sharpe, W. F. (1964), CAPM; and (1966), “Mutual Fund Performance”, Journal of Business
- Treynor, J. L. (1965), “How to Rate Management of Investment Funds”, Harvard Business Review
- Jensen, M. C. (1968), “The Performance of Mutual Funds in the Period 1945–1964”, Journal of Finance
- Modigliani, F. and Modigliani, L. (1997), “Risk-Adjusted Performance”, Journal of Portfolio Management
- CFA Institute, CFA Program curriculum — Quantitative Methods and Portfolio Management readings
Educational content. All figures are illustrative and do not represent any real fund or forecast.
Prof. V. Ravichandran · The Mountain Path Academy · https://themountainpathacademy.com