Financial Modeling and Forecasting Analysis with Excel

Description

***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:

1. 5+ hours of video tutorials

2. 38 individual video lectures

3. Course and exercise files to follow along

4. 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

TAKE THIS COURSE