Common IRR Mistakes : Why Your IRR Is Wrong (and How to Fix It)
IRR (internal rate of return) is a powerful metric—if your cash flows are complete, timed correctly, and modeled consistently. The problem is that IRR is extremely sensitive to missing line items and timing assumptions. A single mistake (selling costs, taxes, a mid-hold capital expense, or a timing shift) can change IRR by several percentage points—sometimes flipping the “yes/no” decision. This guide covers the most common IRR mistakes in real estate and investing, plus a practical checklist you can use to compute an IRR you can trust.
Jump to section
Quick Answer
The #1 reason IRR is wrong is simple: the cash flows are wrong or inconsistently timed. Missing selling costs, ignoring taxes, forgetting reserves, smoothing lumpy expenses, or mixing annual and monthly timing can all produce misleading IRR.
If you want an IRR you can trust:
- Model net cash flows (after expenses, reserves, and taxes if included).
- Include exit costs (commissions, closing costs, payoff, taxes if relevant).
- Use consistent timing (annual vs monthly vs dated cash flows).
- Validate with NPV at a hurdle rate and scenario stress tests.
Rule: If you can’t explain every line in the cash flow timeline, the IRR is just a guess with decimals.
The IRR Foundation: What Must Be True Before IRR Means Anything
IRR is not magic. It’s a calculation on a list of cash flows. If your cash flows are incomplete or inconsistent, IRR becomes a misleading output. Before focusing on the IRR number, make sure these foundations are solid:
1) Define the perspective: whose IRR are you calculating?
IRR can be calculated for:
- Equity investors (cash invested and cash received on equity)
- The property / asset (unlevered IRR, before financing)
- A sponsor / GP (after promote / carried interest)
- Lender (yield to lender, different concept)
If you mix perspectives, you can get numbers that look comparable but aren’t. Always label IRR clearly: “levered equity IRR,” “unlevered IRR,” or “LP net IRR.”
2) Define the timing convention
Are cash flows annual at year-end? Monthly? Exact dates? IRR is extremely sensitive to timing—so you must define the convention before calculating. For irregular dates, use XIRR-style dated cash flows (or at least be consistent).
3) Decide whether taxes are included
Some models are pre-tax. Others include after-tax cash flows. Either approach can be fine—but mixing pre-tax on one deal and after-tax on another makes comparisons meaningless. Be consistent and transparent.
4) Define the exit clearly
Many IRR mistakes happen at the exit: gross sale price gets modeled, but net proceeds are what investors actually receive. Exit modeling must include: selling costs, debt payoff, and realistic transaction friction.
15 Common IRR Mistakes (and How to Fix Them)
1) Missing a cash flow category (the “incomplete timeline” mistake)
IRR is only as good as the cash flow series. Common missing items include: reserves, leasing commissions, tenant improvements, turnover costs, major repairs, and legal/HOA surprises. Fix: build a checklist of cash flow categories and never compute IRR without it.
2) Using gross sale price instead of net sale proceeds
Gross sale price is not cash in your pocket. Fix: subtract broker commissions, closing costs, transfer taxes (if applicable), and any other sale friction. Then subtract remaining loan payoff. What remains is net equity proceeds.
3) Forgetting selling costs entirely
Especially in short holds (3–7 years), selling costs can dominate the return. Fix: include realistic selling costs even in “base case” models. Don’t hide them in optimistic assumptions.
4) Confusing principal paydown with cash flow
Paying down principal increases equity, but it is not spendable cash flow (unless you refinance or sell). Fix: treat principal paydown as equity buildup that shows up at exit, not as operating cash flow.
5) Mixing levered and unlevered returns
Levered IRR (equity) and unlevered IRR (asset) answer different questions. Fix: calculate both if needed, but compare deals on the same basis.
6) Double-counting financing effects
A common model error: counting loan proceeds as income and also counting full purchase price as an equity outflow. Fix: build the equity cash flow correctly: equity outflow = down payment + closing costs + initial CapEx (net of financing).
7) Ignoring mid-hold capital needs (capital calls / big CapEx)
Roofs, HVAC, plumbing, and major renovations can require large negative cash flows later. Fix: include lumpy CapEx. If you ignore it, IRR is inflated and risk is hidden.
8) Smoothing cash flows unrealistically
Models often assume steady rent growth and stable expenses. Real life has vacancy, turnover, repairs, insurance spikes, and tax reassessments. Fix: include vacancy assumptions, turnover costs, and reserves.
9) Using optimistic timing (cash flows earlier than realistic)
IRR rewards earlier cash flows. If a model assumes rents increase immediately after renovation or lease-up is instant, IRR can look artificially high. Fix: model realistic ramp-up periods and delays.
10) Calculating IRR on partial cash flows (missing the exit)
Some people compute IRR on operating cash flow only, without a sale. That’s not a complete investment lifecycle return. Fix: either include the exit or use cash-on-cash for operating yield.
11) Misusing IRR for deals with multiple sign changes (multiple IRRs possible)
If cash flows switch signs more than once (invest → receive → invest again), IRR can be ambiguous or unstable. Fix: validate with NPV at a hurdle rate and consider MIRR.
12) Mixing annual IRR with monthly cash flow assumptions
If cash flows are monthly but you calculate IRR annually, you can introduce timing distortion. Fix: keep frequency consistent (monthly model → monthly IRR, or convert carefully).
13) Using IRR without a hurdle rate / NPV decision filter
A deal can have a “good” IRR but still not beat your alternatives after risk. Fix: set a hurdle rate and compute NPV at that rate. If NPV is negative, the deal doesn’t clear your minimum.
14) Ignoring taxes (or inconsistently including them)
Taxes can materially change net returns. Fix: decide whether your analysis is pre-tax or after-tax and be consistent across deals. If you include taxes, include them on all scenarios you compare.
15) Treating IRR as the only metric
IRR can be “high” even when profit dollars are small, cash flow is fragile, or the deal is exit-dependent. Fix: use a return dashboard: IRR (or MIRR), NPV, equity multiple, profit dollars, and cash-flow stress tests.
Shortcut: If the model doesn’t include net sale proceeds after costs + debt payoff, your IRR is not a real lifecycle IRR.
Timing Errors: IRR’s Biggest Weakness
IRR is highly sensitive to timing because discounting is exponential. A payment received earlier is worth more today than the same payment received later. That is correct mathematically—but it means timing assumptions can quietly dominate IRR.
End-of-year vs mid-year vs exact dates
If your spreadsheet assumes all cash flows happen at year-end, but in reality rent arrives monthly, the IRR can be slightly distorted. Sometimes it doesn’t matter much; sometimes it does—especially for shorter holds. For irregular timing, dated cash flows (XIRR approach) produce more realistic results.
Renovation timing and lease-up timing
Value-add deals often assume you renovate, raise rents, and stabilize quickly. If that timeline slips, IRR can fall sharply. A realistic model should include: renovation duration, vacancy during renovation, leasing time, and rent ramp-up.
Exit timing assumptions
Many investors underestimate how long a sale can take (marketing, inspections, buyer financing). Pushing the exit by even 6–12 months can change IRR materially. That’s why timeline stress tests should be standard.
Exit Mistakes: Selling Costs, Taxes, and Net Proceeds
The exit is where most “too good to be true” IRRs are born. In many real estate deals, the sale proceeds are the largest single cash flow. If that number is inflated, the IRR headline becomes misleading.
Model exit the same way you’d model reality
A disciplined exit model typically starts with an estimated sale price, then subtracts:
- Broker commission
- Seller closing costs
- Transfer taxes (where applicable)
- Repair credits / concessions (a buffer)
- Loan payoff (remaining principal + payoff fees if any)
- Capital gains taxes (if your analysis is after-tax)
What remains is net equity proceeds to the investor. That’s what belongs in the IRR cash flow series.
IRR honesty check: Calculate the “% of total return from the exit.” If most value comes from the exit, the deal is more speculative than it looks.
Levered vs Unlevered Confusion (and Why It Breaks Comparisons)
Real estate returns can be computed in two ways:
- Unlevered (asset-level): assumes no debt, measures property performance.
- Levered (equity-level): includes financing, measures investor equity return.
Both are useful, but they are not interchangeable. A low unlevered IRR can still produce a high levered IRR if leverage is used aggressively. But leverage also increases downside.
Fix: label and compare consistently
If you compare two deals, make sure you are comparing the same return type: levered equity to levered equity, or unlevered to unlevered. If one deal has different loan terms, leverage changes the return profile. That’s not “free return”—it’s increased risk.
Real Estate-Specific IRR Modeling Traps
Vacancy and turnover under-modeling
Many models assume full occupancy and low turnover. In reality, vacancy and turnover costs are part of the business. If you don’t include them, cash flows are too smooth and IRR is inflated.
Property tax and insurance growth ignored
Taxes and insurance can grow faster than inflation. Ignoring their growth makes long-hold IRR look better than reality. A conservative model should include rising operating costs.
Maintenance and CapEx treated as optional
Some models include only a small “repairs” line. But large CapEx events (roof, HVAC, exterior) can dominate returns. If you don’t model them, your IRR is optimistic and risk-blind.
Refinance modeled as pure upside
A refinance can return capital and boost IRR, but it’s not free money: it increases leverage and future debt service. Treat refinance as a risk shift, not a guaranteed benefit.
How to Fix IRR: A Step-by-Step Checklist You Can Reuse
Step 1: Build the cash flow timeline (every inflow and outflow)
- Initial equity outflow (down payment + closing costs + initial CapEx)
- Net operating cash flows (after all operating expenses and reserves)
- Mid-hold CapEx or capital calls (negative cash flows)
- Exit net proceeds (sale price minus costs minus loan payoff)
Step 2: Choose timing method
If cash flows happen on specific dates, use dated cash flows (XIRR approach). If using annual, define whether you assume end-of-year or mid-year and stay consistent.
Step 3: Validate exit math separately
Calculate net sale proceeds on a separate line and confirm the numbers make sense. Many IRR errors are simply exit math mistakes.
Step 4: Run IRR and validate with NPV at a hurdle rate
IRR alone is not a decision filter. Compute NPV at your hurdle rate: if NPV is positive under conservative assumptions, the deal is more robust.
Step 5: Add scenario stress tests
Test: exit price haircut, exit delay, higher expenses, vacancy shock, interest rate/refi shock. If IRR collapses, the deal is fragile and you need a lower price or more margin of safety.
Want to compute IRR the right way?
Model net cash flows and net sale proceeds, then validate with NPV and stress tests. A clean IRR is a process, not a button.
Return Dashboard: What to Report With IRR
If you want IRR to be useful instead of misleading, always pair it with:
- NPV at your hurdle rate (decision clarity)
- Equity multiple (dollars back per dollar in)
- Total profit dollars (absolute outcome)
- Cash-on-cash and worst-year cash flow (survivability)
- % of return from exit (exit dependence)
Simple rule: If someone gives you IRR without equity multiple and net exit proceeds, you don’t have enough information to evaluate the deal.
Fast Stress Tests (IRR Sanity Checks)
1) Exit haircut + delay
Reduce sale price and delay sale by one year. If IRR collapses, the deal is exit-dependent.
2) Expense spike scenario
Increase insurance/taxes/maintenance. Many “good IRR” models fail when expenses rise.
3) Vacancy + repair in the same year
Add vacancy and a major repair simultaneously. If cash flow becomes negative, compute required reserves.
4) Refinance realism (if applicable)
If a refinance drives IRR, test higher refinance rate and lower appraisal value. If the deal breaks, the refinance assumption is fragile.
5) Multiple IRR detection
Count sign changes in cash flows. If they change sign more than once, prefer NPV/MIRR dashboards over IRR alone.
Frequently Asked Questions
What is the most common IRR mistake?
Incomplete cash flows—missing selling costs, taxes, reserves, or mid-hold capital needs. If the cash flow timeline is wrong, IRR is wrong.
Why do two tools give different IRR for the same deal?
Usually because of timing assumptions (annual vs monthly vs exact dates), end-of-period vs mid-period conventions, or multiple sign changes (multiple IRRs). Use dated cash flows (XIRR) and validate with NPV.
Should I use IRR or NPV to make a decision?
Use NPV at a hurdle rate for clearer decisions. IRR is a helpful summary percentage, but NPV directly tells you whether the deal creates value above your required return.
How can I sanity-check an IRR quickly?
Run a conservative scenario: include selling costs and taxes (if relevant), add reserves and lumpy CapEx, haircut the exit price, and delay the sale by a year. If IRR collapses, the deal is fragile.
Is IRR useless if it has pitfalls?
No—IRR is useful as a summary metric when cash flows are complete and “normal” (one sign change). The mistake is using IRR alone as a decision tool. Pair it with NPV, equity multiple, dollars, and stress tests.
Bottom Line
IRR mistakes are rarely about complex math—they’re about missing cash flows and unrealistic timing. To compute an IRR you can trust, model net cash flows, include net exit proceeds after selling costs and debt payoff, label levered vs unlevered returns, and validate decisions with NPV at a hurdle rate. Then stress-test the exit and the timeline. If the deal still works under conservative assumptions, the IRR becomes meaningful instead of misleading.
Next step: build a full cash flow timeline in the IRR calculator, then add NPV + equity multiple and run exit stress tests.
Methodology and assumptions
Educational only. IRR depends on the completeness and timing of cash flows. Always include net sale proceeds, realistic reserves and CapEx, and scenario stress tests. Use NPV at a hurdle rate for clearer decisions.