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.

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