This course introduces the theories of financial modelling and best practice using Excel to create a financial model. Delegates will build a forecasting model from scratch in a practical modelling exercise.
Forecast drivers will be created for key P&L, cash flow and balance sheet items, and these will be methodically linked through the integrated model, creating the platform for further analysis.
Prior knowledge: Participants should have attended to Introduction to Financial Statements course or have a good working knowledge of accountancy. Participants will require calculators and computers.
Review of the modelling process
Forecasting the income statement
Fixed assets and working capital
Net income and shareholders’ equity
Cash flow statement
|Training Course||Training Course Summary|
|Bank Valuation||Get an overview of financial statement analysis for banks, including the banking book, financial instruments and the reporting and valuation of derivatives|
|Modelling for Disposals||Be introduced to why corporates divest or restucture their assets|
|Valuing a Pharmaceutical Company||Get to grips with the pharma business model with many illustrations|