Every cost of a flip financed with hard money, the profit, the return on the cash you put in, and the most the 70 per cent rule says you should pay. Free, in the browser, no sign-up.
A flip makes money only after hard money interest and points, holding costs, closing costs and selling costs. With the defaults below, a $220,000 purchase renovated for $60,000 and worth $340,000 after repairs, financed at 90 per cent of the price and all of the works at 11 per cent plus two points, makes $8,700 of profit after six months, 17.6 per cent on the $49,500 of cash put in. The 70 per cent rule says the most to pay was $178,000.
| Result | Value |
|---|---|
| Total project cost | 331,300 |
| Profit on the sale | 8,700 |
| Cash invested (everything not lent) | 49,500 |
| Return on cash | 17.58% |
| Annualised return on cash | 38.24% |
| Maximum offer by the 70% rule | 178,000 |
| Price paid above (+) or below (−) the 70% rule | 42,000 |
| If held instead (BRRRR): cash left in the deal | 57,600 |
| If held: annual cash flow | -1,638 |
Runs in your browser: nothing you type is sent anywhere.
Profit = ARV − (price + renovation + points + interest + holding + closing + selling costs)
Interest: on the purchase part for the whole period, on the renovation part for half of it (drawn evenly)
70% rule: maximum offer = 70% × ARV − renovation
The return is measured on the cash not lent by the hard money lender: the down payment on the price, the points, the interest and the costs. Selling costs alone take 7 per cent of the ARV in the default case, and financing about 5 per cent more, which is why a price that looks like a discount to the finished value can leave almost nothing.
The same deal held as a rental is in the BRRRR calculator; the free Excel version works both, with checks.
Go further with the free Excel template and the companion files for The Real Estate Development Manager.
Take the after-repair value and subtract the purchase price, the renovation, the lender’s points and interest, holding costs, closing costs on the purchase and selling costs. The default deal sells for $340,000 against $331,300 of total cost: $8,700.
Pay no more than 70 per cent of the after-repair value less the renovation cost. On a $340,000 ARV and $60,000 of works, that is $178,000; the default deal pays $42,000 more.
Usually interest-only on the amount drawn. The purchase part is drawn at closing and accrues for the whole period; renovation draws come in stages, so on average they accrue for about half of it. Points are paid upfront on the whole loan.
This calculator comes from The Real Estate Development Manager 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: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →