How to calculate mortgage loan settlement: 5 steps to calculate principal and interest.

When wanting to pay off a mortgage early or preparing to sell a house, many people are most concerned about how to calculate the final settlement amount correctly and avoid omissions. In reality, the amount to be settled is not only the remaining principal balance, but also relates to interest rates, loan term, and the number of installments already paid.

This article will help you understand how to calculate your mortgage loan settlement amount in a simple and easy-to-apply way, based on the basic information in your loan contract. This will allow you to proactively check your figure before dealing with the bank and avoid unnecessary mistakes.

Part 1: Things to know before paying off your loan

Article 1: Why is the mortgage loan settlement amount higher than the current outstanding balance?

1. Understand the concept of "paying interest at the end of the term" for mortgage loans.

• Mortgage loans are calculated with interest based on the principle of paying interest for the period the capital has been used .

• The current payment is actually for the interest from the previous month , not the current month.

• For example:

  • The July payment is for the interest paid for June .

2. Why is the outstanding balance on the statement not the full amount of the mortgage loan repayment?

• The balance on the statement only reflects:

  • Remaining principal balance

  • Interest has been recognized up to the most recent statement date.

• The interest accrued from the most recent payment date up to the date you finalize the payment has not been added to the outstanding balance on your statement.

• This is why the amount paid off on a mortgage loan is always higher than the current outstanding balance .

3. How is accrued interest calculated when settling a mortgage loan?

• When you request a settlement, the bank will:

  • Interest accrues daily starting from the most recent payment date.

  • Add this interest to the current principal balance.

• This interest:

  • Not yet shown on the statement.

  • It is only recorded at the next statement date or upon settlement.

4. Practical examples to make it easier to understand.

• Outstanding balance on statement: $12,250

• Interest accrued from the payment due date to the settlement date: 250 USD

• Actual mortgage loan settlement amount:

  • 12,250 + 250 = 12,500 USD

5. Things to do before paying off your mortgage loan

• Always ask your bank for a payoff statement .

• Check:

  • Effective date of the settlement amount

  • Interest accrues daily.

• You shouldn't rely solely on the outstanding balance on your statement to make a final payment.

Article 2: Information required to settle a mortgage loan

1. Total initial loan amount

• This is the amount you borrowed when you signed the mortgage agreement.

• For example:

  • Initial loan amount: $200,000

• This information helps determine the loan structure and how the principal and interest will be allocated over time.

2. Annual loan interest rate

• It is the interest rate stated in the mortgage loan contract.

• For example:

  • Interest rate: 3% per year (equivalent to 0.03)

• When doing the calculations yourself, you need:

  • Divide the annual interest rate by 12 to get the monthly interest rate.

  • Example: 0.03 ÷ 12 = 0.0025

• This is an important step because mortgage interest is calculated monthly , not annually.

3. Total number of installments for the loan

• With monthly installment loans, the formula is:

  • Number of loan years × 12 months

• For example:

  • Loan term: 20 years

  • Total number of payment installments: 240 installments

• This information helps determine the entire loan lifecycle.

4. Number of installments paid and number of installments remaining.

• You need to clearly define:

  • How many years (or installments) have you paid for?

  • How many years (or terms) are left?

• For example:

  • Payments have been made over 15 years = 180 installments.

  • Remaining 5 years = 60 payment installments

• This is the key data to calculate:

  • Remaining principal balance

  • Interest accrues when a mortgage loan is fully repaid.

5. Important notes before starting the calculations

• Information should be cross-referenced from:

  • most recent bank statement

  • Loan contract or electronic banking system

• Even small discrepancies can lead to significant differences in the final calculation of a mortgage loan.

Article 3: Use online tools to calculate the final settlement of the mortgage loan.

1. When should you use an online mortgage loan settlement calculator?

• When you want to quickly check the amount you need to pay off your loan.

• When you are not familiar with the formulas for calculating principal and interest.

• When you need to compare results before requesting the bank to provide the official settlement statement.

2. How to use a mortgage loan settlement calculator.

• Search on Google using the keyword:

  • “mortgage payoff calculator”

  • or equivalent loan settlement instruments

• Enter the basic loan information:

  • Initial loan amount

  • Annual interest rate

  • Loan term

  • Number of years or periods remaining

• Press “Calculate” to see the results.

3. Why should you use multiple tools for comparison?

• Each tool can:

  • Rounding different numbers

  • Apply interest calculation method based on daily or monthly rates.

• The difference in results can be small, often just a few cents, but it still has an impact when the final settlement is made.

• Comparison helps you:

  • To have a more accurate perspective

  • Detecting abnormal discrepancies

4. Practical examples of calculating the final settlement of a mortgage loan.
With the following loan information:

• Initial loan amount: $200,000

• Interest rate: 3% per year

• Loan term: 20 years

• Remaining time: 5 years

The results from two different online calculators are as follows:

• First item: $61,729.26

• Second item: $61,729.33

Although the difference is small, it shows that the results from online tools are only for reference .

