Internal Rate of Return (IRR) for Rental Properties: A Step-by-Step Guide

Q: When should I use XIRR instead of IRR?

Use XIRR() whenever cash flows do not occur at perfectly regular annual or monthly intervals. A closing in March, distributions in June and December, and a sale in October require dated cash flows. IRR() would treat them as evenly spaced and produce a misleading result.

Last reviewed: 2026-05-08 — ScoutMyTool Editorial

You are deciding between two duplexes. Property A throws off steady $9,000 a year in cash flow but barely appreciates. Property B is cash-flow flat for three years, then a tenant turnover and small remodel push rents up, and a sale in year five delivers a $120,000 gain. Cap rate says A wins. Cash-on-cash says A wins. But after the sale, B was the better investment by a wide margin. Cap rate is a snapshot of one year, and cash-on-cash return ignores appreciation and the eventual sale. Internal rate of return (IRR) is the metric that ties every dollar in and every dollar out together, weighted by when it happens.

This guide walks through the IRR formula, how to compute it manually and in Excel, why it can produce more than one answer, common pitfalls, and a side-by-side worked example so you can see exactly why intermediate investors graduate from cap rate to IRR.

Free ScoutMyTool tools

Compound Interest Calculator

Visualize compounding returns

BMI Calculator

Quick body-mass index

Merge PDFs

Combine multiple PDFs

Browse all tools →

What IRR Actually Measures

IRR is the discount rate that makes the net present value (NPV) of all cash flows from an investment equal to zero. Mathematically,

Σ CFₜ / (1 + r)ᵗ = 0

where CFₜ is the cash flow in period t (negative for outflows, positive for inflows) and r is the IRR. Solve for r and you have the annualized return that reconciles the timing and magnitude of every cash flow over the life of the deal, including the sale.

This is fundamentally different from cap rate, which is just net operating income divided by purchase price for one stabilized year. The U.S. Securities and Exchange Commission's investor education site treats internal rate of return as the standard measure of an investment's annualized return. Institutional real-estate investors track IRR alongside time-weighted return because IRR captures how much capital was at work and for how long, which is exactly what a buy-and-hold landlord wants to know.

The CFA Institute publishes the Global Investment Performance Standards (GIPS), which require private real estate composites to report a since-inception IRR. The convention exists because cap rate and cash-on-cash, while useful, omit two of the most important drivers of total return: appreciation and exit timing. Brueggeman and Fisher's Real Estate Finance and Investments treats IRR as the central yardstick once a hold-period model is built.

Why Cap Rate and Cash-on-Cash Miss the Point

Cap rate is a pricing tool. It tells you how the market values a stabilized stream of NOI in a particular submarket. It is a single-period ratio. If you buy a property at a 6% cap and hold it for ten years, the cap rate at purchase tells you almost nothing about the return you actually earned over that decade. Compare cap rate against the cap rate calculator on ScoutMyTool to size up a deal at acquisition, but do not confuse it with a return measure.

Cash-on-cash return divides annual pre-tax cash flow by the cash you put in. It is intuitive and it captures leverage, but it ignores principal paydown, appreciation, and the eventual sale. A property with mediocre year-one cash flow and a strong rent-growth trajectory will look worse on cash-on-cash than a flat-line property in a stagnant market—right up until the sale, when reality reasserts itself.

IRR plugs both holes. It absorbs the equity check on day one as a negative cash flow, every year of operating cash flow as positive (or negative), and the net sale proceeds at exit. The single resulting rate is the annualized compounded return on the equity actually deployed, weighted by when it was deployed. Treating real estate as a general investment return problem clarifies why IRR is the workhorse for any multi-year analysis.

The IRR Formula and How to Solve It

There is no closed-form algebraic solution for IRR when you have more than two periods. You must solve iteratively. Three approaches are practical.

Trial and error. Pick a guess, compute NPV, adjust until NPV is close to zero. This is what early real-estate textbooks teach because it builds intuition. If your guess produces a positive NPV, the true IRR is higher; if NPV is negative, IRR is lower. Bracket and bisect.

