Mortgage Affordability Calculator · Calculation guide

Estimate a housing loan using income, debts and housing costs.

Calculation guide

For borrowers checking repayment costs and timing under their entered terms.

Rates are entered annual nominal rates converted to the stated payment period. Payments occur at period ends. Principal and interest are kept separate, and the final payment reconciles the remaining balance. Fees are included only where entered. Comparing different terms also shows remaining balances at a common horizon. These are product assumptions, not lender approval or universal statutory APR calculations.

C=max(0,Y·DTI−D−H); P=PV(C,r,N)

Inputs

Income

Income for the stated period. Loan affordability and monthly ratios use monthly income.

Debt payment

Total existing debt payments each month.

Dti limit

Your assumed maximum share of gross income available for debt and the entered housing costs.

Housing costs

Monthly housing costs reserved before calculating the loan payment you could support.

Annual interest / discount rate

Annual interest or discount rate; the selected frequency determines its periodic rate.

Months

Duration in months. Payment frequency may divide this into different repayment periods.

Worked example

InputValue
Income100,000
Debt payment10,000
Dti limit35%
Housing costs5,000
Annual interest / discount rate8%
Months240

Formula:

C=max(0,Y·DTI−D−H); P=PV(C,r,N)

Supported principal = 2391085.83404753

ResultValue
Supported principal2,391,085.834048
Available payment20,000
Entered dti limit35%

Interpreting the result

Loan principal supported by the entered repayment amount, rate and duration.

Gross-income debt allowance minus existing debt payments and entered housing costs.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Income100,000110,000Supported principal2,391,085.8340482,809,525.855006
Debt payment10,00011,000Supported principal2,391,085.8340482,271,531.542345
Dti limit35%39%Supported principal2,391,085.8340482,869,303.000857
Housing costs5,0005,500Supported principal2,391,085.8340482,331,308.688196
Annual interest / discount rate8%9%Supported principal2,391,085.8340482,222,899.080543
Months240264Supported principal2,391,085.8340482,480,841.988845
Mortgage Affordability Calculator →