{"product_id":"house-flip-profit-calculator","title":"House Flip Profit Calculator Spreadsheet","description":"\u003cp\u003eThis house flip calculator shows the profit on a deal, the return, the 70% rule and what happens when things go wrong, all on one screen. It is for real estate investors who want to test a fix and flip before they make an offer, not after the works have started.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eSixteen scenarios on one screen\u003c\/h2\u003e\u003cp\u003eThe Deal tab builds a sixteen-cell grid with the after-repair value down the side and the rehab overrun across the top. The whole deal is rebuilt in every cell, so you can see whether it survives a valuation that comes in light and works that run over. That is the question a flip turns on, and no printable worksheet can answer it.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e16 scenarios, ARV against rehab overrun, with the profit in every cell\u003c\/li\u003e\n\u003cli\u003eThe 70 percent rule figure, set against what you are paying\u003c\/li\u003e\n\u003cli\u003eEight inputs drive everything: change the ARV once and the profit, the return, the 70% rule and all sixteen cells move together\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe costs most calculators skip\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eHolding costs by the month, including loan interest, council tax, insurance, utilities, security and staging, multiplied by the months you expect to hold the property\u003c\/li\u003e\n\u003cli\u003eLender points on the draw\u003c\/li\u003e\n\u003cli\u003eAgent fee and seller's closing costs on the way out\u003c\/li\u003e\n\u003cli\u003eA rehab budget of thirteen lines, budget against actual, with a contingency percentage that moves with the scope\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe property books underneath\u003c\/h2\u003e\u003cp\u003eEverything recalculates from one list, so nothing is typed twice.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eIncome and expenses, coded to the property\u003c\/li\u003e\n\u003cli\u003eMaintenance jobs recorded against the unit they belong to\u003c\/li\u003e\n\u003cli\u003eProfit and loss for each property, not averaged across them\u003c\/li\u003e\n\u003cli\u003eEvery total, margin, percentage and date calculated for you\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not static pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eThe nine connected tabs include a Start Here tab that walks you through setup in a few minutes, so the roi calculator and the books are ready to use quickly.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: a worked demo deal you can click through, and a blank one for your own\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eWhat does the 16-cell grid show?\u003c\/h3\u003e\u003cp\u003eEach cell rebuilds the whole deal for a different after-repair value and rehab overrun, so you can see the profit if the valuation comes in light or the works run over.\u003c\/p\u003e\u003ch3\u003eDoes it calculate the 70% rule?\u003c\/h3\u003e\u003cp\u003eYes. It works out the 70% rule figure and sets it against the price you are paying.\u003c\/p\u003e\u003ch3\u003eAre holding and selling costs included?\u003c\/h3\u003e\u003cp\u003eYes. Holding costs are entered by the month and multiplied by the months held, and lender points, agent fee and seller's closing costs are included.\u003c\/p\u003e\u003ch3\u003eHow many inputs do I need to enter?\u003c\/h3\u003e\u003cp\u003eEight inputs drive the deal. Change one and the profit, the return, the 70% rule and the grid all update together.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864632414,"sku":"OPX-086","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/house-flip-profit-calculator-01.jpg?v=1790832420","url":"https:\/\/opxviashop.com\/products\/house-flip-profit-calculator","provider":"OPXVIA","version":"1.0","type":"link"}