Excess Return Calculator
A 10% return sounds excellent until you learn the market returned 12%. Excess return puts performance in context: your return minus the benchmark return, or minus the risk-free rate, stated in percentage points. This calculator works it out for a single period and for a multi-year track record of up to five years, annualizing the multi-year result geometrically so compounded outperformance is judged fairly.
Presets are rough long-run figures built into the tool, not current index returns. They fill the comparison field only; always replace them with the actual return for your period before drawing conclusions.
Quick Answer
A portfolio return of 12.5% against a benchmark return of 8.0% gives an excess return of +4.50 percentage points, a relative outperformance of 56.25%. Over the three-year track record pre-filled in the multi-year mode (12.5%, 6.0%, 9.0% against 8.0%, 7.5%, 8.0%), the annualized geometric excess return is +1.21 pp per year. Excess return is always a difference in percentage points, never a ratio.
Key takeaways
- Excess return = portfolio return minus comparison return, in percentage points. Pick the comparison first: benchmark for manager skill, risk-free rate for the risk premium.
- Multi-year gaps must be annualized geometrically. The simple average of yearly differences overstates outperformance whenever returns vary.
- Excess return is not risk-adjusted. A positive gap earned with far more risk than the benchmark can still mean zero alpha.
- The relative outperformance line breaks down when the benchmark return is near zero or negative. Trust the percentage points first.
- Quick Answer
- How to use the excess return calculator
- The excess return formulas
- Worked examples: one year, then three years
- Benchmark or risk-free rate: choosing the comparison
- Reading the verdict: the eight bands
- Excess return, active return and alpha
- What this calculator does not do
- What competing calculators miss
- Frequently asked questions
- Add This Calculator to Your Website
- References
How to use the excess return calculator
Pick a mode, enter returns for the same period on both sides, then click Calculate. Results stay hidden until you do.
- Single period: enter your portfolio return and one comparison return. Use the "Compare against" switch to label the comparison as a benchmark index or the risk-free rate. The label changes the wording of the verdict, not the subtraction.
- Multi-year: enter up to five years of paired annual returns. Each year needs both sides; a half-filled year stops the calculation with a message naming the year. Blank years are skipped and the entered years are counted in order.
- Get your portfolio return right first: if money moved in or out during the period, a simple gain-divided-by-start figure distorts the return. A time-weighted return calculator removes the effect of those cash flows, which is the return a manager should be judged on.
- Read the headline, then the verdict: the headline is the gap in percentage points (or pp per year in multi-year mode). The verdict band under it puts the size of the gap in context, and the interpretation box spells out what the band means.
The excess return formulas
Single-period excess return is one subtraction. Multi-year excess return is a ratio of compounded growth factors, annualized.
Relative outperformance = Excess return ÷ |Benchmark return| × 100
Annualized geometric excess return = [(1 + cumulative portfolio growth) ÷ (1 + cumulative benchmark growth)]1/n − 1
Two details in those formulas cause most reading errors. First, the result is stated in percentage points, because it is a difference of two percentages: 12.5% minus 8.0% is 4.50 points, not 4.50%. The relative line is the one stated in percent, and it turns fragile when the benchmark return is small or negative: at a benchmark of 0% the tool reports relative outperformance as 0.00% rather than dividing by zero, and at a benchmark of -30% a portfolio at -20% shows +33.33% relative, which is arithmetically true and practically meaningless. Second, the multi-year formula compounds each side before dividing. That is the same compounding logic a CAGR return calculator applies to a single series, applied here to the ratio of two series, and it is why the geometric result sits below the simple average whenever yearly returns bounce around.
Worked examples: one year, then three years
The single-period example is a portfolio up 12.5% in a year when its benchmark rose 8.0%. The multi-year example extends the same portfolio over three years.
| Year | Portfolio | Benchmark | Excess return |
|---|---|---|---|
| Year 1 | 12.50% | 8.00% | +4.50 pp |
| Year 2 | 6.00% | 7.50% | -1.50 pp |
| Year 3 | 9.00% | 8.00% | +1.00 pp |
| 3-year result | +29.98% cumulative | +25.39% cumulative | +1.21 pp/yr geometric (simple average 1.33) |
Year 2 is the lesson in that table: the portfolio made money and still lost ground, because the benchmark made more. The three-year geometric figure of +1.21 pp/yr is lower than the 1.33 simple average for a real reason, not rounding: compounding the growth factors (1.2998 against 1.2539, ratio taken to the one-third power) prices in the down year properly. Other real runs of this calculator, for checking:
| Check | Excess return | Verdict |
|---|---|---|
| 10.0% vs benchmark 12.0% | -2.00 pp | Notable underperformance |
| 5.0% vs risk-free rate 4.5% | +0.50 pp | Modest outperformance |
| -20.0% vs benchmark -30.0% | +10.00 pp | Exceptional outperformance (losing less is still beating the benchmark) |
Benchmark or risk-free rate: choosing the comparison
The two comparisons answer different questions, and the gap between their answers is often several points. Against a benchmark, excess return judges active management. Against the risk-free rate, the same subtraction is the risk premium.
Against a benchmark index
- Question: did the manager or strategy beat the market it invests in?
- Typical comparison: S&P 500, Nasdaq-100, a bond index, a peer group.
- Use it to judge fees: persistent negative excess return after fees is the case against an active fund.
- The benchmark must match the portfolio's universe. Beating a cash-like benchmark with an equity portfolio proves nothing.
Against the risk-free rate
- Question: what did you earn for taking market risk at all?
- Typical comparison: the 3-month Treasury bill return over the same period.
- Use it for risk-premium work: it is the numerator concept behind the Sharpe ratio and CAPM.
- Use the bill return for your exact period, not a current yield pasted into a past period.
Benchmark choice is where excess return gets gamed. Professional standards exist precisely to police it: the CFA Institute guidance on benchmarks for firms requires an appropriate, total-return benchmark specified in advance, and S&P Dow Jones Indices' SPIVA scorecards show why it matters, since most active funds trail a properly matched benchmark over long periods. If you need an index's actual return for a period rather than a rough preset, published index return histories such as our S&P 500 returns calculator are the place to get the figure before entering it here. The presets inside this tool (S&P 500 ≈ 10%, Nasdaq-100 ≈ 12%, T-bill ≈ 4.5%) are long-run ballparks for orientation only; no verdict should rest on them.
Reading the verdict: the eight bands
Every result is sorted into one of eight bands by the size of the gap. The band thresholds are fixed, so the same excess return always earns the same reading.
| Excess return | Band | How to read it |
|---|---|---|
| +10.00 or more | Exceptional | Verify it is repeatable and not driven by concentrated risk. |
| +5.00 to +9.99 | Strong | A genuinely good result; check consistency across periods. |
| +2.00 to +4.99 | Solid | Positive value-add after allowing for fees. |
| Above +0.10 to +1.99 | Modest | Positive, but confirm it survives fees and taxes. |
| Above -0.10 to +0.10 | Essentially matching | Index-like performance. |
| -1.99 to -0.10 | Slight underperformance | Worth watching, not alarming in one period. |
| -4.99 to -2.00 | Notable underperformance | Investigate the cause. |
| -5.00 and below | Significant underperformance | Review the strategy. |
Treat the bands as a first read, not a grade. A band earned in one quarter against a mismatched benchmark means little; the same band repeated over three to five years against the right benchmark, with returns measured net of fees, is close to a verdict on the strategy itself.
Excess return, active return and alpha
These three terms overlap, and only one of them adjusts for risk. Excess return against a benchmark is also called active return in performance-measurement practice. Alpha goes a step further.
Excess / active return is the raw difference this calculator computes. Jensen's alpha compares the actual return with the return the Capital Asset Pricing Model predicts for the portfolio's beta: alpha = portfolio return minus [risk-free rate + beta × (benchmark return minus risk-free rate)]. A high-beta portfolio in a rising market should beat its benchmark; if it beats it by exactly what beta predicts, its excess return is positive and its alpha is zero. A related but different idea, return above what a model expected rather than above an index, is what an abnormal return calculator measures around events and expectations. Two companion measures complete the picture without being computed here: tracking error, the standard deviation of the excess return series, and the information ratio, average excess return divided by that tracking error. Together they answer the question this page deliberately leaves open: was the gap consistent, or one lucky period?
What this calculator does not do
It computes differences and compounded differences of returns you supply, and nothing else. Knowing the limits keeps the number honest.
- No risk adjustment: no beta, volatility, Sharpe ratio or alpha is computed. Pair a positive result with a risk measure before calling it skill.
- No fee or tax engine: enter returns on a consistent basis (both net, or both gross). The tool cannot convert one basis to the other.
- Five years maximum in multi-year mode, and the years are treated as consecutive equal periods.
- One honest edge case: a benchmark year of exactly -100% makes the benchmark's compounded growth zero, so a geometric excess return is mathematically undefined. Earlier versions of this tool printed infinity or NaN for that input; the calculator now flags it with an error message instead. A portfolio year of -100% is fine and returns -100.00 pp/yr when the benchmark survived.
What competing calculators miss
The typical excess return tool online is a two-input subtraction box. It gets the arithmetic right and stops before the parts that decide whether the answer means anything.
- CalculatorUltra Excess Return: portfolio minus benchmark only, and it calls the result "also known as alpha", which conflates the raw difference with the risk-adjusted measure. No risk-free mode, no multi-period handling.
- BraveCalculator Excess Return: a clearer explainer, but still a single subtraction against a benchmark. Returns are shown as percents rather than percentage points, the exact confusion this metric suffers from most.
- Jensen's alpha calculators (FasterCapital and similar): they answer the risk-adjusted question with beta and CAPM, which is a different question. Useful next step, not a substitute for the raw gap.
- Information ratio explainers (Wall Street Prep): strong on consistency and tracking error, but they are formula guides; you still need your excess return series computed first.
- The gap this page fills: benchmark and risk-free comparisons in one tool with the label switching correctly, per-year excess returns plus cumulative growth on both sides, geometric annualization next to the simple average so you can see the overstatement, fixed verdict bands, and an explicit statement of what the tool refuses to compute.
Frequently asked questions
Excess return is your portfolio return minus a comparison return over the same period, stated in percentage points. The comparison is usually a benchmark index, such as the S&P 500, or the risk-free rate. Positive means you outperformed the comparison; negative means you trailed it.
On this calculator, 2 to 5 points in a period reads as solid to strong, and 5 points or more reads as strong to exceptional. Context matters more than the label: the same gap repeated across several periods, after fees, against a benchmark that matches the portfolio, is worth far more than one big year.
Compare against a benchmark index to judge active management: did the strategy beat the market it invests in? Compare against the risk-free rate to measure the risk premium: what did you earn for taking market risk at all? The two answers can differ by several points, so pick the comparison before you look at the result.
Excess return is the raw difference between the portfolio return and the comparison return. Alpha, in the Jensen sense, adjusts that difference for risk: it compares the actual return with the return CAPM predicts for the portfolio's beta. A portfolio can show positive excess return and zero alpha if it simply took more market risk than its benchmark.
Because returns compound, and yearly differences do not. The multi-year mode compounds the portfolio and benchmark growth factors, divides them, and takes the nth root, so the result is the constant yearly gap that would have produced the same overall outperformance. A simple average of yearly differences overstates the gap whenever returns vary.
Yes. Any period in which the portfolio trails its comparison gives a negative excess return, and the calculator keeps the sign rather than flooring it at zero. Persistent negative excess return after fees is the standard evidence that an active strategy is not covering its costs.
The excess return itself is in percentage points: 12.5% minus 8.0% is 4.50 percentage points. The relative outperformance line restates that gap as a percent of the benchmark return, 56.25% in that example. Mixing the two up is the most common reading error with this metric.
A -100% benchmark year reduces the benchmark's compounded growth to zero, so a geometric excess return is mathematically undefined for that track record. The calculator flags it with an error instead of printing a number. A portfolio year at -100% is handled normally: the annualized excess return is -100.00 pp/yr if the benchmark survived.
Add This Calculator to Your Website
Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.
Powered by Calculator Zilo
References
- Jensen, M. C. The Performance of Mutual Funds in the Period 1945-1964, Journal of Finance 23(2), 1968. Accessed October 21, 2026.
- Sharpe, W. F., explained in Background: Mean-Variance Analyzer (Sharpe 1994 differential return definition). Accessed October 21, 2026.
- CFA Institute. Global Investment Performance Standards (GIPS) Handbook. Accessed October 21, 2026.
- CFA Institute guidance summary. 10 Takeaways from CFA on Benchmarks for Firms. Accessed October 21, 2026.
- CFA Institute. Global Investment Performance Standards (GIPS) Standards: performance calculation and benchmark presentation requirements. Accessed October 21, 2026.
- FTSE Russell, London Stock Exchange Group. FTSE Russell Benchmarks and Indices: index construction and benchmark methodology. Accessed October 21, 2026.
- Bacon, C. R. Practical Portfolio Performance Measurement and Attribution: Glossary (active return, active risk, alpha). Accessed October 21, 2026.
- U.S. Securities and Exchange Commission, Investor.gov. Glossary: Alphas (return above a benchmark or predicted return). Accessed October 21, 2026.
- FinQuiz. Rates and Returns, CFA Level 1 (risk-free rate, geometric mean return). Accessed October 21, 2026.
- S&P Dow Jones Indices SPIVA data, summarized in SPIVA Scorecard: How Active Funds Performed vs. Their Benchmarks. Accessed October 21, 2026.
- U.S. Securities and Exchange Commission, EDGAR filing example. Fund prospectus performance information compared to a benchmark index. Accessed October 21, 2026.