Newton's method. Start with a guess r₀, then iterate r_{n+1} = r_n − NPV(r_n)/NPV'(r_n), where NPV'(r) is the derivative of NPV with respect to r. This is what spreadsheets and financial calculators do under the hood. Convergence is usually fast (3–8 iterations) when cash flows behave nicely.

Spreadsheet IRR(). Excel and Google Sheets implement the iterative solver and accept an optional guess argument, defaulting to 10%. Microsoft documents the IRR function and notes the values list must contain at least one positive and one negative number and that cash flows must occur at regular intervals. For irregular dates, use XIRR(), which accepts a date column.

A subtle but important point: IRR can have multiple real solutions when the sign of cash flows changes more than once. Descartes' rule of signs tells you the maximum number of positive real roots equals the number of sign changes in the coefficient sequence. A property that needs a major capex injection in year three—producing a single negative cash flow surrounded by positives—has two sign changes and can produce two valid IRRs. Practitioners handle this by either (a) using modified IRR (MIRR()) which assumes a separate financing rate and reinvestment rate, or (b) solving for NPV at a target hurdle rate and reporting NPV alongside IRR.

How the Calculator Works

The ScoutMyTool cash-on-cash calculator handles the simple year-one ratio, while the investment return calculator generalizes the IRR computation to any series of dated cash flows. Enter the equity check as a negative number on day one, the projected annual cash flows for each year of the hold, and the net sale proceeds (after broker commission, mortgage payoff, and selling costs) in the final year. The calculator runs Newton's method and returns the annualized IRR. Pair it with the compound interest calculator to sanity-check what an equivalent passive return would have produced over the same hold.

Worked Example 1 cash flows. Equity check at Y0 (-$80K), modest annual operating cash flow, terminal sale at Y5. Solving Σ CFₜ/(1+r)ᵗ=0 with the Excel IRR() Newton-method solver yields ≈23.6%. Cap rate at purchase was 6.5% — IRR captures the appreciation and exit timing the cap rate cannot.

Worked Examples

Example 1: Five-year buy-hold-sell, levered. Purchase price $300,000. Equity in (down payment plus closing costs and initial reserves) $80,000 on day zero. Year-one NOI $19,500 against debt service of $14,400 produces $5,100 of cash flow. Annual rent and NOI growth of 3%; cash flow grows roughly in line. Sale at end of year five at a 5.5% cap on year-six NOI ($23,400 ÷ 0.055 = $425,000), less $25,500 of selling costs, less remaining mortgage balance of $208,000, leaves $191,500 of net sale proceeds. The cash flow vector is [-80,000; 5,100; 5,253; 5,411; 5,573; 5,740 + 191,500]. Excel IRR() returns approximately 23.6%. Cap rate at purchase was 6.5%. Year-one cash-on-cash was 6.4%. IRR captures everything the other two miss.

Example 2: Same property, no appreciation. Hold the cash flows constant at the year-one figure ($5,100) and assume the property sells for the same nominal price as purchase, with $208,000 mortgage payoff and $25,500 selling costs—net proceeds $66,500. Cash flow vector [-80,000; 5,100; 5,100; 5,100; 5,100; 5,100 + 66,500]. IRR is approximately 2.9%. Cap rate and cash-on-cash look identical to Example 1, but IRR exposes the lack of price appreciation.

Example 3: Capex year and sign-change warning. Purchase $300,000, equity in $80,000. Cash flows [-80,000; 4,000; 4,200; -22,000; 6,500; 6,700 + 195,000]. The negative cash flow in year three (a roof and HVAC overhaul) creates two sign changes. Excel IRR() with default guess returns 19.1%; with a guess of -50% it converges to a second root near -71%. The 19.1% figure is the economically meaningful answer; reporting it alongside NPV at a 10% hurdle ($23,400) is the cleanest disclosure.

Common Pitfalls

