Debt schedule · Loan documents

Count each debt once and know when it matures.

Fixed charges and global debt service start from the business debt schedule, with every balance tied to the balance sheet, the income statement and the tax return. Each debt is counted once, each payment is cited to its page, and every ratio built on them shows its formula. Maturities stay in view at every review.

DEBT SCHEDULE · ILLUSTRATIVESAMPLE FABRICATION, INC.
The schedule as the borrower prepared it
SCHEDULE OF DEBT · SAMPLE FABRICATION, INC. AND SAMPLE REALTY · FISCAL YEAR END · PAGE 1
SAMPLE FABRICATION, INC. · EXISTING
FACILITYBALANCEMATURESANNUALRATE
RevolverReceivables, inventory900,0008 mo72,0008.00%
Equipment loanEquipment financed800,00048 mo258,0007.25%
1Existing total1,700,000330,000
SAMPLE FABRICATION, INC. · PROPOSED
2New term loanNew equipment, first lien1,200,00084 mo220,8727.50%
3Pro forma total2,900,000550,872
SAMPLE REALTY · OWNED BY THE SAME TWO OWNERS
4MortgageThe plant1,800,00030 mo168,0006.00%
READ FROM THIS DOCUMENT, EACH FIGURE CITED
1Existing business debt$1,700,000 · $330,000 a yearDebt schedule, p. 1 · Balance sheet
2Proposed term loan$1,200,000 · $220,872 a yearDebt schedule, p. 1 · Term sheet
3Pro forma business debt service$550,872Debt schedule, p. 1
4Plant mortgage, Sample Realty$1,800,000 · $168,000 a yearDebt schedule, p. 1 · Mortgage note
Balloon inside the new loan's term$1,640,000
The plant mortgage at Sample Realty matures in 30 months with $1,640,000 still owed, well inside the 84-month equipment loan. The borrower operates from that plant, so the refinance goes to committee with a plan.
Debt schedule, p. 1Mortgage note
What a credit officer checks on a debt schedule

Balances tied to the statements they came from.

The schedule is set against the balance sheet, the income statement, the returns and the owners' statements, every one from the same illustrative Sample Fabrication file used across these pages.

THE CHECKON THE SAMPLE FILE · ILLUSTRATIVE
Balances against the balance sheet
Funded debt on the schedule should equal the revolver, current maturities and long-term debt on the balance sheet.
TIES OUT
$1,700,000 on both: revolver $900,000, current portion $200,000 and long-term $600,000. The $200,000 current portion is next year's principal on the equipment loan.
Debt schedule, p. 1Balance sheet
Interest against the statements and the return
Each balance at its stated rate, set beside interest expense on the income statement and the tax return.
TIES OUT
$900,000 at 8.00% is $72,000 and $800,000 at 7.25% is $58,000: $130,000, the figure on the income statement and Form 1120-S.
Debt schedule, p. 11120-S, p. 1
Maturities inside the new term
Any facility that matures or renews before the proposed loan does.
FLAGGED
The revolver renews in 8 months and the equipment loan pays off in 48. The plant mortgage at Sample Realty balloons in 30 months with $1,640,000 due.
Debt schedule, p. 1Mortgage note
Payments into fixed charges
Scheduled principal and interest on business debt, today and with the new loan.
TIES OUT
$330,000 today and $550,872 with the new loan. Fixed charge coverage falls from 2.45x to 1.47x, above your 1.20x minimum.
Debt schedule, p. 1Financial statements
Related-entity and personal debt
Debt the owners and their other entities carry, from the personal financial statements and the related returns.
TIES OUT
Sample Realty's $168,000 and the owners' $105,000 of personal debt service bring global debt service to $823,872: coverage 1.56x against your 1.25x minimum.
PFS, p. 11065, Sample Realty
Obligations the schedule leaves out
Guaranties and loans that appear on the personal financial statements and nowhere on the schedule.
ON THE RECORD
Owner A guarantees a $250,000 loan to an unrelated partnership, $30,000 a year, paid by that partnership today. If Owner A had to pay it, global coverage would be 1.51x.
PFS, p. 2
What LenderBox returns

