Prepare the annual budget and cash budget, compare actuals to plan with variance analysis, and forecast revenues and expenses the way FP&A teams do.
Course Curriculum
| 1. Planning Foundations | |||
| 1.1 The role of FP&A Details | 00:06:00 | ||
| 1.2 Budget types: static, flexible, zero-based Details | 00:08:00 | ||
| 1.3 The budgeting calendar and process Details | 00:07:00 | ||
| 2. Building the Budget | |||
| 2.1 Sales budget Details | 00:08:00 | ||
| 2.2 Production and purchases budget Details | 00:08:00 | ||
| 2.3 Operating expenses budget Details | 00:07:00 | ||
| 2.4 Headcount and payroll budget Details | 00:07:00 | ||
| 2.5 Capex budget Details | 00:06:00 | ||
| 2.6 Budgeted P&L and balance sheet Details | 00:09:00 | ||
| 3. Cash Budget | |||
| 3.1 Cash inflows and outflows Details | 00:07:00 | ||
| 3.2 Financing gaps and short-term funding Details | 00:07:00 | ||
| 3.3 13-week cash forecast Details | 00:08:00 | ||
| 4. Forecasting | |||
| 4.1 Trend and seasonality Details | 00:08:00 | ||
| 4.2 Forecasting with Excel functions Details | 00:08:00 | ||
| 4.3 Rolling forecasts Details | 00:07:00 | ||
| 4.4 Driver-based planning Details | 00:08:00 | ||
| 5. Control and Reporting | |||
| 5.1 Actual vs. budget variance analysis Details | 00:09:00 | ||
| 5.2 Explaining variances to management Details | 00:07:00 | ||
| 5.3 Monthly FP&A reporting pack Details | 00:08:00 | ||
| 5.4 Final project: annual budget for a company Details | 00:15:00 | ||
Course Reviews
No Reviews found for this course.
Related Courses
STUDENTS ENROLLED
