13-Week Cash Flow Forecast: Receipts, Disbursements, Liquidity & Variance
Week calendar and opening cash, receipts from the AR ageing, other receipts, payroll, rent and suppliers, the revolver with MAX/MIN, covenant headroom, weekly variances and scenario levers: 8 labs on one wholesaler under pressure.
The first lesson is free — no account needed.
About this course
A 13-week cash flow forecast course that builds the weekly direct-method forecast of one fictional wholesaler under pressure, Kestrel Outdoor Supply, in a spreadsheet, for FP&A and treasury staff, controllers, restructuring and turnaround advisers, lenders and finance students. You start from the available cash on the bank statement and a Monday-to-Friday week calendar, forecast customer receipts from the AR ageing with a collection curve, place one-off receipts in the right week, schedule payroll, rent and supplier payments on their terms, let a revolver draw and repay around a minimum cash balance with MAX and MIN, measure liquidity headroom against a covenant in a chart, compare forecast with actual and roll forward a week, and test levers that lift the cash trough. Fictional company, illustrative figures, educational only, not financial or lending advice. The first lab is free.
Lessons
- The Week Calendar and the Opening Cash PositionFree
- Customer Receipts from the AR Ageing and a Collection Curve Pro
- Other Receipts: Mapping Dates to Weeks and Risk-Weighting Pro
- Disbursements: Payroll, Rent and Suppliers on Payment Terms Pro
- Debt Service and the Revolver: Draw and Repay Around a Minimum Cash Balance Pro
- Liquidity Headroom and the Minimum-Liquidity Covenant (with Chart) Pro
- Forecast vs Actual: Variances, Timing vs Permanent, and Rolling Forward a Week Pro
- Scenario Levers: Delay Payables, Accelerate Receivables and Find the Cash Trough Pro