Free workbook
The package a bank
says yes to.
Banks say no slowly and expensively when the file arrives incomplete. This workbook assembles what a credit committee actually reads: the debt schedule in lender format, a covenant certificate with honest headroom, a sources-and-uses that balances to the dollar, and the checklist with the freshness rules underwriters apply.
What's inside
- A creditor-level debt schedule with totals, weighted average rate, and annual debt service, the format lenders read first
- A covenant compliance certificate: net leverage and fixed-charge coverage with headroom math and a PASS, WATCH, or FAIL read before the bank does it for you
- A sources-and-uses of funds where the check cell stays red until both sides balance
- The 18-item document checklist with the rules that trip first-time borrowers: three years of filed returns, interims dated within 60 days, personal financial statements for every owner at 20% or more
- No macros, no lock-in. Opens in Excel and imports cleanly into Google Sheets
Get the workbook
We only use this to send the workbook and occasional operator notes. Unsubscribe anytime.
Done. Your download is ready:
Download the workbook (Excel)How to use it
- Build the debt schedule from your loan statements, one row per facility. The weighted average rate is your negotiating baseline: if new money prices below it, lead with that.
- Enter TTM figures and your covenant levels on the compliance certificate. WATCH means under 15% headroom; arrive with the explanation, not the surprise.
- Lay out the sources and uses until the check cell turns green. A package that does not balance does not leave the analyst's desk.
- Work the checklist top to bottom. Interims within 60 days and the 20%-owner rules are the two that stall most applications.
The covenant math continues in the covenant headroom tracker, and the projections a lender wants come from the annual operating plan. If the meeting matters, start a conversation and walk in with the package defended.