Four constructed deals where cap rate, cash-on-cash and IRR each give the wrong answer. Full arithmetic at 6.67% money, plus which metric to lead with.
Cap rate measures the asset, cash-on-cash measures your capital in year one, and IRR measures every dollar across the whole hold including the sale — so all three can be correct and still point three different directions on the same property. The useful question is not which metric is best. It is which one is lying to you on the deal in front of you.
Most articles define the three formulas and stop. This one builds four deals where the metrics openly disagree, shows all the arithmetic, and names each one's failure mode.
Cap rate is NOI divided by purchase price. NOI is effective gross rent minus operating expenses and the CapEx reserve — no mortgage payment, ever. That omission is the point: cap rate compares buildings on equal footing regardless of who buys them or how, so a cash buyer and a 75%-leveraged buyer compute the identical number on the same property. Which also means it cannot see your loan, your rate, your rehab budget or your closing costs. In most markets a 6–8% cap rate is strong; below that you are buying growth, not yield.
Cash-on-cash is annual cash flow divided by total cash invested — down payment plus rehab plus closing costs plus points. It is the most honest metric about your position, because the denominator is real money that left your account and the numerator is real money arriving. Its blindness is time. It has no opinion about principal reduction, rent growth, or what the property is worth when you sell. A deal that returns 5% forever and a deal that returns 5% in year one on its way to 11% look identical.
IRR is the discount rate that sets the net present value of the full cash flow series to zero — the initial outlay, every year of cash flow, and the net sale proceeds at the end. CasaWise solves it with Newton-Raphson over up to 100 iterations (how the model is built). It is the only one of the three that prices time, amortization and the sale into a single number. And the sale is a forecast. IRR inherits every appreciation assumption you made, with compounding — the most complete metric and the easiest one to manufacture.
These are constructed, not observed — each pair isolates one variable so you can watch a metric fail. All four use a 30-year fixed at 6.67% (FRED, MORTGAGE30US, week of 13 Aug 2026), 8% vacancy, a five-year hold, and the standing 6% selling-cost assumption. Operating cash flow is held flat so the exit is the only thing moving between deals.
| Input | Deal A | Deal B | Deal C | Deal D |
|---|---|---|---|---|
| Purchase price | $250,000 | $400,000 | $300,000 | $500,000 |
| Monthly rent | $2,500 | $4,000 | $2,600 | $2,900 |
| Vacancy | 8% | 8% | 8% | 8% |
| Effective gross rent | $27,600 | $44,160 | $28,704 | $32,016 |
| Operating expenses incl. CapEx reserve | $9,350 | $14,960 | $14,804 | $11,016 |
| NOI | $18,250 | $29,200 | $13,900 | $21,000 |
| Down payment | All cash | 25% ($100,000) | All cash | 25% ($125,000) |
| Loan amount | $0 | $300,000 | $0 | $375,000 |
| Rate / term | — | 6.67% / 30 yr | — | 6.67% / 30 yr |
| Rehab | $0 | $25,000 | $0 | $0 |
| Closing costs | $5,000 | $8,000 | $6,000 | $10,000 |
| Total cash invested | $255,000 | $133,000 | $306,000 | $135,000 |
| Annual debt service | $0 | $23,158 | $0 | $28,948 |
| Annual cash flow | $18,250 | $6,042 | $13,900 | −$7,948 |
| Appreciation assumed | 3.0%/yr | 3.0%/yr | 0.0%/yr | 6.0%/yr |
Deal A's expense stack, itemized, so the $9,350 is real lines and not a plug:
Property tax 1.10% of price $2,750 Insurance 0.45% of price $1,125 Maintenance/repairs 5% of gross rent $1,500 Property management $2,175 CapEx reserve 6% of gross rent $1,800 ------------------------------------------------ Total operating expenses $9,350 Effective gross rent $2,500 x 12 x 0.92 = $27,600 NOI $27,600 - $9,350 = $18,250
The results, with the exit computed as Property Value x (1 − 6%) − Remaining Loan Balance:
| Result | Deal A | Deal B | Deal C | Deal D |
|---|---|---|---|---|
| Cap rate | 7.30% | 7.30% | 4.63% | 4.20% |
| Cash-on-cash (yr 1) | 7.16% | 4.54% | 4.54% | −5.89% |
| DSCR | n/a (all cash) | 1.26 | n/a (all cash) | 0.73 |
| Rent ratio | 1.00% | 1.00% | 0.87% | 0.58% |
| GRM | 8.33 | 8.33 | 9.62 | 14.37 |
| Value at year 5 | $289,819 | $463,710 | $300,000 | $669,113 |
| Loan balance at year 5 | $0 | $281,376 | $0 | $351,720 |
| Net sale proceeds | $272,429 | $154,511 | $282,000 | $277,246 |
| 5-year IRR | 8.32% | 7.34% | 3.07% | 11.02% |
| CasaWise Deal Score | 78.5 (Fair) | 66.1 (Fair) | 55.4 (Fair) | 28.6 (Caution) |
Both yield exactly 7.30% unlevered, so a cap-rate-first buyer treats them as interchangeable and picks on location, roof age, tenant file. Then the financing lands.
Deal A $18,250 cash flow / $255,000 invested = 7.16% cash-on-cash Deal B $6,042 cash flow / $133,000 invested = 4.54% cash-on-cash
Two things cap rate could not see. First, Deal B's $25,000 of deferred maintenance and $8,000 of closing costs sit in the denominator of cash-on-cash and nowhere in cap rate — cap rate divides by purchase price, not by what the deal costs you.
Second, and larger: at 6.67% over 30 years the annual loan constant is 7.72% — $643.29 a month per $100,000 borrowed, times twelve. When the constant exceeds the cap rate, every borrowed dollar earns 7.30% and costs 7.72%. Leverage runs backwards. Buy Deal B for all cash and its cash-on-cash is $29,200 / $433,000 = 6.74%; the loan removes 2.2 points.
That is not an edge case in 2026, it is the default condition. A property has to clear roughly a 7.72% cap before borrowing at 6.67% improves your yield, and most do not. Cap rate lies whenever you compare your deal to someone else's, because it was never measuring your deal.
Now hold cash-on-cash constant. Deal B returns 4.54% on $133,000; Deal C returns 4.54% on $306,000. In year one they are the same investment at different scale, and a cash-on-cash-first buyer takes Deal C — more absolute cash flow, no lender, no vacancy risk against a mortgage payment. Over five years they are nothing alike.
| Source of return over 5 years | Deal B | Deal C |
|---|---|---|
| Operating cash flow | $30,208 | $69,500 |
| Principal paid down | $18,624 | $0 |
| Appreciation on value | $63,710 | $0 |
| Selling costs at 6% | −$27,823 | −$18,000 |
| Rehab and closing, never recovered | −$33,000 | −$6,000 |
| Total profit | $51,719 | $45,500 |
| On invested capital of | $133,000 | $306,000 |
| IRR | 7.34% | 3.07% |
Deal C throws off more than twice the cash and finishes worse, because two of the four pillars never show up. An all-cash purchase has no loan to amortize. Appreciation was assumed at zero. And the 6% selling cost still arrives — $18,000 handed back at the closing table against a value that did not move. Meanwhile Deal B's $300,000 loan amortizes $18,624 while 3% appreciation adds $63,710 to a $400,000 basis. Both are invisible to cash-on-cash. Cash-on-cash lies whenever the hold period matters, which is every buy-and-hold.
Deal D posts the highest IRR of the four — 11.02%, against 8.32%, 7.34% and 3.07%. It also has the lowest cap rate, a 0.58% rent ratio, and it bleeds $7,948 a year. Here is where the 11.02% comes from:
Operating cash flow, 5 years -$7,948 x 5 = -$39,740
Net sale proceeds $669,113 x 0.94
- $351,720 = $277,246
------------------------------------------------------------
Total profit on $135,000 invested = $102,506Total cash coming back over five years is $237,506, and the sale supplies $277,246 of it — 117% — because operations remove $39,740 on the way. The sale is not the largest contributor to the return; it is the only one. Every dollar of that $102,506 is produced at a single moment, by a single assumption, five years out.
Test the assumption:
| Appreciation assumed | Value at yr 5 | Net proceeds | 5-year IRR | Deal Score |
|---|---|---|---|---|
| 6.0%/yr | $669,113 | $277,246 | 11.02% | 28.6 |
| 5.0%/yr | $638,141 | $248,132 | 8.31% | — |
| 4.0%/yr | $608,326 | $220,107 | 5.43% | — |
| 3.0%/yr | $579,637 | $193,139 | 2.33% | 9.3 |
| 0.0%/yr | $500,000 | $118,280 | −8.84% | — |
Drop appreciation from 6% to the 3.0% CasaWise uses as its base default and the IRR falls from 11.02% to 2.33%. Nothing about the building changed — no tenant left, no roof failed, no rate moved. One assumption moved three points and took 79% of the return with it.
Watch the 6% selling cost across those rows. At 6% appreciation it takes $40,147; at 0% it takes $30,000 against a gain of nothing, which is why Deal D at flat values does not merely underperform — it loses $56,460. Exit cost is the one line in an IRR that is certain while everything above it is a forecast.
IRR lies whenever the terminal value carries the number. An IRR built on appreciation is a forecast wearing a metric's clothes. Before you accept one, do what that table does: re-run it at the base rate, then at zero, and see what survives. More in appreciation and rent growth assumptions.
IRR carries the largest single weight in the Deal Score — 40%, on a curve where 0% is the floor, 9% the midpoint and 18% the ceiling. It earns that weight because it is the only metric that prices the full hold. It does not get all of the weight for exactly the reason Deal D demonstrates. Deal D posts the best IRR in the set and scores 28.6 — Caution, because the other 60% is doing its job: cash-on-cash at 25% scores zero at −5.89%, DSCR at 20% scores zero at 0.73, and a 4.20% cap rate and 0.58% rent ratio add almost nothing. The metric with the biggest weight said buy. The system said no. That disagreement is the feature.
Two guardrails sit on top. IRR is displayed only within −100% to +500% — outside that band the figure is arithmetically valid and practically meaningless, usually the artifact of a near-zero denominator or a series that flips sign more than once. When the solver does not converge inside 100 iterations, CasaWise reports N/A rather than the last iterate. A confidently wrong IRR is worse than none, because you will act on it.
DSCR is a veto, not a score. NOI divided by annual debt service, and it belongs to the lender before it belongs to you. Deal B is 1.26 and financeable. Deal D is 0.73 — the property covers 73 cents of every dollar of debt service before a single maintenance surprise. Most lenders require 1.20+, and below 1.00 the outcome is not a weak return; it is monthly contributions from outside income, with foreclosure at the end of a bad enough run. DSCR carries 20% of the Deal Score, floor 0.95, ceiling 1.40. No IRR fixes a 0.73.
GRM and rent ratio are screens, nothing more. Deals A and B share an identical 8.33 GRM and an identical 1.00% rent ratio, and their cash-on-cash returns differ by 37%. GRM ignores expenses entirely; under 12 warrants a closer look, and that is the whole of its usefulness. The rent ratio is the 1% rule with the dogma removed — CasaWise grades it on a curve where 0.65% is par and approaching 1% is excellent, weighted at 5%. Use both to eliminate addresses in seconds, never to choose between survivors.
One tension worth naming: professional investors have historically targeted 8–12%+ cash-on-cash, while the Deal Score curve tops out at 6% because that is what is achievable against 6.67% money. Deal A's 7.16% scores 100 today and would have been mediocre in 2015. Both are true — calibrate to the rates you are actually buying in. See what a good rental deal actually looks like.
Run every property through all of them. The most useful signal in underwriting is not a strong number — it is two metrics disagreeing, because that always has a specific cause, and the cause is usually what decides the deal. How to analyze a rental property walks one deal end to end.
Cash-on-cash, if you are buying with a loan. Cap rate measures the building unlevered and cannot see your rate, your down payment, your rehab or your closing costs — two buyers get the same cap rate and completely different returns. Use cap rate to compare properties against each other and against the market, then use cash-on-cash to decide whether your version of the deal works.
Because your loan constant is higher than your cap rate, which is the normal condition at current rates. A 30-year fixed at 6.67% has an annual constant of about 7.72%, so borrowing against a 7.30% cap rate loses 42 basis points on every borrowed dollar. Leverage only amplifies returns when the cap rate clears the loan constant. Below that line, more leverage means less cash-on-cash.
CasaWise scores IRR on a curve where 0% is the floor, 9% the midpoint and 18% the ceiling, calibrated to roughly a 7% rate environment. Composition matters more than level. If most of the IRR comes from the terminal sale rather than operations, you are looking at a forecast, not a result. Re-run it at base-case appreciation and at zero first.
Yes, and it is common. In the example above, the deal with the highest IRR at 11.02% has a 0.73 DSCR, negative cash flow of $7,948 a year, and scores 28.6 out of 100 — Caution. Its entire return depends on a 6% annual appreciation assumption; at 3% the IRR falls to 2.33%. IRR is only as honest as its exit assumption.
The solver runs Newton-Raphson over up to 100 iterations, and some cash flow series do not converge — typically when the series changes sign more than once. IRR is also displayed only inside a −100% to +500% band, because outside it the figure is arithmetically valid and practically meaningless. Reporting N/A is deliberate; a confident wrong number is worse than none.
No. The IRR here is pre-tax: cash invested, operating cash flow, net sale proceeds. Depreciation is modeled separately — residential rental property is written off over 27.5 years (IRS Publication 527) — because the value of that shelter depends on your bracket, your passive-loss position and eventual recapture. Folding it into a headline IRR makes deals look comparable when the tax outcomes are not.
Knowledge is power, and here it is the power to notice two metrics disagreeing and know which one is wrong. To get cap rate, cash-on-cash, IRR, DSCR, the Deal Score and a three-scenario stress test on one set of inputs at live FRED rates, start with the free tier. No credit card.