Financial Modelling with Excel
In-house
This 2 day practical course is designed to equip the delegates with a sound financial modelling skills and techniques to prepare and forecast financial statements needed in a modern corporate world. You will gain a firm understanding of the modelling process and financial ratios analysis.
The course is run in a very small group allowing for a direct interaction with the trainer throughout the whole course and each session is concluded with a practical model building exercise.
By the end of this course you will be able to:
- Build a financial model from a scratch using the best structuring techniques
- Use efficiently key Excel functions to construct sound financial forecasting models
- Create a forecast income, cash flow statement and balance sheet
- Interpret and analyse the key ratios used in a financial forecast
- Apply and analyse more complex issues in financial forecasting such as taxation, provisions, associates and NCIs
- Develop the analysis of balance sheet structures through a cash waterfall
- Use the financial ratios in the forecast analysis
Prerequisites: Basic/intermediate knowledge of accounting
Main Topics Covered During This Training
- Overview of the modelling process
- The key Excel functions in modelling
- Model structure: inputs, workings, outputs
- Key drivers for modelling: revenues and operating costs
- Forecasting revenues and margins, fixed tangible and intangible assets
- Creating and analysing cash flow statement from operations, investing and financing activities
- Calculating tax and dividends
- Linking up interest
- Forecasting depreciation, net income and shareholders' equity
- Creating and analysing cash flow statement from operations, investing and financing activities
- More complex issues in forecasting: taxation, provisions, associates and non controlling interests
- Key ratio analysis
Who Should Attend
Participants who want or need to be able to build a sound financial models should attend this course.
From:
- Corporates
- Investment Banks
- Private Equity companies
- Analysts
- M&A Departments
- Consultant Companies
- Equity Research, Analysts and Sales
- Equity Capital Markets
- Investment Managers
- Corporate Financial Managers
- Corporate Development
- Corporate Finance Lawyers
Teaching Method
This is a highly practical course with many real life case studies and exercises. Tutor will be focused on teaching practical strategies that can be taken back to your business and put into immediate effect.
In order to help us establish your individual and business concerns, you will be asked to fill pre-course questionnaire.
Due to the practical nature of the course the number of places is limited and will be filled on first come, first accepted basis. We advise to book in advance in order to avoid disappointment.
Delegates are requested to bring laptop with Microsoft Excel. If necessary, we can provide one for an additional fee of £100 + VAT.
Financial Modelling and Forecasting - A Two Day Course
Modelling basics
- Modelling process overview
- Modelling and formatting best practice
- The key Excel functions used in modelling
- Model structure:inputs, workings, outputs
- Connections between income statement, balance sheet and cash flow statement
- Sources of information
- Inputting historical financials
Model building: Participants are introduced to a forecasting model and a set of historical accounts.
Forecasting the income statement
- Key drivers for modelling
- Revenues
- Operating costs
- Using equity research to model – pluses and minuses
- Segment analysis
Model building: Using all available information, participants build a forecasting module to the pre-tax level and link it to the income statement
Fixed assets and working capital
- Forecasting fixed tangible and intangible assets
- Discussion of key drivers of capital expenditure and depreciation
- Forecasting depreciation, existing and new assets
- Forecasting components of non-cash working capital
Model building: Analysis and forecast of capital expenditure, depreciation, fixed assets and non-cash working capital
Net income and shareholders' equity
- Forecasting net income
- Dividend policy and retained earnings
- Forecasting shareholders’ equity
Model building: Participants forecast net income based on the assumption of constant debt and a calculated tax rate. Participants analyse a case company’s dividend policy and forecast the movement in shareholders’ equity
Cash flow statement
- Cash flow from operations, what happens if cash is working capital?
- Cash flow from investing activities
- Cash flow from financing activities
- Modelling the cash waterfall
- Scenario capital structures
- Interest calculation
Model building: Participants complete the cash flow statement and balance the balance sheet by using a cash waterfall. Participants complete the model using the forecast interest line and flex the model for different capital structures
More complex issues
- Taxation, including net operating losses
- Provisions (restructuring, environmental, deferred taxation), effects on income statement and cash flow
- Associates, treatment and forecasting
- Non controlling interests (“NCI”)s, treatment and forecasting
Model building: Participants build out the income statement to the post-tax and dividend level, to include associates and modules
Ratio analysis
- Assessing the company’s operating performance and credit quality
- Use of ratios in evaluating forecasts, using DuPont analysis in forecasting
Model building: Participants build a detailed schedule of DuPont ratios and use this to interpret and adjust the forecasts for case company
Mike Corless
The course director is a qualified chartered accountant who begun his career in Grant Thornton International and since 1986 worked in Ernst & Young as a senior manager in the corporate advisory team, working on major acquisitions, disposals, IPOs and insolvency/restructuring transactions.
In 1989 he joined Threadneedle Asset Management as an analyst, becoming a fund manager specialising in income funds in 1991. In 1996 he joined Scottish Widows Investment Partnership as a director in the UK Equity team, again specialising in income funds. On becoming head of UK Equities in 1998, he introduced a new investment process incorporating cash flow based corporate valuation techniques. In 2000 he was appointed head of UK Equities when Scottish Widows was acquired by Lloyds Bank and he led the integration of the UK Equity teams.
In 2001 he joined HSBC Asset Management as European Head of Equity Research, managing a team of analysts in Paris and London tasked with developing a new research team and research process.In 2004 he was appointed Global Head of Equity Research, responsible for 60 global equity research analysts and 40 global credit analysts. He developed a global valuation and research process, training local analysts in Europe, the US and Asia in its use.
In 2006 he joined BG Consulting Group, a professional training company, as the head of investment banking and investment management managing a team of 12 trainers. His experience at BG included managing major graduate programmes for investment banking and investment management clients, training graduate to managing director level participants and advising clients on their training requirements for accountancy, corporate finance and valuation, investment management and private wealth training.
His clients have included HSBC, Morgan Stanley, Deutsche Bank, Citigroup, Allen & Overy, JP Morgan, Barclays Bank, Barclays Wealth, Morgan Stanley Investment Management and Schroders.
IN-HOUSE TRAINING
If you have a team of 4 or more this course can be customised and organised in-house at your convenience. Contact one of our advisors to find out more.
Call us now on +44 (0) 207 993 8597
