This calculator estimates the remaining principal on a mortgage after a chosen number of monthly payments, a starting point for estimating when private mortgage insurance (PMI) might end. Enter the original loan amount, APR, loan term, and payments already made to see the estimated balance and its share of the home’s value. You will also need your current home value and your loan servicer’s PMI cancellation requirements, which vary by loan.
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 principal-and-interest payment, rounded to cents:
PMT = round(P × r / (1 − (1 + r)^−n), 2)
It then calculates the balance after k payments:
B = P × (1 + r)^k − PMT × ((1 + r)^k − 1) / r
- P is the original loan principal, in dollars.
- APR is the annual percentage rate entered as a percent; r = APR / 1200 is the monthly rate as a decimal.
- n is the number of scheduled monthly payments: loan term in years × 12.
- k is the number of monthly payments made.
- PMT is the estimated monthly principal-and-interest payment, in dollars.
- B is the estimated remaining principal, in dollars.
Estimated equity is current home value minus the estimated balance. Estimated loan-to-value (LTV) is the balance divided by current home value, multiplied by 100. The 80% balance output is simply 0.80 times the value you enter; it is a comparison point, not a statement that your loan qualifies for PMI cancellation. The calculator uses the original loan amount and scheduled payment formula; it does not reconstruct your actual payment history.
Worked Example
Using the calculator’s defaults: original loan amount $200,000, APR 6%, term 30 years, 60 payments made, and current home value $250,000.
- Convert the APR to a monthly rate:
r = 6 / 1200 = 0.005, or 0.5% per month. The total scheduled payment count isn = 30 × 12 = 360. - Calculate and round the monthly principal-and-interest payment:
PMT = round(200000 × 0.005 / (1 − 1.005^−360), 2) = $1,199.10. - Substitute 60 payments into the balance formula:
B = 200000 × 1.005^60 − 1199.10 × (1.005^60 − 1) / 0.005. Rounded to cents, the estimated balance is $187,308.98. - Estimate equity:
$250,000 − $187,308.98 = $62,691.02. - Estimate LTV:
100 × $187,308.98 / $250,000 = 74.92%. The 80% comparison balance is0.80 × $250,000 = $200,000.00.
These figures use the displayed payment rounded to the cent, as the calculator does. Your servicer’s statement can differ because of actual payment dates, rounding, extra principal, or loan changes.
Assumptions
- The interest rate stays fixed and the loan is repaid with equal monthly payments.
- Payments are treated as monthly payments made on schedule; payment timing within the month is not modelled.
- Interest compounds monthly at APR divided by 12.
- This estimates principal and interest only. It excludes fees, taxes, insurance, PMI, escrow, missed or late payments, extra principal payments, and any loan modification.
- PMI cancellation and termination eligibility, valuation methods, and required procedures are not modelled. Check the loan documents and ask the servicer for the requirements applicable to your loan.
Step-by-Step
- Find the loan figures. Use the original principal, note APR, and original term from your mortgage documents. If the mortgage has a variable rate, a changed term, or a modification, this fixed-rate estimate may not match the servicer’s balance.
- Enter payments actually credited. Count monthly payments posted to the loan, not simply the months since closing. If you made extra principal payments or skipped, deferred, or changed payments, use the current principal balance from a recent statement instead of relying on this standard schedule.
- Enter a supportable home value. Use a value consistent with the servicer’s accepted valuation process. A personal estimate may be useful for a rough comparison but may not be accepted for an official PMI review.
- Read the estimated balance and LTV. The balance is the calculator’s estimate of principal still owed. LTV compares that balance with the home value entered. For example, an LTV of 80% means the estimated balance is 80% of that entered value; it does not by itself establish a right to remove PMI.
- Compare with the relevant requirement. Review the mortgage documents and ask the servicer what balance, valuation, payment-history, or other conditions apply to your loan. The 80% comparison shown is a calculation aid only; requirements can depend on loan terms and applicable rules.
- Request a formal review if appropriate. Contact the servicer to ask about its process, required documents, valuation, timing, and whether payments must continue while a request is reviewed. Keep written confirmation and continue following the payment instructions you receive.
- Confirm the result in writing. Ask the servicer to state whether PMI has ended and the effective date, and check a later statement to see whether the charge has stopped. The calculator cannot change your account or submit a cancellation request.
Common Mistakes
- Using the purchase price as today’s value. Home value can change, and a servicer may use its own required valuation. A different value changes the LTV calculation.
- Confusing PMI with homeowners insurance. PMI is mortgage insurance; homeowners insurance is a separate expense. Removing PMI does not remove other insurance or escrow charges.
- Assuming an 80% LTV automatically ends PMI. The displayed threshold is not a guarantee. Contract terms and the servicer’s process determine whether and when a request can be approved.
- Entering total housing payments as principal and interest. Taxes, insurance, escrow, and PMI are not part of the payment used in this formula. The payment is calculated from principal, APR, and term.
- Ignoring payment changes or extra principal. Those affect the real balance. Use a current servicer balance where the standard schedule no longer represents the loan.
- Rounding inputs too early. Enter the stated APR and loan amount as accurately as possible. The formula rounds the monthly payment to cents, so results can differ slightly from systems that apply daily interest or different rounding.
Tips
- Compare the estimate with a recent mortgage statement; use the servicer’s principal balance for an official request.
- Ask whether the servicer uses the original value, a new valuation, or another method, and whether valuation costs or documents are required. Obtain any figures directly from the servicer.
- Keep notes of calls, copies of correspondence, and the date any request was submitted. Confirm any approved change on a statement.
- Recalculate with more than one plausible home value to see how sensitive the estimated LTV is. Treat each result as an estimate, not an eligibility decision.
Troubleshooting
The estimated balance differs from my statement: Check the APR, original principal, number of credited payments, and whether the loan has had extra payments, rate changes, or modifications. For an accurate current balance, ask the servicer for a payoff or principal-balance figure; payoff amounts may include accrued interest or other amounts the calculator omits.
The calculator says the LTV is below 80%, but PMI remains: A calculated ratio alone does not confirm eligibility. Ask the servicer for the exact cancellation requirements, valuation method, and any outstanding steps. Do not stop making scheduled payments unless the servicer confirms a change.
The LTV looks too high or low: Check that the home value is in dollars, not thousands, and that the balance and value refer to the same property and date. A lower value increases LTV; a higher value reduces it.
The loan has a variable rate or unusual payment schedule: This calculator assumes a fixed APR and monthly level payments. Request an up-to-date balance and applicable PMI process from the servicer instead of treating this estimate as exact.
Frequently Asked Questions
What does PMI payoff mean?
It commonly refers to paying down a mortgage enough to seek PMI cancellation, but the phrase can also mean getting a formal mortgage payoff amount. Ask the servicer which figure or process you need.
Does reaching 80% LTV automatically remove PMI?
No. The calculator’s 80% comparison is not an eligibility decision. Requirements and procedures depend on the loan; confirm them with the servicer.
Can I use an online home-value estimate?
You can use one for an informal estimate, but the servicer may require a particular valuation method or evidence. Ask what it accepts before relying on a value for a request.
Does this include taxes, homeowners insurance, or PMI?
No. It estimates principal and interest and the remaining principal balance. It does not calculate escrow, insurance charges, or an actual mortgage payoff quote.
What if I made extra principal payments?
The scheduled-payment estimate may overstate your balance. Use the current principal balance shown by the servicer, or obtain an updated amortization schedule, for a more relevant comparison.
This result is an estimate for educational use, and the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Original loan amount | $ | 200000 | 1 | 100000000 in apr | Interest rate (APR) | % | 6 | 0.01 | 100 in yrs | Loan term | years | 30 | 0.0833 | 50 in k | Monthly payments made | - | 60 | 0 | 600 in val | Current home value | $ | 250000 | 1 | 100000000 out bal | Estimated loan 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 eq | Estimated equity | $ | val - bal | 2 out ltv | Estimated loan-to-value ratio | % | 100 * bal / val | 2 out target | Balance at 80% of home value | $ | 0.8 * val | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Avalanche Game Schedule: Dates, Times and Where to Check
- Avalanche Hockey Schedule: Games, Dates and TV
- Avalanche Debt Payoff Tracker Calculator
- Avalanche Debt Repayment Calculator and Payoff Plan
- Avalanche Debt Payoff Calculator and Spreadsheet
- Avalanche Debt Payoff Calculator: Free Estimate