Mortgage Calculator

This calculator subtracts the down payment from the home price, calculates a level monthly principal and interest payment, and builds an amortization schedule.

Formula and assumptions

Mortgage principal equals price minus down payment. The payment uses the standard amortizing loan formula with monthly interest and a fixed payment count.

Rates, timing, and compounding

Enter the nominal mortgage interest rate used for payments. A disclosed APR that includes fees may not be the same rate used in the lender's payment schedule.

Payments occur at month end. The first payment includes interest on the full opening mortgage principal.

Interest is calculated monthly from nominal APR divided by 12. The effective annual borrowing cost KPI shows the compounding effect on that note rate.

A step by step interpretation

Start with mortgage principal, which is home price minus down payment. Confirm that this matches the amount expected to be financed before reading payment. Monthly payment includes principal and interest only. It excludes the property costs named in the summary. Total interest measures interest across the full scheduled term when every payment is made as assumed, while total paid adds principal and interest. Effective annual cost converts the nominal note rate under monthly compounding but does not add closing costs. Read the amortisation table to see that balance declines slowly early in a long mortgage because interest is charged on a large opening principal. Later, more of the fixed payment reduces principal. Compare remaining balance with possible sale dates, not only the final zero balance. A payment can appear affordable while the complete housing budget is not, so interpret it beside tax, insurance, maintenance, services, and cash retained after the down payment.

Sensitivity analysis

Change down payment first while holding home price, rate, and term fixed. Record mortgage principal, monthly payment, and total interest, then consider the cash reserve left after closing. Restore down payment and compare a shorter term with the original term. The shorter term raises payment but can reduce total interest substantially. Next raise the rate by one and two percentage points to represent quotation changes or refinance risk before a rate is fixed. Test a lower home price under the same down payment to see the combined effect on principal and payment. Add property tax, insurance, maintenance, association charges, and utilities outside the calculator for every case. A useful stress scenario combines a higher rate with realistic nonmortgage housing costs and lower available income. Do not choose the largest down payment solely because it lowers interest if doing so removes funds needed for closing, repairs, or emergencies.

Formula verification

Subtract down payment from home price to verify mortgage principal. Divide nominal APR by twelve for monthly rate and multiply years by twelve for payment count. Apply the standard amortising payment formula, or straight division at zero rate. For the first table row, interest equals opening principal times monthly rate, principal repaid equals payment minus interest, and closing balance equals opening principal minus principal repaid. Repeat at a later annual row and confirm interest has declined under a positive fixed rate. Sum all schedule interest to reproduce total interest and all payments to reproduce total paid. The last balance should be zero. Raising down payment should lower principal, payment, and interest when other inputs remain fixed. A lender figure can differ because of daily timing, fees, insurance, or rounding, so reconcile the contract inputs rather than forcing the calculator to match.

Use the estimate to compare down payments, rates, and terms, then add all other ownership costs before assessing affordability.

What the estimate leaves out

• Closing costs, loan fees, insurance, property taxes, maintenance, and association charges are excluded from the payment shown.
• The calculator does not assume any mortgage interest deduction or property tax treatment. Rules and eligibility vary by location.
• Inflation is not included. The fixed principal and interest payment stays nominally level, while tax, insurance, maintenance, and income may change.
• The schedule assumes a fixed rate and on time payments. Variable rates, refinancing, extra payments, and payment changes alter the result.

Compare scenarios carefully

Compare both monthly cash cost and total interest. A larger down payment reduces borrowing but also uses cash that may have other purposes.

The model covers only a fixed principal and interest loan. It excludes fees, insurance, taxes, maintenance, rate changes, and sale costs.

Realistic use cases

This calculator can screen a fixed principal and interest mortgage for a proposed purchase, compare down payment choices, or show the payment and balance effects of different terms. A buyer can estimate remaining principal after a planned ownership period and compare it with likely selling costs separately. Someone considering a refinance can model the new principal, rate, and term before adding fees and comparing the new schedule with the existing one. A household can use the result as one line in a complete ownership budget that also includes taxes, insurance, maintenance, association charges, and utilities. The table can explain why a thirty year loan builds equity from principal slowly in early years. It can also compare price cases before viewing properties, helping keep financing discussions tied to total housing limits. The result is a mathematical estimate, not a lending quotation, property valuation, or affordability approval.

When this model is unsuitable

