Introduction To Financial Modelling with Excel

You'll cover the principles and practice of financial modelling, focusing on a case study involving the construction of an integrated set of financial statements, and subsequent investment appraisal.

Learning Outcomes:

• Learn and apply Excel tools useful in financial forecasting
• Understand and design the layout of a flexible model
• Forecast financial statements of a public or private company
• Apply scenario analysis to the forecasted financial statements
• Prepare charts for data presentation

Key Topics:

• Overview of financial modelling
• Excel tools used in financial modelling
• Model design and structure for the case study company
• Know the key model outputs and their drivers and understand the requisite inputs
• Developing cell styles for model transparency and review
• Incorporating historical financial statements of the subject company
• Building balance sheet error checks in the model
• Forecasting financial statements: forecasting revenue and key operating expenses
• Projecting key schedules: debt and interest, capex and depreciation, and working capital
• Stepwise projection of income state