Formula
LTV of proposed loan alone = Proposed loan ÷ Appraised collateral value. Combined LTV = (Proposed loan + Existing senior liens) ÷ Appraised collateral value.
Advance rate by Collateral type: commercial real estate 100% of appraisal, equipment 80% (of orderly liquidation value), inventory 50%, accounts receivable 85%. Lendable value = Appraised collateral value × advance rate.
Maximum loan at policy LTV = max(0, Lendable value × Policy maximum LTV − Existing senior liens).
Equity cushion after loan = Appraised collateral value − Existing senior liens − Proposed loan. Combined LTV passes when it is at or below Policy maximum LTV.
Worked examples
Example 1: default inputs, a second lien on commercial property
Inputs: Appraised collateral value $800,000, Existing senior liens $350,000, Proposed loan $200,000, Policy maximum LTV 75%, Collateral type commercial real estate. The advance rate for real estate is 100 percent, so lendable value = 800,000 × 1.00 = $800,000. LTV of the proposed loan alone = 200,000 ÷ 800,000 = 25.0%. Combined LTV = (200,000 + 350,000) ÷ 800,000 = 550,000 ÷ 800,000 = 68.8%, which is at or below the 75 percent policy and therefore shown in green. Maximum loan at policy LTV = 800,000 × 0.75 − 350,000 = 600,000 − 350,000 = $250,000, so the request of $200,000 leaves $50,000 of unused capacity. Equity cushion after loan = 800,000 − 350,000 − 200,000 = $250,000, meaning the property could sell for 31 percent less than appraisal before the combined debt is impaired, and for 56 percent less before the senior lender is. That last point is the one the second-lien lender should dwell on: in a forced sale the senior lien is paid first, and the $250,000 cushion is all that stands between the junior loan and a loss.
Example 2: equipment at orderly liquidation value
Inputs: appraised value $500,000, senior liens $0, proposed loan $300,000, policy LTV 80%, collateral type equipment. The equipment advance rate is 80 percent, so lendable value = 500,000 × 0.80 = $400,000. LTV of the loan alone = 300,000 ÷ 500,000 = 60.0%, and with no senior liens combined LTV is the same 60.0%, which passes against 80 percent. Maximum loan at policy LTV = 400,000 × 0.80 − 0 = $320,000. Equity cushion = 500,000 − 0 − 300,000 = $200,000. The two-stage haircut is the point of this example: the appraisal is first discounted to $400,000 for how equipment sells in an orderly liquidation, and the policy LTV is then applied to that figure, so the effective maximum is 64 percent of appraisal even though the policy says 80. A lender that applied 80 percent to the $500,000 appraisal would lend $400,000 against collateral likely to realize $400,000 before costs of sale, leaving no cushion at all.
Example 3: a receivables facility
Inputs: eligible receivables $1,200,000, senior liens $0, proposed loan $500,000, policy LTV 85%, collateral type accounts receivable. The receivables advance rate is 85 percent: lendable value = 1,200,000 × 0.85 = $1,020,000. LTV alone and combined = 500,000 ÷ 1,200,000 = 41.7%. Maximum loan at policy LTV = 1,020,000 × 0.85 = $867,000. Equity cushion = 1,200,000 − 500,000 = $700,000. Receivables are advanced at high rates because they convert to cash on their own schedule, but the 85 percent policy applied on top of the 85 percent advance rate gives an effective 72 percent of face, which is in the range asset-based lenders use for eligible receivables after excluding past-due, concentrated and related-party invoices. The $1,200,000 entered must already be the eligible pool; the tool does not perform the aging and concentration exclusions that an asset-based lender's borrowing base certificate would.