XIRR vs CAGR in Real Estate: Why Every Property Investor Must Know the Difference.

One of the biggest mistakes we see real estate investors make is using CAGR (Compound Annual Growth Rate) to calculate returns on an under-construction property. At first glance, it seems perfectly logical.

You bought a property for ₹2 crore, sold it for ₹3 crore after four years, and concluded that your annual return was 10.67%. But here's the problem. CAGR assumes you invested the entire ₹2 crore on Day One. In most under-construction projects, that's not true. You make payments over time based on construction milestones or flexible payment plans. That's where XIRR (Extended Internal Rate of Return) comes in. Unlike CAGR, XIRR accounts for when each payment was made, making it the right way to calculate returns with multiple cash flows.

What is CAGR?

Compound Annual Growth Rate (CAGR) calculates the yearly rate of return on an investment under the following assumptions:

• A lump-sum investment made at the start
• A single withdrawal at the end
• No cash flows in between

CAGR essentially answers: "What constant annual rate would my investment need to achieve to reach its final value?"

Example 1: Ready-to-Move Property (Use CAGR) Suppose you purchase a ready-to-move apartment. The CAGR Formula = (Final Value ÷ Initial Investment)^(1 ÷ Number of Years) − 1

Where:

·       Final Value = Selling Price

·       Initial Investment = Purchase Price

·       Number of Years = Holding Period

Substituting the values: CAGR = (₹3,00,00,000 ÷ ₹2,00,00,000)^(1 ÷ 4) − 1

= (1.5)^0.25 − 1

= 1.1067 − 1

= 0.1067

= 10.67% per annum

Since the entire ₹2 crore was invested on Day One, CAGR correctly measures the annual return.

Why CAGR Doesn't Work for Under-Construction Properties

Now let's consider the same ₹2 crore property, but this time it's purchased under a Construction Linked Plan (CLP). Instead of paying the builder in one go, payments are made in stages.

Total Investment = ₹2,00,00,000 The property is sold on 1 January 2026 for ₹3,00,00,000. Now ask yourself: Did you really have ₹2 crore invested for four full years? "No"

1. The first ₹20 lakh remained invested for four years.
2. The next ₹30 lakh remained invested for about three and a half years.
3. The ₹40 lakh remained invested for about two and a half years.
4. The ₹50 lakh remained invested for about one and a half years.
5. The final ₹60 lakh remained invested for only one year.

Yet, if you use CAGR, it assumes every rupee was invested for four years. That's mathematically incorrect.

What is XIRR?

XIRR (Extended Internal Rate of Return) is a financial metric that calculates the annualized return on an investment by taking into account the exact dates of every cash inflow and outflow. Unlike simple rate of return or CAGR, which assume investments and withdrawals occur at regular intervals, XIRR handles situations where cash flows are irregular or unevenly spread over time.

For example, if you invest additional amounts at different times or receive periodic returns, XIRR provides a more accurate measure of your investment’s performance. By considering the timing and size of each transaction, XIRR reflects your money's actual earning power.

In Microsoft Excel, simply use: =XIRR(B2:B7,A2:A7) Result ≈ 18.8% per annum. Although the profit is still ₹1 crore, the annualised return is much higher because your capital was invested gradually rather than all at once. Important: The 18.8% XIRR is specific to this payment schedule. XIRR is not always higher than CAGR. It depends on the timing of each investment, the cash flow pattern, and the final sale value.

CAGR vs XIRR

The profits are identical. The returns are not. That's because return depends not only on how much you invest but also on when you invest it.

Why Timing Matters?

Imagine two investors. Investor A buys a ready-to-move apartment by paying ₹2 crore upfront. Investor B buys an under-construction apartment of the same value but pays ₹2 crore over four years through a construction-linked payment plan.

Both eventually sell their properties for ₹3 crore. Each makes a profit of ₹1 crore. Does that mean both earned the same annual return? Absolutely not. Investor B had much less capital tied up during most of the investment period. Since less money was invested for a shorter duration, Investor B's capital generated the same profit more efficiently. That's exactly what XIRR captures.

CAGR vs XIRR: Which One Should You Use?

The thumb rule is:

1. One investment + One sale = CAGR.
2. Multiple investments or receipts = XIRR

Why Professional Investors Prefer XIRR?

Institutional investors don't just look at profits; they evaluate capital efficiency. XIRR lets them compare real estate performance with other options such as Mutual Funds, SIPs, Stocks, Bonds, REITs, Private Equity, and alternative investment funds (AIFs). Since XIRR converts all irregular cash flows into a single annualised return, it provides a fair comparison across different asset classes.

Final Thoughts

Many investors focus only on the total profit made from a property. Professional investors focus on how efficiently their capital generated that profit. That's the difference between looking at returns and understanding returns. If your investment involves a single upfront payment, CAGR is the right metric.

If your investment involves staggered payments, milestone-based construction payments, flexible payment plans, rental income, or any other irregular cash flows, XIRR is the correct measure. The next time someone tells you they earned 15% annually on a property, ask them one simple question: "Did you invest the entire amount on Day One, or did you pay over time?" That single question determines whether you should measure the answer using CAGR or XIRR.

In real estate, it's not just how much you invest; it is also when you invest that determines your true return.

FAQ's

What's the main difference between CAGR and XIRR?
CAGR assumes a single lump-sum investment made at the start and one final payout. XIRR accounts for multiple cash flows made at different times, making it more accurate for staggered payments.

When should I use CAGR to calculate my real estate returns?
Use CAGR only when you made a single upfront payment for a ready-to-move property and sold it once, with no cash flows in between.

Why doesn't CAGR work for under-construction properties?
Under a construction-linked plan, payments are made in stages over time. CAGR incorrectly assumes the full amount was invested from Day One, which overstates how long your capital was actually tied up.

If two investors make the same profit, do they earn the same return?
Not necessarily. An investor who paid in stages had less capital tied up for a shorter time, so their capital generated the same profit more efficiently, resulting in a higher XIRR.

Is XIRR always higher than CAGR?
No. It depends on the specific payment schedule, timing of investments, and final sale value. XIRR can be higher or lower than CAGR depending on the cash flow pattern.

How do I calculate XIRR?
In Excel, you can use the formula =XIRR(cash flow range, date range) to get an annualized return based on the exact timing of each payment and receipt.

Why do professional investors prefer XIRR?
XIRR measures capital efficiency, not just total profit, allowing fair comparisons between real estate and other investments like mutual funds, stocks, bonds, or REITs.