Advanced financial modelling course – 3 days

Day 1 of the advanced modelling course

• Session 1 - advanced Excel modelling tools
  • Modelling functions
  • Naming cells
  • Dates and timing conventions
  • AND, IF and MIN functions

• Session 2 – modelling functions
  • Time value of money
  • Using advanced formulae and the fx functions
  • Practical statistical tools

• Session 3 – tools for advanced modelling
  • Short cut keys
  • Match and offset – power together
  • Pivot tables
  • Graphs

• Session 4 - modelling process
  • Planning
  • Streamlining modelling workflow
  • Objectives
  • Advanced model layout and design
  • Outputs

• Session 5 - income statement: modelling revenue
  • Revenue analysis
  • Projecting data
  • Arithmetic means
  • Geometric means
  • ‘Detailed’ versus ‘top level’ analysis
  • How to build growth into the model
  • Compound annual growth rate (CAGR)
  • External factors and revenue drivers
  • Modelling scenario analysis

Day 2 of the advanced modelling course

• Session 6 – balance sheet: assets
  • The structure
  • Modelling non-current assets and deprecation tools and techniques
  • Amortization of intangibles
  • Inventory, accounts receivable and cash
  • Current assets

• Session 7 - balance sheet: liabilities
  • Modelling non-current liabilities
  • Amortisation tables
  • Accounts payable
  • Taxation and deferred taxation

• Session 8 - cash flow statement modelling
  • Link between financial statements
  • Working capital projections
  • Free cash flow and applying it in the model

• Session 9 – modelling valuation: discounted cash flow
  • Weighted average cost of capital (WACC)
  • Valuation using discounted cash flow (DCF)
  • Terminal cash flows, growth and terminal values
  • Sensitivity tables
  • Implied multiples

• Session 10 – modelling valuation: multiples
  • Enterprise value – the balance sheet and income statement
  • Comparable multiples
  • Market capitalisations
  • Applying multiples in practice

Day 3 of the advanced modelling course

• Session 11 - advanced modelling techniques
  • Data base techniques
  • Goal seek
  • Optimisation
  • Scenario analysis

• Session 12 – modelling case study
  • Develop a summary profit and loss statement, using actual and budgets over a one year period

• Session 13 - modelling for acquisition finance
  • Construction of cash flow, income statement and balance sheet
  • Input of depreciation and capital allowances
  • Earnings statements in models
  • Depreciation, goodwill and the treatment of interest expense
  • Input of short-term debt and overdrafts and other debt sources
  • Mezzanine finance
  • Valuation for acquisition finance
  • Modelling internal rate of return (IRR)

• Session 14 - mergers and acquisitions
  • Motives for mergers and modeling the inputs
  • Evaluating mergers and acquisitions
  • Net present value of acquisitions
  • Problem using earnings per share in valuation of mergers
  • Accretion and dilution

• Session 15 – Summary and close

Enquire about an in-house advanced modelling course

Our advanced financial modelling course is available for delivery inside your company. If you have 4-5 staff who are interested in an advanced modelling course, in-company training will prove cost-effective. To enquire about an advanced modelling course for a small group of your company's employees, please use Financial Training Associates' contact details at the top right.

Book the advanced modelling course

The advanced modelling course is next running Nov 2012. To book yourself on the program please click on the red "book course" button below.

More on FTA's advanced Excel financial modelling training

For further details of Financial Training Associates' advanced Excel modelling course, please see our advanced modelling training program.