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