House Hack Calculator Spreadsheet, Duplex Triplex Fourplex Analyzer, FHA Owner Occupied Multifamily, Excel & Google Sheets Template
NowPrice:$9.60
Original Price: $12.00
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
Be the first to review this item
More from this shop
Visit shop-
Digital download
NYC Rent Stabilized Building Excel Model, New York Landlord Cash Flow and Breakeven Rent Forecast, Multifamily Pro Forma Spreadsheet
Sale Price $63.20
Original Price $79.00
-
Digital download
Net Worth Projection Spreadsheet, 10 Year Wealth Planner Excel, FIRE and Passive Income Calculator, Rental Property Portfolio Tracker
Sale Price $31.20
Original Price $39.00
-
Digital download
Real Estate Investor Spreadsheet Bundle, Rental Property Calculator, BRRRR, House Hack and Seller Financing, Excel & Google Sheets
Sale Price $23.19
Original Price $28.99
-
Digital download
BRRRR Calculator Spreadsheet, Cash Out Refinance and Rehab Analyzer for Rental Property, Excel & Google Sheets, ARV and Cash Left in Deal
Sale Price $11.20
Original Price $14.00
-
Digital download
Real Estate Investor Bundle | Loan Comparison, DSCR Calculator, Property Analyzer, Multifamily Proforma, and More! | Excel & Google Sheets
$13.99
-
Digital download
Rental Property ROI Calculator Excel | Real Estate Investment Analyzer, Cash Flow, Cap Rate, IRR, DSCR, Mortgage Schedule & Dashboard
$19.90
-
Digital download
Rental Property Investment Calculator Spreadsheet Excel Google Sheets With Mortgage Calculator and ROI
Sale Price $9.35
Original Price $17.00
-
Digital download
House Flipping Calculator spreadsheet, Fix & Flip real estate investment analysis, Renovation budget ROI, Excel / Google property rehab BRRR
Sale Price $8.49
Original Price $16.99
-
Digital download
Rental Property Quick Analysis Tool: Excel Spreadsheet Calculator Template w/ Real Estate Investment ROI, Cap Rate, Cash on Cash, Cash Flow
$12.96
-
Digital download
Rental Property Investment Calculator Spreadsheet Excel Google Sheets With Mortgage Calculator and ROI
Sale Price $9.35
Original Price $17.00
-
Digital download
Rental Property Calculator Spreadsheet Investment Property Analysis Mortgage Calculator Airbnb Real Estate Excel Google Sheets ROI Cap Rate
Sale Price $8.95
Original Price $12.79
-
Digital download
Property Flip Calculator - Rehab Cost Profit and ROI Spreadsheet Excel Google Sheets
Sale Price $7.62
Original Price $12.69
-
Digital download
Property Investment All in One Excel - Rental Property Analysis | Mortgage Calculator | Performance Forecast | Cash Flow, ROI, ROE, Cap Rate
$13.99
-
Digital download
Rental Analysis Calculator For Multifamily & Single-Family Investments | Accurate and Simple
$10.00
-
Digital download
Rental Property - Real Estate Investment Calculator - Microsoft Excel
$14.99
-
Digital download
House Flipping Calculator Excel Template | Real Estate Deal Analyzer for 25 Properties
$10.90
Shoppers with similar taste loved these
-
Customizable | Welcome To Our Open House Bakery Bags | Real Estate Mortgage Pop By | Custom Marketing Treat Bags | 3-BB
$11.00
-
Flyer and Shop Online Stand with QR Code (All Acrylic) - Personalisable
$52.70
-
REAL Broker OPEN HOUSE Feather Flag Banner
$114.99
-
Digital download
Real Estate & Loan Officer Co-Marketing Flyer Template Realtor Mortgage Lender Partnership Flyer Editable Canva Open House Marketing
$9.00
-
Digital download
Mortgage Broker Marketing Bundle, Home Lending Templates, Mortgage Loan Officer Marketing, Home Lender Marketing Flyers, Mortgage Canva
$12.99
-
Digital download
Budget Planner Printable, Monthly Budget Printable, Finance Planner, Yearly Finance Tracker, Personal Finance Tracker
$2.29
-
Open House, Real Estate Sign, Welcome Open House Sign, Retractable Banner, Roll up Banner Realtor Sign Banner real estate Broker, Open House
Sale Price $104.99
Original Price $116.66
-
Digital download
Non-QM Mortgage Marketing Templates | Loan Officer and Mortgage Broker Social Media Marketing | Home Buyers | RE Investor Marketing
$18.99
-
Digital download
First Time Home Buyer Seminar Bundle for Realtors & Loan Officers, Editable Canva Presentation, Home Buying Workshop Slides
$44.99
-
Digital download
1700+ Mortgage Social Media Templates: Loan Officer Marketing (Canva)
$26.71
-
Digital download
Financial Scripts, career coach workbook, coaching scripts, therapist resources, coaching resources, therapy session, self growth
$12.90
-
Digital download
2-1 BUYDOWN Co-Branded Listing Flyer | Mortgage Marketing | Real Estate Agent | Loan Officer | Homebuyer and Seller Presentation | Canva
$5.00