Budgeting and Forecasting in Excel

If you are new to the budgeting and forecasting process, this practical course will cover issues such as using budgets to measure staff performance, linking budgets to the strategic planning process and a comparison of budgeting techniques. We will explore the difference between budgets and forecasts, rolling forecast, report and budget scenarios in Excel.

Who Should Attend?

• Accountants
• Finance Staff
• Department heads

Course Agenda Highlights

Budgeting and Forecasting Theory

• Cost Management Concepts
• Budgets and Strategic Planning
• Using Budgets as Performance Management
• Financial Ratio Analysis
• Financial Ratio Analysis
• Reporting
• Budgeting Techniques
• Limitations of budgets
• Budgeting “Soft’’ Skills

Budgeting and Forecast Modeling

• Budget Modeling
• Historical Data Analysis in Excel
• Determination of business trends, cycles and seasonality
• Scenarios, Sensitivities and Stress-testing