Mortgage Affordability Ratios: Set Your Own Limits
Compare user-set housing and debt ratios, deduct other housing costs, and translate a monthly payment budget into a loan estimate.
By Dr. Hassan Khames EliwaLast updated

A ratio is a planning constraint, not a lending promise
Mortgage affordability ratios compare selected monthly costs with a stated income measure. They are useful for testing a budget, but they do not establish approval, eligibility, or the amount a household should borrow. The chosen definitions matter as much as the percentages.
Start with the mortgage affordability calculator and enter your own planning limits. The percentages in this article are user-set scenario inputs, not universal lender thresholds. Actual underwriting differs by lender, product, borrower, and applicable rules.
A sensible workflow has two stages. First determine the payment envelope under transparent income and debt assumptions. Then test whether that envelope leaves enough spendable cash for the household’s actual expenses and reserves. Passing the first test does not mean passing the second.
Separate housing-only and total-debt constraints
A housing-only ratio compares defined housing costs with gross monthly income. A total-debt ratio includes those housing costs plus the monthly nonhousing debt payments counted in the model. Both ratios need an agreed numerator and denominator.
The Consumer Financial Protection Bureau’s debt-to-income explanation describes DTI as monthly debt payments divided by gross monthly income and notes that limits vary. Use that definition as a starting point for understanding the arithmetic, not as a promise that a particular lender accepts your inputs.
For this planning example, housing cost includes mortgage principal and interest, property tax, homeowners insurance, and an association or service charge. Other debt includes the selected required monthly payments entered by the user. Mortgage insurance is assumed to be zero in the example, but it must be included when applicable.
If the calculated room is negative, the scenario does not support a positive mortgage payment under those selected limits. Do not convert a negative result into a loan amount or treat it as a recommendation to ignore existing obligations.
Work a complete monthly example
Assume gross monthly income of 8,000 and other required monthly debt payments of 600. Select a housing-only limit of 30% and a total-debt limit of 40%. These are chosen planning settings only.
The housing-only calculation permits 2,400 per month. The total-debt calculation permits 3,200 for all included debt, then subtracts 600 of other debt to leave 2,600 for housing. The lower housing allowance is therefore 2,400.
Assume property tax of 300 per month, insurance of 100, and an association charge of 100. These non-loan housing costs total 500. Subtracting them from the housing allowance leaves a principal-and-interest budget of 1,900 per month.
| Step | Calculation | Monthly amount |
|---|---|---|
| Housing-only allowance | 8,000 × 30% | 2,400 |
| Total-debt allowance | 8,000 × 40% | 3,200 |
| Housing room after other debt | 3,200 − 600 | 2,600 |
| Selected housing budget | Lower of 2,400 and 2,600 | 2,400 |
| Non-loan housing costs | 300 + 100 + 100 | 500 |
| Principal-and-interest budget | 2,400 − 500 | 1,900 |
At this housing budget, the housing ratio is 30%. Total included monthly debt is 3,000, so the total-debt ratio is 37.5%. The model does not force both constraints to equal their limits; one can bind while the other has unused room.
Translate the payment budget into a loan estimate
For a fully amortizing fixed-rate loan, a payment can be converted into principal using the monthly rate and number of payments. Assume a 6% nominal annual interest rate, monthly compounding and payments, and a 30-year term. The monthly rate is 0.005 and the term contains 360 payments.
Using the 1,900 payment budget gives estimated principal of approximately 316,904.07. This is a mathematical principal amount under the stated payment convention, not an approved mortgage offer. Fees, actual rate conventions, payment timing, and product features can change a real quotation.
Check the amortization with the mortgage payment calculator. Use the same rate, term, and principal-and-interest basis. Do not compare a payment including tax and insurance with one excluding them and conclude that the calculators disagree.
With a fixed cash down payment of 80,000, the corresponding illustrative purchase price is approximately 396,904.07. This assumes the entire down payment goes toward the price and that closing costs, reserves, and any other cash needs are funded separately. It does not assume a particular loan-to-value policy.
Find the constraint that actually binds
Now increase other monthly debt from 600 to 1,000 while keeping the remaining example inputs unchanged. The housing-only allowance stays 2,400. The total-debt constraint now leaves only 2,200 for housing, so it becomes the binding constraint.
After the same 500 of non-loan housing costs, the principal-and-interest budget falls to 1,700. Under the same 6% and 30-year assumptions, estimated principal becomes approximately 283,545.74. The result falls because the payment envelope shrank, not because the interest formula changed.
The loan payment calculator for checking existing debts can help test a modeled installment payment. For affordability planning, however, use the required payment and debt treatment appropriate to the actual obligation rather than replacing it with an optimistic estimate.
Gross income does not pay the grocery bill
Ratios based on gross income leave out payroll deductions and many ordinary expenses. Childcare, food, transport, healthcare, maintenance, and savings can make a ratio-compliant payment uncomfortable. Build a separate household cash-flow budget using expected take-home income.
Include costs that do not appear in the simplified ratio. Repairs and maintenance are real ownership expenses even when they are not counted as debt payments. Utilities may also differ substantially from the current home. Leaving those out does not make them disappear after completion.
The CFPB’s guidance on estimating an affordable house payment emphasizes the broader budget and costs of ownership. Treat the ratio result as one screen within that broader exercise, not the final answer.
Stress the inputs you cannot hold fixed
For a variable-rate product or a future refinancing assumption, test a higher rate while keeping income unchanged. Even a fixed-rate mortgage does not freeze property taxes, insurance, association charges, or household expenses. Increase those inputs independently to see which assumption drives the result.
Income also deserves scrutiny. A recurring salary, irregular overtime, and a recent bonus are not interchangeable budgeting resources. Use a documented income scenario and avoid assuming that every good month will recur. Lenders may also use different income evidence and averaging methods from a personal spreadsheet.
Keep the decision wider than the maximum
A maximum under selected ratios is a ceiling within that model, not a spending target. Leave room for savings, emergency expenses, and decisions that matter outside the mortgage calculation. A smaller payment can be the more robust choice even when a larger one fits the selected percentages.
Before relying on the result, confirm currency, frequency, income basis, debt inclusions, housing charges, interest convention, and available cash. Then obtain actual product information and appropriate professional guidance. The arithmetic should clarify the conversation, not stand in for underwriting or individualized financial advice.
Calculators used in this guide
Frequently asked questions
Are 30% and 40% standard approval limits?
No. They are user-selected planning assumptions in this example. Lenders and products use different criteria, and no ratio here guarantees approval or suitability.
Why use the lower of the two housing allowances?
Both selected constraints must be satisfied. The smaller allowance is the binding one; using the larger could breach the other selected limit.
Do taxes and insurance belong in the mortgage payment budget?
They belong in the example’s total housing budget and are deducted before calculating the principal-and-interest allowance. Include mortgage insurance and other required charges when applicable.
Does the estimated purchase price include closing costs?
No. The example adds a fixed 80,000 down payment to the mathematical loan amount and assumes all closing costs and reserves are funded separately.
What if the calculated principal-and-interest budget is zero or negative?
The selected income, debt, costs, and ratio limits leave no room for a positive principal-and-interest payment. Review the scenario rather than forcing the result into a positive loan estimate.
Sources and standards
About the author
Dr. Hassan Khames Eliwa holds a PhD in Construction & Built Environment and has more than 20 years of international project controls experience. He is Director of Eliwa Project Controls Limited in Auckland and founder of PMMilestone.org and PMMilestone.com.
Buy me a coffee