The purpose of the course is for participants to learn how to build a financial model using best practice principles. This will include the development of financial statements and the mastering of the main Excel techniques (such as forecasting, risk issues, differing scenarios and optimisation).
Attendees will learn how to deal with more problematic modelling issues and gain hands-on experience of applying these skills. By building a complete model, participants will gain the confidence to build and revise their own models.
Many models fail due to inadequate structures and methodology and this course offers the opportunity to build a comprehensive financial model using international best-practice principles. The course commences with a discussion of objectives and common mistakes and then develops the case model in stages. On completion, participants will have built a complete model for future use and review.
The course is taught using demonstrations combined with practical and interactive case studies. The exercises in each session reinforce the concepts covered in each of the units.
Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel.
Comprehensive product notes and modelling software are provided for future reference.
Introduction and Overview
Financial Modelling and Model Planning
- Overview of the course – building a model from a blank sheet
- Case study outline – desired outcomes
- Review of available financial data
- Avoiding Excel modelling errors
- Starting initial template from a blank file
- Required Excel framework
- Template sheets
- Basic information e.g. timelines and version control
- Styles, colours and number formats
Exercise: setting up model framework
Income Statement and Balance Sheet
- Extracting data from annual reports
- Adding income and balance sheet
- Model checks on consistency
Exercise: completing and checking the initial statements
- Essential auditing methods
- Consistency and other checks
- Checking the initial model
Exercise: finding errors in model
Questions and answers
Forecasting and Equity Valuation
- Review of forecasting methods
- Macro forecasting
- Linear methods
- Review of historical performance
- Relationship between company and financial strategy
- Identifying and forecasting key drivers
- Linkages and modelling problems
Exercise: reviewing performance and adding a forecast to the case template
Free Cash Flows
- Derivation of free cash flow
- Checking model results and redefining forecast
- Reasonableness of forecast and results
Exercise: adding free cash flow to the model
Cost of Capital
- Alternative theories – bonds and arbitrage pricing theory
- Capital Asset Pricing Model constituents
- Discussion and agreement on WACC inputs
- Asset and equity betas and risk
- Mathematical derivation
Exercise: deriving beta from data and adding WACC to case
Initial Equity Valuation
- Methods of adding terminal value
- Producing an equity valuation
- Comparison to existing share price
Exercise: adding equity valuation to the template
Questions and Answers
Risk, Targeting and Other Layers
Alternative Cash Flow Valuation
- Time varying WACC
- Adjustments to value
- Adjusted present value (APV) method
- Existence and addition of financial and operational synergies
- Reconciliation to economic profit
Exercise: adding APV to the template
Risk and Sensitivity
- Understanding of risk and multiple answers
- Sensitivity and matrices
- Creating sensitivity graphs
- Scenario planning based on economic climate
- Alternative scenario methods
Exercise: testing the models with different sensitivity and risk matrices
Optimum Structure and Targeting
- Achieving a target valuation
- Goal seek method
- Testing valuation with leverage and structure
Exercise: targeting the case to improve results
Management Reporting and Model Review
- Management reporting and summary
- Exercise: adding reporting to the valuation model
- Suggestions for other improvements to the valuation model
- Final audit
- Help and user assistance
- Securing and protection
- Documentation and maintenance
Questions and Answers
- Investment Analysts
- Investment Bankers
- Finance Executives
- Finance Managers
- Financial Analysts
- Financial Modellers
- Treasury Department Staff
- CFOs & Accountants
- Portfolio Managers
- Project Risk Managers
- Project Finance Officers
- Business Analysts
- Financial Controllers
Mr. A. Day
Mr. Day is a finance professional with extensive experience of financial modelling, finance and leasing. Alastair was previously a director of a start-up structured finance company, which grew rapidly and was subsequently sold to a public company.
Later, he established an independent consultancy to concentrate on assignments in structured finance, leasing and financial model development.
Past projects have included investment analysis, debt restructuring, valuation, aircraft leasing, power and project finance models prepared for a variety of clients. In addition, Alastair designs and delivers courses covering financial modelling, credit analysis and equipment leasing.
Mr. Day has a degree in German and Economics from London University and an MBA. He has held positions as an associate lecturer at the OUBS and the ifs University College (Chartered Institute of Bankers).
Books Authored By Mr. Day
He is the author of standard modelling textbooks such as Mastering Financial Modelling, Mastering Risk Modelling, Mastering Cash Flow and Valuation Modelling and Mastering Financial Mathematics in Excel, together with a number of leasing and credit books.
Note: His full professional Biography is available on request.
Holiday Inn Hotel, Sandton – Johannesburg
5th – 7th December 2018 | 13th – 15th March 2019
Local Fee: R 20,999
International Fee: $ 2,000
Get 15% discount, when you register 3 or More delegates.
Get 10% discount, when you register 3 months before the course’s start date.
Get 5% discount, when you register 2 months before the course’s start date.
Do you know anyone that could benefit from our training courses? Share the details with a colleague and SAVE BIG…