Free House Flipping Spreadsheet (Excel & Google Sheets)

• The tab is titled "House Flipping Spreadsheet". Under it: "Deal analyzer and rehab budget. Example values shown."
• Five steps say how to use the other tabs.
• Example values shown. Replace every number with your own deal.
• It says the file is a planning tool, and to check every number with your lender, your agent, and your accountant.
• It points to the last tab, Outgrew the Sheet.
• Amber cells are inputs. Shaded cells calculate. This tab calculates nothing.
• Each sheet is protected, with no password, so a paste cannot erase a formula. Excel: Review › Unprotect Sheet. Google Sheets does not keep that protection, so a shaded cell can be edited there.

Amber cells are inputs. Shaded cells calculate. The loan in this example is purchase money, so it stays under the purchase price. Selling costs use the expected sale price. A blank expected sale price uses the ARV.

Profit lost to overruns so far is planned profit minus current profit. A negative number is savings under the budget, from a trade marked done. On the purchase-versus-offer row, the sheet writes a verdict. In the example it says Under 70% rule. Annualized return on cash is the cash return above, spread over a year. It is not a promise of what the next flip makes. Interest per month is a simple interest-only estimate.

On a fix and flip spreadsheet, the rehab budget for a house flip is one row per trade, in the order the work usually happens, then a contingency line and a total. The columns are Trade category, Budget, Committed, Paid, Forecast at completion, Over/(under) budget, Left to pay, Notes, Done? (Y/N), Savings credit.

• Demo & dumpsters
• Framing & structural
• Roof
• Windows & exterior doors
• Siding & exterior paint
• Electrical
• Plumbing
• HVAC
• Insulation & drywall
• Interior paint
• Flooring
• Kitchen
• Bathrooms
• Interior doors & trim
• Landscaping & hardscape
• Permits & fees
• Cleaning & staging
• Other

Then Contingency and TOTAL. 18 trades.

• Budget is the number you type for each of the 18 trades.
• Committed is the signed bid you type.
• Paid adds up the Expense Log for that category.
• Done? (Y/N). Enter Y when the trade is finished and the savings should count. Enter N to keep the full budget in the forecast.
• Savings credit stays at $0 until the trade is marked Done. Then it is the amount under budget, as a negative number, when the higher of committed or paid is below the budget.
• Forecast at completion is the higher of budget, committed, or paid, plus the savings credit.
• Over/(under) budget is Forecast minus Budget.
• Left to pay is Forecast minus Paid.
• Notes is a note you type. The sheet does not calculate it.

Contingency % is an input under the total. In the example it is 10%. Contingency dollars are the shaded formula, not an input: that percent of the trade budgets, rounded to the nearest dollar. The total row adds the trades and the contingency line.

Unmatched expenses should be $0. A receipt whose category is not on this list is missing from Paid.

The Expense Log is the house flipping expense spreadsheet: one row per receipt. The example has 6 rows. Total logged is $8,900. Paid on the Rehab Budget adds up from the Amount column, by category. The category has to match a row on Rehab Budget or it will not count as Paid.

• Date, Category, Vendor, Description, Amount, Paid with, Receipt photo saved? (Y/N), Notes.
• Category is a list of the 19 Rehab Budget lines, the 18 trades plus Contingency. You pick the trade for each receipt.
• Receipt photo saved? is a Y/N reminder you fill in yourself. The file does not store a photo and does not read one.

One row per payment. The example has 3 rows, and total paid is $6,100. Enter the contract amount once for each contractor. Later payments for that contractor can leave Contract amount blank. The balance uses the amount already entered. Balance left on contract is that contract amount minus what you have paid that contractor through this row.

• Contractor, Trade, Contract amount, Milestone / scope completed, Walked & inspected? (Y/N), Photos taken? (Y/N), Date paid, Amount paid, Balance left on contract.
• Walked & inspected? and Photos taken? take Y, N, or N/A. The file does not store a photo.

A short note on when a spreadsheet gets hard, with a link to Fixer Upper House. It says the example values are a sample deal, not a house we bought. This tab calculates nothing. The spreadsheet does not import into the app.