Confusing levered and unlevered IRR. Levered IRR uses equity cash flows after debt service. Unlevered (or "free cash flow to property") IRR ignores financing entirely. They answer different questions and are not interchangeable. State which one you are reporting.

Ignoring closing and selling costs. Day-zero costs and exit costs both materially shrink IRR. Round-trip transaction costs of 8–10% on a five-year hold can compress IRR by 200–400 basis points. Brueggeman and Fisher show this drag explicitly in their hold-period worksheets, and the IRS guidance on the tax treatment of selling a home and rental property confirms which costs are deductible at sale.

Reinvestment-rate fantasy. IRR implicitly assumes interim cash flows are reinvested at the IRR itself. For a deal projected at 25% IRR, that is unrealistic. MIRR fixes this by letting you specify a separate, lower reinvestment rate. When IRRs get above roughly 20%, report MIRR alongside.

Using IRR to rank deals of very different sizes. A 30% IRR on $20,000 of equity and a 15% IRR on $400,000 of equity can both look attractive, but they build wealth at very different scales. Pair IRR with equity multiple and total dollar profit when ranking.

Forgetting depreciation recapture and capital-gains tax. Pre-tax IRR is what most investors compute. After-tax IRR depends on holding period, depreciation taken, and the investor's marginal bracket. The IRS Publication 527 on residential rental property and the rules for unrecaptured Section 1250 gain (taxed at a maximum 25% rate) are required reading; ordinary gain on personal property recapture is at the marginal rate. After-tax IRR is typically 200–500 bps below pre-tax for buy-and-hold rentals.

Treating IRR as a stand-alone decision rule. A high IRR earned over six months on a flip is not the same as the same IRR earned over seven years on a stabilized rental. Always pair IRR with hold period, equity multiple, and a sensitivity table on rent growth and exit cap rate.

Frequently Asked Questions

Q: Is a "good" IRR for rental property a fixed number? A: No. The hurdle depends on risk. Stabilized core multifamily in primary markets historically clears 8–12% pre-tax, value-add deals 14–18%, and ground-up development 20%+ to compensate for risk. Compare your IRR against the Federal Reserve's Survey of Consumer Finances data on household equity returns and the 10-year Treasury yield to set your own minimum acceptable rate.

Q: When should I use XIRR instead of IRR? A: Use XIRR() whenever cash flows do not occur at perfectly regular annual or monthly intervals. A closing in March, distributions in June and December, and a sale in October require dated cash flows. IRR() would treat them as evenly spaced and produce a misleading result.

Q: Why might IRR have multiple answers? A: When the cash-flow stream changes sign more than once—a buy, distributions, a major capex year, more distributions, then a sale—the polynomial whose root is IRR can have multiple real roots. Use NPV at a hurdle rate or MIRR to disambiguate. The Microsoft documentation for IRR addresses this in its remarks section.

Q: Should I include my own labor as a cash flow? A: For self-managed rentals, opportunity-cost labor should at least appear in a sensitivity case. Allocate a fair-market property-management fee (typically 8–10% of collected rent) as an outflow and rerun the IRR. If the deal still clears your hurdle after paying yourself, it is a true investment return rather than a job.

Q: How do institutional investors benchmark IRR?

A: They compare against the National Council of Real Estate Investment Fiduciaries (NCREIF) Property Index for unlevered core returns and against private-equity real-estate fund composites reported under the GIPS standards. Individual landlords rarely have access to NCREIF data directly but can read the quarterly index summaries published in the financial press for context on broad-market trends.

Q: Does IRR change when interest rates move?

A: Indirectly — exit cap rates and refinancing terms are correlated with prevailing rates, so a rising-rate environment compresses IRR through both higher debt service and weaker exit pricing. The Federal Reserve Bank of New York Quarterly Report on Household Debt and Credit and Freddie Mac PMMS are the standard rate references; rerun your IRR sensitivity table at the higher of (a) current 30-yr rate, (b) historical median 30-yr rate, and (c) market-stress scenario.

A Final Note

This article is general financial information, not investment or tax advice; consult a CPA or licensed financial advisor before acting on a specific deal.