House Hacking Calculator Spreadsheet for Excel and Google Sheets, FHA vs Conventional, Duplex Triplex Fourplex, Owner Occupied Multifamily

Excel house hacking calculator: see what you pay to live in a duplex, triplex or fourplex. Example: $1,353 a month after rent, $1,047 less than renting.

Change the blue cells to your numbers. Everything else updates on its own.

WHAT IT SHOWS
- Your effective housing cost: mortgage + mortgage insurance + operating costs - rent from the other units (after vacancy). It can reach $0 or go negative.
- Savings vs renting, per month and per year, against the rent you would otherwise pay.
- FHA and conventional side by side: down payment, upfront and monthly mortgage insurance, cash to close. Pick one from a dropdown and the Summary and Years tabs follow it.
- After you move out: all units rented, management fee applied, NOI, cash flow, cash-on-cash return, cap rate and DSCR.
- A 10-year view: cost vs renting each year, rental cash flow from the year you move out, loan balance, equity and total gain.
- Works for 2, 3 or 4 units. Rent growth, expense growth, appreciation and the year you move out are all inputs.

EXAMPLE IN THE FILE (fake numbers, a made-up triplex)
$675,000 price, FHA, 3.5% down: cash to close $48,875. Rents of $2,600 and $2,500 on the other two units bring the owner's effective housing cost to about $1,353 a month against $2,400 of rent, a saving of roughly $1,047 a month. After the owner moves out, the same building cash-flows about $357 a month. Replace every example number with your own.

HOW IT WORKS
Blue text = inputs. Black = formulas. Yellow = key assumptions. No macros, no add-ins. Built as an Excel (.xlsx) file.

WHAT YOU GET
- 1 Excel workbook (.xlsx) with 5 tabs: Start Here, Summary, Inputs, Loans, Years
- 1-page HOW-TO-USE PDF
- Instant digital download, delivered as one .zip file

GOOD TO KNOW
- Works in Excel and in Google Sheets (upload the .xlsx; tested Oct 2026).
- This is a pre-tax screening tool. It does not model income tax, depreciation, refinancing or selling costs. Mortgage insurance is held flat for all 10 years.
- Owner-occupied loan rules (occupancy period, FHA self-sufficiency test, loan limits, credit minimums) vary by lender and county. Check them with a lender.
- Not financial, tax or investment advice. Verify every assumption before you buy.

Pairs with: Rental Property Analysis Spreadsheet (run the same building as a pure rental) and the Real Estate Investor Spreadsheet Bundle (rent vs buy).

Digital download. Nothing ships. You get the file right after purchase. Personal use license, one per buyer, no resale or sharing. Because this is a digital file, I do not offer returns or exchanges, but if the file is damaged, will not open, or is not as described, message me and I will make it right.

Calculator only, not financial, tax or legal advice.

Designed by Cap Rate Studio with the help of AI tools. The formulas were recalculated and checked against an independent calculation of the example numbers before release.