This financial modeling course covers Financial Modeling Fundamentals plus Advanced Excel for Financial Modeling.

Our financial modelling course provides a sound understanding of both the principles of financial modelling and the practical application of these to real-world situations by using Excel to build financial models.

The course builds upon the financial modelling principles and practices learned to apply these to company or project valuations. In this, participants improve their mastery of valuation principles and concepts, and learn how to apply these in real-life situations.

Finally, participants will receive training in how to both detect and prevent errors from occurring.

Excel is the tool of choice for most financial modellers so before we start building financial models, it’s critical that we have a good understanding of the key functions and tools in Excel that can help us build models that are robust, easy-to-use, and flexible.

Here are just some of the areas we cover in our in-depth, hands-on workshop:

● Working with large data sets

● Summarising and aggregating data

● Extracting data that matches criteria using flexible formulas

● Error handling

● Ways of improving structure

● Techniques for keeping formulas constant yet flexible

● Combining and splitting cells according to the content they contain

● Advanced techniques for creating automatically expanding charts and ranges

● Introduction to macros & when to use these

We then apply and practise these functions during the remainder of the course.

  • April 28th 2023
  • 9 am – 5 pm
  • Regus, Guelph
  • Price: C$545.00

Duration                Learning Credits

2 Days – 16 hours of     16 PDU’s


Public Classroom Pricing:    

Early Bird Price: CAD 1295.00

Regular Price: CAD 1495.00

Instructor-Led Virtual Live Pricing:

Early Bird Price: CAD 995.00

Regular Price: CAD 1195.00

Private Group / In-House Learning:

Have a group of 3 or more people? 

Register yourself with a special pricing and

request the training exclusively

  • 4.5 | 2546 Ratings | 5246 Attended |245 Corporate Trainings
Course Outline

Course Overview, Objectives & Introductory Concepts

● Financial modelling concepts: Aims, design, structure and development

● Corporate finance and valuation concepts

● Introductory Concepts

○ Cash vs Profit

○ Time Value of Money

○ Cost of Capital

○ Risk, return & value

○ Scenario Analysis

Financial Forecasting & Analysis

● Common difficulties, problems and limitations with financial analysis

● Defining the decision

● Availability of information

● Defining model scope

● Knowing the limitations of financial analysis

● Information overload

● Financial Forecasting

○ What is it?

○ Steps involved

○ Best practices & financial modelling standards

Financial Decision Making & Evaluation

● Common financial / investment decisions

● Understanding the Time Value of Money concept

● Understanding Discounted Cash Flows

● Evaluation of different methodologies (including NPV, IRR, Payback Period)

● Introduction to valuation concepts including NPV

● Identifying & dealing with IRR difficulties

Valuation tools and methodologies

● Reviewing valuation concepts

● Valuation methodologies (including evaluation of different methodologies)

● Dealing with common valuation issues

● Compare & contrast alternative valuation methods to know when to apply each

Discounted Cash flow

● Overview of DCF methodology

● The role of Cash Flow Forecasts

● Cost of Capital

Ratios and Key Performance Metrics

● Performing a Ratio Analysis

● Understanding Profitability Ratios

● Interpreting Liquidity and Solvency Ratios

Financial Modelling & Forecasting in Excel

● Overview & Objectives

○ Defining the scope of your model

○ Objectives: What are the aims of the model?

○ Understanding model limitations

● Development and structuring

○ Planning the financial model

○ Ensuring the model structure matches the objectives

● Incorporating best practice techniques into your models

● Compare a selection of best practice guidelines/standards

Structuring the Cash Flow Model

● Setting Up the Work Book & structure

○ Time scale

○ Separate business areas

○ Timing and frequency formats

○ Data Sources

● Managing the Input Section

● Building the Calculation Section

○ Building the C/Flow Forecast

○ Line by line build-up of cash flows

○ Capex and OpEx

● Presenting Model Outputs

○ Key Financials

○ Summary of model data

○ Dashboards & Graphs

○ Valuations & terminal values

Integrated 3-way Financial Models

● Balance sheet, Income statement, cash flow

● Dealing with interest circularity

● Using ratios to produce financial forecasts

● Debugging a 3-way model

Debt and Capital Structuring

● Typical Bank Covenants & Ratios

● The Importance of Capital Management

○ Why it is important (cost of debt vs equity)

○ Defining your optimal capital structure

● The Effect of Capital Structure

○ Understanding its effects on risk

Sensitivities & Scenario Management

● Sensitivity

○ Identifying key variables for sensitivity

○ Building in sensitivities

○ Displaying the results of sensitivity analysis

● Scenarios

○ How to run multiple sets of inputs through a single calculation engine

○ Building, managing and extending a scenario manager that is far better than Excel

● Introduction to Monte Carlo simulation: how to apply these techniques in practical ways to real-life financial models

Best Practice Reporting, Review and Presentation

● Checking outputs for consistency

● Techniques for building checks & balances

● Model audit & review

● Automated spreadsheet auditing software tools: role, purpose & limitations, demonstration

● Documentation

● Use of financial modelling software: when is it useful or not useful?

Who can attend?

● Business & Finance Analysts

● Finance Managers

● Investment Managers

● Investment Analysts

● CFO’s

● Financial Modellers

● Project Managers

● Project Accountants

● Investment & Corporate Bankers

● Corporate Finance Managers

● Finance Professionals

● Accountants

Learning Goals

● An excellent working knowledge of financial modelling functions in Excel that allow you to efficiently create robust and flexible models.

● A sound understanding of financial modelling and valuation concepts.

● Practical experience in designing solutions to real-world financial modelling challenges by building financial models in Excel.

● A solid foundation for Excel-based financial modelling.

● Excel tools and techniques that are essential for modelling to make your models robust, user-friendly, and efficient.

Frequently Registered Together
Train the Trainer

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Leading Effective Teams

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Essential Management Skills

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Essential Coaching Skills for Managers

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Manager Management

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Presentation Skills – Pro

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Conflict Management

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Employee Management

Duration: 1 Day
Timing: 9:00 am to 5:00 pm
Certificate: Course Completion
Price: CA$595 – $795

Courses Relevant to your Job Role / Industry
Data Modelling
  • 8 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
  • 5 Courses
  • 8 – 16 Hours
  • Certificate by ITIL
  • 5 Courses
  • 8 – 16 Hours
  • Certificate by DASA
Cyber Security
  • 5 Courses
  • 8 – 16 Hours
  • Certificate by Mangates
Comparing Other Courses
Essential Management Skills
  • Management as a Product
  • Assessing Your Personal Management Style
  • Setting Goals, Strategies, Objectives, Tasks and KPIs
  • Delegating
  • Having Innovative Meetings
  • Creating Engagement
Leading Effective Teams
  • Qualities of an Effective Leader
  • Developing Your Team Goals
  • Dealing With Difficult Team Members
  • Coaching
  • Three Key Skills of Coaching
  • Instant Results Coaching
Performance Management
  • The Performance Management Cycle
  • Adapting Your Leadership Style
  • Giving Difficult Feedback
  • Performance Reviews Practice
  • Using the GROW Model to Joint Problem Solve
  • Managing Poor Performance
Employee Engagement
  • Roles and Responsibilities
  • The Four Enablers
  • Critical Success Factors
  • Creating the Right Work Environment
  • Engagement and Retention
  • Disengagement and the Six Human Needs