Advanced Financial Modelling with Excel

Duration: 2 Days
Location: London
Level: Advanced
Participants: 8 Maximum per tutor
PC Requirements: Laptops will be provided if requested
Take-away: Corporate Forecasting and Project Appraisal models (for teaching purposes only)

Course Dates (2 days):

  • 4th – 5th September 2014

Course Fees

  • £1200 + VAT (includes all refreshments, lunch and course documentation.)

PDF Brochure

The brochure also incorporates a booking form for you to complete and return to FSMD.

Course Objectives

The aims of the Advanced Financial Modelling with Excel course are to develop practical skills and concepts for:

  • financial modelling within a robust financial/accounting framework
  • use of Excel as an advanced modelling tool
  • modelling financial forecasts
  • reconciling the projected accounting statements
  • financial projections, valuations and funding

During the event attendees will build i) a Corporate Forecasting and Valuation Model and ii) a Project Appraisal Model.

Who Should Attend?

You should attend if your work requires the use of Excel 2007 or 2010 to develop financial models in particular:

  • corporate planners responsible for developing or enhancing forecasting models
  • corporate finance practitioners building or auditing valuation models
  • those involved in structuring or auditing funding models
  • analysts producing or using financial forecasts for capital projects

Course Design

The Advanced Financial Modelling with Excel course is designed:

  • to cultivate best practice modelling principles
  • with the emphasis on practical applications;
  • as a workshop to encourage an interactive approach;
  • using case studies adapted from the real world;
  • at a pace to suit all delegates

Pre-requisite Knowledge

In advance of the course, a basic knowledge of Excel is assumed. This knowledge should include at least the following:

  • the Excel screen menu and toolbar
  • moving around a worksheet and between worksheets in a workbook
  • changing column width
  • entering labels
  • entering, selecting, copying and editing cell contents
  • centring titles
  • saving, closing & retrieving the worksheet
  • auto fill
  • entering formulae
  • relative and absolute cell referencing
  • formatting, previewing and printing

Course Tutor

Richard Peck, BSc., MBA has over 20 years experience designing and implementing training programmes for UK and European banks covering most areas of the financial markets and the bank/corporate interface.

Originally a civil engineer, he managed infrastructure projects in the UK and the Middle East before studying for an MBA at Cranfield School of Management prior to joining FSMD.

At FSMD, Richard has been responsible for the ongoing development of modelling courses and applications, principally for project finance, corporate finance and credit.

Richard has advised and built models for a range of clients including Innogy plc, Heineken, HSBC, Bayerisch Landesbank, National Australia Bank, Lloyds TSB, Bankgesellschaft Berlin AG, Allied Irish Bank, Bank Leumi, Stockbrokers Dolman, Butler and Briscoe, the Welsh Government, National Housing Federation, Tenant Services Authority, Newcastle Building Society and Principality Building Society.

Course Timetable

Day 1Day 2

Advanced Financial Modelling with Excel – Day 1

8.30 – 9.00 Registration and Coffee
9.00 – 9.15 Introduction
  • Overview of course and content

9.15 – 10.30Review of Advanced Excel Functions and Techniques

  • worksheets and workbooks
  • copying, dragging & summing
  • copying & naming sheets
  • linking sheets & books
  • array arithmetic
  • grouping sheets
  • conditional statements
  • using names

10.30 – 10.45Coffee10.45 – 13.00Basic Modelling Concepts & “Good-Practice” Guidelines

  • spreadsheet style guide

Advanced Financial Modelling Techniques (1)

  • iterative calculations & alternatives
  • interest calculations
  • tracing and auditing
  • Goalseek and solver
  • Excel financial functions

13.00 – 14.00Lunch14.00 – 15.30Practical Applications (1)
Overview of Forecasting & Valuation Issues

Corporate Forecasting Model Case Study

  • income flows
  • costing structure
  • working capital
  • capex & depreciation

15.30 – 15.45Tea15.45 – 17.30Corporate Forecasting Model Case Study (cont’d)

  • funding structure
  • interests payments & receipts
  • tax
  • dividends
  • modelling value
    • DCF
    • multiples
  • modelling investor returns

Advanced Financial Modelling with Excel – Day 2

8.30 – 9.00 Registration and Coffee
9.00 – 10.30 Practical Applications (2)
Overview of Project Appraisal IssuesProject Appraisal Model Case Study

  • operating income & expenditure
  • capital expenditures
  • operating surplus
  • cashflow before funding & interest
  • terminal value
10.30 – 10.45 Coffee
10.45 – 13.00 Project Appraisal Model Case Study (cont’d)

  • NPV & IRR
  • debt & interest paid
  • true short-term balances and interest received
  • project life & loan cover ratios
13.00 – 14.00 Lunch
14.00 – 15.30 Advanced Modelling Techniques (2)
Application to Case Studies

  • sensitivity analysis
    • one-input data tables
    • two-input data tables
    • scenarios
    • beyond the two-input data table
    • data validation
15.30 – 15.45 Tea
15.45 – 17.30 Advanced Modelling Techniques (2) (cont’d)
Application to Case Studies

  • sensitivity analysis
    • advanced sensitivity techniques
    • automating the model using controls & macros

Reserve a Place

If you would like to provisionally book a place on the Advanced Financial Modelling with Excel course, please fill in the form below. Alternatively, download the PDF brochure and booking form at the top of the page.

Your Name (required)

Your Email (required)

Your Message

Please complete the box below. This is so we know you are not a spammer!

Cancellation Period

    • Cancellations received 30 days prior to course commencement will be eligible for a refund less an administration charge of £50.
    • After this time no refund can be made although a substitute delegate is acceptable
    • FSMD reserves the right to cancel any of its courses. Either full refunds will be given OR a reserved place on the next available course.

Registration Fee

The registration fee includes participation on the course, documentation, lunch and refreshments throughout the day.

A VAT invoice will be issued to confirm your booking and joining instructions will be sent seven days before the course.