LTV calculator for commercial real estate
An LTV calculator divides credit extended by the market value of the real estate securing or being improved by that credit, and expresses the result as a percent. Interagency real estate lending guidelines treat LTV as a core underwriting and portfolio limit. Senior liens on the same collateral are included when the ratio is calculated, per interagency guidance. OCC CRE guidance expects internal LTV limits that do not exceed supervisory loan-to-value ceilings and that reflect cash-flow and value volatility of the property type.
LTV calculator formula
LTV = extension of credit / property value × 100
Value is the appraisal premise used for the credit decision: as-is, as-complete or as-stabilised. Senior liens on the same collateral are included in determining the ratio. Cross-collateralised pools size maximum loan amount as the sum of each property's value, less senior liens, multiplied by the applicable LTV limit for that property. When mortgage insurance or other credit enhancement used in the LTV calculation is later released or replaced, the ratio requires recalculation.
Inputs
- Proposed loan amount (or outstanding balance for a current LTV restatement)
- Senior liens on the same collateral
- Appraised value under the premise used in the credit paper
- Property type / phase (raw land, land development, construction, improved property)
- Credit enhancement counted in the LTV calculation, if any
- Readily marketable collateral added to the value base where policy permits
For construction loan and development facilities, desks often run LTV beside LTC, because cost is observable while as-complete value remains prospective.
Worked numerical example
Illustrative acquisition of improved income-producing property:
- Proposed senior loan: 68.0 million
- Existing senior lien: none
- Appraised as-is market value: 100.0 million
LTV = 68.0 / 100.0 × 100 = 68.0%
If a mezzanine or second mortgage of 12.0 million sits ahead for combined-leverage reporting (or is treated as a senior lien on the same collateral for the desk's combined test), combined exposure = 80.0 million and combined LTV = 80.0%. The senior-only LTV remains 68.0% when the calculator is scoped to the first mortgage alone. Credit papers must state which lien stack the LTV covers.
Supervisory context under the Interagency Guidelines (internal limits should not exceed):
- raw land: 65 percent
- land development: 75 percent
- commercial, multifamily and other nonresidential construction: 80 percent
- improved property: 85 percent
Those ceilings are supervisory reference points in US interagency guidance, not automatic bank policy for every jurisdiction. The European Systemic Risk Board monitors LTV at origination and current LTV for CRE stocks and flows, and treats loan-to-cost as the substitute indicator for property under development where market value is not yet the binding measure.
Interpretation limits
LTV is a collateral-value test. It does not measure cash-flow coverage. A loan can clear LTV and still fail DSCR, debt yield or interest coverage when net operating income is thin. Rising capitalisation rates can lift LTV even when NOI is unchanged, so value stress and coverage stress belong together.
Appraisal premise error is a common source of calculator distortion: an as-stabilised value applied to an as-is advance overstates headroom, an omitted senior lien understates leverage, and unsupported soft costs recorded inside value rather than inside LTC's cost base blend two different metrics.
Aggregate loans above supervisory LTV limits face capital-relative caps in the same US interagency framework, and a single-asset calculator does not apply those portfolio caps.