Overview
Budgeting and Forecasting
This financial budgeting course will teach you about the entire budgeting process from start to finish, including how to create a disciplined culture of budgeting in your organization, the various methods for building budgets, techniques to analyze results, and how to increase the chances of organizational performance improvements. This interactive and applied budgeting course enables participants to:- Adopt a disciplined approach to developing budgets
- Forecast results with quantitative and qualitative methods
- Effectively use variance analysis to track performance
- Present results with charts and graphs
Who Should Take This Budgeting Class?
This online budgeting class is designed for those who are responsible for financial management, budgeting, and forecasting within their organizations. This may include professionals working in financial planning and analysis (FP&A), accounting, treasury, financial reporting, corporate development, etc.
Financial Budgeting Class Content
Topics covered will include:- Budgeting within a strategic framework
- Building a robust budgeting process
- Managing budget psychology
- A practical guide to developing budgets
- Common budgeting approaches (e.g. Incremental, value-based, zero-based, etc.)
- Forecasting techniques (moving average, regression analysis, etc.)
- Tracking budget performance with variance analysis (waterfall charts, etc.)
- Applied budgeting tools and techniques (Excel, solver, pivot tables, etc.)
CPE Information
For further CPE information, please read before purchasing: https://corporatefinanceinstitute.com/about/cpe-information/ Publish Date: Sep 06, 2017 Last Revision: Jan 18, 2018Budgeting 101 Class Screenshots
Budgeting and Forecasting Learning Objectives
- Adopt a disciplined approach to developing budgets
- Forecast results with quantitative and qualitative methods
- Effectively use variance analysis to track performance
- Present results with charts and graphs
- Understand the principles behind best practice financial management
- Explain the importance of budgeting within a strategic framework
- Build a robust budgeting process within their organization
- Know when and where to use various budgeting approaches such as zero-based budgeting
- Forecast future performance by better analyzing revenue and cost drivers
- Use effective variance reporting to track organizational performance
- Make use of Excel functions and tools that are particularly suited to the budgeting process
Prerequisite Courses
Recommended courses to complete before taking this course.
Prerequisite Skills
Recommended skills to have before taking this course.
- Excel
- Critical thinking
- Financial accounting
Budgeting and Forecasting
Led by
Tim Vipond
Level 3
100% online and self-paced
Field of Study: Finance
Start LearningWhat You'll Learn
Lesson
Multimedia
Exams
Files
Building a Robust Budgeting Process
Learning objectives
The master budget
3 categories of budgets
Interactive exercise 3
Manufacturing company example
Retail company example
Services company example
Where to start with budgeting
Steps in the budgeting process
Psychology and target setting
Top down vs. bottom up involvement
Interactive exercise 4
A Practical Guide to Developing Budgets
Forecasting Techniques
Learning objectives
Cost types
Modified cost types
Cost structure and earnings volatility
Cost structure exercise template
Cost analysis demonstration
Breakeven analysis and margin of safety demonstration
Sensitivity analysis with data table
Interactive exercise 6
Cost control matrix
Quantitative forecasting methods
Forecasting exercise template
Moving averages
Simple linear regression
Excel FORECAST function
Equation of a line regression
Multiple linear regression overview
Multiple regression Excel demonstration
Interpreting regression summary output
Using the multiple regression equation
Interactive exercise 7
PEST analysis
Porter's 5 forces
Tracking Budget Performance with Variance Analysis
Learning objectives
What is variance analysis
Volume vs. price variance
Cost variance
Interactive exercise 8
Variance analysis exercise template
Variance analysis in Excel
Variance impact and waterfall chart data
Variance waterfall chart in Excel
Variance waterfall chart template
Root cause analysis
Presenting results of variance analysis
Interactive exercise 9
Applied Budgeting Tools and Techniques in Excel
Qualified Assessment
What Our Members Say
Very Insightful
Interesting concepts to consider when budgeting; the strategy involved, the fact that we have to consider both internal and external factors (the financial statements, PEST and Porter's analysis) and the building the of Dashboards. I really love how everything we learned in the previous courses come together and flow. Mookho Letlala
Simplicity
The teaching makes it simple to understand Oluwatobi Olusoji
Very intensive, extensive and comprehensive
One of most loved courses. Very extensive. Abel Joshua Chinaza
Smooth learning.
How about 21st century learning at CFI! Ibrahim Nasser
Frequently Asked Questions
If you haven’t found your answer from our FAQ, please send us a message.
If you haven’t found your answer from our FAQ, please send us a message.