Do not use this fixed mortgage schedule for variable rates, interest only periods, offset accounts, balloon payments, changing payment frequencies, construction draws, shared equity, or fees financed under special rules. It cannot calculate borrowing eligibility, required income, loan to value policy, mortgage insurance, taxes, or closing cash. It is unsuitable for comparing ownership with renting from payment alone because ownership includes transaction costs, maintenance, opportunity cost, and uncertain property value. A refinance decision needs remaining old loan costs, new fees, reset term, and break point analysis beyond the displayed new payment. The model should not replace a lender amortisation statement or contract. It does not assess property condition, location, insurance availability, legal title, or future sale value. Entering a fee inclusive disclosed APR instead of the note rate can also produce a payment different from the lender's schedule.

A consistent comparison method

Use the same home price, down payment, start date, and included costs across lender cases. Obtain the note rate that produces payments, term, payment frequency, points, origination charges, valuation fees, legal costs, mortgage insurance, and any mandatory account charges. Calculate principal and interest with the note rate, then add fees separately according to whether they are paid upfront or financed. Compare total housing cost using the same estimates for property tax, insurance, maintenance, association fees, and utilities. For different terms, record monthly payment, total interest, remaining balance at the expected sale date, and cash reserve after closing. Include early repayment and portability conditions. When comparing renting, use a separate framework with rent changes, deposits, moving costs, investment opportunity cost, and property risk. A consistent mortgage comparison never ranks offers only by payment or headline APR.

Data and source checklist

Obtain a recent purchase price or offer amount and list what is included. Confirm down payment from accessible cash after preserving any required reserve. Gather the lender's nominal note rate, exact term, payment frequency, quotation expiry, and whether the rate is fixed. List points, origination, valuation, legal, registration, insurance, tax, and account fees, noting which are financed. Estimate property taxes, building and contents insurance, maintenance, association charges, utilities, and immediate repairs from current sources. Check loan to value rules and whether mortgage insurance applies. Record expected first payment and any interest due before it. For an existing mortgage, use the current payoff principal rather than original borrowing. Keep all amounts in one currency and collect comparison quotations on the same date. Reconcile the displayed payment with lender documents before making commitments.

Edge cases to inspect

A down payment equal to home price produces zero mortgage principal and zero principal and interest payment, although transaction and ownership costs remain. A down payment above price is invalid. At zero rate, monthly payment is principal divided by payment count. A shorter term raises payment, and a longer term generally raises total interest. A very low down payment may trigger costs absent from the model. A final payment can be slightly smaller because the schedule pays exact remaining principal and interest. Rounding the regular payment down can leave a residual balance in real agreements. A term extending beyond expected ownership still matters because remaining balance at sale must be repaid. Financing closing fees increases principal and interest, while paying them upfront reduces available cash. Property values can fall below remaining principal, a condition the amortisation table cannot predict. Variable and interest only mortgages require different schedules.

Decision framework

Set a complete monthly housing limit from cautious income and essential spending, then reserve space for taxes, insurance, maintenance, utilities, and association costs before deriving an affordable principal and interest payment. Compare home prices, down payments, rates, and terms within that full limit. Preserve cash for closing, repairs, and emergencies instead of applying every available amount to the down payment. Review how long the property is likely to be held and inspect remaining balance at that date. Consider rate stability, refinancing dependence, early repayment rules, and sale costs. If affordability depends on optimistic income growth, unusually low maintenance, or a future refinance, reduce the purchase case or gather stronger evidence. The calculator makes debt cost visible, but the decision also depends on property suitability, mobility, legal checks, insurance, and concentration of household wealth. Document assumptions and update them when rates or property costs change.

Relevant risk limitations

Mortgage risk extends beyond interest. Income can fall while taxes, insurance, maintenance, energy, and association costs rise. A property can require major repairs or become difficult to insure or sell. Value can fall below remaining principal, limiting mobility. A long fixed payment may become easier in real terms if income rises, but inflation can also raise every excluded ownership cost. Variable rates create direct payment risk that this fixed model does not show. Refinancing may be unavailable when credit, income, property value, or market rates change. Large down payments concentrate liquidity in an asset that cannot be spent quickly. Currency mismatch can affect borrowers paid in one currency and owing another. Stress total housing cash flow, retain reserves, and read legal and lending documents. The projection assumes perfect payment performance and no property shock, so it cannot measure the consequences of either failing.