Course Details
Course Outline
5 days course
Forecasting
- What are the forecasting basics?
- What causes forecasting errors?
- What types of charts should we use?
- How do we review forecasts?
- How can we appraise accuracy?
- How do we analyse data in Excel?
Forecasting methods
- How can we identify patterns?
- What is the simple percentage plus method?
- How do we use compound annual growth rate?
- How are trends useful?
- What is smoothing?
- How do we look at seasons?
- How do we use regression?
- What is the inflation problem?
Ratios
- What factors can affect cash flow?
- What are the core ratios?
- What are the profitability ratios?
- What ratios measure operating efficiency?
- What ratios can help with financial structure?
- Is growth sustainable?
- What are the market ratios?
- What error functions and units should be considered?
- What checks are required?
Forecast drivers
- What assumptions can we make?
- How do we generate the income statement?
- How are balance sheet assets generated?
- What about balance sheet liabilities?
- Why are the workings sheets important?
- How do we deal with divisions?
Accounting statements
- What is the structure of the balance sheet?
- How do we model the income statement?
- How do we model the balance sheet?
- What are the mechanics of cash flow?
- What are the cash flow ratios?
- Can we avoid common mistakes?
- How should we deal with iteration?
- What further checks are needed?
