Forecast vs Actual: Variances, Timing vs Permanent, and Rolling Forward a Week
This lesson is part of the course
In this lesson
You compare Kestrel's first forecast week with the bank, split the variances into timing and permanent, and roll the forecast forward: new opening cash from the actuals and a week-2 forecast that picks up the cash that slipped.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Week Calendar and the Opening Cash Position Locked
- Customer Receipts from the AR Ageing and a Collection Curve Locked
- Other Receipts: Mapping Dates to Weeks and Risk-Weighting Locked
- Disbursements: Payroll, Rent and Suppliers on Payment Terms Locked
- Debt Service and the Revolver: Draw and Repay Around a Minimum Cash Balance Locked
- Liquidity Headroom and the Minimum-Liquidity Covenant (with Chart) Locked
- Forecast vs Actual: Variances, Timing vs Permanent, and Rolling Forward a Week Locked
- Scenario Levers: Delay Payables, Accelerate Receivables and Find the Cash Trough Locked