Free Excel templates

A free fix and flip and BRRRR calculator in Excel: one house, two strategies

Hard money on the purchase and the renovation, points, interest, holding, closing and selling costs, profit and return on cash, the 70% rule, then the same house refinanced and rented: four sheets, no macros.

The file buys a distressed house for 220,000, renovates it for 60,000 and values it at 340,000 after repairs. As a flip with 90% hard money at 11% plus two points, it makes only 8,700 after six months, 17.6% on the 49,500 of cash put in. The 70% rule says the most to pay was 178,000; the price paid was 42,000 above it. As a BRRRR, the 75% refinance does not even repay the hard money: 57,600 stays in the deal and the rent does not cover the new mortgage.

Free online calculator, no sign-up: fix and flip calculator.

Free online calculator, no sign-up: brrrr calculator.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Fix_and_Flip_BRRRR_Calculator.xlsx (14 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Real Estate Development Manager, which explains the method behind it, chapter by chapter.

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

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

Four sheets. Inputs are blue cells on a pale blue fill on the Inputs sheet.

Read me
What the file does and its conventions.
Inputs
Purchase, renovation, ARV, closing costs, months, holding costs, hard money terms, selling costs, the rule-of-thumb share, refinance terms, rent and operating costs.
Flip
The hard money loan, points, interest, holding, closing and selling costs, total cost, profit, return on cash, annualized return and the maximum offer.
BRRRR and Checks
Cash in, hard money repaid, the refinance, cash returned and left in, rent, NOI, mortgage, cash flow and DSCR; then the checks: all OK.

What the worked case returns

MeasureValue
Total project cost331,300
Flip profit8,700
Cash invested49,500
Return on cash17.6% (38.2% annualized)
Maximum offer by the 70% rule178,000
Price paid above it42,000
BRRRR refinance at 75% of ARV255,000
BRRRR cash left in the deal57,600
BRRRR annual cash flow-1,638

The 70% rule exists for exactly this case. Selling costs alone take 7% of the ARV and financing another 5%, so a purchase price that looks like a discount to the finished value leaves almost nothing once every cost is counted.

How to use it on your own deal

  1. Enter purchase price, renovation budget and ARV on Inputs.
  2. Enter your lender's terms and the months the works will take.
  3. Read the profit and the maximum offer on Flip before making an offer.
  4. For a hold, enter rent and refinance terms and read BRRRR.

Questions people ask about it

Is this template really free?

Yes. The file costs nothing: you enter an email address, the download opens at once, and you can leave the reader list in one click.

Does it use macros or circular references?

No macros and no circular reference.

What is the 70% rule?

A rule of thumb for flips: pay no more than 70% of the after-repair value, less the renovation cost. Here 70% of 340,000 less 60,000, or 178,000.

Can I use it for a real house?

Yes, by replacing the inputs. The house is fictional, and nothing here is investment advice.

Go further

For appraisal, cost plans and the development decisions behind a renovation, The Real Estate Development Manager and its companion workbooks go further.

See the book and its free files →

Other free templates

This template goes with The Real Estate Development Manager. The book is on Amazon.

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. The template stays free either way.