Housing decision guide

Can I afford a mortgage if costs rise?

What happens to monthly housing costs if the rate or property costs rise?

Estimate principal and interest, add recurring property costs, and compare the total with monthly household income. Then rerun the model with a higher rate and cost allowance; a payment quote alone cannot show the full pressure.

Open the full model Try it on this page

1. Start with the full monthly outflow

The loan payment covers principal and interest. Add recurring property costs such as insurance, taxes, shared-building charges, and a maintenance allowance using figures relevant to the home and location. Keep utilities and one-off repairs in the wider budget.

2. Inspect a baseline

The example models a $350,000 home, 20% down, a 4.8% annual rate, and a 30-year term. It gives roughly $1,470 for the loan payment. Adding $250 in monthly property costs raises the modeled housing outflow to about $1,720.

3. Change one pressure at a time

Increase the rate by one percentage point, then reset it and increase recurring costs. Finally combine the two changes. Compare each total with your remaining cash after closing and your other monthly commitments.

4. Keep the lending decision separate

The housing-load result is an informational ratio, not an approval or a safe-spending threshold. Loan structures, taxes, fees, insurance, and local rules differ. Verify terms with a qualified lender and consider a separate emergency reserve.

Live model

Change an assumption.
Read the consequence.

Enter your assumptions to see an estimate. Use source view to inspect or change the calculation. Your inputs stay in this browser.

Worked exampleCalculate in your browser

Assumptions

template: mortgage_repayments

home_price = 350000 in usd
down_payment = 70000 in usd
mortgage_interest_rate = 4.8%
mortgage_term_years = 30
monthly_household_income = 6500 in usd
monthly_property_costs = 250 in usd

Inputs

What the model needs

Home price: The agreed or expected purchase price.
Down payment: Cash applied before the mortgage principal is calculated.
Interest rate: The annual mortgage rate used for the repayment estimate.
Term: The repayment period in years.
Property costs: Recurring tax, insurance, association, or maintenance allowance.
Household income: Monthly income used only for the housing-load check.

Method

Formulas stay visible

principal = home_price - down_paymentmonthly_rate = annual_interest_rate / 12payment = principal × monthly_rate × (1 + monthly_rate)^n / ((1 + monthly_rate)^n - 1)at zero interest: payment = principal / n; n = term_years × 12housing_load = (payment + property_costs) / household_income

The inputs and source use the same model. Open it in Continuum for a document you can keep and revisit.

Worked example

A $350,000 home with 20% down

$280,000 principal
4.8% annual rate
30-year term
$250 monthly property costs

ResultThe modeled payment is about $1,470; total monthly housing cost is about $1,720.

Against $6,500 monthly household income, the modeled housing load is roughly 26.5% before utilities and irregular repairs.

Stress-test it

Move the interest rate by one percentage point in both directions.
Add a realistic maintenance allowance instead of using only the lender payment.
Compare the cash impact of a larger down payment with the liquidity it removes.

Use it when

Checking a likely payment before speaking with a lender
Comparing down-payment choices
Understanding how property costs change affordability

Know the boundary

The worked example uses a fixed-rate amortization model.
Taxes, insurance, fees, and rate changes vary by location and loan.
The affordability signal is informational and is not lending advice.

Questions

Does this model a variable-rate mortgage?

It calculates a payment for the interest rate you enter. Rerun it at another rate to compare cases; it does not forecast when or how a variable rate may change.

Are taxes and insurance included?

Only when you enter them in recurring property costs. The loan payment itself is principal and interest.

Does the housing-load number tell me what I can borrow?

No. It is an estimate for your planning, not a lending decision or affordability rule.

Keep the reasoning

Turn this example into
your living model.

The full template opens as a local Continuum document. Edit every assumption, explore the result breakdown, and keep the source.

Open the editable model