1.5 - Portfolio Performance Spreadsheet: Track Returns, Dividends, Contributions and CAGR in Excel
- Compounding Investor
- Jul 30
- 16 min read
Measure What Your Portfolio Actually Earned
Many investors spend hours building an investment portfolio spreadsheet. They carefully record every holding.
Every contribution.
Every dividend.
Every portfolio value update.
At first glance, everything appears to be working exactly as intended.
The portfolio is growing.
The account balance is higher than it was last year.
Performance charts point upwards.
But one important question often remains unanswered.
How much of that growth actually came from your investments?
If you’ve added new money, reinvested dividends or transferred assets between accounts, simply comparing today’s portfolio value with last year’s tells you very little about how successfully your investments have performed.
This creates what I call The Portfolio Performance Gap.
It’s the difference between watching your portfolio become larger and understanding whether your investment decisions are genuinely creating wealth.
Closing that gap represents another important step within the Investor Progression Model.
A Reactive Investor focuses almost entirely on account balances.
A Lucky Investor begins calculating returns but often mixes together investment growth, contributions and dividends.
A Conservative Compounder starts separating these different sources of portfolio growth.
A Structured Compounder builds a performance measurement system that explains exactly where every pound or dollar of growth came from—and uses that information to make better investment decisions.
Throughout this guide you’ll learn how to build an Excel portfolio performance spreadsheet that measures your portfolio properly, separates investment returns from new contributions and dividend income, and helps you review your long-term performance with confidence.
Build A Performance Spreadsheet That Measures The Right Things
Don’t judge your investing by looking at a bigger portfolio balance.
Complete the Free Investor Assessment to discover your current Investor Progression Model stage and learn whether you’re measuring genuine investment performance—or simply recording portfolio growth.
Only takes 2-minutes • manually reviewed • delivered within 24 hours
Who This Guide Is For
This guide is designed for investors who:
already use Excel to manage part or all of their portfolio
invest regularly through monthly contributions
reinvest dividends and want to measure their real impact
want to calculate CAGR and understand long-term investment performance
compare their returns against market benchmarks
are building a structured portfolio review process
are working towards becoming a Structured Compounder using the Investor Progression Model
What You'll Learn | |
The Portfolio Performance Gap | Understand why growing portfolio values often hide poor investment performance. |
The Investor Progression Model and Performance Measurement | Learn how successful investors evolve from tracking balances to measuring genuine investment skill. |
Building a Portfolio Performance Spreadsheet | Structure an Excel spreadsheet that separates contributions, dividends and investment returns. |
Calculating Meaningful Investment Returns | Learn when to use total return, CAGR and money-weighted returns, and what each actually tells you. |
Avoiding Common Performance Mistakes | Prevent the errors that cause investors to overestimate how well their portfolios are really performing. |
Contents
Why Most Portfolio Spreadsheets Misstate Performance
The Investor Progression Model and Portfolio Performance
The Portfolio Performance Gap
What a Portfolio Performance Spreadsheet Should Measure
Portfolio Value vs Investment Return
How to Structure a Portfolio Performance Spreadsheet in Excel
Tracking Contributions and Withdrawals
Tracking Dividends Without Misreading Performance
Calculating Total Return
CAGR vs Money-Weighted Return
Benchmarking Your Portfolio Performance
Building a Performance Dashboard
Discover What Your Portfolio Performance Reveals About You
Real Investor Case Study (Dallas, Texas 🇺🇸)
What the Review Revealed
The Real Issue
What Changed
Basic Portfolio Tracking vs Structured Performance Measurement
Quick Portfolio Performance Audit
Who This Guide Is For
Who This Guide Is Not For
FAQ
Explore the Full Framework
Related Articles
Final Thought
Why Most Portfolio Spreadsheets Misstate Performance
Most investment portfolio spreadsheets do an excellent job of recording information.
They show what you own.
They display your current portfolio value.
They often include attractive charts and colourful dashboards.
The problem is that many of them fail to answer the single most important question every investor eventually asks.
A portfolio growing from $100,000 to $140,000 might appear to have generated a 40% return.
But what if you contributed $30,000 during that period?
Or reinvested $3,000 of dividends?
Or transferred holdings from another account?
Suddenly the apparent performance tells a very different story.
Many investors unknowingly measure portfolio growth rather than investment performance.
The larger the portfolio becomes, the more misleading this can be. Without separating contributions, withdrawals, dividends and investment returns, it becomes almost impossible to judge whether your investment decisions are adding value or whether your portfolio is simply benefiting from regular savings.
A good portfolio performance spreadsheet doesn’t just record what happened. It explains why your portfolio has grown.
§That distinction is one of the defining characteristics of more sophisticated investors.
The Investor Progression Model And Portfolio Performance
Performance measurement represents another important stage within the Investor Progression Model.
As investors gain experience, they naturally move beyond recording transactions towards understanding how their portfolio is actually performing.
Investor Stage | Primary Focus |
Reactive Investor | Watches portfolio balances rise and fall without measuring investment performance. |
Lucky Investor | Begins calculating returns but often confuses investment gains with new contributions and dividend income. |
Conservative Compounder | Separates portfolio growth into contributions, income and capital appreciation to understand performance more accurately. |
Structured Compounder | Uses a structured performance measurement system to analyse returns, benchmark results and continuously improve investment decisions. |
Each stage represents a shift from collecting more data to extracting better insight. The goal is no longer to know how much your portfolio is worth. It is to understand how effectively your capital is compounding over time.
That change in thinking allows investors to identify successful decisions, recognise mistakes earlier and evaluate whether their investment strategy is genuinely outperforming over the long term.
The Portfolio Performance Gap
Simply watching your portfolio value increase tells you very little about how successfully your investments are performing.
The graphic below illustrates the Portfolio Performance Gap—the difference between apparent portfolio growth and genuine investment performance. It shows why separating the different sources of growth is essential if you want to measure your investment decisions accurately rather than simply recording a larger account balance.
Most portfolios grow because several different factors are working at the same time. New contributions, dividend income, market appreciation, currency movements and transfers between accounts can all change the value of your portfolio, but they do not all measure investment skill.
Structured Compounders separate each of these sources before assessing performance. By measuring where every pound or dollar of growth actually came from, they can calculate meaningful returns, benchmark their results accurately and make better long-term investment decisions.
Closing the Portfolio Performance Gap is therefore about far more than improving a spreadsheet—it is about understanding what is genuinely driving your wealth creation.
What a Portfolio Performance Spreadsheet Should Measure
A well-designed portfolio performance spreadsheet should measure considerably more than today’s account value. Instead, it should explain every major component of portfolio growth.
At a minimum, your spreadsheet should track:
Total contributions
Total withdrawals
Reinvested dividends
Unrealised capital gains
Realised gains from investments sold
When viewed together, these metrics create a much clearer picture of your investment journey. Rather than simply asking whether your portfolio has become larger, you begin asking much more useful questions.
How much wealth came from disciplined investing?
How much came from regular saving?
Which investments generated the strongest returns?
Am I outperforming the market?
Is my long-term strategy working?
These are the questions that distinguish structured investors from those who simply monitor account balances.
Portfolio Value vs Investment Return
One of the most common mistakes investors make is treating portfolio value and investment return as though they mean the same thing.
They don’t.
Your portfolio value is simply the current value of your investments at a particular point in time. Your investment return measures how effectively those investments have grown your wealth.
For example:
Scenario | Portfolio Value |
Starting portfolio | $100,000 |
Contributions during year | $20,000 |
Portfolio at year end | $128,000 |
Looking only at portfolio value suggests your investments earned 28%. In reality, only $8,000 came from investment performance. The remaining $20,000 came from additional contributions.
Without separating these figures, you risk dramatically overestimating your investment success.
This distinction becomes even more important as portfolios mature.
Most long-term investors continue adding money throughout their working lives.
Unless contributions, withdrawals and investment returns are measured independently, performance becomes increasingly difficult to interpret.
How to Structure a Portfolio Performance Spreadsheet in Excel
An effective portfolio performance spreadsheet does not need to be complicated.
It simply needs to organise information in a way that separates the different drivers of portfolio growth. A practical structure might include the following worksheets:
Worksheet | Purpose |
Current investments, quantities, prices and market values. | |
Transactions | Purchases, sales, contributions and withdrawals. |
Income received, payment dates and reinvestments. | |
Performance | Total return, CAGR, benchmark comparisons and key performance metrics. |
Charts and summary metrics for regular portfolio reviews. |
Keeping these elements separate makes formulas easier to manage and reduces the risk of double counting contributions or dividend income.
As your investing becomes more sophisticated, this structure also provides a solid foundation for analysing asset allocation, ETF exposure, portfolio concentration and long-term compounding.
Your spreadsheet gradually evolves from a simple record of what you own into a complete investment management system that supports better decision-making over many years.
Discover What Your Portfolio Performance Reveals About You
Many investors already monitor their portfolio performance. They can see:
Current portfolio value
Total return
Dividend income
CAGR
Performance charts
Yet many still cannot answer some of the most important questions about their investment process.
Am I measuring genuine investment performance or simply portfolio growth?
How much of my wealth has come from contributions rather than investment returns?
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 lots of numbers. But recording information isn’t the same as understanding investment performance.
The Free Investor Assessment helps identify:
weaknesses in your current performance measurement process
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 successful investors don’t judge themselves by how large their portfolio has become. They judge themselves by how effectively their investments have compounded over time.
Take the Free Investor Assessment
Only takes 2-minutes • manually reviewed • delivered within 24 hours
Dividend income is another area where investors often overestimate portfolio performance. When dividends are automatically reinvested, portfolio values continue to rise and it becomes easy to assume that all of the growth came from capital appreciation.
In reality, dividends represent a separate source of return.
A structured portfolio performance spreadsheet should record:
Dividend payment date
Company or ETF
Gross dividend received
Reinvested amount
Cash retained (if applicable)
Tracking dividends independently allows you to understand how much of your long-term returns have been generated through investment income rather than rising share prices.
For many long-term investors, particularly those investing in dividend-paying companies or income-focused ETFs, this can become one of the largest contributors to overall portfolio growth.
By measuring dividends separately, you gain a much clearer understanding of how your portfolio compounds over time.
Calculating Total Return
Once contributions, withdrawals and dividends have been separated, calculating total return becomes much more meaningful.
Total return measures the overall growth generated by your investments after taking both capital appreciation and income into account.
Unlike simply comparing two portfolio balances, total return focuses on what your investments actually earned.
For long-term investors, this provides a far better measure of investment performance. A structured portfolio performance spreadsheet should allow you to monitor:
Capital growth
Dividend income
Combined total return
Annual performance
Cumulative performance
Looking at these figures together helps answer questions such as:
Is my investment strategy working?
Which investments are creating the greatest value?
Has my portfolio outperformed over the long term?
Measuring total return moves the conversation away from portfolio size and towards investment quality.
One performance measure rarely tells the whole story.
Two of the most useful calculations are Compound Annual Growth Rate (CAGR) and Money-Weighted Return.
CAGR answers a simple question:
“If my portfolio had grown at a constant annual rate, what would that rate have been?”
It provides an excellent measure of long-term compounding and allows investors to compare performance across different periods.
Money-Weighted Return answers a different question. It considers when contributions and withdrawals occurred, making it particularly useful for investors who regularly add new capital.
Neither calculation is universally better.
They simply measure different aspects of investment performance.
A well-designed portfolio performance spreadsheet should support both, allowing you to understand not only how quickly your investments have compounded, but also how your own investment decisions and cash flows have influenced overall results.
Investment performance only becomes meaningful when viewed in context.
A portfolio returning 10% may appear impressive. It may also have underperformed the market. Benchmarking allows you to compare your results against an appropriate reference point.
Depending on your investment strategy, that might include:
A global equity index
An S&P 500 index fund
An FTSE All-World ETF
A balanced portfolio benchmark
A custom benchmark reflecting your own asset allocation
The purpose isn’t to copy an index.
It’s to understand whether your investment decisions are adding value beyond simply investing in a passive alternative.
A structured performance spreadsheet should therefore include benchmark returns alongside your own portfolio performance, allowing you to review long-term progress objectively rather than emotionally.
Raw data becomes far more useful when presented clearly.
A performance dashboard transforms rows of transactions into information that supports better investment decisions.
Rather than displaying dozens of disconnected statistics, an effective dashboard focuses attention on the metrics that matter most. A typical performance dashboard might include:
Current portfolio value
Total contributions
Total investment return
Dividend income
CAGR
Benchmark comparison
Portfolio growth over time
Asset allocation summary
Largest holdings
Recent performance trends
The objective isn’t to create the most visually impressive dashboard. It’s to create one that helps you review your portfolio consistently and make better decisions over many years.
The best dashboards don’t simply describe the portfolio. They improve the investor.
Real Investor Case Study (Dallas, Texas 🇺🇸): When Portfolio Growth Creates False Confidence
An engineering director from Dallas, reviewed his portfolio at the end of every month. His spreadsheet showed steady progress.
The portfolio value continued to reach new highs.
His performance charts looked impressive.
Every month reinforced the same conclusion.
“My investment strategy is working.”
As a result, this Texan investor became increasingly confident in his stock selection, regularly adding new positions because he believed he was consistently outperforming the market.
A structured portfolio performance review revealed a very different story.
What The Review Revealed
Rather than looking only at portfolio value, the review separated every source of portfolio growth. His spreadsheet identified:
new monthly contributions
reinvested dividends
market appreciation
changes in portfolio value
For the first time, the Investor could see exactly where each pound of growth had come from. The results were surprising.
Most of the increase in portfolio value had been driven by years of disciplined monthly investing rather than exceptional investment performance.
His portfolio had certainly grown.
But his investment decisions had added far less value than he had believed.
It was consistent investing.
The Real Issue
The Investors spreadsheet wasn’t inaccurate. It was incomplete. Every month he judged his investing by one number:
Portfolio Value.
That single figure combined investment returns, fresh contributions and dividend income into one headline result. Because everything moved upwards together, he naturally assumed his investment decisions deserved the credit.
Over time, this affected his behaviour.
He became more willing to chase new ideas.
More confident in his stock-picking ability.
Less interested in benchmarking his results against the market.
The portfolio wasn’t creating overconfidence because of poor investments. It was creating overconfidence because of poor measurement.
What Changed
Michael rebuilt his spreadsheet around performance rather than portfolio value.
Instead of reviewing one headline number, every monthly review answered four separate questions.
How much did I contribute?
How much income did the portfolio generate?
How much came from market performance?
Am I outperforming my benchmark?
His monthly reviews became noticeably less emotional. Good months were easier to explain.
Poor months became opportunities to learn rather than reasons to change strategy.
Most importantly, he stopped judging himself by how large his portfolio had become.
He started judging himself by how effectively his investments were compounding.
That shift—from measuring portfolio size to measuring investment performance—is another defining characteristic of a Structured Compounder.
Basic Portfolio Tracking vs Structured Performance Measurement
Recording your portfolio is an important first step. Understanding your portfolio is the next. Improving your investment decisions is the final goal.
Many investors never progress beyond tracking balances and recording transactions. Structured investors build systems that explain how their wealth is being created and whether their investment decisions are working.
Basic Portfolio Tracking | Structured Performance Measurement |
Records portfolio value | Separates portfolio value from investment return |
Records purchases and sales | Tracks contributions, withdrawals and dividends independently |
Focuses on current balances | Focuses on long-term compounding |
Measures what happened | Explains why it happened |
Reviews individual investments | Reviews the portfolio as a complete investment system |
Looks backwards | Supports better future investment decisions |
The difference may appear subtle, but it fundamentally changes how investors think. Instead of asking:
“How much is my portfolio worth?”
Structured investors ask:
“How effectively is my capital compounding?”
That shift is another important milestone on the journey towards becoming a Structured Compounder.
Quick Portfolio Performance Audit
Answer these five questions.
✓ Do I separate investment returns from new contributions?
✓ Can I identify exactly how much growth came from dividends?
✓ Do I benchmark my portfolio against an appropriate index?
✓ Do I measure long-term performance using CAGR or another appropriate return calculation?
✓ Does my spreadsheet help me improve future investment decisions rather than simply record past activity?
If you answered “No” to two or more questions, your portfolio may still contain a significant Portfolio Performance Gap.
Who This Guide Is For
This guide is designed for investors who want to move beyond simply tracking their portfolio value. It will be particularly valuable if you:
use Excel to manage your investments
regularly contribute to your portfolio
reinvest dividends
want to calculate genuine investment performance rather than portfolio growth
compare your returns with market benchmarks
want to build a more structured long-term investment process
are working towards becoming a Structured Compounder
Whether you’re investing a few hundred pounds each month or managing a substantial portfolio, measuring performance accurately is one of the foundations of successful long-term investing.
Who This Guide Is NOT For
This guide is unlikely to be useful if you:
only want to record your investment holdings
are looking for stock tips or investment recommendations
trade frequently and focus on short-term price movements
believe portfolio value alone is an accurate measure of investment success
This article isn’t about choosing investments. It’s about measuring how effectively those investments are creating long-term wealth.
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
Isn’t my portfolio value enough to measure performance?
No. Portfolio value includes contributions, withdrawals, dividends and market movements. Without separating these factors, it’s difficult to understand how well your investments have actually performed.
Why should I track contributions separately?
Because new money increases portfolio value without representing investment returns.
Separating contributions allows you to distinguish disciplined saving from investment performance.
Should dividends be included in performance?
Yes. Dividends form an important part of total return, particularly for long-term investors. However, they should be tracked separately from capital appreciation so you understand where your returns are coming from.
Is CAGR the best performance measure?
CAGR is one of the best measures of long-term compounding.
However, investors making regular contributions should also understand money-weighted returns, as each calculation answers a different question.
Do I need specialist portfolio software?
No. A well-designed Excel spreadsheet can measure contributions, dividends, total return, CAGR and benchmarking while remaining completely customisable to your own investment process.
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 portfolio management system and learn why recording your investments is the first step towards making better long-term investment decisions.
Discover the key metrics every investor should monitor and understand why measuring the right information is just as important as recording it.
Transform your portfolio data into a structured dashboard that supports better investment decisions instead of simply displaying historical information.
Learn how hidden overlap between ETFs can distort diversification and why understanding portfolio composition is just as important as measuring portfolio performance.
Each guide builds on the previous one, helping you progress from recording your investments to measuring performance, improving diversification and making better long-term investment decisions.
Because successful investing isn’t built around a single spreadsheet. It’s built around a structured investment system.
Final Thought
Most investors believe they’re measuring portfolio performance. In reality, they’re often measuring a combination of contributions, dividends, market returns and portfolio growth without separating any of them.
That’s what creates the Portfolio Performance Gap.
When every source of growth is combined into a single headline number, it’s easy to overestimate the quality of your investment decisions and underestimate the power of disciplined investing.
Structured investors take a different approach.
They don’t simply ask whether their portfolio has grown.
They ask why it has grown.
By separating contributions from investment returns, measuring dividend income independently, benchmarking performance and reviewing results consistently, a spreadsheet becomes far more than a collection of numbers.
It becomes a framework for better decision-making. characteristics of a Structured Compounder.
Because successful investing isn’t just about building wealth. It’s about building the systems that allow you to understand, improve and repeat the decisions that created it.
Comments