Report this item to Etsy

House Hack Calculator Spreadsheet, Duplex Triplex Fourplex Analyzer, FHA Owner Occupied Multifamily, Excel & Google Sheets Template

NowPrice:$9.60

Original Price: $12.00

Loading

20% off

•

Sale ends on December 9

You can only make an offer when buying a single item

Highlights

Can the other units pay your mortgage? See your true monthly housing cost, with the rent from the units you rent out, before you make an offer.

INSTANT DIGITAL DOWNLOAD for Microsoft Excel and Google Sheets. No physical item will be shipped.

Enter the price, number of units (2-4), the market rent for your own unit, rents for the other units, loan terms and expenses. The Results tab shows your monthly payment (principal, interest and mortgage insurance), taxes and insurance, rent from the other units net of vacancy, repairs and reserves, your net housing cost, the cash needed to close, and what the property looks like when you move out and rent every unit.

WHAT'S INSIDE
- Inputs tab: price, unit mix, rents, loan type, term, closing costs, taxes, insurance, utilities, vacancy, repairs, management, capex reserve and your targets
- Loan Presets tab: FHA, conventional and VA starting points (down payment, rate, upfront fee, mortgage insurance) that you can edit to match your lender's quote
- Results tab: net housing cost per month, 'live for free' check, cash to close, PASS / MISS scorecard
- Move-out view: monthly cash flow, cap rate, cash-on-cash and DSCR once all units are rented
- Chart: cost to own with no tenants vs. your net housing cost
- Sample fictional duplex: $420,000 price, FHA loan, which gives a net housing cost of $1,421 a month instead of $3,501 with no tenants

HOW TO USE IT
Fill the blue cells for the property, pick your loan type, then compare the 'living there' and 'moved out' results.

READY FOR MORE?
Ready to compare more rentals? The Rental Property Quick Deal Analyzer in my shop scores cap rate, cash-on-cash, DSCR and the 1% rule.

Note: Loan preset numbers are illustrative starting points, not current lender terms. Enter the terms you are quoted.

HOW TO OPEN IT
- Excel: after purchase go to Etsy > You > Purchases and reviews, click "Download Files", save the .xlsx and open it in Excel 2016+ or Microsoft 365. If Excel opens it in Protected View, click Enable Editing so the numbers calculate.
- Google Sheets: upload the .xlsx to Google Drive, then right-click it and choose Open with > Google Sheets (or use File > Import in a new Sheet).
- Start on the Inputs tab and replace the sample numbers in the blue cells. Read the answer on the Results tab.

PLEASE NOTE
- Digital file only; nothing is shipped. All sales are final. If something isn't working, message me and I'll help.
- Educational tool, not investment, lending, tax or legal advice. Example figures are fictional.
- Single-user license. Please do not resell or share the file.

Created by Kyle H, CFA · JENCPTemplates

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 28, 2026