Business Debt Schedule: How to Build One Underwriters Can Use

01

Why the Debt Schedule Matters in Commercial Underwriting

Financial statements show total debt, but they often do not reveal the payment structure behind it. A debt schedule connects each balance with its lender, purpose, interest rate, required payment, maturity, collateral, and guarantors. That detail helps an underwriter identify fixed versus floating exposure, balloon payments, overlapping liens, short maturities, and obligations that may not be obvious from a single reporting period. It also creates the base for calculating historical and proposed debt service.

02

Include the Fields a Reviewer Actually Needs

For every term loan, line of credit, mortgage, equipment note, vehicle loan, capital lease, seller note, shareholder loan, and other material obligation, list the borrower entity, lender, loan purpose, original amount, origination date, current balance and balance date, interest rate and benchmark, monthly payment, amortization term, maturity date, collateral, lien position, guarantors, and any balloon amount. For revolving facilities, also state the commitment, current availability, renewal date, and whether a borrowing base limits access. Do not include full account numbers or other unnecessary sensitive information.

• Requested amount and use of proceeds
• Historical and current financial statements
• Complete debt and ownership schedules
• Collateral and transaction documentation

03

Reconcile the Schedule to Current Records

The total principal on the schedule should reconcile to the corresponding debt accounts on the most recent balance sheet. Compare balances with lender statements and identify accrued interest, unamortized fees, current portions of long-term debt, and intercompany obligations that cause differences. The payment should agree with the latest statement or amortization schedule. If the financial statements combine several obligations in one account, add a reconciliation note instead of forcing the schedule to match by omission.

04

Separate Amortization, Maturity, and Payment Structure

A 20-year amortization with a five-year maturity is not a 20-year loan commitment. Record both dates so the lender can see the balloon risk. Identify interest-only periods, variable-rate resets, minimum rate floors, seasonal payment arrangements, and payment changes that have not yet begun. If a loan is currently deferred, modified, or under a temporary payment agreement, disclose the contractual payment, current treatment, and date normal payments resume.

05

Show Collateral, Liens, and Guarantees Clearly

A lender evaluating new collateral must understand what is already pledged. Describe real estate, equipment, receivables, inventory, deposit accounts, vehicles, or blanket business assets securing each obligation, and note known lien positions. List guarantees by person or entity and distinguish limited guarantees or carve-outs when supported by the documents. If collateral is cross-collateralized or several loans are cross-defaulted, explain the relationship in a short note and provide the governing documents when requested.

06

Capture Contingent and Off-Balance-Sheet Exposure

A complete review may include loans guaranteed for related companies, pending equipment commitments, operating leases, letters of credit, merchant cash advances, factoring obligations, seller earnouts, and litigation or tax-payment agreements when relevant. These items do not always receive identical accounting or underwriting treatment, but excluding them can undermine confidence in the entire file. Label contingent obligations separately and explain the primary repayment source and current status.

07

Use the Schedule to Test the New Request

Once the existing obligations are verified, calculate annual debt service and add the proposed loan under realistic rate, amortization, and payment assumptions. Model upcoming maturities, line renewals, balloon payments, and floating-rate changes rather than assuming every facility continues unchanged. The schedule should make it easy to identify which debts will be refinanced, paid off, subordinated, or remain in place after closing.

08

Run a Final Quality-Control Review

Date the schedule, identify the preparer, use consistent entity names, and mark estimates clearly. Check that every lender statement, balance-sheet account, UCC lien, and property mortgage has a corresponding line or explanation. Remove duplicate obligations and explain recent payoffs that still appear in older records. PFCS can help organize the schedule and coordinate a financing request with third-party capital sources, but each lender determines required documentation, adjustments, collateral treatment, approval, pricing, and final terms.