Financial Modeling Bootcamp: Financial Forecasting in Excel

Create your first financial forecasting model in Excel and become an expert in no time!

***Exercise and demo files included***

What you’ll learn

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

Course Content

  • Introduction –> 5 lectures • 16min.
  • Strategic Role of Financial Forecasting –> 8 lectures • 1hr 16min.
  • Planning Your Financial Forecast –> 7 lectures • 52min.
  • Creating Your Financial Forecast –> 14 lectures • 2hr 18min.
  • Analyzing Your Financial Forecast –> 4 lectures • 24min.
  • Key Trends in Forecasting –> 3 lectures • 13min.

Financial Modeling Bootcamp: Financial Forecasting in Excel

Requirements

  • Excel installed in a PC or Mac.
  • A good understanding of Excel and Excel formulas.
  • Basic knowledge of accounting principles is beneficial.

***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
Get Tutorial