How to Actually Measure Investment Property Returns: Cash-on-Cash, Cap Rate, and IRR
Three metrics, three different questions — confuse them and you are pricing a different deal than you think
Which number is the “real” return on an investment property — cap rate, cash-on-cash, or IRR?
There is no single “real” return — these three metrics each answer a different question, and serious investors read all three rather than picking one. Cap rate = Net Operating Income ÷ property price, measuring how productive the property is on its own, before any financing. Cash-on-cash return = annual pre-tax cash flow ÷ cash actually invested, measuring what the money you personally put in earns each year. IRR (internal rate of return) discounts every cash flow over the hold — including appreciation and the eventual sale — into one time-weighted annualized total return. They do not contradict each other; missing any one of them will skew your decision.
Definitions synthesized from Investopedia, Wall Street Prep, J.P. Morgan, and Plante Moran on cap rate, cash-on-cash return, IRR, and NOI.
In my years as a broker, the question I hear most is “what’s the return on this investment property?” The problem is that “return” is never a single number — it is at least three, and they can diverge sharply. Some people treat cap rate as if it were their cash flow, forgetting they still write a mortgage check every month. Others fixate on a healthy cash-on-cash figure while ignoring the large gain (or loss) waiting at the eventual sale. And plenty buy on a crude “annual rent ÷ price” figure that never subtracts vacancy or maintenance. In this article I’ll use three clearly labeled hypothetical examples to make cap rate, cash-on-cash, and IRR concrete: what each one measures, when to use it, and exactly where investors go wrong. To be clear up front — this is education on methodology, not personalized financial advice on any specific property of yours.
→
→
→
→
Step 1: Get NOI right — it is the foundation
Step 2: Cap rate — is the property itself worth it
Step 3: Cash-on-cash — what your own money earns
Why you need IRR: time and compounding rewrite the conclusion
Cap rate and cash-on-cash are both single-year snapshots — they say nothing about year three or year five, and they exclude the large gain or loss at sale. IRR — the Internal Rate of Return — fills that gap. IRR is the discount rate that makes the net present value (NPV) of all cash flows equal zero. In plain terms, it takes your initial outlay (negative), each year’s cash flow (positive), and the net proceeds at sale (a large positive), discounts them all for timing, and solves for one time-weighted annualized total return. Its core insight: a dollar received sooner is worth more than a dollar received later, so the timing of cash flows materially changes the result. When appreciation is realized, and which year rents rise, both move the number. That is why two properties with identical cash-on-cash can have wildly different IRRs — one leaning on a late price spike, the other on steady early cash flow, with IRR rewarding the latter for getting money back sooner.
ℹ️IRR is extremely sensitive to the assumed sale price and timing — both of which are forecasts, not facts. When deciding, run several sale-price and hold-period scenarios and look at the range of IRRs rather than trusting a single figure.
Step 4: How IRR is calculated — a hypothetical illustration
Step 5: Which to use when — never decide on one number
💡 Mistake 1: assuming zero vacancy and zero maintenance. The real world always has vacant months and repair bills; skip them and your NOI — and every metric downstream — is inflated. Mistake 2: treating cap rate as cash flow. Cap rate excludes the mortgage; a pretty 5% can shrink to 2.9% or go negative after debt service, especially when rates are high. Mistake 3: ignoring time and appreciation. Reading only cash-on-cash makes you undervalue a property with weak current cash flow but strong long-term appreciation — only IRR brings the sale proceeds and the time value of money into the picture. Three lines to remember: NOI excludes the mortgage, cash-on-cash includes it, and IRR includes appreciation and time.
Frequently Asked Questions
Which matters more — cap rate or cash-on-cash return?
It depends on your question. Cap rate measures the property’s earning power without financing, which is best for comparing different properties. Cash-on-cash includes the mortgage and measures what your invested cash earns each year, which is closer to your actual cash-flow experience. They answer different questions, so investors read both rather than picking one.
Why is my cash-on-cash return so much lower than my cap rate?
Usually the mortgage payment is eating the cash flow. Cap rate excludes debt service; cash-on-cash subtracts it. When your loan rate is above the cap rate, leverage drags returns down rather than lifting them, so cash-on-cash falls well below cap rate — sometimes turning negative. This is common in a high-rate environment.
Is IRR always higher than cash-on-cash return?
Not necessarily. If the property appreciates meaningfully over the hold, IRR is usually higher because it captures the gain at sale. But if the property loses value, or you hold briefly with weak cash flow, IRR can fall below cash-on-cash or go negative. IRR is more complete because it includes appreciation and the time value of money — but it also depends heavily on your forecast of the future sale price.
Can I calculate all three myself in Excel?
Yes. Cap rate and cash-on-cash are simple division — one formula each. For IRR, use Excel’s =IRR() or =XIRR() with a column holding the Year 0 outlay (negative), each year’s cash flow, and the final year’s cash flow including net sale proceeds. The hard part is not the formula but the assumptions — vacancy, maintenance, future sale price, hold period — which is what actually drives the result.
Discover more from GTA Real Estate Broker | Arthur Zhao
Subscribe to get the latest posts sent to your email.