5. Important notes before making the final payment.

• Do not use money from online tools to transfer funds directly.

• Always request an official payoff statement from your bank.

• Confirm clearly:

  • Effective date of the settlement amount

  • Interest accrues up to the payment date.

Article 4: Contact the bank before settling your mortgage loan.

1. Why you shouldn't transfer the settlement money yourself based on estimates.

• The amount you calculate yourself could be:

  • Missing a few cents or a few pennies in daily accrued interest.

  • Excluding year-end adjustments

• Even with just a very small shortfall, the mortgage loan still:

  • Not yet fully closed

  • Interest continues to be charged.

• This is a fairly common mistake when borrowers don't understand how to calculate the final repayment of a mortgage loan.

2. How to contact the bank to request the exact settlement amount.

• You can contact us by:

  • Phone

  • Online banking system

• Many banks offer this option:

  • Request a payment settlement statement (payoff request)

  • Manage your mortgage loan online.

• After submitting your request, you will typically receive:

  • The mortgage loan settlement amount is processed within 5–7 business days.

3. Choose a specific settlement date.

• The bank will ask you:

  • Choose a specific date to calculate the final settlement amount.

• Reason:

  • Mortgage interest is calculated daily.

  • Each day that passes, the settlement amount will change.

• The amount of money the bank provided was only:

  • Valid for a specific period of time.

4. Complete the final payment procedures.

• To pay off your mortgage loan, you need:

  • Complete the final payment form (online or paper).

  • Transfer the exact amount provided by the bank.

  • Payment must be made within the validity period of the settlement statement.

• Incorrect payment amounts or payments made at the wrong time may result in the settlement not being recorded.

5. A final settlement statement may be requested for reference only.

• You are not required to settle the payment immediately after making the request.

• Many people use settlement statements to:

  • Estimated likelihood of early repayment

  • Preparing to sell the house.

  • Financial planning

• Some banks also:

  • The mortgage loan payment amount is displayed on your monthly statement.

Part 2: How to calculate interest and principal yourself when paying off a loan.

Step 1: Formula for calculating the final settlement of a mortgage loan

1. Formula for calculating the final settlement balance of a mortgage loan

• The standard formula used is as follows: B = L × $(1 + c)^n − (1 + c)^p$ / $$ ( 1 + c ) n − 1 (1 + c)^n − 1

2. The meaning of each variable in the formula

• B :

  • The amount of the mortgage loan repayment due at the time of calculation.

• L :

  • Total initial loan amount

• c :

  • Monthly interest rate

  • Calculated as: annual interest rate ÷ 12

• n :

  • Total number of installments for the entire loan

  • Formula: number of loan years × 12

• p :

  • The number of payments you have made so far.

3. How to apply the formula to avoid errors

• Prepare all necessary loan information before proceeding.

• Ensure:

  • Interest rates have been changed from annual to monthly.

  • The number of payment installments is calculated precisely on a monthly basis.

• Follow the steps carefully, without simplifying or altering the formula.

4. Important notes when calculating your mortgage loan settlement yourself.

• The formula above gives the remaining principal balance , excluding:

  • Interest accrues after the most recent payment period.

• When the actual settlement takes place, the bank will:

  • Plus interest calculated daily until the payment due date.

• Therefore, the calculated results should only be used for:

  • Estimate

  • Compare

  • Understand how banks calculate it.

Step 2: Substitute the numbers into the formula for calculating the final settlement of the mortgage loan.

1. Example loan used to illustrate

• Loan term: 20 years

• Initial loan amount: $200,000

• Interest rate: 3% per year

• Remaining time: 5 years

• Payment period: 15 years

2. Identify the variables before calculating.

• L (initial loan amount) :

  • 200,000 USD

• c (monthly interest rate) :

  • Annual interest rate: 3% = 0.03

  • Monthly interest rate: 0.03 ÷ 12 = 0.0025

• n (total number of payment periods) :

  • 20 years × 12 months = 240 periods

• p (number of installments paid) :

  • 15 years × 12 months = 180 terms

3. Substitute the numbers into the formula for calculating the final settlement of the mortgage loan.

• The formula after substituting the numbers will be: B = 200,000 × $(1 + 0,0025)^240 − (1 + 0,0025)^180$ $$ ( 1 + 0 , 0025 ) 2 40 − 1 (1 + 0.0025)^240 − 1

• The result obtained is the remaining principal balance at the time of repayment after 15 years.

4. Important notes when substituting numbers into formulas

• Always double-check:

  • Has the interest rate been correctly divided by 12?

  • The number of payment installments is calculated monthly, not annually.

• Just one mistake in a variable (for example, confusing 180 with 60) will result in a completely wrong answer.

5. Understand the correct result after calculation.

• The calculated number is:

  • Remaining principal balance according to the repayment schedule

• Not included:

  • Interest accrues from the most recent payment date until the actual settlement date.

• When paying off a mortgage loan, the bank will add this interest.

Step 3: Calculate the exponent in the mortgage loan settlement formula.

