Cash on cash return is the metric a rental investor lives on, because it answers the only question that pays the bills in year one: for every dollar of my own money in this deal, how much cash comes back to me this year? Cap rate ignores your loan. IRR waits until you sell. Cash on cash tells you what the property does for your wallet right now, and Excel calculates it in a single division once the inputs are clean.
The hard part is never the formula. It is assembling honest numbers for the cash flow on top and the cash invested on the bottom, and both usually start life buried in PDFs: an operating statement, a loan estimate, a settlement statement. This walks through the calculation, a worked example, the two mistakes that quietly inflate the result, and how it stacks up against the other return figures investors quote.
Last updated July 2026.
What is cash on cash return?
Cash on cash return is the annual pre-tax cash flow a property produces divided by the total cash you actually invested to acquire it. It is a leveraged, first-year cash yield: it counts your mortgage payment as a real cost and it counts only the money that left your bank account, not the full purchase price. A property bought for a million dollars with a quarter million down is measured against that quarter million, because that is the capital genuinely at risk.
The figure matters because it isolates cash. Appreciation, principal paydown, and tax benefits are all real forms of return, but you cannot spend them until later. Cash on cash strips those out and shows the spendable yield on your equity in the current year, which is exactly what you compare against a savings rate, a bond, or the next deal on your desk.
How do you calculate cash on cash return in Excel?
Put annual pre-tax cash flow in one cell and total cash invested in another, then divide: =cash_flow / cash_invested, formatted as a percentage. Annual cash flow is net operating income minus annual debt service. Total cash invested is your down payment plus closing costs plus any upfront rehab, everything you paid out of pocket to get the property producing.
Lay it out so each input is its own row and the two intermediate figures are visible. That way you can audit the number instead of trusting a black box:
| Cell | Line | Amount |
|---|---|---|
| B2 | Net operating income | 78,000 |
| B3 | Annual debt service | -52,800 |
| B4 | Annual pre-tax cash flow (=B2+B3) | 25,200 |
| B6 | Down payment | 250,000 |
| B7 | Closing costs | 8,000 |
| B8 | Upfront rehab | 15,000 |
| B9 | Total cash invested (=SUM(B6:B8)) | 273,000 |
| B11 | Cash on cash (=B4/B9) | 9.2% |
That deal returns 9.2%. Keep debt service as a negative so the cash flow formula reads cleanly, and make sure the debt service is the full annual payment, principal and interest, not interest only. The single most common error is comparing cash flow against the whole purchase price instead of the cash you actually put in, which understates the return on a leveraged deal by a wide margin.
What is a good cash on cash return?
Most investors treat 8% to 12% as a solid target for a stabilized rental, but that band is a rule of thumb, not a law, and it means little without the context of risk and strategy. A turnkey property in a strong market with a long lease in place can be attractive at the lower end because the cash flow is dependable. A heavier value-add deal should clear a higher number to justify the execution risk and the months of weaker cash flow while you reposition it.
Judge any cash on cash figure against your own alternatives and the leverage behind it. A high return driven entirely by aggressive financing carries more downside if rents soften or a rate resets. The number is a starting point for a conversation about risk, not a verdict on its own.
What is the difference between cash on cash return and cap rate?
Cap rate is unleveraged and cash on cash is leveraged. Cap rate divides net operating income by the property value and deliberately ignores your loan, so it measures the asset itself. Cash on cash divides cash flow after debt service by the cash you invested, so it measures your equity position with the specific financing you used. Change the loan terms and the cap rate stays put while the cash on cash moves.
| Metric | Numerator | Denominator | Counts your loan? |
|---|---|---|---|
| Cap rate | Net operating income | Property value | No |
| Cash on cash | Pre-tax cash flow (after debt service) | Total cash invested | Yes |
Use cap rate to compare properties on an even footing regardless of how each is financed. Use cash on cash to see what a particular deal, with your down payment and your interest rate, does for you. Two investors can buy the same building at the same cap rate and earn very different cash on cash returns because one put more down or borrowed at a better rate. If you want the mechanics of the numerator both metrics share, work through how to calculate cap rate in Excel.
What is the difference between cash on cash return and ROI?
Cash on cash counts only spendable cash in a single year, while total ROI counts every form of return over the whole hold. ROI folds in appreciation, the loan balance you paid down, and the profit at sale, then measures it across the full period you owned the property. Cash on cash ignores all of that on purpose to answer a narrower, more immediate question about current cash yield.
Neither is better, they answer different things. Cash on cash tells you whether the property carries itself and rewards your capital today. ROI, and its time-weighted cousin the internal rate of return, tells you whether the whole investment was worthwhile once you sell. Serious underwriting looks at both, which is why the same cash flow column you build here feeds directly into how to calculate IRR in Excel.
Does cash on cash return include the mortgage?
Yes. Including the mortgage is the whole point of cash on cash return. The numerator is cash flow after your annual debt service is subtracted, so the payment directly lowers the return, and the denominator is your down payment and costs rather than the full price, which is only possible because you borrowed the rest. A cap rate ignores the loan, but cash on cash is defined by it.
Because financing drives the result so heavily, small changes in loan terms swing the number. A lower rate or a longer amortization reduces annual debt service and lifts cash on cash, while a larger down payment raises the denominator and can lower it even as it improves your monthly cash flow. Model the loan the way a lender actually underwrites it, and pressure test the coverage with DSCR so the financing that flatters your return still clears the bank's minimum.
How do you get the numbers into Excel in the first place?
Every input in the calculation starts in a document, not a spreadsheet. Net operating income comes off a trailing operating statement, debt service off a loan estimate or amortization schedule, and your cash invested off the closing disclosure. Retyping those by hand is where a transposed figure slips in and quietly moves the return by a point.
Convert the source documents instead of rekeying them. Drop the property's operating statement PDF into a spreadsheet so the income and expense lines that build NOI each land in their own row, and pull the in place rents from the rent roll. Financing terms usually hinge on how a lender underwrites the loan, so match your debt service to the terms you will actually get. Scanned statements are fine, because OCR reads the numbers off the image. The full deal package workflow lives on the PDF to Excel for real estate page, and if you need to confirm the NOI underneath everything, walk through NOI from a T12.
A short checklist before you trust the number
- Confirm annual cash flow is net operating income minus full annual debt service, principal and interest.
- Divide by cash actually invested, down payment plus closing costs plus upfront rehab, not the purchase price.
- Check that no input cell is stored as text, or the formula will read it as zero.
- Note the loan terms next to the result, since the return only holds at that rate and amortization.
- Compare the figure against your alternatives and against the deal's risk, not against a fixed benchmark.
Get the inputs honest and the division takes care of itself. Cash on cash is a simple ratio built on numbers that are easy to fudge, so the discipline is in the sourcing, not the math.