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.
| Result | Value |
|---|---|
| Loan | 13,000,000 |
| Annual debt service | 885,751 |
| Loan constant | 6.81% |
| Equity invested (total cost less loan) | 7,400,000 |
| Cash flow after debt service | 254,249 |
| Cash-on-cash return | 3.44% |
| Unlevered yield on total cost | 5.59% |
| DSCR | 1.35x |
Runs in your browser: nothing you type is sent anywhere.
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
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.
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.
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.
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.
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 →