Free download
Fix and flip spreadsheet template
The sheet is a single invented flip: purchase, rehab lines, a contingency, holding, buyer closing, a financing cost, seller closing, profit, ROI, and a 70 percent screen. Replace the example inputs with your own. The totals are formulas. Nothing in the file is a closed sale.
Download the xlsx. The same example as values, with each formula written out beside the number, is the csv. The xlsx is the one that calculates. The csv is there so you can read the numbers without a spreadsheet app.
What is in the sheet
- After-repair value and purchase price.
- Rehab lines for kitchen, bath, and floors and paint, then a subtotal.
- A contingency rate applied to that subtotal.
- Holding months times a monthly holding cost.
- Buyer closing as a rate times the purchase price.
- A financing line for interest and points you type yourself.
- All-in cost, seller closing, net sale proceeds, profit, and ROI.
- A 70 percent screen: ARV times 0.70, minus the rehab subtotal, and the gap against the purchase price.
How to fill it in
- Put your ARV in the after-repair value cell. Leave the formulas alone.
- Put the price you would actually pay in the purchase cell.
- Replace the three rehab lines with your own rooms. Add rows only if you also add them to the rehab subtotal.
- Set the contingency rate, the holding months, the monthly holding cost, and the buyer closing rate. The sheet multiplies them.
- Type interest and points on the financing line. The example uses $4,000 so the cell is not blank. That $4,000 is not a quote.
- Read profit, ROI, and the 70 percent gap. If you change a formula cell, the total it fed is no longer the total this page describes.
Five minutes is enough to replace the inputs on a deal you already priced. It is not enough to build the ARV. The ARV cell is a number you bring. Sold comps are a different job, and this file does not do it.
The invented example, checked
ARV is $200,000. Purchase is $100,000. Rehab is $15,000 + $8,000 + $7,000, which is $30,000. Contingency is 10 percent of that subtotal, which is $3,000. Holding is 6 months at $500, which is $3,000. Buyer closing is 3 percent of the $100,000 purchase, which is $3,000. Financing is the invented $4,000. All-in cost is $100,000 + $30,000 + $3,000 + $3,000 + $3,000 + $4,000, which is $143,000.
Seller closing is 6 percent of the $200,000 ARV, which is $12,000. Net sale proceeds are $200,000 − $12,000, which is $188,000. Profit is $188,000 − $143,000, which is $45,000. The sheet’s ROI cell is profit divided by all-in cost. One-decimal rounding of that ratio is 31.5 percent: $45,000 / $143,000 times 1,000 is 314.685, which rounds to 315, then divided by 10 is 31.5.
The 70 percent screen is $200,000 times 0.70, minus the $30,000 rehab subtotal, which is $110,000. Contingency is not inside that screen. The purchase of $100,000 is $10,000 under it. The screen is a check, not the profit. Profit still has to survive closing, holding, and the financing line.
Limits of a sheet
A sheet will multiply whatever you type. It will not notice that the ARV is a list price, that the rehab line is the same kitchen twice, or that the financing cell is a guess. It also will not store the file on this site. The download is a file on your computer. The house flipping calculator runs the report’s flip projection in the browser, with buyer closing, seller closing, and holding fixed at the report’s rates. The MAO calculator is the 25/5/3 offer. Neither one is this sheet, and this sheet is not a substitute for an address.
The lines the sheet is standing in for are written out on the fix and flip profit guide, the holding costs guide, the closing costs guide, and the rehab contingency guide. Those pages use their own invented examples. Do not add this sheet’s $45,000 to one of theirs.
Questions
What is in the spreadsheet?
One sheet with an invented example: after-repair value, purchase price, three rehab lines and their subtotal, a contingency rate and the contingency dollars, holding months and a monthly holding cost, buyer closing, a financing cost, all-in cost, seller closing, net sale proceeds, profit, ROI, and a 70 percent screen. The xlsx calculates those totals. The csv has the same invented numbers with each formula written out as text.
Are the numbers a real flip?
No. Every dollar in the file is invented so the formulas can be checked. They are not a closed sale, not a contractor bid, and not a loan quote.
What will a spreadsheet not do?
It will not pull comps, score a deal, or flag a risk. It repeats the arithmetic for the numbers you type over the example. An address still has to go through an analysis if you want comps and a score.
When the sheet is not enough, an address opens the full analysis. Open the sample analysis after you sign up. The sample uses invented figures, the same way this spreadsheet does.