Formula
New annual debt service = 12 × [Requested loan × r ÷ (1 − (1 + r)^−Proposed term)], where r = Proposed rate ÷ 12.
DSCR after new loan = Annual EBITDA ÷ (Existing annual debt service + New annual debt service); passes when DSCR ≥ Policy minimum DSCR.
Leverage after loan = (Total liabilities + Requested loan) ÷ Owner equity; passes when ≤ Policy maximum debt-to-equity. Current ratio = Current assets ÷ Current liabilities; passes at 1.0 or above.
Time in business passes at 2 years or more and Guarantor credit score passes at 660 or more. Zero failures = Pass, one failure = Refer, two or more = Decline.
Maximum loan at policy DSCR = [(Annual EBITDA ÷ Policy minimum DSCR − Existing annual debt service) ÷ 12] × (1 − (1 + r)^−Proposed term) ÷ r.
Worked examples
Example 1: the default file passes all five tests
Inputs: Annual EBITDA $150,000, Existing annual debt service $40,000, Requested loan $200,000 at a Proposed rate of 11% over 48 months, Total liabilities $220,000, Owner equity $180,000, Current assets $160,000, Current liabilities $110,000, 4 Years in business, Guarantor credit score 690, Policy minimum DSCR 1.25, Policy maximum debt-to-equity 3. Step 1, the new payment: r = 0.11 ÷ 12 = 0.009167; payment = 200,000 × 0.009167 ÷ (1 − 1.009167^−48) = $5,169.10, so new annual debt service = $62,029. Step 2, coverage: 150,000 ÷ (40,000 + 62,029) = 150,000 ÷ 102,029 = 1.47, above 1.25. Step 3, leverage: (220,000 + 200,000) ÷ 180,000 = 2.33, below 3. Step 4, liquidity: 160,000 ÷ 110,000 = 1.45, above 1.0. Steps 5 and 6: 4 years beats the 2-year floor and 690 beats 660. Zero failures, so the decision is Pass and the binding constraint reads None. Maximum loan: 150,000 ÷ 1.25 = 120,000; less 40,000 = $80,000 of annual capacity, or $6,666.67 a month; multiplied by the annuity factor (1 − 1.009167^−48) ÷ 0.009167 = 38.69 gives $257,943.
Example 2: a young, thin file fails every test
Inputs: EBITDA $90,000, existing debt service $30,000, request $150,000 at 13% over 36 months, liabilities $300,000, equity $90,000, current assets $70,000, current liabilities $80,000, 1.5 years in business, credit 640, policy 1.25 and 3. Payment: r = 0.010833; 150,000 × 0.010833 ÷ (1 − 1.010833^−36) = $5,054.09, or $60,649 a year. DSCR = 90,000 ÷ (30,000 + 60,649) = 90,000 ÷ 90,649 = 0.99, below 1.25. Leverage = (300,000 + 150,000) ÷ 90,000 = 5.0, above 3. Current ratio = 70,000 ÷ 80,000 = 0.88, below 1.0. Tenure 1.5 years is under 2 and credit 640 is under 660. Five failures produce a Decline, and the binding constraint is the first failure in list order, Debt service coverage. The cash flow would support at most (90,000 ÷ 1.25 − 30,000) = $42,000 a year, or $3,500 a month, times the 36-month annuity factor of 29.68, which is $103,876. The honest counter-offer is roughly two thirds of the request, and only if the other four exceptions can be mitigated.
Example 3: one exception produces a refer
Inputs: EBITDA $200,000, existing debt service $60,000, request $300,000 at 10% over 60 months, liabilities $400,000, equity $500,000, current assets $250,000, current liabilities $150,000, 7 years in business, credit 650, default policy thresholds. Payment: r = 0.008333; 300,000 × 0.008333 ÷ (1 − 1.008333^−60) = $6,374.11, or $76,489 a year. DSCR = 200,000 ÷ (60,000 + 76,489) = 200,000 ÷ 136,489 = 1.47, a pass. Leverage = 700,000 ÷ 500,000 = 1.4, a pass. Current ratio = 250,000 ÷ 150,000 = 1.67, a pass. Seven years passes. Credit 650 is 10 points under 660 and fails. One failure yields Refer with Guarantor credit as the binding constraint. Maximum loan = (200,000 ÷ 1.25 − 60,000) ÷ 12 = $8,333.33 a month × 47.07 = $392,211, so the cash flow has room above the request. A credit committee would typically approve this with a mitigant: a second guarantor, a blanket lien, or a modest rate premium for the score.