Financial Modelling Fundamentals

Course Objectives

NEW 2 DAY COURSE
Course Requirements

• Mid level Excel knowledge
• Laptops

Key Learning Outcomes

> Examine relevant functions and commands of Excel for building models
– Define a financial model, its purpose, structure and common errors
– Key elements of best practice model design
– Build a case study model

> The skeleton structure, construction and operation pages

> Creating assumptions, calculations, dates, worksheets, debt schedules, ratios etc
– Debt – Develop debt schedules, ratios and cash waterfalls
– Risk -  Identify scenarios and incorporate breakeven, what-if and payback analysis
– Document, summarise and present results
– Tips for using your new skills so you don’t forget back at work

"Most people have only ever uncovered 10% off Excel’s potential... because they are too busy, but sitting down for a day and learning about the other 90% will actually increase productivity"

In partnership with

About the Course

We take a company, with global operations, that has both a construction and operations phase, and use many of the powerful functions and commands of Excel to create a model covering 6 different international branches and a report with impressive presentation.

We also look at some key calculations covering valuation and debt ratios.

Depending on the participants on the day and their knowledge/requirements, this course can be tailored to have more or less basic Excel and Corporate Finance

Who Should Attend

Business and Finance Analysts, General Managers, Finance Managers, Government Analysts, Investment Managers, CFOs and Finance Directors, Bankers, Accountants and those in Corporate/Structured Finance

Course Requirements

• Mid level Excel knowledge
• Laptopss

Online Media Partner



ORGANISATIONAL MEMBER