Formula
Maximum new monthly payment = (monthly cash available for debt payments ÷ target coverage ratio) − existing monthly debt payments, floored at zero.
Loan you can afford = maximum new payment × (1 − (1 + r)^−n) ÷ r, where r = expected interest rate ÷ 12 and n = term in years × 12. If the rate is zero, it is simply the payment × n.
Coverage after the new loan = monthly cash available ÷ (existing payments + maximum new payment). By construction this equals the target ratio whenever the new payment is above zero.
Total interest over the term = maximum new payment × n − loan you can afford.
Worked examples
Example 1: $6,000 of monthly cash, $1,500 of existing payments, 1.25 coverage, 12 percent, 5 years (the defaults)
Step 1: cash available ÷ target coverage = $6,000 ÷ 1.25 = $4,800. That is the most total debt service the cash flow supports at a 1.25 cushion. Step 2: subtract existing payments: $4,800 − $1,500 = $3,300 maximum new monthly payment. Step 3: convert to a loan amount. r = 0.12 ÷ 12 = 0.01; n = 60. (1.01)^−60 = 0.5504; 1 − 0.5504 = 0.4496; $3,300 × 0.4496 = $1,483.50; $1,483.50 ÷ 0.01 = $148,352. Step 4: coverage after the loan = $6,000 ÷ ($1,500 + $3,300) = $6,000 ÷ $4,800 = 1.25x, matching the target. Step 5: total interest = $3,300 × 60 − $148,352 = $198,000 − $148,352 = $49,648. The tool shows $148,352, $3,300.00, 1.25x and $49,648. A lender using the same inputs and the same 1.25 ratio would land on roughly the same ceiling, which is the point of the exercise.
Example 2: a stronger business with a longer term and a stricter lender
Inputs: $12,000 monthly cash, $4,000 existing payments, target coverage 1.35, 9 percent, 10 years. Step 1: $12,000 ÷ 1.35 = $8,888.89. Step 2: $8,888.89 − $4,000 = $4,888.89 maximum new payment. Step 3: r = 0.0075; n = 120; (1.0075)^−120 = 0.4079; 1 − 0.4079 = 0.5921; $4,888.89 × 0.5921 = $2,894.53; ÷ 0.0075 = $385,937. Coverage after = $12,000 ÷ $8,888.89 = 1.35x. Total interest = $4,888.89 × 120 − $385,937 = $586,667 − $385,937 = $200,730. The ten-year term is what makes $385,937 possible; at five years the same $4,888.89 payment supports only about $235,500. Terms that long are mainly available through SBA 7(a) loans for working capital and equipment, which is why the affordable amount and the product are decided together.
Example 3: when the answer is zero
Inputs: $3,000 monthly cash, $2,500 existing payments, 1.25 coverage, 12 percent, 3 years. Step 1: $3,000 ÷ 1.25 = $2,400. Step 2: $2,400 − $2,500 = −$100, floored at $0. Loan you can afford: $0. Coverage after = $3,000 ÷ $2,500 = 1.2x, which is the coverage the business already has on its existing debt, below the 1.25 target. The tool shows a warning: existing payments already use the cash flow available at this ratio. This is not a quirk of the calculator; it is the answer a bank underwriter would give. The routes out are to raise cash flow, reduce existing payments by refinancing or consolidating (the refinance calculator and debt consolidation calculator model both), or to use a product that does not depend on coverage, such as factoring secured by specific invoices.