What a Debt Schedule Is and Why Every Business Owner Should Have One

Most business owners cannot list every debt their business carries without looking it up. A debt schedule fixes that and it is one of the most useful documents you can build. Here is what it is and how to make one.

Table of Contents

Want Some Help?

Let PGS bring our years of expertise to help your business.

 

I am going to ask you a question and I want you to answer it honestly, even if the answer is just in your own head.

Right now, without looking anything up, can you tell me every debt your business is carrying, the current balance on each one, the monthly payment, the interest rate, and when each one matures?

Most business owners cannot. They know the big ones. They know the payment that hits the checking account every month. But the complete picture, organized in one place, with all the details? Most people do not have that document and have never had it.

That document is called a debt schedule and it is one of the most useful things you can build for your business. Not because a lender will ask for it, although they will. Because you need it to actually understand your own financial position.

What a Debt Schedule Is

A debt schedule is a simple document that lists every financial obligation your business carries, organized with the key details of each one. No complicated format required. A well-organized spreadsheet is all you need.

Here is what a complete debt schedule includes for each obligation.

FieldWhat to IncludeWhy It Matters
Creditor nameThe lender, lessor, or creditorIdentifies who holds the obligation
Type of debtTerm loan, line of credit, equipment lease, MCA, credit card, etc.Different debt types have different characteristics and risks
Original amountWhat you borrowed or the original obligationContext for how much has been paid down
Current balanceWhat you owe todayYour actual current liability
Interest rate or factor rateThe cost of the moneyIdentifies expensive debt worth prioritizing for payoff or refinance
Monthly paymentWhat hits your account each periodYour total monthly debt service obligation
Maturity dateWhen the debt is fully paid or comes dueIdentifies balloon payments or renewals coming up
CollateralWhat secures the debt if anythingShows what assets are encumbered
Personal guaranteeYes or noTracks your personal exposure

A Real Example of What This Looks Like

Here is a simplified debt schedule for a business I will call a regional staffing company. Nothing unusual about this business. Just a typical small company that has accumulated obligations over several years of operation.

CreditorTypeBalanceRateMonthly PaymentMaturityPersonal Guarantee
First National BankTerm loan$187,0008.5%$3,2002027Yes
Equipment Finance CoEquipment lease$44,0007.2%$9202026Yes
Business credit cardRevolving credit$18,50024.9%$555 (min)RevolvingYes
MCA CompanyMerchant cash advance$62,000~140% APR$1,840 daily4 monthsYes
Commercial landlordLease obligation$96,000 remainingN/A$4,0002026Yes

Look at that picture for a moment. The business has $407,500 in total obligations. Monthly cash going out to debt service is approximately $10,515 before the daily MCA pull. The MCA is costing roughly $38,640 over its remaining four months at the daily rate shown. The credit card is costing nearly 25 percent on a balance that has probably been sitting there for a while.

None of this is visible until you put it in one place. But once you do, things you can do about it become obvious immediately. The MCA is the most expensive debt by a significant margin and should be the first target for refinancing. The credit card balance at nearly 25 percent is next. The bank term loan at 8.5 percent is fine. The equipment lease at 7.2 percent is fine.

Without the debt schedule, you are just making payments. With it, you have a strategy.

What a Debt Schedule Tells You That Your P&L Does Not

Your P&L shows you what the business earned and spent. Your debt schedule shows you what the business owes and what it costs to carry that debt. They are different pictures and you need both.

  • Your total monthly debt service commitment. This is the floor of what has to go out every month regardless of revenue. Knowing this number precisely is basic financial hygiene.
  • Your total annual debt service, which is what lenders use to calculate your DSCR. If you do not know this number, you cannot calculate your own borrowing capacity before you apply for anything.
  • Upcoming maturities and balloon payments. A loan maturing in eighteen months that requires a balloon payment is a cash flow event you need to be planning for now, not in sixteen months when it is almost too late.
  • Your most expensive debt. The debt schedule makes the cost of every obligation visible in the same document. The expensive stuff stands out immediately. That is where to focus refinancing energy first.
  • Your personal exposure. Adding up the personal guarantees column tells you exactly how much of your business debt you are personally on the hook for. That number matters for your personal financial planning.

Why Lenders Ask for It and What They Do With It

Every serious lender will ask for a debt schedule as part of the underwriting process. Here is what they are doing with it.

First, they are calculating your total debt service to run the DSCR calculation. They need to know every payment obligation to understand how much capacity is left for a new loan payment.

Second, they are looking for obligations that were not on your tax return or bank statements. Debt that does not show up clearly in your financials but that you are actually paying creates a gap between what the documents say and what your cash flow actually looks like. Lenders find these gaps and they ask about them. Having a complete debt schedule ready answers those questions before they become problems.

Third, they are assessing your overall debt management. A business with a clear, organized debt schedule that the owner can speak to intelligently signals something different than a business where the owner vaguely knows they have some loans and sort of knows what the payments are. The first owner looks like someone who runs a business. The second looks like a risk.

How to Build Yours Right Now

This does not need to be complicated. Here is the straightforward approach.

  • Open a spreadsheet with the column headers from the table above. Every field matters so include all of them.
  • Pull every loan statement, lease agreement, credit card statement, and MCA agreement you have. Go through each one and fill in the row for that obligation.
  • Check your bank statements for recurring debits you may have forgotten about. Obligations that auto-debit sometimes fall off the mental radar. If money is leaving your account on a schedule, it belongs on the debt schedule.
  • Run a UCC search on your business to identify any creditors who have filed liens. If there is a filing you did not know about, there may be an obligation attached to it.
  • Add up the monthly payment column. That is your total monthly debt service. Add up the balance column. That is your total business debt. Look at both numbers and let them sit for a moment.
  • Update it quarterly. Balances change, obligations mature, new debt gets added. A debt schedule that is eighteen months out of date is not much more useful than not having one.

The Bottom Line

A debt schedule is not an exciting document. It is not the kind of thing that makes people feel good when they build it for the first time, especially if the total obligations column turns out to be larger than they expected.

But it is one of the most useful things you can have as a business owner. It gives you clarity on your actual financial position, it prepares you for any lender conversation, it identifies where your most expensive debt is, and it surfaces upcoming obligations before they become surprises.

If you want help building one and understanding what it means for your borrowing capacity and financing options, that is a conversation we have with business owners regularly. Let’s talk.

about the author

Need Help?

Let PGS bring our expertise to your business.

Recent Articles