Homeownering Multifamily
Calculate affordability with rental income
| Current situation | Scenario B | Scenario C | Scenario D | Scenario E | ||
|---|---|---|---|---|---|---|
| Income | Yearly salary | |||||
| Monthly salary | $11,667 | $16,667 | $5,833 | $7,500 | $7,083 | |
| Debt | Monthly credit card debt | |||||
| Monthly car payments | ||||||
| Monthly student loans | ||||||
| Monthly child support payments | ||||||
| Monthly alimony payments | ||||||
| Monthly other debt (to relatives, etc.) | ||||||
| Total | $0 | $950 | $1,050 | $750 | $250 | |
| Insurance | Homeowners insurance (monthly) | |||||
| Tax | Property tax (monthly) | |||||
| Home details | House sale price | |||||
| Down payment | ||||||
| Percent down payment | 20% | 15% | 3% | 4% | 8% | |
| Term (years) | 30 | 30 | 30 | 30 | 30 | |
| Loan amount | $960,000 | $170,000 | $460,000 | $335,000 | $275,000 | |
| Rental units | Unit #1 appraised monthly rental amount | |||||
| Unit #2 appraised monthly rental amount | ||||||
| Unit #3 appraised monthly rental amount | ||||||
| Unit #4 appraised monthly rental amount | ||||||
| Unit #5 appraised monthly rental amount | ||||||
| Total rental income | $5,500 | $0 | $0 | $0 | $0 | |
| Total usable income (75% of rental) | $4,125 | $0 | $0 | $0 | $0 | |
| Interest rate | Look up current at https://www.freddiemac.com/pmms | |||||
| Payment (mortgage, monthly) | $6,227 | $1,103 | $2,984 | $2,173 | $1,784 | |
| Housing costs (mortgage + ins + tax, monthly) | $7,777 | $1,361 | $3,598 | $2,625 | $2,171 | |
| Housing costs + debt (monthly) | $7,777 | $2,311 | $4,648 | $3,375 | $2,421 | |
| Front end | 49% | 8% | 61% | 35% | 31% | |
| Back end | 49% | 14% | 79% | 45% | 34% | |
Loan Approval Matrix - Possibility of approval
| Loan Type | Current situation Back: 49% |
Scenario B Back: 14% |
Scenario C Back: 79% |
Scenario D Back: 45% |
Scenario E Back: 34% |
|---|---|---|---|---|---|
| Conventional | MAYBE | YES | NO | MAYBE | YES |
| FHA | MAYBE | YES | NO | MAYBE | YES |
| VA | MAYBE | YES | NO | MAYBE | YES |
| USDA | MAYBE | YES | NO | MAYBE | YES |
Legend:
YES = Clear to close
MAYBE = Possible with compensating factors
NO = Unlikely approval
Note: Rental income is calculated at 75% for qualification purposes.
Note: Rental income is calculated at 75% for qualification purposes.
INSTRUCTIONS: Edit the cells with green backgrounds to input your values. The gray cells contain formulas and will update automatically.
Enter rental income for up to 5 units. The calculator uses 75% of total rental income for DTI calculations.
For questions, contact: nicole@homeownering.com
Copyright 2022-2025 Homeownering
