13-Week Cash Flow Modeling
Learn how to build a fully integrated 3 statement 13-week cash flow model for a distressed company
Overview
During this course participants build a fully integrated three statement 13-week cash flow model. Best modeling practices are covered while also addressing the practicalities of building this model during a distressed situation. Cash is reconciled via both an indirect and direct cash flow statement and weekly, quarterly and annual financial statement statements are produced.
- Structural issues with 13-week cash flow modeling
- DIP financing
- Detailed forecast assumptions for sales and cost components - (COGS and SG&A)
- Accrual vs. cash forecasting methodologies
- Forecasting and rolling forward key working capital accounts including: -Accounts receivable -Accounts payable -Inventory -Payroll -Taxes
- Issues with forecasting cash receipts and disbursements
- Direct and indirect cash flow statements
- Weekly, quarterly and annual outputs
- Updating the model for actual performance
- Variance analysis between historicals and actuals