What is Loan-to-Value Calculator?
Loan-to-value ratio compares what you owe on a property with what it is worth: the loan balance divided by the value, expressed as a percentage. On a 400,000 home with a 320,000 balance the LTV is exactly 80.000%, and the 80,000 difference is your equity — 20% of the asset. Lenders read the number as risk: the higher the share of the asset financed, the more of a cushion a default would have to eat through before they recover. That is why LTV sets your mortgage-insurance obligation, your pricing tier and, in many cases, whether the loan is approved at all. This calculator runs three related views. The LTV mode solves a single lien and adds a goal solver — the largest loan that still lands on your target ratio, the down payment that gets you there, and the gap if you are over. The CLTV mode stacks the first mortgage with up to two junior liens, the combined picture behind every home equity decision. The PMI mode takes the origination ratio and lays out the exact months mortgage insurance starts and stops under US conventional rules.
When to Use This Calculator
- When you are deciding between a 5%, 10% and 20% down payment and want the mortgage-insurance consequence of each spelled out.
- Before signing a HELOC or second-mortgage offer, to see the combined ratio the package will carry.
- When your servicer's escrow analysis mentions PMI and you want an independent month when it should stop.
- While shopping refinance quotes, to know your maximum new loan before a lender names their number.
- If home prices in your area have fallen and you suspect the LTV drifted above a threshold.
- When you are planning a sale or a cash-out and need the equity share you would actually realise.
Steps:
- Enter the property value the lender will appraise — every threshold in the calculator is measured against this original number.
- In LTV mode enter the single loan balance; the ratio, equity and equity share update together.
- Set the target LTV — 80% is the conventional PMI line — to see the largest loan the target allows and the gap you still need to close.
- Switch to CLTV mode to add the first lien with its rate and term, then stack a HELOC or second mortgage as the junior lien.
- Read first-lien LTV and CLTV side by side: the first lien can sit at 70% while the package is already at 85%.
- Open the PMI tab, add the note rate, the term in months and the annual PMI premium you were quoted.
- The schedule shows the request floor month — when the balance first touches 80% of the original value — and the automatic cut-off month at 78%.
- Compare the two premium totals, then use the sensitivity grid to see how a different rate or appraised value moves the cut-off.
Formula
LTV = (Loan ÷ Value) × 100
CLTV = (First lien + Junior liens) × 100 ÷ Value
Equity = Value − Total debt
Payment: M = P × i ÷ (1 − (1 + i)^−n), where i = annual rate ÷ 12 and n = months
Balance after m months: B(m) = P × (1 + i)^m − M × ((1 + i)^m − 1) ÷ i
Monthly PMI = Opening balance × annual premium ÷ 12
Automatic cut-off: first month with B(m) ≤ 0.78 × original value
Request floor: first month with B(m) ≤ 0.80 × original value
Use Cases
- You are comparing two purchase offers and want to know which down payment clears mortgage insurance fastest.
- A lender quoted a HELOC and you need the combined LTV before deciding whether to draw on it.
- You hit 80% LTV and want the exact month to send a cancellation request rather than waiting for the servicer.
- A cash-out refinance quote is on the table and you need the LTV ceiling for your loan type before calling back.
- Home prices dipped and you want to see how close the balance is to the 78% automatic cut-off at the original value.
- You are planning a sale in three years and need the equity share you would actually walk away with.
Key Benefits
- Three purpose-built modes — single lien, stacked liens and the PMI schedule — instead of one ratio box with missing context.
- The exact request-floor and automatic cut-off months, not a vague 'roughly eight years' answer, so you know when to act.
- A goal solver that answers the reverse question: the largest loan your target ratio allows and the gap you must close to get there.
- Per-lien payments and shares in the CLTV table, so you can see which balance is actually driving the combined ratio.
- Sensitivity grids that re-run the whole schedule across appraised values, loan sizes and note rates without touching the inputs.
- Full export, print report and step-by-step arithmetic — every displayed figure can be traced back to a formula on the page.
Pro Tips
- Diarise the month you cross 80% and send the cancellation request then — waiting for the automatic 78% cut-off costs about 1,843.65 on the default example.
- One extra principal payment early in the schedule pulls month 112 forward: the cut-off depends on balance, not on the calendar date.
- Twenty percent down still beats everything else — it starts you at 80% and no mortgage insurance is ever charged.
- Run CLTV before opening a HELOC. The combined ratio is what governs the line, not the first mortgage in isolation.
- Use the target-LTV solver before calling a refinance lender, so you already know the maximum new loan your equity supports.
- The 0.5% premium default is a best-case quote. A lower credit score can double it — plug your real number into the premium field.
Common Mistakes to Avoid
- Measuring the 78% cut-off against today's market value. The law uses the ORIGINAL value at origination, so a rising price does not end PMI sooner.
- Checking only the first lien. Lenders qualify on CLTV, so a clean 70% first mortgage plus a drawn HELOC can still sit above the line.
- Treating 80% as the automatic end date. 80% is the point where you may REQUEST removal; the automatic end is 78% on the original amortisation.
- Applying conventional logic to FHA. FHA premiums run 11 years with at least 10% down and for the life of the loan below that.
- Comparing loans by the monthly payment alone. Two quotes with the same payment can sit several LTV points apart once fees and junior liens are stacked.
- Forgetting the premium inside the payment. A 150.00 first-month PMI is real money and should sit next to principal and interest when you budget.
Key Terms Explained
- Loan-to-value ratio:
- loan balance divided by property value, times 100. The single number that drives mortgage-insurance obligations and pricing tiers.
- Combined LTV (CLTV):
- every secured balance — first lien plus juniors — divided by the value. What lenders actually qualify on for HELOCs and cash-out loans.
- Private mortgage insurance:
- monthly insurance protecting the lender, not you, required on new conventional loans above 80% LTV.
- Equity:
- value minus total debt. Shown here in both currency and as a share of the value so a price dip can be judged instantly.
- Homeowners Protection Act:
- the federal law behind the 78% automatic termination and the 80% borrower-request right on conventional loans.
- Request floor:
- the first month the balance sits at or below 80% of the original value — the earliest point a cancellation request can take effect.
- Automatic cut-off:
- the first month the balance sits at or below 78% of the original value, when PMI ends without any request.
- Amortisation schedule:
- the fixed month-by-month balance path the cut-offs are measured on; a shorter term or extra principal moves both earlier.
Related Concepts
- Mortgage Calculator: run the full amortisation for any rate you are quoted and see the principal and interest split month by month.
- Home Affordability Calculator – How Much House: work backwards from income and debts to the purchase price your LTV should start from.
- DSCR Calculator: the investor-side ratio lenders pair with LTV when the property is a rental rather than a residence.
- Cap Rate Calculator: net operating income against price — the yield view that sits beside the financing view of the same deal.
- Closing Cost Calculator: the prepaid fees and escrow items that stack on top of the down payment at settlement.
- Debt-to-Income Ratio Calculator: the other underwriting ratio — monthly obligations against gross income — that decides approval alongside LTV.
Example
Start from the Standard preset: a 400,000 property with a 320,000 loan gives LTV = 320,000 ÷ 400,000 × 100 = 80.000% and equity of 80,000, exactly 20% of the value. The target solver confirms the same numbers the other way around: at an 80% target the largest loan is 400,000 × 0.80 = 320,000, so the gap over target is zero. Now switch to the PMI preset: 400,000 with 360,000 borrowed is 90% LTV, equity drops to 40,000, and mortgage insurance is required. At a 0.5% annual premium the first month costs 360,000 × 0.005 ÷ 12 = 150.00. Following the amortisation schedule at 6.75% over 360 months, the balance first touches the 80% request floor of 320,000 at month 98 with a balance of 319,623.85, and the 78% automatic line of 312,000 at month 112 with a balance of 311,823.69 — an LTV of 77.96%. Total premium to the automatic cut-off is 15,802.85, against 13,959.20 if the servicer stops it at your 80% request: asking at 98 instead of waiting for 112 keeps 1,843.65 in your pocket. In the HELOC preset the first lien of 280,000 is 70% LTV on its own, the 60,000 junior adds 15 points, and the package lands at 85% CLTV with 60,000 of equity.
Interpreting Your Results
Read the page in this order. Start with the hero: the headline ratio is colour-coded — green at or below 80%, blue through the PMI band, amber above 97%, red past 100%. The four cards under it give the currency equity, the equity share, and in goal mode the maximum loan and remaining gap. The breakdown block restates every input against every output, so a wrong field is visible immediately. In CLTV mode the lien table shows which balance drives the combined ratio; in PMI mode the yearly schedule shows the balance, equity and running premium, with the year the cut-off lands highlighted in green. The sensitivity grid answers 'what if' without disturbing your inputs, and the step-by-step section shows the arithmetic behind every figure. Treat the amber advisory box as a decision prompt, not an error — it appears whenever the ratio crosses a policy line.