$823,872 of global debt service, rerun from the source.

Every balance and payment is cited to its page, and each ratio built on them shows its formula.

CITED TO ITS PAGEEvery balance, rate and payment is cited to its document and page.
BOTH PAGES FOR EVERY GAPDebt on the schedule is read against the balance sheet, the income statement and the tax returns, and each gap shows both pages for your analyst.
FORMULA SHOWNFixed charges and global coverage carry their formulas, so anyone on your team can check the $823,872 line by line.
ONE RELATIONSHIPBorrower, guarantors and related entities are brought into one view, with each payment counted once.
WRITTEN BACKResults write back to your loan system, so the record your team keeps there stays current without re-keying.
See global cash flow built from the schedule →
WHERE THE FIGURES GO · ILLUSTRATIVESAME SAMPLE FILE
Fixed charges and global coverage
FIXED CHARGE COVERAGE1.47x pro forma against a 1.20x minimum
GLOBAL DEBT SERVICE$823,872 across the company, Sample Realty and both owners
GLOBAL COVERAGE1.56x against your 1.25x minimum
CREDIT MEMODebt and maturity section drafted with the recommendation, each figure cited

Maturities, related debt and what your credit team decides.

Reading the schedule
LENDERBOX DOESReads every facility with its balance, payment, rate, maturity and collateral.
STAYS WITH YOUR TEAMWhich obligations the analysis must include.
Tying out
LENDERBOX DOESSets the schedule beside the balance sheet, the income statement and the returns, with both pages for any gap.
STAYS WITH YOUR TEAMWhether a gap is missing debt.
Maturities
LENDERBOX DOESLists each maturity against the term of the new loan.
STAYS WITH YOUR TEAMHow a balloon inside the term is handled: a condition, a covenant or the price.
Related debt
LENDERBOX DOESBrings the related entities and the owners into one view of debt service.
STAYS WITH YOUR TEAMWhose debts and guaranties count toward the relationship.
The memo
LENDERBOX DOESDrafts the debt and maturity section, each facility cited.
STAYS WITH YOUR TEAMThe decision, and the structure it rests on.

The schedule at approval and each annual review.

01 · FIRST LOOKThe borrower's schedule with the request shows early whether the new payment fits under your coverage minimum.
02 · UNDERWRITING · THIS DOCUMENTThe schedule is tied to the statements and the returns, and every payment is carried into fixed charges and global debt service.
03 · CREDIT DECISIONCommittee sees coverage today and with the new loan, with each maturity inside the term on the record.
04 · CLOSINGA balloon refinance plan is a closing condition.
05 · LIFE OF THE LOANAn updated schedule arrives with each annual review, and covenant monitoring keeps the headroom on each test in view.

If the borrower owes more than listed

Which facilities on the schedule are captured?

Every facility: creditor, balance, payment, rate, maturity and collateral, for the borrower and any related entity on the schedule. Each balance, rate and payment carries its page.

Do the schedule's balances agree with the balance sheet?

Yes. Balances are read against the balance sheet and interest against the income statement and the tax return. On the sample, $1,700,000 of debt and $130,000 of interest agree on all three.

Does it find debt the schedule leaves out?

The personal financial statements and related-entity returns are read beside the schedule, so a guaranty or loan that appears there and not on the schedule is shown with its page. Your analyst decides whether it counts.

How are maturities inside the new term handled?

Each one is listed against the new loan's term. On the sample, the plant mortgage balloons in 30 months with $1,640,000 due, and it goes into the memo for committee.

How is the new loan's payment counted in fixed charges?

At its scheduled payment. On the sample, the $1.2 million loan adds $220,872 a year, so fixed charges go from $330,000 to $550,872.

A borrower with debts in more than one place.

The demo can run on your own deal documents: the debt schedule comes back tied to the statements and the returns, with global debt service built and cited.

Book a demo
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.
Not ready to talk? See pricing