Blog · Finance metrics and formulas · Finance and FP&A teams
Prepare a documented business cash-flow bridge and repayment schedule for an SBA lender's coverage review. Follow the spreadsheet steps, reconcile the inputs, and compare a change in accepted adjustments.
SBA debt service coverage ratio compares accepted business cash flow with required principal and interest after the proposed financing. Prepare the numerator and repayment schedule separately, then reconcile both before calculating coverage. The applicable SBA program, delivery method, and lender determine which definitions and requirements apply.
This preparation example concerns a US business seeking a 7(a) term loan. SBA says 7(a) applicants must be creditworthy and demonstrate a reasonable ability to repay, and that most 7(a) term loans are repaid through monthly principal and interest payments from business cash flow. Applications go through participating lenders, with documentation varying by circumstances and processing method.
As of October 23, 2026, SBA's SOP 50 10 8.1 with Technical Updates is effective October 1, 2026. Its Standard 7(a) credit analysis requires business coverage of at least 1.15 on a historical and/or projected basis and global coverage of at least 1:1. It defines debt service as future required principal and interest on all business debt, including the new financing, and requires justification of cash-flow adjustments.
Those are specific underwriting provisions, not a universal approval rule for every SBA program or financing structure. Have the lender identify the applicable section, assessment periods, accepted adjustments, and any higher lender requirement before treating a worksheet as its underwriting calculation.
Bring the annual P&L, an interim P&L, the balance sheet, and a current debt schedule. Keep historical results and projections in separate columns. The general DSCR method explains the underlying ratio; this worksheet focuses on preparing support for lender review.
Your cash-flow bridge needs account names, reporting dates, signed amounts, and references to supporting entries. Your repayment file needs lender, obligation identifier, payment date, principal, interest, and whether the obligation remains after closing. Identify shareholder debt and any refinanced obligations for the lender to assess.
Use the same business perimeter throughout. A business-only worksheet does not replace a lender's global cash-flow assessment. Keep that assessment separate so additional entities or guarantor obligations do not disappear inside an unexplained total.
Consider an Ohio equipment-service company. The following annual figures are illustrative business preparation assumptions accepted for this example, not a universal SBA numerator. Historical interest is added back because the denominator separately captures the post-financing repayment schedule.
| Inputs worksheet row | Item | Signed amount (USD) |
|---|---|---|
| 2 | Income before income taxes | 190,000 |
| 3 | Interest expense included above | 45,000 |
| 4 | Depreciation and amortization included above | 55,000 |
| 5 | Documented nonrecurring expense adjustment | 10,000 |
| 6 | Unfunded capital expenditure deduction | -25,000 |
| 7 | Distribution deduction under stated assumptions | -35,000 |
| 8 | Business cash available for this worksheet | 240,000 |
The first three inputs produce EBITDA of $290,000. Adding the documented expense and deducting the two cash requirements gives $240,000. Every adjustment needs a reason: the ledger proves an expense occurred, while supporting documentation explains why treating it differently is appropriate.
Put the signed amounts in Inputs!B2:B7. In Inputs!B8, sum those signed spreadsheet inputs:
=SUM(B2:B7)
Keep the sign convention visible. A deduction entered as positive increases repayment capacity when it should reduce it. Also label this bridge distinctly from the statement of cash flows; cash debt coverage uses a different numerator and denominator.
For the next full annual repayment period, use the lender's proposed schedule and existing loan schedules. These amounts include no refinanced debt or payment holidays.
| Debt worksheet row | Obligation | Principal (USD) | Interest (USD) | Debt service (USD) |
|---|---|---|---|---|
| 2 | Existing equipment loan | 42,000 | 12,000 | 54,000 |
| 3 | Existing term loan | 30,000 | 18,000 | 48,000 |
| 4 | Proposed SBA loan | 60,000 | 30,000 | 90,000 |
| Total | All included obligations | 132,000 | 60,000 | 192,000 |
Put principal in column B and interest in column C. In Debt!D2, enter and fill down:
=B2+C2
Historical interest expense was $45,000; scheduled future interest is $60,000. Those amounts need not match because the second reflects a different period and the proposed borrowing. Explain that bridge instead of forcing the figures to agree.
This denominator includes principal. The comparison of DSCR and interest coverage explains why an interest-only test answers a narrower question.
Business coverage under stated assumptions = Accepted business cash available / Required annual principal and interest
Using the worksheet locations above:
=IF(SUM(Debt!D2:D4)>0,Inputs!B8/SUM(Debt!D2:D4),NA())
Coverage is $240,000 / $192,000 = 1.25 times. Display ratios to two decimals and retain unrounded calculations. A zero denominator requires investigation rather than a displayed zero ratio.
The proof has two parts. Principal of $132,000 plus interest of $60,000 must equal scheduled service of $192,000. Then 1.25 × $192,000 must recover the $240,000 numerator. Reconcile each debt subtotal to its repayment schedule and every bridge input to its source statement or documented adjustment.
If the lender rejects the $10,000 expense adjustment, cash available becomes $230,000 and coverage becomes 1.20 times, rounded from $230,000 / $192,000. Nothing in the payment schedule changed. This variation isolates the consequence of accepting that adjustment.
Upload your P&L, documented cash-flow bridge, and repayment schedule; Covirage maps the columns, and its tools compute and check coverage under your supplied assumptions. The external AI model explains the result with every figure traced to its rows, giving you a reconciled comparison to discuss with the lender. Create a free Covirage account and bring a sample of your own export.
See Covirage for finance teams for the same approach to your reporting files.
No. Coverage addresses repayment capacity within a broader credit review. Eligibility, creditworthiness, the financing structure, supporting evidence, and other applicable requirements still matter. A lender can also apply its own credit standards beyond a program's minimum requirements.
The repayment analysis should reflect the business after the proposed financing. Include the proposed payment schedule alongside remaining existing obligations, and document debt being refinanced so its old and replacement payments are not both counted for the same period.
An expense needs evidence and acceptance under the lender's analysis. Identify its ledger entries, explain why it will not recur, and show a separate calculation without it. An expense being unusual does not automatically make it an acceptable cash-flow adjustment.