What loan-to-value measures
Loan-to-value, or LTV, compares a modeled loan principal with one selected property value:
LTV = loan amount ÷ selected property value
The result is expressed as a percentage. A $300,000 loan divided by a $400,000 selected property value produces 75.00% LTV.
The Office of the Comptroller of the Currency's Commercial Real Estate Lending handbook uses the same loan-to-market-value relationship for commercial real-estate lending. The Consumer Financial Protection Bureau's LTV explanation likewise describes LTV as a comparison between the amount financed and property value.
LTV is a leverage measure, not a complete loan decision. DealYield does not appraise the property, verify the debt, select a lender's value, quote financing, or decide whether a borrower or property qualifies.
Select the value basis before reading the percentage
Version 1 keeps three value inputs distinct and requires one explicit denominator:
- Purchase price is the entered contractual or historical acquisition price.
- Current market value is a user-supplied estimate for the property's present condition and valuation date.
- After-repair value (ARV) is a projected value contingent on planned work, completion, future property condition, and market evidence.
Only the selected value enters the formula. The other two values can remain visible for scenario context, but they do not get blended, averaged, or silently substituted.
That selection is a modeling choice, not a conclusion about what a lender will accept. For example, Fannie Mae's current first-mortgage LTV guidance uses the lower of sales price and current appraised value for its covered purchase transactions, while refinance and certain special transactions use different rules. Commercial, renovation, private, and portfolio lenders may define value and debt scope differently. Confirm the convention for the actual analysis.
Forward, target, and equity formulas
The Loan-to-Value Calculator answers related arithmetic questions from the same selected value:
LTV = loan amount ÷ selected property valueMaximum loan at target = selected property value × maximum LTVCurrent modeled equity = selected property value − loan amountMinimum modeled equity at target = selected property value − maximum loan at targetRemaining loan capacity = max(maximum loan at target − loan amount, 0)Additional reduction or equity required = max(loan amount − maximum loan at target, 0)
The maximum-LTV input is editable from 0% through 100%. It is a comparison assumption, not a DealYield recommendation or a universal lender ceiling.
Money inputs use USD cents and the target uses whole basis-point precision. Formula version loan-to-value@1.0.0 calculates the ratio with high-precision decimal arithmetic, rounds money outputs half-up to cents, and compares the entered loan with the target maximum at displayed cent precision. The interface displays LTV as a percentage to two decimal places.
Worked purchase-price example
Consider these entered values:
- Purchase price: $400,000
- Current market value: $425,000
- After-repair value: $500,000
- Modeled first-lien loan: $300,000
- Editable maximum LTV: 80.00%
- Selected basis: Purchase price
Because purchase price is selected, the other values do not affect this result:
- LTV:
$300,000 ÷ $400,000 = 75.00% - Maximum loan at 80%:
$400,000 × 80.00% = $320,000 - Current modeled equity:
$400,000 − $300,000 = $100,000 - Minimum modeled equity at target:
$400,000 − $320,000 = $80,000 - Remaining loan capacity:
$320,000 − $300,000 = $20,000 - Additional reduction or equity required: $0
Selecting current market value instead would produce approximately 70.59% LTV. Selecting ARV would produce 60.00% LTV. Those percentages answer different value-basis questions; the lowest-looking result is not automatically the correct underwriting result.
Equity, down payment, and sale proceeds are not interchangeable
The calculator's equity output is the arithmetic difference between the selected value and the modeled loan. It can help explain the denominator, but it is not a verified balance-sheet asset or an estimate of cash received in a sale.
In a simplified purchase where price is the selected value, there is one loan, and no costs or credits are financed, purchase price − loan amount may resemble a down payment. Real transactions can also include earnest money, seller credits, closing costs, repairs, financed fees, subordinate debt, and other cash sources. Use Cash-on-Cash Return for total upfront cash and Mortgage Payment for modeled payments and financing fees.
Sale proceeds require payoff balances, selling costs, taxes, and transaction timing that LTV does not model. Negative arithmetic equity means the selected loan exceeds the selected value; it does not calculate the cash required to close or exit.
First-lien LTV, combined LTV, and loan-to-cost
DealYield version 1 accepts one modeled first-lien principal. It does not add a second mortgage, line of credit, or other senior lien. If the actual analysis uses total secured debt, combined LTV or another lender-defined ratio may differ.
LTV also differs from loan-to-cost (LTC):
LTV = loan amount ÷ selected property valueLTC = loan amount ÷ total project or property cost
The OCC handbook distinguishes market value from acquisition and construction cost in these ratios. A renovation can have purchase cost, rehab cost, and ARV that move independently. This calculator does not infer costs from ARV and does not calculate LTC. Use the House Flip Calculator to separate acquisition, renovation, carrying, financing, and selling assumptions.
Compare leverage with payment and income measures
LTV does not use interest rate, amortization, payment, rent, expenses, or NOI. Related measures answer different questions:
- Mortgage payment translates principal, rate, and term into scheduled payments.
- DSCR compares NOI with annual debt service.
- Debt Yield compares NOI with loan principal.
- Maximum Loan Amount places LTV, Debt Yield, and DSCR limits side by side and reports the binding modeled constraint.
Use the DSCR Calculator, Debt Yield Calculator, and Maximum Loan Amount Calculator when property income or payment capacity matters. A loan can be below an LTV target and still fail another requirement.
Zero, above-target, and negative-equity states
- The selected property value must be positive because it is the denominator.
- The modeled loan may be $0, producing 0.00% LTV and equity equal to the selected value.
- A 0% target is valid. Any positive loan is above that target, while the modeled maximum loan is $0.
- If the loan exceeds the selected value, LTV is above 100% and arithmetic equity is negative.
- If the loan exceeds the target maximum, the calculator shows the additional principal reduction or equity required to meet the selected target.
- Non-finite values, fractions of a cent, unsupported target precision, and unknown fields are invalid rather than rounded silently.
Every valid result also includes a deterministic warning about the selected value basis. Current value needs dated support, ARV is projected, and purchase price may not be the value a lender uses.
Stress-test the selected value
The sensitivity table reruns loan-to-value@1.0.0 with the selected property value moved by −10%, −5%, 0%, +5%, and +10%. The modeled loan, target, basis, and unselected values stay fixed.
Each row recalculates LTV, maximum modeled loan, current equity, target status, remaining capacity, and any additional reduction or equity required. This makes valuation dependence visible: a lower selected value raises LTV and can move the loan above target.
The rows are arithmetic scenarios, not appraisals, forecasts, confidence intervals, or probabilities. Evidence for a different value should come from appropriate market data and, when required, a qualified valuation process.
Reviewing an LTV scenario
- Identify the transaction and the value convention required for the analysis.
- Record the value source, date, property condition, and whether it is as-is or projected.
- Confirm which loan or liens belong in the numerator.
- Keep the maximum-LTV source visible and editable.
- Review lower-value sensitivity instead of relying on one estimate.
- Compare leverage with payment, DSCR, Debt Yield, costs, reserves, and borrower requirements.
- Reconcile the result with the lender's actual underwriting and appraisal documentation.
LTV is an educational leverage estimate. It is not an appraisal, loan offer, qualification, approval, pricing result, or lending, financial, investment, legal, or tax advice.