House Hacking Calculator, Duplex Cost to Live Spreadsheet, FHA Self-Sufficiency Test, Triplex Fourplex, Google Sheets + Excel

Is this 2 to 4 unit listing worth a closer look? Type 9 numbers and see the monthly payment, the rent you collect, what it costs you to live there and how that compares with the rent you pay today.

I went from living in a van to owning a multi-family home. I built this as the quick first check before you spend time on a listing; it is the short version of my House Hack Deal Analyzer.

WHAT YOU TYPE (9 numbers, all on the Start Here tab)
Price, units (2, 3 or 4), rent per rented unit, property tax, insurance, FHA or conventional, your rate quote, a vacancy and repair set-aside, and the rent you pay today.

WHAT YOU SEE (on the Overview tab)
- Your monthly payment: principal and interest, mortgage insurance, tax and insurance
- The rent you collect from the other units, after the set-aside
- Your cost to live there, and how it compares with your rent today, per month and per year
- FHA self-sufficiency test for 3 and 4 unit buildings, using FHA's 25% vacancy factor (an appraiser can apply more): PASS or FAIL, the margin, and the rent each unit would need to pass
- Break-even rent per unit, to match your rent today or for tenants to cover the whole payment
- Your cost at five interest rates, from 1% lower to 1% higher than your quote
- Rough cash to close
- A plain-sentence verdict at the top

The lender assumptions (FHA 3.5% down and its mortgage insurance, conventional 5% down, closing costs, 30-year term) are filled in and editable, and a How It Works tab explains each one with its source.

YOU GET
- Blank workbook and a filled sample ($300,000 FHA duplex at 6.5%)
- Excel .xlsx files (Excel 2016 or newer, Windows or Mac)
- A two-page start-here PDF with one-click links to make your own Google Sheets copy (blank or sample)
The Google and Excel versions do not sync. A free Google account is needed for Sheets. Desktop or laptop recommended.

WANT THE FULL PICTURE?
The House Hack Deal Analyzer in my shop compares FHA, VA and conventional side by side, runs eleven checks on one deal and shows what changes when you move out.

PLEASE NOTE
- Digital download. Nothing is shipped.
- Estimates only, not financial, tax or lending advice. A lender's Loan Estimate is the number to trust.
- For your personal use. Please don't share or resell.

HOW IT WAS MADE
I designed this spreadsheet and its images with the help of AI tools, then checked every formula in an Excel-compatible spreadsheet app. The images show the actual spreadsheet with fictional sample data.