IRR Calculator: How to Measure Property Performance with Internal Rate of Return
Internal Rate of Return (IRR) Calculator
Internal Rate of Return (IRR) Calculator
What Is IRR?
IRR is the annualized rate of growth an investment is expected to generate based on its projected cash flows and eventual sale.
Think of IRR as the annual "growth rate" your property would earn if everything goes according to plan. When you're comparing multiple properties or portfolios, it's a reliable way to evaluate deals of different sizes, timelines, and risk levels because it accounts for when money moves in and out.
Every investor wants their capital to work efficiently. Knowing your IRR shows how effectively each dollar you invest is performing and whether a deal is truly building your wealth.
How Do You Calculate IRR for Commercial Property?
Start by listing every cash flow from purchase to sale, then find the rate of return that brings them all to today's value.
Here's the breakdown:
- Estimate your initial equity investment (negative cash flow at year zero).
- Forecast annual net cash flows from operations (income minus expenses minus capital expenditures). Your net operating income (NOI) drives this figure.
- Estimate the sale or refinance proceeds at exit (positive cash flow at the end).
The internal rate of return represents the discount rate that makes the total present value of all future cash flow equal your initial investment. In simpler terms, it's the annualized return that balances what you put in with what you expect to get back over time.
IRR Formula
0 = Sum of [Cash flow in period t / (1 + IRR)^t] - Initial investment
Where:
- CFt = Cash flow in period t (the net income after expenses in each year)
- t = Time period (0, 1, 2, 3... representing each year)
- IRR = The internal rate of return you're solving for
- Initial investment = Your upfront equity
Getting this right gives you more than a number. It gives you a clear sense of whether your investment is truly building long-term wealth.
Tip for investors: Model your cash flows carefully. Account for when property taxes, utilities, and lease-up costs (the dollars to attract and sign tenants until stabilized) actually occur, and use reliable local market data when estimating your exit cap rate.
Instead of solving the formula by hand, let Excel and Google Sheets do the heavy lifting for you.
In Excel or Google Sheets, use the =XIRR() function. Enter your cash flows in a column (starting with the initial investment as a negative number), add the corresponding dates in a second column, then apply =XIRR(values, dates). The spreadsheet returns your IRR as a percentage.
Why XIRR instead of the basic IRR function? The standard =IRR() function assumes cash flows occur at perfectly even intervals, which rarely reflects real property investments. =XIRR() accounts for actual dates, making it far more accurate for CRE analysis where rent payments, capital expenditures, and sale proceeds rarely line up to the exact month.
Before committing capital, model at least two scenarios in your spreadsheet: one with conservative rent growth and one with a higher vacancy assumption. Once you've run both, you'll have a much clearer picture of what this deal can actually survive.
How Does IRR Work?
Two five-year scenarios show how the timing of cash flows, not just the total amount, determines your return.
IRR can look simple on paper, but when your cash flow arrives matters just as much as how much arrives. The two scenarios below use the same annual amount and the same exit price. The only difference is timing.
| Year | Scenario A Cash Flow | Scenario B Cash Flow |
|---|---|---|
| 0 | -$1,000,000 | -$1,000,000 |
| 1 | $80,000 | $0 |
| 2 | $80,000 | $0 |
| 3 | $80,000 | $100,000 |
| 4 | $80,000 | $100,000 |
| 5 | $80,000 + $1,200,000 | $100,000 + $1,200,000 |
| IRR | ~11.2% | ~8.8% |
Scenario B produces a lower IRR despite paying $100,000 per year in years 3 to 5, more than Scenario A's $80,000. Those two years of zero income at the start drag the time-weighted return down enough to outweigh the higher payments later. This is the core of what IRR measures: not just what you earned, but when you earned it.
What Is a "Good" IRR?
A "good" IRR depends on your strategy, your risk tolerance, and what else you could do with your money.
There's no universal benchmark, but a useful starting point is to compare your target IRR against your opportunity cost: What could you earn by deploying that capital elsewhere? For example, if Government of Canada bonds are yielding around 3.5%, a commercial real estate deal would need to deliver meaningfully more to justify the added complexity, illiquidity, and risk.
A rough framework that many Canadian CRE investors use:
- Core assets (stabilized, low-risk properties): These target the lowest IRR, reflecting stable income and lower execution risk.
- Value-add assets (properties needing repositioning or renovation): Investors expect a meaningfully higher IRR to compensate for the added complexity and execution risk.
- Opportunistic or development projects: These carry the highest IRR targets, reflecting the greatest level of uncertainty and capital at risk.
These targets shift depending on market conditions, interest rates, and your cost of capital. The Bank of Canada's policy rate decisions are a practical reference point for current context.
If you use financing, your target IRR should be higher than an all-cash scenario, since leverage amplifies both the upside and the downside. The key is to use IRR as a compass, not a finish line.
How Is IRR Different from Other Return Metrics?
Cap rate and cash-on-cash return show a snapshot in time, while ROI ignores timing entirely and IRR captures the full investment journey.
Understanding where IRR sits relative to other metrics helps you know when to reach for it and when to pair it with something else. While cap rate and cash-on-cash return offer quick snapshots, they only show how a property performs at one point in time. IRR captures the full investment journey by accounting for both timing and growth in cash flow.
For example, two retail properties for sale in Vancouver might start with the same cap rate. The one with earlier lease renewals and steadier rent growth will likely deliver better returns when measured through IRR.
Most first-time investors already know return on investment (ROI): divide your total profit by your initial investment and you get a percentage. The problem with ROI in CRE is that it ignores time entirely. A 20% ROI over two years and a 20% ROI over ten years look identical on paper, but they represent very different levels of investment performance. IRR solves for this by incorporating when cash flow actually occurs to give you a time-adjusted annual return.
| Metric | Accounts for Timing? | Best Used For |
|---|---|---|
| IRR | Yes | Multi-year CRE investment analysis |
| ROI | No | Quick profitability snapshot |
| CAGR | Partially | Smoothed average growth over a fixed period |
What Impacts IRR the Most?
The timing of cash flows, exit value, and capital spend are the biggest drivers.
Here's how each one can influence your returns:
- Timing of cash flows: Faster lease-up or early rent growth improves IRR.
- Exit value: Selling at a tighter cap rate or higher price increases IRR.
- Capital spend: Major renovations, tenant improvements, or long vacancy periods reduce IRR.
IRR also varies by asset class. If you were comparing office properties for sale in Calgary, you might need to expect longer lease-up times than industrial or retail buildings, which affects early cash flow.
What Are the Limitations of IRR?
IRR doesn't account for risk, reinvestment assumptions, or uneven cash flow patterns.
Like any financial tool, IRR works best when you know what it can and can't tell you. Keep in mind:
- It assumes interim cash flows are reinvested at the same IRR, which isn't always realistic.
- Unusual cash flow patterns can create more than one IRR.
- IRR measures efficiency, not size. A 20% IRR on $100,000 isn't the same as 20% on $10 million.
Knowing where IRR falls short before you rely on it is the difference between a confident decision and an expensive surprise. Once you're analyzing more advanced deals, always look at IRR alongside NPV, equity multiple, and hold period to understand both efficiency and scale. This is especially true for land for sale, where cash flows may be limited until development begins, making IRR less predictive on its own.
Commercial Properties For Sale
Frequently Asked Questions
Should I always pick the deal with the higher IRR?
Not always. A higher IRR can come with more risk or a shorter hold period, so it's important to look at the full picture. Use IRR alongside metrics like cap rate and cash-on-cash return to understand how the deal performs under different assumptions.
Does leverage increase IRR?
Usually, yes. When borrowing costs are lower than your property's return, leverage can lift IRR, but it also increases exposure to risk. Always model different loan scenarios to see how financing terms affect both returns and resilience.
Can IRR be negative?
Yes. If the total discounted cash flows are less than your initial investment, the IRR will be negative. This typically happens when income falls short or expenses rise faster than expected, so tracking performance early can help you course-correct.
How often should I update IRR?
Review your IRR annually or whenever rents, expenses, or financing terms change significantly. Regular updates help you spot shifts in performance early and keep your investment plan aligned with your long-term goals.
