House Flip Calculator Excel with BRRRR analysis, rehab costs, refinance cash-out, and rental profit after the refinance. Flip it or BRRRR it — run both numbers on the same deal, and compare 3 deals side by side. Built…
About this template
House Flip Calculator Excel with BRRRR analysis, rehab costs, refinance cash-out, and rental profit after the refinance. Flip it or BRRRR it — run both numbers on the same deal, and compare 3 deals side by side. Built for house flippers and BRRRR investors who want to know, before they make an offer, whether the flip pays, what the refinance pulls out, and whether the rent covers the new mortgage.
$49
Excel & Google Sheets template — instant download on Etsy
Deal Inputs — enter purchase price, closing costs, rehab budget, down payment, hard-money rate and term, loan points, holding months, ARV, agent commission, other selling costs, refinance LTV, rate and term, refinance closing costs, rent, vacancy, taxes, insurance, HOA, maintenance, management, utilities, and other costs for up to 3 deals. Loan amount, points, and total cash invested are calculated for you.
Flip Analysis — monthly hard-money interest, holding interest and other holding costs, agent commission and selling costs, total project cost, flip profit, ROI on cash, profit per month, flip margin, and ARV spread. It flags any deal that loses money as a flip.
BRRRR Analysis — new refinance loan, old loan payoff, refinance closing costs, cash-out at refinance, total cash out, cash left in the deal, new monthly mortgage, effective gross income, operating expenses, NOI, and monthly and annual net cash flow after the refinance, plus cash-on-cash after refi and cap rate.
Comparison — purchase price, ARV, rehab, flip profit, flip ROI, cash-out, cash left in deal, monthly BRRRR cash flow, cash-on-cash after refi, and cap rate for all 3 deals, ranked by flip profit and by BRRRR cash flow, with the best flip, best BRRRR hold, and best overall named.
Summary and 5-Year Hold — Year 1 to Year 5 rent growth, expense growth, property value, refinance loan balance, equity, and cumulative cash flow for each deal if you hold after the BRRRR, with a Year 5 summary.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — House Flip / BRRRR Investment Analyzer
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the House Flip / BRRRR Investment Analyzer track?
The House Flip / BRRRR Investment Analyzer tracks Deal Inputs; Flip Analysis; BRRRR Analysis; Comparison; Summary and 5-Year Hold.
What do the example numbers show?
The included example shows: Deal A, Phoenix single-family home: purchase 260,000, ARV 410,000, flip profit 53,710, ROI on cash 44.5 percent, profit per month 8,951.67. Refinance loan 287,000, cash-out 74,000, cash left in deal 46,690, BRRRR monthly net cash flow 314.02, cash-on-cash after refi 8.1 percent. Best flip in the example.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.