Skip to content
CalculatorZilo Logo
  • Home
  • CalculatorsExpand
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
CalculatorZilo Logo
Home / Excess Return Calculator
Investment Calculators

Excess Return Calculator

Published onSeptember 29, 2025 Updated onOctober 21, 2026 1:11 pm

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.

Excess Return Calculator
Single period, benchmark or risk-free rate, and multi-year track records up to five years

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.

Enter up to 5 years of annual returns. Blank years are skipped, and the years you do enter are counted in order. The calculator annualizes the geometric excess return, which is the fair way to judge multi-period outperformance.

Excess return
–
Verdict: –

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.
On this page
  • 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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.

Excess return = Portfolio return − Benchmark (or risk-free) return
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.

1. Portfolio: 12.5%→ 2. Minus benchmark 8.0%→ 3. Excess return: +4.50 pp→ 4. Verdict: solid outperformance
YearPortfolioBenchmarkExcess return
Year 112.50%8.00%+4.50 pp
Year 26.00%7.50%-1.50 pp
Year 39.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:

CheckExcess returnVerdict
10.0% vs benchmark 12.0%-2.00 ppNotable underperformance
5.0% vs risk-free rate 4.5%+0.50 ppModest outperformance
-20.0% vs benchmark -30.0%+10.00 ppExceptional 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 returnBandHow to read it
+10.00 or moreExceptionalVerify it is repeatable and not driven by concentrated risk.
+5.00 to +9.99StrongA genuinely good result; check consistency across periods.
+2.00 to +4.99SolidPositive value-add after allowing for fees.
Above +0.10 to +1.99ModestPositive, but confirm it survives fees and taxes.
Above -0.10 to +0.10Essentially matchingIndex-like performance.
-1.99 to -0.10Slight underperformanceWorth watching, not alarming in one period.
-4.99 to -2.00Notable underperformanceInvestigate the cause.
-5.00 and belowSignificant underperformanceReview 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

  1. Jensen, M. C. The Performance of Mutual Funds in the Period 1945-1964, Journal of Finance 23(2), 1968. Accessed October 21, 2026.
  2. Sharpe, W. F., explained in Background: Mean-Variance Analyzer (Sharpe 1994 differential return definition). Accessed October 21, 2026.
  3. CFA Institute. Global Investment Performance Standards (GIPS) Handbook. Accessed October 21, 2026.
  4. CFA Institute guidance summary. 10 Takeaways from CFA on Benchmarks for Firms. Accessed October 21, 2026.
  5. CFA Institute. Global Investment Performance Standards (GIPS) Standards: performance calculation and benchmark presentation requirements. Accessed October 21, 2026.
  6. FTSE Russell, London Stock Exchange Group. FTSE Russell Benchmarks and Indices: index construction and benchmark methodology. Accessed October 21, 2026.
  7. Bacon, C. R. Practical Portfolio Performance Measurement and Attribution: Glossary (active return, active risk, alpha). Accessed October 21, 2026.
  8. U.S. Securities and Exchange Commission, Investor.gov. Glossary: Alphas (return above a benchmark or predicted return). Accessed October 21, 2026.
  9. FinQuiz. Rates and Returns, CFA Level 1 (risk-free rate, geometric mean return). Accessed October 21, 2026.
  10. S&P Dow Jones Indices SPIVA data, summarized in SPIVA Scorecard: How Active Funds Performed vs. Their Benchmarks. Accessed October 21, 2026.
  11. U.S. Securities and Exchange Commission, EDGAR filing example. Fund prospectus performance information compared to a benchmark index. Accessed October 21, 2026.

Related calculators

Investment CalculatorsP/E Ratio CalculatorA price-to-earnings ratio calculator, usually shortened to P/E ratio calculator, answers one valuation...Investment CalculatorsStock Position Return CalculatorYour brokerage app shows a percentage for each holding, but it rarely shows the whole story in dollars: what...Investment CalculatorsS&P 500 Returns CalculatorAsk what the S&P 500 returned over the last decade and you will get two different answers, both correct.Investment CalculatorsS&P Growth CalculatorProject how an investment compounds over time.Investment CalculatorsLot Size CalculatorIn trading, lot size is the single number that turns a stop loss into a known dollar risk.Investment CalculatorsReverse Investment Calculator: Free Goal PlannerMost investment calculators run forward: you enter what you have and they tell you what you get.

We use cookies to analyze traffic. You can accept or decline cookies below. Learn more

calculatorzilo

CalculatorZilo

Free calculators for everyday life. No signup, no cost, just answers.

Categories

Finance Math Health & Fitness Education Science Real Estate Chemistry Browse all calculators

Popular tools

Mortgage Payment Calculator BMI Walking Calculator Salary Per Minute Calculator Percentage Off Calculator

Company

About Us Contact Us Privacy Policy Terms and Conditions
Disclaimer Cookie Policy DMCA Policy Affiliate Disclosure FAQ Accessibility Statement

© 2026 CalculatorZilo • Free calculators for everyone

  • Home
  • Calculators
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
Search