The Week Calendar and the Opening Cash Position
This lesson is part of the course
In this lesson
You set up the backbone of Kestrel's 13-week forecast: the available opening cash from the bank statement, a Monday-to-Friday week calendar built with date arithmetic, and a flag for the weeks in which the monthly rent falls due.
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