What changes the income you need?
For the $350,000 example, 20% down leaves a $280,000 loan. At a fixed 6.5% over 30 years, principal and interest are about $1,770 a month. Property tax and homeowners insurance bring housing costs to about $2,270. The 28% housing ratio requires about $97,277 gross per year, which is higher than the requirement at the 36% ratio with $500 in other monthly debt.
Load the second example to double the other debt to $1,000 a month. The home and its payment stay the same. The housing-plus-debt ratio now sets the higher income target at about $108,993 a year.
How the worksheet works
Principal is the price minus the down payment. For a fixed-rate loan, the monthly principal and interest payment is P × r ÷ (1 − (1 + r)−n), where P is principal, r is the annual interest rate divided by 12 as a decimal and n is the number of months. At 0% interest, divide principal by n.
Gross annual income = 12 × the larger of (monthly housing cost ÷ housing ratio) and ((monthly housing cost + other debt payments) ÷ total debt ratio).
Monthly housing cost includes principal, interest, taxes, insurance, HOA dues and any monthly mortgage insurance you enter. Include monthly obligations such as car and student loans in other debt payments. Check a quote for your actual mortgage insurance charges. Closing costs, maintenance and utilities belong in your cash budget, outside the ratios used here.
This worksheet models a fixed-rate U.S. mortgage and a gross income target for planning. Lenders use their own eligibility rules and may count income or debts differently. For the reverse question, use the mortgage affordability calculator to start with your income.
Methodology & sources
The CFPB explains debt-to-income ratios, how to read a Loan Estimate and when private mortgage insurance may apply. The ratios above are adjustable planning inputs.