Flip and Rental Deal Analyzer: Excel and Google Sheets Calculator (English y Español)

Know your numbers before you make the offer. A bilingual spreadsheet that runs a fix and flip, a long-term rental and a BRRRR deal in minutes, and gives each one a clear verdict.

Analiza un flip, una renta o un BRRRR en minutos, con etiquetas en inglés y español.

Six tabs

• Flip: net profit, ROI, annualized ROI, profit as a percent of ARV, the 70% rule, your maximum offer for a target profit, and a stress test for a lower ARV, rehab overruns and a longer hold.
• Rehab Budget: 20 line items plus contingency, flowing into the Flip tab automatically.
• Rental: mortgage payment, NOI, monthly cash flow, cap rate, cash-on-cash return, DSCR, the 1% rule and break-even occupancy.
• BRRRR: cash left in the deal after the refinance, the new payment and the new cash flow.
• Compare: three deals side by side, with the best one by return.
• Start Here: how to use it in 5 steps, a color legend and a bilingual glossary.

Details

• Works in Microsoft Excel and Google Sheets. No macros.
• Example numbers are filled in so you can see how it works, then replace them with yours.
• Formulas are locked so they do not break by accident (no password, you can unlock them any time).

Pairs well with the printable Fix and Flip Deal Workbook and a Renovation Quote Review before you sign with a contractor.

An educational calculator, not investment, financial, tax, legal or lending advice, and no promise of any result. Verify every number with your lender, agent, contractor and tax professional. Personal use, no resale.