Housing Loan Full Settlement Calculator

A housing loan full settlement calculator estimates the balance remaining when you pay off a home loan in full on a chosen payment date. Enter the original loan amount, annual interest rate, loan term, and the number of monthly payments already made to estimate the payoff balance and total interest paid so far.

Formula

The calculator estimates the balance after a specified number of equal monthly payments on a fixed-rate, fully amortizing loan. It first calculates the monthly payment, rounded to cents, then applies the standard balance-after-payments formula:

r = APR / 1200
PMT = round[P × r / (1 − (1 + r)^−N), 2]
B = P × (1 + r)^k − PMT × [(1 + r)^k − 1] / r

• P is the original principal, in dollars.
• APR is the annual percentage rate entered as a percentage, such as 6 for 6%.
• r is the monthly rate as a decimal.
• N is the full loan term in months: years × 12.
• k is the number of monthly payments already made.
• PMT is the estimated monthly principal-and-interest payment in dollars.
• B is the estimated principal balance after payment k, in dollars.

The outputs also show total regular payments, PMT × k, and estimated interest included in those payments: total payments − (P − B). These figures exclude any separate charges. The first output is the estimated balance, not an official lender payoff quote.

Worked Example

Using the calculator’s defaults: P = $200,000, APR = 6%, term = 25 years, and k = 60 monthly payments.

1. Convert the annual rate to a monthly decimal: r = 6 / 1200 = 0.005.
2. Convert the term to months: N = 25 × 12 = 300.
3. Calculate the monthly payment: PMT = round[$200,000 × 0.005 / (1 − 1.005⁻³⁰⁰), 2] = $1,288.60.
4. Calculate the balance after 60 payments: B = $200,000 × 1.005⁶⁰ − $1,288.60 × [(1.005⁶⁰ − 1) / 0.005] = $181,913.88.
5. Total regular payments made: $1,288.60 × 60 = $77,316.00.
6. Estimated interest in those payments: $77,316.00 − ($200,000 − $181,913.88) = $59,229.88.

Assumptions

• The interest rate remains fixed for the full term.
• Payments are equal monthly principal-and-interest payments, made at the end of each monthly period; the count entered represents completed payments.
• Interest compounds monthly using APR divided by 12.
• The estimate does not include payoff fees, accrued interest between payment dates, taxes, insurance, PMI, escrow, or other charges.

What a Full Settlement Estimate Means

A full settlement is the amount needed to close out the loan rather than continue making scheduled installments. The calculator estimates the unpaid principal under a simplified payment schedule. A lender’s requested payoff figure can differ because it may account for interest accrued since the last scheduled payment, payment posting dates, unpaid amounts, fees, or other contract-specific adjustments.

Use the result as a planning estimate, not as the amount to send. Ask the loan servicer for a written payoff statement for the intended date and follow its instructions for payment and delivery. Payoff figures can be date-sensitive: interest may continue accruing until the funds are received and processed.

How to Use the Calculator

1. Enter the original principal, not the current balance, in the loan amount field.
2. Enter the annual APR as a percentage. For example, type 6 for 6%, not 0.06.
3. Enter the original loan term in years.
4. Enter the count of completed monthly payments. If you have made 60 monthly payments, enter 60; do not enter the number of years elapsed.
5. Read the estimated balance as the model’s remaining principal, then compare it with a lender-issued payoff quote for the actual settlement amount.

For a loan with an adjustable rate, a payment change, extra principal payments, missed installments, or a refinance, the standard schedule may not match the account. The calculator assumes the original payment pattern stayed unchanged.

Common Errors and Limits

A frequent misunderstanding is that the remaining principal and the full settlement amount are always identical. The balance formula represents principal after the selected number of payments. A real payoff quote may add accrued interest or other applicable account amounts, so it should be obtained directly from the servicer.

• Using the current balance as the original amount: the formula needs the loan’s starting principal and the number of payments made since then.
• Entering APR as a decimal: enter 6 for 6%; the calculator converts the percentage to a monthly rate.
• Counting scheduled payments rather than completed ones: enter payments actually made and posted. A payment in transit may not yet reduce the account balance.
• Ignoring extra payments: additional principal changes the balance path, but this calculator has no field to record them.
• Expecting a quote for a specific date: the model does not calculate daily interest or the servicer’s processing rules.

Rounding the monthly payment to cents follows the displayed schedule, but a lender’s exact payment allocation and rounding may differ. Small differences can accumulate over many payments. The formula also assumes a fully amortizing loan with regular monthly installments; it is not designed for interest-only periods, balloon payments, or irregular payment histories.

Frequently Asked Questions

Is a housing loan settlement balance the same as the outstanding principal?
No. The calculator estimates outstanding principal after the entered payments. A lender’s payoff amount may include accrued interest through the payoff date and other account-specific amounts.

How do I find the number of payments already made?
Use your payment history or account statement and count completed monthly installments from the start of the loan. Do not count payments that are pending or have not posted.

Can I use this calculator if I made extra payments?
You can use it for a rough reference, but the result will not account for extra principal payments. Those payments generally change the remaining balance and may also affect the payment schedule; check your account history or request a current payoff quote.

Why is my lender’s payoff quote different?
The quote may use the requested payoff date and include interest accrued since the last payment, fees, unpaid amounts, or other contract-specific adjustments that this estimate does not model.

Does this estimate include taxes, insurance, or escrow?
No. It models principal and interest only. Any taxes, insurance, escrow balance, or other amounts must be checked separately with the relevant provider or servicer.

This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.

Related

• Mortgage Calculator With Escrow: Payment With Tax and Insurance
• Mortgage Loan Amount Calculator: The Loan a Monthly Payment Repays
• Home Equity Loan Calculator: Amount Up to a CLTV Limit and Payment

in p | Original loan amount | $ | 200000 | 1 | 100000000
in apr | Interest rate (APR) | % | 6 | 0.01 | 100
in yrs | Loan term | years | 25 | 0.0833 | 50
in k | Monthly payments made | - | 60 | 0 | 599
out bal | Estimated settlement balance | $ | p * (1 + apr / 1200) ^ k - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2
out paid | Total regular payments made | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * k | 2
out int | Interest paid in regular payments | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * k - (p - bal) | 2