Housing P&L: Comprehensive Calculator
Four-scenario housing P&L: S1 FHA with house hack, S2 min down no house hack, S3 conventional 20% down no rental, S4 renting with full capital invested.
Adjust to your situation
Property & Financing
Starting capital pool ($)
$
Purchase price ($)
$
Mortgage rate (%)
Closing costs ($)
$
FHA loan (auto): —
S3 conventional loan (auto): —
S3 conventional loan (auto): —
Income
Gross annual income ($)
$
Annual income raise (%)
Rental
Suite rent / month ($)
$
Annual rent raise (%)
Rental % of home sq ft
S4 rent / month ($)
$
Annual Costs
HOA dues ($/yr)
$
Repairs – Year 1 ($)
$
Repairs ongoing ($/yr)
$
Homeowner's insurance ($/yr)
$
Assumptions
Investment return (%)
Est. appreciation % / yr
Marginal tax rate (%)
Loading...
S1 FHA + house hack
—
housing P&L
S2 min down, no hack
—
housing P&L
S3 20% down, no hack
—
housing P&L
S4 renting
—
housing P&L
S1 — FHA + house hack
FHA - House Hacking
—
| Housing income | |
| Suite rental (gross) | — |
| Tenant utility share | — |
| Total housing income | — |
| Housing expenses | |
| Mortgage P&I | — |
| Property taxes | — |
| Homeowner's insurance | — |
| FHA MIP (annual) | — |
| HOA dues | — |
| Repairs (yr 1) | — |
| Total housing expenses | — |
| Tax benefits | |
| Depreciation §168 | — |
| Schedule A — mortgage interest | — |
| Schedule E — rental deductions | — |
| Total tax shield | — |
| Housing P&L | — |
Year 1 total wealth created
Housing P&L—
Principal paydown—
Appreciation (3%)—
Portfolio gain—
Total Net—
S2 — min down, no hack
FHA leverage, owner-occupant only
—
| Housing income | |
| Suite rental (gross) | — |
| Tenant utility share | — |
| Total housing income | — |
| Housing expenses | |
| Mortgage P&I | — |
| Property taxes | — |
| Homeowner's insurance | — |
| FHA MIP (annual) | — |
| HOA dues | — |
| Repairs (yr 1) | — |
| Total housing expenses | — |
| Tax benefits | |
| Depreciation §168 | — |
| Schedule A — mortgage interest | — |
| Schedule E — rental deductions | — |
| Total tax shield | — |
| Housing P&L | — |
Year 1 total wealth created
Housing P&L—
Principal paydown—
Appreciation (3%)—
Portfolio gain—
Total Net—
S3 — 20% down, no hack
Conventional, owner-occupant
—
| Housing income | |
| Suite rental (gross) | — |
| Tenant utility share | — |
| Total housing income | — |
| Housing expenses | |
| Mortgage P&I | — |
| Property taxes | — |
| Homeowner's insurance | — |
| PMI | — |
| HOA dues | — |
| Repairs (yr 1) | — |
| Total housing expenses | — |
| Tax benefits | |
| Depreciation §168 | — |
| Schedule A — mortgage interest | — |
| Schedule E — rental deductions | — |
| Total tax shield | — |
| Housing P&L | — |
Year 1 total wealth created
Housing P&L—
Principal paydown—
Appreciation (3%)—
Portfolio gain—
Total Net—
S4 — renting
Full capital invested, no equity
—
| Housing income | |
| Rental income from property | — |
| Tenant utility share | — |
| Total housing income | — |
| Housing expenses | |
| Monthly rent × 12 | — |
| Utilities (100%) | — |
| Renter's insurance | — |
| HOA / repairs / taxes | — |
| Total housing expenses | — |
| Tax benefits | |
| Depreciation / interest ded. | — |
| Total tax shield | — |
| Housing P&L | — |
Year 1 total wealth created
Housing P&L—
Principal paydown—
Property appreciation—
Portfolio gain—
Total Net—
5-year cumulative total wealth (housing P&L + principal + appreciation + portfolio)
S1 FHA + house hack
S2 min down, no hack
S3 20% down, no hack
S4 renting
Year 1 wealth breakdown by component
Housing P&L
Principal paydown
Appreciation
Portfolio gain
Debt-to-Income ratio — front-end, Year 1
S1 FHA + hack
—
—
S2 min down
—
—
S3 20% down
—
—
S4 renting
—
—
—
5-year appreciation & equity build-up
S1/S2 FHA equity
S3 conventional equity
| Year | Home Value | S1/S2 Loan Bal | S1/S2 Equity | Apprecn Gain | S3 Loan Bal | S3 Equity | Apprecn Gain |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
—
5-year DTI trend — income grows at 3%/yr, housing cost stable
S1 FHA + hack
S2 min down
S3 20% down
S4 renting
28% guideline
43% hard limit
Total Year 1 net worth gain — income + housing + investments
S1 FHA + hack
—
total net worth gain
S2 min down
—
total net worth gain
S3 20% down
—
total net worth gain
S4 renting
—
total net worth gain
| Component | S1 FHA + hack | S2 min down | S3 20% down | S4 renting |
|---|
—
—