Educational guide · Updated 6 de October de 2026 · 8 min read
A mortgage's repayment duration changes how much principal is returned each month and how long debt remains outstanding. At a constant positive rate, extending duration generally lowers payments and raises total modelled interest. That alone does not decide the right choice: a higher payment can leave little monthly room, while a lower payment can prolong an obligation you would prefer to finish sooner. Connect the schedule with income, reserves and housing plans. There is no universally optimal duration that can be identified simply by selecting the smallest full term interest total on the screen.
Hold principal and rate constant
Compare the same loan over twenty, twenty five and thirty years using the same rate convention. Record payment, total interest and outstanding balance at a common intermediate date. Changing the down payment or rate simultaneously mixes effects and makes the difference harder to explain. Actual offers may use different rates for different durations. First isolate duration, then compare documented offer conditions. Both exercises provide information, but they answer different questions. One explains the mathematics; the other compares combinations of terms that might actually be available in the transaction under consideration.
A smaller payment is not a lower total cost
Slower repayment keeps principal outstanding longer. With otherwise identical conditions and a positive rate, that exposure generates more interest. Compare debt after five years across the schedules. The longer loan may have required less monthly cash while reducing debt by less. Do not call the entire payment difference a permanent saving without examining what remains owed. Equally, do not ignore the practical value of monthly room if a shorter schedule would prevent essential spending or adequate reserves. Cost and cash flexibility are separate dimensions, and both need to remain visible in the decision.
Specify how the monthly difference would be used
If an option releases 150 per month, decide what happens to it. It might support spending, build reserves, fund another goal or enable later overpayments where allowed. Do not automatically assume decades of successful investing at a constant return. A complete comparison needs a spending or saving rule and consistent conditions. Cash retained should appear as a balance; cash spent will not become accumulated wealth. Later overpayments need dates and any applicable charges. Different behaviour can therefore produce different outcomes from the same initial mortgage payment, even when the loan calculations themselves are unchanged.
Your ownership horizon may be shorter
A thirty year repayment schedule does not mean thirty years in the same property. If a move or sale is possible, calculate the balance at that date and investigate exit expenses. Interest scheduled after a loan is discharged is not part of a loan that has already ended, although it appears in the full horizon scenario. Nor should a sale price that covers every cost be assumed. Keep the debt projection separate from the property value assumption so contractual effects and future market assumptions remain distinguishable. This is particularly useful when comparing options around an uncertain move date.
Test payments against difficult months
Alongside the usual budget, examine lower income or higher expense months. A mathematically cheaper schedule can still be difficult for a particular household. The calculator does not assess employment conditions or other commitments. Use additional monthly housing costs, then include the rest of essential spending in the household budget. No single headroom figure guarantees comfort for everyone. The selected duration should be explainable through its consequences and your priorities without relying on an unconfirmed future income increase. A plan that only works after an expected promotion needs that dependency stated explicitly.
Frequently asked questions about duration
Is the shortest duration always best? Not necessarily: under specified assumptions it reduces interest but demands larger periodic payments. Can a long loan be repaid as if it were short? Conditions, charges and payment behaviour matter, so equivalence is not automatic. What changes at a zero interest rate? Without interest or other costs, duration distributes principal across more or fewer payments without generating extra interest. What should be retained? Keep payments, balances at common dates, interest and the planned use of monthly differences. The workshop below explains those measures before you repeat the calculation with another duration.
Practical workshop: from the loan to the monthly budget
Consider hypothetical financing of 200,000.00 over 20 years at a constant nominal annual rate of 4%, divided by twelve to calculate monthly interest. Add 150.00 per month for other housing expenses. These are educational inputs, not an available offer. The loan uses monthly principal and interest payments, without an interest only period or a final balloon payment. If your contract uses another convention, review the rate selector and its written conditions before comparing the contractual figures with this example. Matching a rate number alone does not make two repayment models equivalent.
The calculated principal and interest payment is 1,211.96. Adding the other expenses entered gives a monthly budget of 1,361.96. These figures answer different questions. The first repays the loan, while the second includes costs that do not reduce debt. Accordingly, the loan table does not include those extras as interest or deduct them from the outstanding balance. Keeping categories separate avoids attributing a maintenance expense to financing or assuming that an insurance premium repays part of the principal. It also makes the calculation easier to compare with an itemised lender statement.
Reconstruct the first year
The starting debt is 200,000.00. Under this example's convention, first month interest is 666.67. The rest of the payment reduces principal. During the first twelve months, cumulative interest is approximately 7,878.69 and principal repaid is 6,664.84. At the end of the first year, the outstanding balance is 193,335.16. Small differences from a real contract may arise from rounding or actual payment dates. The model retains internal precision and rounds displayed figures for readability. A lender's statement may instead apply rounding at each monthly step or use a different day counting method.
Check two relationships: starting principal minus principal repaid should equal outstanding debt, and payments made should split into principal and interest. Do not add the entire original loan to the sum of payments when calculating total repayment, because those payments already contain principal. Also avoid describing every unit of principal repaid as a financing expense: reducing an obligation and paying interest have different effects on your wealth. These simple identities help detect copying mistakes when moving the annual schedule into another spreadsheet or comparing it with a manually prepared budget.
Examine the whole horizon without losing the detail
If the rate remained unchanged throughout the term, payments would total 290,870.56 and interest would be 90,870.56. This total excludes purchase taxes, insurance, charges and other expenses outside the loan entered. A financed cost that increases principal belongs in the starting loan amount. A cost paid in cash belongs in the cash budget. Do not include it both ways. Distinguishing initial cash outlay, recurring expenses and principal repayment makes it easier to compare offers with different structures, such as an upfront fee versus a higher ongoing interest rate.
Read several annual rows rather than only the last one. Outstanding debt may matter if you expect to sell, move or refinance before final maturity. A substantial balance may remain at that date even after many regular payments. Interest scheduled after that date would not automatically be part of your ownership period if the loan ends sooner. An early exit analysis also needs the amount required to discharge the outstanding balance and any applicable charges, based on the lender's documents and the specific transaction. The full term interest total answers a different question from a five year ownership budget.
Test sensitivity to another interest rate
As a further exercise, increase the rate by 2 percentage points while keeping principal and duration unchanged. The new payment would be 1,432.86, a monthly difference of 220.90. This scenario does not predict that such an increase will occur. It shows how the budget responds to a different borrowing cost. For a mortgage with future resets, a proper reset calculation would start with the outstanding balance and remaining duration at the reset date. This example instead compares two conditions from the same starting position so the effect of the rate can be isolated.
Add the payment difference to the household budget and examine the margin left after essential commitments. If the result looks too tight, the variables to review may include price, borrowing amount, down payment, duration or purchase date. Extending duration also changes interest and exposure, so a lower payment does not automatically resolve every concern. Record the purpose of each alternative. That distinguishes a choice intended to improve monthly flexibility from one intended to reduce total cost or limit future uncertainty. It also makes a joint decision easier to discuss with another household member.
Before applying the exercise to a real transaction
Choose country and currency separately. Currency labels amounts; it does not convert them using an exchange rate. Country context points toward relevant sources but does not determine your taxes or reproduce every local contract. Confirm the rate, schedule, charges, upfront expenses and reset conditions against the actual transaction documents. Is the result a lending approval? No. Is it a property valuation? No. It is an explanatory calculation that helps you approach the discussion with specific questions, a record of assumptions and a clearer understanding of the payments that need to be checked before you proceed.