1. Identify the calculations that need to be performed.

• In the formula, the value (1 + c) appears multiple times.

• Using the example below:

  • c = 0.0025

  • 1 + c = 1.0025

• You need to calculate:

  • 1.0025 to the power of 240 (calculated twice)

  • 1.0025 to the power of 180 (calculated once)

2. Results of exponent calculations

• 1.0025^240 = 1.82075499532

• 1.0025^180 = 1.56743172467

These figures reflect the impact of compound interest over time on mortgage loans.

3. Substitute the exponent result into the mortgage loan settlement formula.
After obtaining the above values, the formula becomes:

• B = 200,000 × (1.82075499532 − 1.56743172467) / (1.82075499532 − 1)

This is an intermediate step before you proceed with subtraction and division to arrive at the remaining principal balance .

4. Notes when performing this step

• Recommended to use:

  • Scientific calculator

  • High-precision online calculator

• You shouldn't round numbers too early.

  • Rounding before completing the calculation can cause the result to be off by a few tens or hundreds of currency units.

• Record all intermediate values ​​for easy verification.

Step 4: Perform the subtraction in the mortgage loan settlement formula.

1. Perform subtraction in the numerator.

• Subtract the smaller power from the larger power:

  • 1.82075499532 − 1.56743172467 = 0.253323270652

• This is the difference reflecting the remaining principal balance after a certain number of payment periods.

2. Perform subtraction in the denominator.

• Subtract 1 from the corresponding power value:

  • 1.82075499532 − 1 = 0.82075499532

• This number represents the entire lifecycle of a mortgage loan.

3. Simplify the formula after subtraction.
After completing the two subtractions above, the formula for calculating the final settlement of a mortgage loan is simplified as follows:

• B = 200,000 × (0.253323270652 ÷ 0.82075499532)

At this stage, you only need one division and one multiplication operation to arrive at the final result.

4. Notes to avoid mistakes

• Make sure to use the same number of decimal places for both the numerator and the denominator.

• Do not round too early before completing the division.

• Record the results step by step for easy verification if needed.

Step 5: Divide and multiply to find the final mortgage payment amount.

1. Perform the division in the formula.

• Divide the numerator by the denominator:

  • 0.253323270652 ÷ 0.82075499532 = 0.308646638883

• This result represents the ratio of the remaining principal balance to the initial loan amount.

2. Multiply by the initial loan amount.

• Multiply the result above by the total amount borrowed:

  • 200,000 × 0.308646638883 = 61,729.3277766

3. Round the numbers to get the final result.

• After rounding to two decimal places:

  • Mortgage loan settlement amount = $61,729.33

4. Understand the true meaning of this number.

• This is:

  • The remaining principal balance according to the repayment schedule after 15 years.

• Not included:

  • Interest accrues from the most recent payment date until the actual settlement date.

• When the final payment is made, the bank will:

  • Plus daily interest.

  • Provide the exact figures in the payoff statement.

5. Important notes before making a final payment.

• Do not use the calculated results for direct payment.

• Always double-check the mortgage loan settlement amount with the bank.

• Carefully check the expiry date of the amount provided.

You need to get the money to pay off the mortgage before selling the house.

1. How is the proceeds from the sale of the house allocated?

• The money paid by the buyer will be used in the following order:

  • Pay off the mortgage loan in full.

  • Pay any transaction-related costs that the seller is responsible for.

    • Notary fees

    • Brokerage fees

    • Settlement fee, administrative fee (if any)

• After deducting all of the above expenses, the remaining amount is the total amount you will receive.

2. Why can't you sell your house if you don't have the exact amount of money for the final payment?

• If you don't know the exact amount to pay off your mortgage:

  • It is impossible to calculate the exact profit from selling the house.

  • It's easy to run out of money when transferring ownership.

• The bank will only release the collateral when:

  • The loan was repaid in full and on time.

3. Don't rely solely on calculated numbers.

• Whether you apply the formula yourself or use an online tool:

  • The results are still only estimates.

• Just a slight deviation:

  • A few dollars

  • Or a few cents
    Mortgage loans are still possible:

  • Not yet fully closed

  • Interest continues to accrue.

4. Risks of underpaying at the end of a loan.

• The loan is still considered valid.

• Interest continues to accumulate daily.

• May cause delays:

  • Release of mortgage

  • Complete the house sale transaction.

5. The correct and safest way to do it

• Always ask the bank for:

  • Mortgage loan payment statement

• Check carefully:

  • Effective date of the settlement amount

  • Interest and fees are included.

• Use this number only for home sales transactions.

References

1. http://themortgageinsider.net/
   mortgages-refinancing/mortgage-payoff.html
2. http://www.free-online-calculator-use.com/
   early-payoff-mortgage-calculator.html
3. http://www.calculator.net/mortgage-payoff-calculator.html
4. http://www.mtgprofessor.com/formulas.htm
5. http://budgeting.thenest.com/
   pay-off-mortgage-balance-selling-home-28962.html

Translated by: Sidney Bailey Hoang .