Cash on Cash Return Formula for Rentals – Free Spreadsheet

Want to know if a rental property will actually put cash in your pocket? Learn the exact cash on cash return formula for rental properties and get a free cash on cash return spreadsheet to run the numbers in minutes. No guesswork, just a clear, repeatable method that shows you whether a deal is worth your time.

Why Most Investors Get Cash‑on‑Cash Wrong

Many beginners see a percentage in a listing and assume it guarantees profit. They forget to include property taxes, insurance, vacancy, and a reserve fund for repairs. The result is a misleading figure that can turn a promising property into a cash drain. Treating the return as a magic number instead of a formula with real inputs is the core mistake that leads to over‑optimistic expectations and unexpected losses.

Step‑by‑Step Cash‑on‑Cash Return Formula

Follow these seven steps using Excel (or the free spreadsheet from Rental Property Investor). Fill in the highlighted cells; the sheet does the rest.

Down payment – Enter the cash you put up front (usually purchase price × loan‑to‑value) in B2.
Annual loan payments – Pull monthly principal + interest from your lender’s schedule, multiply by 12, and place the total in B3. This is your annual debt service.
Gross rental income – Take expected monthly rent, multiply by 12, then subtract an estimated vacancy rate (e.g., 5%). Put the result in B4.
Operating expenses – List all yearly costs: property taxes, insurance, management fees, maintenance (≈1 % of property value), utilities you cover, and a reserve fund. Sum them in B5.
Net operating income (NOI) – Subtract B5 from B4; record the outcome in B6. This is cash flow before debt.
Cash flow after debt – Subtract annual loan payments (B3) from NOI (B6) and place the difference in B7. This is the money that actually lands in your pocket each year.
Cash‑on‑cash return – Divide B7 by your down payment (B2) and multiply by 100. The percentage appears in B8 – your final cash on cash return metric.

The free spreadsheet already has these cells preset, plus automatic lines for closing costs and capex reserves, so you only need to input your numbers.

Real‑World Example

I applied this method to a duplex listed at $300,000. My down payment was $60,000, annual loan payments totaled $13,200, gross rent after a 5 % vacancy adjustment came to $24,000, and operating expenses summed to $7,800. The spreadsheet calculated a cash on cash return of 12.3 % – well above the 8 % I had been targeting. That extra 4 % turned a “maybe” into a confident “yes, let’s close”.

Quick Tips for Accurate Results

Double‑check whether your loan is interest‑only or amortizing; the former can inflate early cash‑on‑cash but creates a large balloon payment later.
Use a conservative vacancy rate (5‑8 %) and a maintenance reserve of at least 1 % of property value per year; for a full acquisition workflow, see our step-by-step guide to buying your first cash-flowing rental property.
Always verify that property tax and insurance figures are based on the latest assessor quotes, not outdated estimates.

By plugging real, verified numbers into this consistent formula, you stop guessing and start making data‑driven investment decisions. The free Excel tool from Rental Property Investor handles the math, letting you focus on finding the right property instead of wrestling with spreadsheets.