Bank loan covenant and DSCR forecast
A bank loan covenant forecast is different from a simple repayment schedule. The lender or internal reviewer usually wants to see whether profit, cash flow, debt balance, interest expense, principal repayment, and ending cash remain consistent over time. A linked PL, BS, and CF forecast gives that review a single base.
How do I forecast DSCR for a bank loan?
Start with opening debt and current cash. Add operating revenue and expenses, then add scheduled principal repayments and interest expense. DSCR or repayment capacity can then be reviewed against cash flow and debt service by month or year.
1) Separate debt service from operating profit
Operating profit may look stable while cash becomes tight due to taxes, working capital, capex, or principal repayment. Debt service coverage ratio forecast work should therefore review PL performance and CF movement together.
2) Review covenant headroom and ending cash
If your loan agreement uses a DSCR, interest coverage, leverage, or minimum cash covenant, keep a small internal buffer. A forecast that only barely clears a covenant can still be risky if sales collection timing slips.
3) Validate before Excel output
Before exporting, check that opening debt, loan draws, repayments, interest expense, and ending debt balance all tell the same story. Statement Engine is not financing advice, but it can help organize the model before professional review.