Create your first Financial Forecasting Model!
You may be wondering who uses financial forecasting, how the forecasts are used, or if such forecasts are even reliable. All these questions will be answered in this course, Financial Forecasting and Modeling.
Financial modeling and forecasting can improve your business decision-making by helping you determine how best to allocate business resources to address expected expenditures in the coming months and years.
In this course, we will use a fictional company as an example to build our financial model and forecast. Having a basic understanding of Excel and a general familiarity with accounting principles is helpful.
The course includes instructor files and exercise files so you can follow along and practice what you've learned.
In this course, you will learn:
- The basics of financial modeling and forecasting
- The purpose of financial forecasting
- How to build a sound financial model
- The role of forecasting in strategic planning
- How to go through the three financial statements (balance sheet, income statement, and cash flow statement)
- How to define your forecasting objectives
- Identifying key variables and drivers
- Analyzing financial forecasts using ratio analysis
- Future trends in forecasting
Course Format
- This is a video-led course. You can preview some videos below.
- This course includes practice exercises.
Course Certificate Included
This course includes an optional online quiz that will generate a course certificate upon completion.
14-Day Guarantee
We offer an unconditional, 14-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your Stream Skill purchase. If you don’t learn, you don’t pay.
Why Trust Us?
Stream Skill is part of the Simon Sez IT family and has been in business 14+ years and taught over 1 million students in that time. We’ve created over 120 software training courses, 8,000+ video tutorials, and we’ve helped thousands of people across the world learn how to use Microsoft Office. We’ve now created Microsoft Excel courses for the last five versions and continue to help people get to grips with this essential tool.
Your Instructor
Course Curriculum
-
Free PreviewFinancial Components to Determine Business Health (10:39)
-
Free PreviewRole of Forecasting in Strategic Planning (12:20)
-
Free PreviewUnderstanding the Business (Part 1 of 2) (14:24)
-
StartUnderstanding the Business (Part 2 of 2) (11:05)
-
StartExercise 01 (3:02)
-
StartGoing through ABC’s Balance Sheet (9:24)
-
StartGoing through ABC’s Income Statement (7:04)
-
StartGoing through ABC’s Cash Flow Statement (7:37)
-
StartDefining Your Forecasting Objectives (7:08)
-
StartIdentifying Our Forecasting Approach and Assessing Timeframes (9:58)
-
StartExercise 02 (1:10)
-
StartIdentifying Key Variables and Drivers (Part 1 of 3) (8:06)
-
StartIdentifying Key Variables and Drivers (Part 2 of 3) (7:28)
-
StartIdentifying Key Variables and Drivers (Part 3 of 3) (9:54)
-
StartKey Points to Consider (8:00)