Listen to this Blog
CAGR vs IRR vs TWRR: The Investor's Definitive Guide to Decoding Stock Market Returns [Formulas Included]
Are You Measuring Your Portfolio Success with the Wrong Return Metric?
We've all been there. You proudly tell a friend your stock is up "2X", but your fund manager keeps talking about CAGR and TWRR. Then you try to calculate your private equity returns and someone throws out IRR. It's enough to make you want to stick to a savings account!
I know that you need to know not just what returns you've earned, but how that return was generated. Are you being rewarded for brilliant stock picks, or are you just lucky because you dumped a huge sum in right before a market rally?
This guide will clearly define the different types of investment returns—including CAGR vs IRR, TWRR, and Absolute Return—and provide the exact Excel formulas for calculation. Knowing these metrics is the first step toward the data-driven analysis we focus on in our workshops.
1. The Simplest View: Absolute Return & The "2X" Phenomenon
🎯 What is it?
The total percentage gain or loss your investment has made from the start until now, regardless of the time period. The "2X" means your investment has doubled, a 100% Absolute Return.
🛑 Why it's Misleading: The Missing Ingredient is Time!
Quote: "Telling me your investment made 50% is like telling me your car goes 100 miles. Is that per hour, or per week? Time matters!"
📊 The Absolute Return Formula in Excel:
Let $FV$ be the Final Value and $IV$ be the Initial Value.
$$\text{Absolute Return} = \frac{FV - IV}{IV}$$
2. The Gold Standard for Growth: Compound Annual Growth Rate (CAGR Explained)
If you want to compare the historical performance of two companies or your portfolio against a benchmark (e.g., the Nifty 50), CAGR is your metric of choice.
🎯 What is it?
The average annualized rate of return that an investment earned over a specified period longer than one year, assuming all profits were reinvested. It smooths out volatility to show the steady growth rate that would have achieved the same result.
🛠️ When is it Used?
Company Comparison: Evaluating a company's revenue or profit growth over 3, 5, or 10 years.
Forecasting: Projecting future value based on a steady growth assumption.
🛑 Why it's Limited:
CAGR assumes you put money in once and never touched it. It cannot fairly measure a portfolio where you make continuous deposits or withdrawals (like an SIP).
📊 The Compound Annual Growth Rate Formula:
Let FV be the Final Value, IV be the Initial Value, and n be the number of years.
CAGR = (FV/IV)^(1/n)-1
3. The True Manager's Scorecard: Time-Weighted Rate of Return (TWRR)
This is the metric institutional investors and fund managers use to prove their stock-picking prowess.
🎯 What is it?
TWRR calculates the compounded return that eliminates the distorting effect of the investor’s cash flows (deposits and withdrawals). It measures the performance of the investment strategy itself, not the investor's ability to time the market.
🛠️ When is it Used?
Evaluating Fund Managers: The only fair way to assess a mutual fund or portfolio manager's skill.
Comparing Investment Strategies: To see which strategy performed better, regardless of when you added or removed capital.
🛑 The Core Concept:
TWRR is perfect for a manager who doesn't control when investors buy or sell. It ensures they are judged purely on the security selection during specific holding periods.
📊 The TWRR Formula in Excel (Requires Sub-Periods):
TWRR is calculated by linking the returns (R_n) of sub-periods where there were no external cash flows.
TWRR = (1 + R_1) X (1 + R_2) *..... (1 + R_n) - 1
Step 1: Identify every day there was a cash flow (deposit/withdrawal). These are your sub-period ends.
Step 2: Calculate the simple return for each sub-period R_n:
R_n =({Ending Market Value} -{Beginning Market Value} -{Cash Flow})/(Beginning Market Value}}Step 3: Chain the returns together using the formula above.
4. The Investor's View: Internal Rate of Return (IRR) / MWRR and Your Personal Performance
If you want to know what rate you actually earned on the money you put in, this is your number. MWRR is simply another name for IRR when applied to personal portfolio cash flows.
🎯 What is it?
IRR (Internal Rate of Return), also known as the Money-Weighted Rate of Return (MWRR), is the annualized compounded return rate of a set of cash flows. It is the discount rate that makes the present value of all money coming in equal to the present value of all money going out.
🛠️ When is it Used?
A Personal Investment Portfolio: Calculating your actual return when you have made monthly SIPs, taken money out, and added a lump sum from a bonus.
Real Estate/Private Equity: Analyzing investments with complex, uneven cash flow schedules.
🛑 Why the Difference is Key:
IRR/MWRR is highly sensitive to the timing and size of your cash flows. If you invested a massive amount right before a rally, your MWRR will look fantastic (rewarding your timing). If you invested right before a crash, your MWRR will be penalized.
Humor Alert: "TWRR is the teacher's grade for the fund. MWRR is your personal report card, showing how well you played the game of 'Investor Timing.' Don't confuse the two!"
📊 The MWRR Calculation Excel Formula (The XIRR Function):
For unevenly spaced cash flows, which is typical for any investor, you must use the powerful Excel function XIRR.
IRR/MWRR = XIRR (Values, Dates)
Values: A range of all cash flows. Investments/deposits are negative (money leaving your pocket). Withdrawals/final portfolio value are positive (money coming back).
Dates: A corresponding range of dates for each cash flow.
🔑 Summary: The Investor's Decoded Table (Save and Share This!)
Conclusion: Master Your Investment Returns: Next Steps to Wealth Building
The true mark of an advanced investor is moving beyond the excitement of a simple "2X" gain and understanding the engine of compounding. This knowledge is crucial for evaluating companies and industries, a core focus of our Fundamental Analysis training.
Remember:
Use CAGR to check if a stock's 5-year growth is sufficient.
Use TWRR to judge if you have a good fund manager.
Use XIRR to know the truth about your personal, overall portfolio performance.
Stop guessing. Start measuring. Your wealth-building journey depends on using the right tools for the job!
.jpg)
