Free calculators

Cash-on-cash return calculator

The year’s cash flow after debt service divided by the equity invested, with the loan constant that tells you whether leverage helps or hurts. Free, in the browser, no sign-up.

Cash-on-cash return is the year’s pre-tax cash flow after debt service divided by the equity invested. With the defaults below, a $20,000,000 purchase at a 6 per cent cap rate, financed with a 65 per cent, 5.50 per cent, 30-year amortising loan, produces $254,249 of cash flow on $7,400,000 of equity: a cash-on-cash return of 3.44 per cent, below the 5.59 per cent the building yields with no debt at all.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Loan13,000,000
Annual debt service885,751
Loan constant6.81%
Equity invested (total cost less loan)7,400,000
Cash flow after debt service254,249
Cash-on-cash return3.44%
Unlevered yield on total cost5.59%
DSCR1.35x

Runs in your browser: nothing you type is sent anywhere.

Using this for a real deal?

The formula

Cash-on-cash = (NOI − reserves − debt service) / equity invested

Loan constant = annual debt service / loan amount

In Excel, annual debt service: =-PMT(5.5%/12,360,13000000)*12

How it works

Equity is total cost, acquisition costs included, less the loan: those costs are cash the investor put in. The loan constant decides the sign of leverage. Here it is 6.81 per cent, above the 5.59 per cent unlevered yield, so every dollar borrowed costs more than it earns in year one and leverage pulls the cash-on-cash return down: negative leverage.

Cash-on-cash ignores principal repayment and appreciation, so a low year-one figure is not the whole return. It is the right measure of what the asset pays the investor in cash this year.

Go further with the worked example, step by step and the companion files for Private Equity Real Estate.

Embed this calculator

Free to embed on your website, blog or intranet, with no sign-up and no tracking. Copy the code below and paste it into any HTML block; the calculator resizes itself to fit.

Preview the embedded version

Questions people ask

How do you calculate cash-on-cash return?

Divide the year’s cash flow after debt service by the equity invested. $1,200,000 of NOI less $60,000 of reserve and $885,751 of debt service leaves $254,249; over $7,400,000 of equity that is 3.44 per cent.

What is negative leverage?

When the loan constant is higher than the property’s unlevered yield, so borrowing lowers the cash return on equity. In the default case the loan costs 6.81 per cent a year against a 5.59 per cent yield.

Is cash-on-cash the same as ROI?

No. Cash-on-cash counts only the cash paid out in one year. Total return or IRR adds principal repaid and the change in value at sale.

The book behind this calculator

This calculator comes from Private Equity Real Estate by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.

Get the book on Amazon → DRM-free PDF edition, $19.99

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.

Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →

All free calculators → · Free Excel templates →