1.6 – XIRR vs CAGR vs Portfolio Return
- Compounding Investor
- Aug 2
- 15 min read
Understand Which Return Metric Answers The Right Question
Many investors eventually reach the point where they want to measure how well their portfolio has performed. They open Excel.
Search for the “best” return formula. And almost immediately discover three different answers.
Portfolio Return
CAGR
XIRR
Unfortunately, the internet rarely explains why these numbers are different.
Instead, articles typically compare formulas without explaining the investment decisions each metric is designed to support.
As a result, many investors calculate multiple performance figures without understanding what any of them actually measure.
This creates what we call The Return Measurement Gap.
It’s the difference between calculating returns and understanding what those returns actually mean.
A Structured Compounder doesn’t look for a single “correct” return calculation.
They understand that each metric answers a different investment question.
Portfolio Return explains how much the portfolio has increased.
CAGR explains the annualised growth rate of an investment.
XIRR explains the annualised return after taking cash flows into account.
Knowing which question you’re trying to answer is far more important than choosing a formula.
Free Investor Assessment
Discover Whether You’re Measuring Returns Correctly
Most investors know roughly how much their portfolio has grown. Far fewer understand whether they’re measuring that growth correctly.
Complete the Free Investor Assessment to discover:
• Your current Investor Progression Model stage
• Whether you’re using the right return metrics
• The hidden measurement mistakes affecting your portfolio reviews
• What Structured Compounders measure differently
Only takes 2-minutes • manually reviewed • delivered within 24 hours
Who This Guide Is For
This guide is designed for investors who:
invest through ETFs or individual shares
have seen both CAGR and XIRR discussed online
want to understand which return metric they should actually use
are building a structured investment process rather than simply recording portfolio values
If you’ve ever asked whether XIRR is “better” than CAGR, this guide will give you the framework to answer that question confidently.
What You'll Learn | |
Portfolio Return | Why a simple portfolio return calculation doesn’t always reflect your true investment performance. |
CAGR | How Compound Annual Growth Rate measures long-term annualised growth and when it provides the clearest picture of investment performance. |
XIRR | Why XIRR accounts for contributions and withdrawals, making it particularly valuable for investors who add money regularly. |
The Return Measurement Gap | How using the wrong return calculation can lead to misleading conclusions about your investment decisions. |
The Investor Progression Model | Why understanding when to use Portfolio Return, CAGR and XIRR is a defining characteristic of a Structured Compounder. |
Contents
Investors Become Confused About Return Metrics
Investor Progression Model and Measuring Returns
Understanding the Return Measurement Gap
What Is Portfolio Return?
What Is CAGR?
What Is XIRR?
Portfolio Return vs CAGR vs XIRR: Which Should You Use?
Why Contributions Change Everything
Choosing the Right Metric for Different Investment Decisions
Common Mistakes Investors Make When Measuring Returns
Which Return Metric Does Warren Buffett Actually Care About?
Discover What Your Return Calculations Reveal About You
Real Investor Case Study (Melbourne, Australia 🇦🇺)
What The Review Revealed
The Real Issue
What Changed
Portfolio Return vs CAGR vs XIRR Comparison Table
Quick Return Measurement Audit
Who This Guide Is For
Who This Guide Is Not For
FAQ
Explore the Full Framework
Related Articles
Final Thought
Why Investors Become Confused About Return Metrics
Few areas of investing create more confusion than measuring portfolio performance. Search online for how to calculate investment returns and you’ll quickly encounter multiple answers.
Some articles recommend Portfolio Return.
Others argue that CAGR is the only meaningful measure.
Many suggest using XIRR instead.
To someone trying to understand how well their portfolio has performed, these competing recommendations can be frustrating. The reality is that none of these calculations are wrong.
They’re simply answering different questions.
Portfolio Return measures how much your portfolio has increased in value.
CAGR measures the annualised rate at which an investment has compounded over time.
XIRR measures the annualised return after accounting for contributions and withdrawals made at different dates.
Problems arise when investors use one calculation to answer a question it was never designed to answer.
Understanding which metric to use—and when—is one of the key characteristics of a Structured Compounder.
Investor Progression Model and Measuring Returns
Every stage of the Investor Progression Model measures investment performance differently.
Investor Type | How They Measure Returns |
Looks only at current portfolio value. | |
Calculates simple gains without separating contributions or time. | |
Understands Portfolio Return, CAGR and begins benchmarking investments. | |
Uses Portfolio Return, CAGR and XIRR together, choosing the right metric for each decision. |
This progression isn’t about learning increasingly complicated formulas. It’s about asking increasingly better questions. Instead of asking:
“How much has my portfolio grown?”
Structured investors ask:
“Which return calculation best explains my investment performance?”
That shift transforms performance measurement from a mathematical exercise into a decision-making tool.
Understanding the Return Measurement Gap
Understanding the Return Measurement Gap becomes much easier when you visualise the different return calculations side by side.
The graphic below shows why investors often become confused when Portfolio Return, CAGR and XIRR all produce different results. Rather than competing with one another, each metric answers a different investment question. Once you understand what each calculation is actually measuring, choosing the appropriate return metric becomes far more straightforward.
The key insight is that there isn’t a single “correct” return calculation.
Portfolio Return measures overall growth across a period. CAGR measures the average annual rate of compounding. XIRR measures your money-weighted return by incorporating the timing of contributions and withdrawals.
Rather than searching for the best formula, Structured Compounders begin by asking the right question. They then choose the return calculation that provides the most meaningful answer. Closing the Return Measurement Gap is less about mastering complex mathematics and more about understanding which performance metric best reflects your investment process.
What Is Portfolio Return?
Portfolio Return is the simplest way to measure investment performance. It compares the change in portfolio value between two points in time and expresses that change as a percentage. For example:
If a portfolio grows from $100,000 to $120,000, the Portfolio Return is 20%.
Because it is straightforward to calculate, Portfolio Return is often the first performance metric investors encounter. It works well when:
comparing two portfolio values
reviewing short investment periods
no significant contributions or withdrawals have been made
However, Portfolio Return has important limitations. If additional money has been invested during the measurement period, Portfolio Return alone can give a misleading impression of investment performance.
It measures portfolio growth.
It doesn’t necessarily measure investment skill.
What Is CAGR?
Compound Annual Growth Rate (CAGR) measures the annualised rate at which an investment has grown over a specific period. Rather than focusing on total growth, CAGR answers a more useful question.
“If my investment had grown at a constant annual rate, what would that annual return have been?”
This makes CAGR particularly valuable for long-term investors. It allows investments held over different time periods to be compared on a like-for-like basis. Structured investors often use CAGR when:
measuring long-term portfolio performance
evaluating progress towards financial goals
CAGR smooths out year-to-year volatility and provides a clear picture of long-term compounding.
For investors focused on building wealth over decades rather than months, it is often one of the most meaningful performance measurements available.
What Is XIRR?
Extended Internal Rate of Return (XIRR) builds on the concepts behind CAGR by recognising that most investors don’t invest a single lump sum. Instead, they contribute money throughout their investing journey.
Monthly savings.
Annual ISA contributions.
Occasional withdrawals.
Each cash flow affects overall investment performance. Unlike Portfolio Return or CAGR, XIRR takes both the size and timing of these cash flows into account.
This makes it particularly valuable for investors who contribute regularly to their portfolio.
Rather than assuming all money was invested on day one, XIRR calculates the annualised return generated by the actual pattern of cash flows.
For many long-term investors, XIRR provides the most realistic measure of how effectively their invested capital has performed.
That doesn’t make it better than Portfolio Return or CAGR. It simply answers a different question.
Understanding those differences—and choosing the right calculation for the right situation—is what closes the Return Measurement Gap and moves investors one step closer to becoming a Structured Compounder.
Portfolio Return vs CAGR vs XIRR: Which Should You Use?
Investors often ask which return calculation is “best.” The better question is:
Portfolio Return, CAGR and XIRR are not competing calculations. They are complementary measurements that each provide a different perspective on portfolio performance.
Return Metric | Best Used For |
Portfolio Return | Measuring overall portfolio growth between two points in time. |
CAGR | Measuring the annualised rate of long-term compounding. |
XIRR | Measuring annualised returns when contributions and withdrawals occur at different dates. |
Think of them as different tools in the same toolbox. You wouldn’t use a tape measure to tighten a screw.
Likewise, you shouldn’t expect one return calculation to answer every investment question. Structured Compounders don’t choose one metric. They understand when each one provides the most meaningful insight.
Why Contributions Change Everything
Imagine two investors. Both start the year with a portfolio worth $100,000.
By year-end, both portfolios are worth $140,000.
At first glance, both appear to have generated exactly the same performance.
But they haven’t.
Investor A added nothing during the year.
Investor B contributed $30,000 through monthly investments.
Although both portfolios finished at the same value, the investment returns were very different.
This is why contributions fundamentally change performance measurement.
As soon as money is added or withdrawn during the measurement period, simple portfolio growth becomes much less informative.
The more frequently you contribute, the greater the risk of misinterpreting your investment performance.
That’s why long-term investors who save regularly often rely on calculations such as XIRR alongside Portfolio Return and CAGR.
The objective isn’t to make performance measurement more complicated.
It’s to ensure you’re measuring the right thing.
Choosing the Right Metric for Different Investment Decisions
Every performance calculation supports a different type of investment decision.
If you’re reviewing how much your portfolio has grown over the last year, Portfolio Return may be sufficient.
If you’re comparing the long-term performance of two investments held over different time periods, CAGR often provides the clearest comparison.
If you’ve made regular monthly contributions and want to understand the return generated by your invested capital, XIRR is usually the more appropriate measure.
The question therefore isn’t:
“Which calculation should I always use?”
It’s:
“Which calculation best answers the question I’m asking?”
That mindset marks another important step within the Investor Progression Model. Reactive investors search for the “correct” formula. Structured Compounders choose the formula that best supports the investment decision in front of them.
Common Mistakes Investors Make When Measuring Returns
Many portfolio reviews become misleading because investors use the right calculation in the wrong situation. Some of the most common mistakes include:
treating Portfolio Return, CAGR and XIRR as interchangeable
ignoring the impact of contributions and withdrawals
comparing annual returns with annualised returns
measuring performance without benchmarking against an appropriate index
assuming a single return calculation tells the complete story
None of these mistakes are mathematical. They’re measurement mistakes. Understanding what each calculation represents is far more important than memorising the formulas themselves.
Which Return Metric Does Warren Buffett Actually Care About?
Investors often ask whether they should measure performance using Portfolio Return, CAGR or XIRR. The better question is how successful long-term investors think about returns in the first place.
Warren Buffett has consistently focused on one central objective:
He doesn’t optimise for impressive monthly returns or headline portfolio growth.
He focuses on the long-term rate at which capital compounds.
For individual investors, that means no single calculation is sufficient on its own.
Portfolio Return helps explain overall growth.
CAGR illustrates the long-term rate of compounding.
XIRR becomes increasingly valuable when regular contributions are part of the investment process.
Structured Compounders understand that each calculation contributes to a more complete picture of investment performance.
Discover What Your Return Calculations Reveal About You
Most investors already calculate some measure of investment performance. They can see:
Portfolio Return
Annual performance
Portfolio growth
CAGR
XIRR calculations
Yet many still cannot answer some of the most important questions about their investment process.
Am I using the right return calculation for the decision I’m making?
Am I measuring investment performance or simply portfolio growth?
Do I understand the strengths and limitations of each performance metric?
What stage of the Investor Progression Model am I currently at?
What should I change to become a more structured long-term investor?
Your spreadsheet may already calculate every return metric discussed in this guide.
But calculating returns isn’t the same as understanding them. The Free Investor Assessment helps identify:
weaknesses in your portfolio performance measurement
your current Investor Progression Model stage
opportunities to build a more structured investment system
practical next steps towards becoming a Structured Compounder
Because successful investors don’t search for a single “best” return calculation.
They understand which calculation answers the right question at the right time.
Take the Free Investor Assessment
Only takes 2-minutes • manually reviewed • delivered within 24 hours
Real Investor Case Study (Melbourne, Australia 🇦🇺): Three Different Return Calculations. Three Correct Answers
An architect from Melbourne, had tracked his investment portfolio in Excel for almost fifteen years. He considered himself a disciplined long-term investor.
Every month he updated his spreadsheet, reviewed his portfolio and calculated investment performance.
The problem was that every calculation produced a different answer.
Portfolio Return showed one figure.
CAGR showed another.
When he eventually discovered XIRR, it produced a third result entirely. Rather than increasing his confidence, each new calculation created more uncertainty. He became convinced at least one of them had to be wrong.
A structured portfolio review revealed that the calculations weren’t conflicting at all.
They were answering different questions.
What The Review Revealed
The review began by identifying exactly what the Investor was trying to measure. Was he reviewing:
the total growth of his portfolio?
the annual rate at which his investments had compounded?
the return achieved after fifteen years of regular monthly contributions?
Each question required a different calculation. When the results were reviewed together, the confusion disappeared. His spreadsheet showed:
Portfolio Return: 61%
CAGR: 7.6% per year
XIRR: 9.1% per year
Initially, the Investor believed only one of these numbers could be correct. The review demonstrated that all three were accurate.
They simply measured performance from different perspectives.
The Real Issue
Daniel’s spreadsheet wasn’t producing inconsistent results. His expectations were. Every time he calculated a return, he expected a single number to explain every aspect of portfolio performance.
It couldn’t.
Portfolio Return measured overall growth.
CAGR measured long-term compounding.
XIRR measured annualised performance after taking cash flows into account.
None of the calculations contradicted one another. The confusion came from using each metric to answer a question it was never designed to answer. That misunderstanding created the Return Measurement Gap.
What Changed
Rather than searching for the “best” return calculation, Daniel began selecting the calculation that matched the investment decision he was making.
When reviewing overall portfolio growth, he used Portfolio Return.
When assessing long-term compounding, he reviewed CAGR.
When evaluating performance after years of regular monthly investing, he used XIRR.
Nothing about the underlying portfolio changed. Only the way he interpreted its performance.
For the first time, every return calculation had a clear purpose. Instead of creating confusion, they worked together to provide a complete picture of long-term investment performance.
That shift—from searching for one perfect number to understanding what each calculation actually measures—is another defining characteristic of a Structured Compounder.
Portfolio Return vs CAGR vs XIRR Comparison Table
Although Portfolio Return, CAGR and XIRR are all used to measure investment performance, each calculation answers a different question. Understanding those differences is far more valuable than memorising the formulas themselves.
Measurement | Portfolio Return | CAGR | XIRR |
Measures | Overall portfolio growth | Annualised growth rate | Annualised return including cash flows |
Accounts for contributions? | ❌ No | ❌ No | ✅ Yes |
Accounts for withdrawals? | ❌ No | ❌ No | ✅ Yes |
Best for | Measuring total portfolio growth | Measuring long-term compounding | |
Easy to calculate? | ✅ Yes | ✅ Yes | Moderate |
Typical use | Portfolio reviews | Comparing long-term investments | Investors making regular monthly investments |
There isn’t a single “best” return calculation. The best calculation is the one that answers the investment question you’re trying to solve.
Quick Return Measurement Audit
Ask yourself these five questions.
✓ Do I understand the difference between Portfolio Return, CAGR and XIRR?
✓ Do I choose my return calculation based on the investment question I’m trying to answer?
✓ Do I account for contributions and withdrawals when measuring long-term performance?
✓ Could I explain why two different return calculations produce different results?
✓ Am I measuring investment performance rather than simply calculating returns?
If you answered “No” to two or more questions, you may still have a significant Return Measurement Gap.
Who This Guide Is For
This guide is designed for investors who want to measure investment performance with greater confidence. It will be particularly valuable if you:
use Excel to track your portfolio
make regular monthly investments
compare your portfolio against market benchmarks
have seen Portfolio Return, CAGR or XIRR but aren’t sure when to use each calculation
want to build a more structured investment review process
are progressing towards becoming a Structured Compounder
Whether you’re investing for retirement, financial independence or long-term wealth creation, understanding return calculations is essential for making better investment decisions.
Who This Guide Is NOT For
This guide is unlikely to be useful if you:
simply want to know whether your portfolio has increased in value
are looking for detailed Excel formula tutorials
trade over very short time periods
want investment recommendations rather than performance measurement guidance
This article isn’t about choosing investments.
It’s about understanding how to measure their performance correctly.
Discover What Your Portfolio Performance Reveals About You
Most investors already track some measure of portfolio performance. They can see:
Current portfolio value
Portfolio growth
Investment performance
Dividend income
CAGR and return calculations
Yet many still cannot answer some of the most important questions about their investment process.
How much of my portfolio growth came from investment returns rather than new contributions?
Am I measuring genuine investment performance or simply watching my portfolio become larger?
Am I focusing on the performance metrics that actually matter?
What stage of the Investor Progression Model am I currently at?
What should I change to become a more structured long-term investor?
Your spreadsheet may already contain hundreds of calculations. But measuring portfolio performance isn’t the same as understanding it.
The Free Investor Assessment helps identify:
hidden weaknesses in your portfolio performance measurement
your current Investor Progression Model stage
performance blind spots affecting long-term decision-making
opportunities to build a more structured investment system
practical next steps towards becoming a Structured Compounder
Because the best investors don’t simply measure how much their portfolio has grown.
They understand why it has grown.
And once you understand where your returns really came from, you can make far better investment decisions in the future.
Takes Less Than 2-Minutes
FAQ
Which return calculation is the most accurate?
None is universally more accurate than the others. Portfolio Return, CAGR and XIRR each measure different aspects of investment performance. The appropriate calculation depends entirely on the question you’re trying to answer.
Should I always use XIRR?
Not necessarily. If no contributions or withdrawals have been made, Portfolio Return or CAGR may provide perfectly suitable measures.
XIRR becomes increasingly valuable once regular cash flows form part of your investment process.
Why are my Portfolio Return, CAGR and XIRR all different?
Because they measure different things. Portfolio Return measures total growth. CAGR measures annualised compounding. XIRR measures annualised performance after considering the timing of contributions and withdrawals. Different numbers don’t necessarily indicate incorrect calculations.
Which return metric should I benchmark against an index?
For long-term comparisons, CAGR is often the most meaningful measure because it annualises performance over time. However, the most appropriate benchmark depends on your investment objective and the period being measured.
Can one spreadsheet calculate all three?
Yes. A well-designed Excel portfolio tracker can calculate Portfolio Return, CAGR and XIRR simultaneously, allowing each calculation to be used when it provides the greatest insight.
Explore The Full Framework
The Investor Progression Model White Paper |
This guide forms part of the Compounding Investor Progression Model—a framework designed to help investors move from reactive decision-making towards a repeatable, structured investment process. Inside the white paper you’ll discover: ✓ The four investor types ✓ Why most investors plateau ✓ The five dimensions of investor progression ✓ How Structured Compounders build repeatable systems ✓ The research behind the Investor Assessment |
⬇ READ THE WHITE PAPER ⬇ |
Related Articles
Continue Building Your Portfolio Management System
Build the foundation of your investment management system by creating a structured Excel portfolio tracker.
Learn how Portfolio Return is calculated, when it should be used and why it forms the starting point for measuring investment performance.
Discover how to build a spreadsheet that separates contributions, dividends and investment returns to measure genuine portfolio performance.
Turn your investment data into a structured dashboard that supports better portfolio reviews and long-term decision-making.
Each guide builds on the previous one, helping you progress from simply calculating investment returns to understanding what those returns actually reveal about your investment process.
Final Thought
Most investors spend their time searching for the right return calculation. Structured investors spend their time asking the right investment question.
That’s an important difference. Portfolio Return, CAGR and XIRR don’t compete with one another. Together, they provide a more complete understanding of long-term investment performance.
The confusion begins when investors expect a single calculation to answer every question.
That’s the Return Measurement Gap.
Closing that gap isn’t about learning more formulas. It’s about understanding what each calculation was designed to measure and using it at the appropriate time.
Because successful investing isn’t measured by finding one perfect number.
It’s measured by developing the judgement to interpret every number correctly.
That’s another defining characteristic of a Structured Compounder.
Comments