Financial Modelling for Budgeting and Forecasting in Excel

In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user.

Objective

• Apply a structured approach to financial modelling in Excel
• Outline the hallmarks of good financial models
• Explain the importance of planning, and prep your model structure
• Build from operating revenues down to operating profit
• Forecast property, plant and equipment and other operating assets
• Forecast the various components of working capital
• Forecast debt financing and related interest costs
• Forecast equity financing and dividends
• Use an iterative analytic approach to managing circular references
• Understand the importance of error checking
• Derive a forecast cash flow statement based on a forecast income statement and balance sheet
• Perform Financial Model integration