When you walk into a rental property you see bricks, paint, and a rent roll. When you sit down with a spreadsheet you see cash flow, equity buildup, and a handful of percentages that try to capture the whole story. Understanding which percentage you need, how it is built, and what it hides is the first step toward disciplined investing.
In this guide we walk through a single, concrete deal from start to finish. The numbers are taken from a typical single‑family home purchase in a midsized market, but the methodology works for any asset class. By the end you will be able to read any ROI figure, decide which one to quote, and know when a “good” total return is actually masking a cash‑flow problem.
On this page
Three ROIs, three definitions
Real‑estate investors usually talk about three distinct return metrics:
- Cash‑on‑cash return – the ratio of cash flow to the cash you actually put into the deal.
- Total return (or equity return) – cash flow plus any equity gains from principal paydown and appreciation, divided by the cash invested.
- Internal rate of return (IRR) – the discount rate that makes the net present value of all cash flows (including the final sale) equal to zero.
Each metric answers a different question. Cash‑on‑cash tells you whether the property can cover its financing and operating costs out of the rent you collect. Total return tells you how much your equity grows in a single year, assuming you keep the property. IRR looks at the whole life of the investment, including the timing of cash flows and the eventual sale price.
Cash‑on‑cash: the worked example
Let’s start with the most frequently quoted figure – cash‑on‑cash. Below is the raw data for our example property:
| Item | Value |
|---|---|
| Purchase price | $250,000 |
| Down payment | $50,000 |
| Closing costs | $5,200 |
| Loan amount | $200,000 |
| Interest rate | 7 % |
| Loan term | 30 years |
| Monthly rent | $1,800 |
| Annual NOI | $12,432 |
| Cash invested | $55,200 |
Yellow = inputs · Green = calculated
The loan amortizes at 7 % over 30 years, giving a monthly payment of $1,330.60. Multiply by twelve to get the annual debt service of $15,967. Subtract this from the NOI to arrive at cash flow:
Because the cash flow is negative, the property is costing you money each month. Divide the annual cash flow by the cash you actually put into the deal ($55,200) to get cash‑on‑cash:
In plain language, for every $100 of your own money you are losing about $6.40 per year. The monthly out‑of‑pocket amount works out to $3,535 ÷ 12 ≈ $294.60 per month.
Total return: adding principal paydown and appreciation
Cash‑on‑cash looks bleak, but investors often add two equity‑building components that are not cash in hand: principal paydown and appreciation.
| Component | Year‑1 Amount |
|---|---|
| Principal repaid | $2,032 |
| Appreciation (3 % of $250,000) | $7,500 |
| Total equity gain | $9,532 |
Yellow = inputs · Green = calculated
The loan balance after twelve payments is $197,968.38, so the principal repaid in year 1 is $200,000 − $197,968.38 = $2,031.62, rounded to $2,032. Appreciation is simply 3 % of the purchase price, which yields $7,500.
Now add cash flow, principal paydown, and appreciation:
Divide this total return by the cash invested to obtain the total return (sometimes called equity ROI):
Notice the stark contrast: cash‑on‑cash is –6.4 % while total ROI is +10.9 %. The difference comes entirely from equity that builds “on paper” – the loan amortizes and the property appreciates.
IRR: what it adds, and what it needs
Internal Rate of Return (IRR) pushes the analysis one step further. Instead of looking at a single year, IRR asks: “If I hold this property for N years and then sell it, what discount rate makes the net present value of all cash flows zero?” To compute IRR you need a projected cash‑flow schedule (including future rent, expense growth, and a realistic exit price). The example we have does not include a multi‑year projection, so we cannot produce a numeric IRR here.
What IRR does add is a sense of time value. A property that delivers a 10 % total ROI in year 1 but then drops to –5 % in later years may have a lower IRR than a property that consistently delivers 6 % cash‑on‑cash. When you have a hold horizon longer than one year, IRR is the metric that best captures the trade‑off between early cash flow and later appreciation.
Why a positive total return does not rescue negative cash flow
The total ROI of 10.9 % looks attractive, but the underlying cash flow is still negative. That means you must cover the shortfall out of pocket each month ($294.60). If your cash reserves are thin, the property could become a financial burden even though the equity is growing on paper.
Two “what‑if” scenarios illustrate the fragility:
- If appreciation drops to 0 % while everything else stays the same, the total return becomes –$1,503 (cash flow –$3,535 + principal paydown $2,032). The resulting total ROI is –2.7 %, turning a seemingly healthy deal into a loss.
- If the loan interest rate were higher, debt service would increase, pushing cash flow deeper into the negative and reducing both cash‑on‑cash and total ROI.
These examples show that total ROI can be misleading if you ignore the cash‑flow component. Investors who cannot afford the monthly out‑of‑pocket amount should prioritize cash‑on‑cash or look for ways to increase rent, lower financing costs, or reduce operating expenses.
Which ROI to quote, and when
Choosing the right metric depends on your audience and your investment strategy:
- Cash‑on‑cash is the go‑to figure for lenders, partners, and investors who care about immediate cash generation. It is also the metric you should track if you are on a tight budget.
- Total return is useful when you are presenting a long‑term value proposition to equity partners who are comfortable with “paper” gains from appreciation and amortization.
- IRR is the preferred metric for institutional investors or anyone evaluating multiple projects with different hold periods.
In practice you will often quote more than one number. For example, a pitch deck might lead with “10.9 % total ROI” while a footnote clarifies “cash‑on‑cash –6.4 % (monthly out‑of‑pocket $295).” This transparency prevents misunderstandings later on.
For deeper dives on the individual components, see our guides on Cash‑on‑Cash Return, Cap Rate, and the BRRRR Method.
The verdict
Our single‑year example demonstrates that a property can appear profitable on an equity basis while simultaneously draining cash each month. The key take‑aways are:
- Never rely on total ROI alone; always check cash‑on‑cash.
- Principal paydown and appreciation are not cash you can spend, but they do increase your equity.
- If you cannot comfortably cover the monthly shortfall, the deal is risky regardless of a high total ROI.
- When you have a longer horizon and a clear exit plan, calculate IRR to see the true time‑adjusted return.
Common mistakes when measuring rental ROI
- Using projected rent without adjusting for vacancy or credit loss.
- Counting principal paydown as cash you can spend.
- Assuming appreciation will continue at historical rates without market evidence.
- Forgetting to include closing costs in the cash‑invested denominator.
- Mixing up cap rate (an unleveraged metric) with cash‑on‑cash (a leveraged metric).
Run your own numbers
The workflow above is exactly what our spreadsheet automates. Start with the free Lite version of the Real Estate Deal Analyzer — the main analyzer sheet with cap rate, NOI, cash flow, cash‑on‑cash, DSCR and the 1% rule check. If you screen deals regularly, the Full version adds a sensitivity grid, a 5‑year projection with IRR, a BRRRR calculator, a 3‑deal comparison sheet, and a 15‑point due‑diligence checklist. Both are on the Real Estate Deal Analyzer page.
Lite first, free — the seven steps above on one sheet.
Already sure? Get the Full version:
Buy — PayPal / card ($24) Buy — crypto ($24)Two checkouts, same file: PayPal (card or balance) or crypto (USDT/USDC).
This guide is an educational calculation aid, not financial, tax, or legal advice. Verify all figures against local data and consult licensed professionals before purchasing any property.