Financial Modeling and Forecasting Analysis with Excel
Create your first financial forecasting model and become an expert in no time!
What you will learn
Come to understand the basics of financial modeling and forecasting
Know the purpose of financial forecasting
Build your first financial forecasting model
Learn how to build a sound financial model
Know the role of forecasting in strategic planning
Go through the three financial statements (balance sheet, income statement, and cash flow statement)
Learn how to define your forecasting objectives
Identify key variables and drivers
Analyze financial forecasts using ratio analysis
Learn about future trends in forecasting
Why take this course?
***Exercise and demo files included***
Forecasting the financial performance of a business is crucial for its success. Both established companies and entrepreneurs use financial forecasting to determine how to allocate their resources to address expected expenditures in the coming years. It is essential to use tools that can generate a clear and reliable forecast for the business.
Financial modeling and forecasting can improve your business decision-making, and the best way to create a financial model is using a widely familiar application such as Microsoft Excel.
This course will discuss a fictional company, for which we will build our financial model and forecast. Coming into the course, you will need to have a basic understanding of Excel. General familiarity with accounting principles will also be beneficial.
You’ll enjoy 5 hours of video tutorials divided into 38 bite-sized video lessons. The course includes instructor files and exercise files so you can practice what you've learned and gain confidence as you go.
In this course, you will:
Come to understand the basics of financial modeling and forecasting using Excel
Know the purpose of financial forecasting
Build your first financial forecasting model in Excel
Learn how to build a sound financial model
Know the role of forecasting in strategic planning
Go through the three financial statements (balance sheet, income statement, and cash flow statement)
Learn how to define your forecasting objectives
Identify key variables and drivers
Analyze financial forecasts using ratio analysis
Learn about future trends in forecasting.
This course includes:
5+ hours of video tutorials
38 individual video lectures
Course and exercise files to follow along
Certificate of completion
Here's what our students are saying...
★★★★★ "This tutor displayed a great control and knowledge of the subject. Excellent delivery mode and clear explanations of concepts." -Kehinde Balogun
★★★★★ "The value of financial forecasting in strategic planning is well presented. I feel empowered to participate in the strategic planning process at my Bank. In addition, as a credit analyst, I have gained insight into the thought process of loan customers who present financial projections as a loan requirement." -John Paul Onyango
★★★★★ "Opened my mind to a different understanding on forecasting" -Wanjun Su
Reviews
Charts
Price
Rating
Enrollment distribution
