Financial Modelling

For finance professionals we recommend our popular ‘Advanced Excel and Financial Modelling’ course. This course covers fundamental skills needed to utilise Excel to best effect and then illustrates these skills in the context of developing best practice financial models.

You will learn key tools of Excel which are useful for business analysis and then how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).

This course adopts a case study approach and minimising the level of classroom-style learning allowing participants to feel more empowered and comfortable in applying skills and techniques developed during the course in their day to day work.

Key outcomes:

Attending this course will be a valuable opportunity to capitalise on the trainer’s well rounded experience and in-depth knowledge.

By the end of the course you will be able to:

• Improve your efficiency using Excel shortcuts
• Use several of the support tools and techniques in spreadsheet programs
• Utilise sensitivity analysis
• Build a robust financial model
• Analyse the results

Topics Covered:

• Basic Excel tools
• Refresher of Excel fundamentals
• Customising Excel
• Basic structure of a model
• Understanding/refresher of financial statements
• Model design and consideration of inputs
• Forecasting EBITDA
• Making sure the model has integrity
• Including checks and balance
• Forecasting working capital
• Forecasting capex and depreciation
• Forecasting financial flows
• Trouble shooting circulatory problems
• Forecasting tax
• The camera function
• Sensitivity analysis
• Charting the results
• Creating impressive output