3 day Masterclass

Financial Modelling


Take your analytical skills to the next level... and design world-class models.

You will receive individual attention and highly personalised support throughout the workshop. In addition to the personal step-by-step expert tuition, you will also receive over 300 pages of exclusive course documentation - and a CDROM full of best-practice templates for a multitude of real-world scenarios.

Learn bulb

learn in depth

Gain real insight into structured methods and best practices in financial model design and construction

Learn bulb

expand your knowledge

Enhance your familiarity with the latest Excel tools and techniques and become a valuable Excel resource in your workplace

Learn bulb

learn from the best

A highly experienced trainer will teach you to build models which are functionally rich, accurate, flexible, reliable and maintainable

Become familiar with an impressive range of Excel facilities and tools

This three-day intensive course is aimed at any professional in any functional area who aspires to become proficient in the design and development of computer-based financial models. The course is designed to take participants through different levels of modelling complexity to enable them to achieve their desired level of proficiency. The entire focus of the course is to teach techniques that will enable you to design and construct financial models that are not only functional but also accurate, reliable, flexible, user-friendly and maintainable. The course has been carefully designed to meet the needs of a variety of different users and their differing levels of expertise. 

In just 3 days you will:

  • Become familiar with an impressive range of Excel facilities and tools
  • Appreciate the nature and use of new facilities in the latest versions of Excel
  • Use a variety of simple and complex Excel functions with confidence
  • Create dashboards and reports that are informative, enlightening and insightful
  • Formulate and solve problems using optimisation techniques
  • Design and build macros and user-defined functions
  • Use macros to extend the functionality and enhance the usability of financial models
  • Clean up, enhance and generally manage raw data for modelling purposes
  • Understand the nature of financial models and their application areas
  • Plan, design, construct and prove modelling applications for planning and decision-making
  • Use the facilities of Excel to prepare forecasts of financial statements and cash flows
  • Build models to evaluate projects and perform company valuations
  • Use tables, scenarios and other tools of sensitivity analysis

Organisations that will benefit:

  • Mining companies
  • Real estate brokers
  • Lawyers
  • Investment Banks
  • Pharmaceutical companies
  • Telecoms companies

Who will attend:

  • Executives and managers
  • Sales and marketing professionals
  • Accountants and lawyers
  • Corporate financiers
  • Investment bankers
  • Commercial bankers
  • Treasury professionals
  • Financial and credit analysts
  • Investment analysts and fund managers
  • Engineers
  • Front and back office staff
  • Administrative professionals

Course Agenda

  • Introduction – Speed Networking
  • Getting Off to a Flying Start!
  • Using Excel Functions to Advantage
  • Using Power Tools in Excel
  • Creating Dashboards, Reports & Charts
  • Exercises: You will design and implement a proper dashboard and reporting capability within a model that will inform, enlighten and provide valuable insights for the intended user.
  • Introduction to Spreadsheet Macros
  • Structured Approach to Building a Financial Model
  • Forecasting for Modelling Applications
  • Modelling the Weighted Average Cost of Capital (WACC)
  • Modelling for Project & Investment Appraisal and Decision-Making
  • Optimization Techniques in Financial Modelling
  • Constructing Models for Company Valuation & Related Applications
  • Valuation Modelling Case Study
  • Financial Modelling for Leasing Applications
  • Using Monte Carlo Simulation for Risk Evaluation in Financial Modelling

For further information please call: +44 (0)207 092 1045

  • “The depth and knowledge of my trainer was extremely impressive. In 3 days I have had, without a doubt, a masterclass on the industry. Truly world class.”

    - Gordon Dowall Potter, Past Delegate

  • “Well worth 3 days of study!”

    - Syed Hamza, Past Delegate

  • “The training was excellent! I give it a 10 and will get my trainer's support for my next challenges.”

    - Head of Partnerships & Customer Loyalty at Avis Budget, Past Delegate

  • “Extremely constructive course with a very good dynamic and passionate trainer.”

    - Managing Director at BNP Paribas, Past Delegate

  • “Impressive and cooperative trainer who wanted to make sure the delegates understood.”

    - Budgeting, Planning & Reporting Manager, Past Delegate


We can come to you too! If you have a team of six or more, why not hold a private course? Our experts come to you and the course is tailored to your requirements.

Call +44 (0)20 7092 1045 (United Kingdom)
or emma-jane.dinan@terrapinn.com (Asia Pacific)
for more details


Sign up for our Monthly Course Calendars