SALE

Applied Financial Modeling and Analysis Virtual Masterclass

Join Andrew Jones (CFA, Ex-Standard Bank), Gerard Kelly (CFA, Ex-Ernst & Young) and Jonathan Rugg (Ex-Lloyds) from 12-6pm London time (7am-1pm New York)*.

Book your place on all 5 days for the price of 4 or pick individual days to suit your schedule.

Rapidly develop modeling skills for valuation and transaction structuring, with practical application.

Receive the complete Investment Banker online course (worth £399/$499). Certify your new skills with a recognized investment banking micro-degree and join our prestigious alumni.

Add to cart

October

Arrow Down Icon

All 5 Days - 25th - 29th October

Day 1 - 25th October

Day 2 - 26th October

Day 3 - 27th October

Day 4 - 28th October

Day 5 - 29th October

Clear All

2021

Dates Available

5 for 4

Book 5 Days For Less

12-6pm

London

Course Instructor Icon

Direct instructor help

Micro-degree Course Icon

Micro-Degree

Rating

4.5 Stars

4.5 Star Rating

Applied Financial Modeling and Analysis Virtual Masterclass

Join Andrew Jones (CFA, Ex-Standard Bank), Gerard Kelly (CFA, Ex-Ernst & Young) and Jonathan Rugg (Ex-Lloyds) from 12-6pm London time (7am-1pm New York)*.

Book your place on all 5 days for the price of 4 or pick individual days to suit your schedule.

Rapidly develop modeling skills for valuation and transaction structuring, with practical application.

Receive the complete Investment Banker online course (worth £399/$499). Certify your new skills with a recognized investment banking micro-degree and join our prestigious alumni.

Add to cart

October

Arrow Down Icon

All 5 Days - 25th - 29th October

Day 1 - 25th October

Day 2 - 26th October

Day 3 - 27th October

Day 4 - 28th October

Day 5 - 29th October

Clear All

Explore the 5-Day Virtual Program Schedule

Pre-Class: The Accountant Online

About

Before your classroom begins you will receive access to The Accountant online course** worth £139. Maximize your time with our instructors by learning the fundamentals first. Includes 114 bite-sized videos, 82 practical exercises and test yourself against 7 tryouts.

Value a company based on multiple analysis

**Access is granted 3 weeks prior to course start date. If you have accessed The Accountant Online and can no longer attend your course its retail price will be deducted from any refund due, in accordance with our open course cancellation policy

About

Before your classroom begins you will receive access to The Accountant online course** worth £139. Maximize your time with our instructors by learning the fundamentals first. Includes 114 bite-sized videos, 82 practical exercises and test yourself against 7 tryouts.

Value a company based on multiple analysis

**Access is granted 3 weeks prior to course start date. If you have accessed The Accountant Online and can no longer attend your course its retail price will be deducted from any refund due, in accordance with our open course cancellation policy

Day 1

Accordion White Arrow Icon

About

 

Excel Fundamentals
This session covers core Excel skills needed to work quickly and efficiently. Discover critical keyboard shortcuts in your own file, gradually building up use of shortcuts and getting away from the mouse.

Three Statement Modeling with Iterations
Learn how to build a three statement model with an iterative circular reference. Relevant shortcuts are reviewed as the model is constructed.

About

 

Excel Fundamentals
This session covers core Excel skills needed to work quickly and efficiently. Discover critical keyboard shortcuts in your own file, gradually building up use of shortcuts and getting away from the mouse.

Three Statement Modeling with Iterations
Learn how to build a three statement model with an iterative circular reference. Relevant shortcuts are reviewed as the model is constructed.

Module

Excel Fundamentals

Accordion Arrow Icon
  • Keyboard shortcuts in place of the mouse
  • Cell selection
  • Sheet navigation
  • SUM and autosum
  • Formulas
  • Key formatting – all consistent with client standards

Three Statement Modeling with Iterations

Accordion Arrow Icon
  • Income statement construction and highlighting key numbers
  • Calculation schedules (PP&E, retained earnings, operating working capital, and debt)
  • Balancing the balance sheet with a cash sweep
  • Calculating interest using average balances
  • Circular references and iterations
    • Working with a circular reference switch
  • Preparing the model for handover
  • Key formatting and putting the output into a pitch book

Day 2

Accordion White Arrow Icon

About

 

Building a Three Statement Model Using Consensus Estimates
Using a company’s consensus estimates for revenues and EBIT, learn how to prepare a simple forecast model.

Checking a Model for Integrity and Errors
Review the common errors found in integrated three statement models, explore the checking and auditing toolkit.

About

 

Building a Three Statement Model Using Consensus Estimates
Using a company’s consensus estimates for revenues and EBIT, learn how to prepare a simple forecast model.

Checking a Model for Integrity and Errors
Review the common errors found in integrated three statement models, explore the checking and auditing toolkit.

Module

Building a Three Statement Model Using Consensus Estimates

Accordion Arrow Icon
  • Cleaning up the income statement and balance sheet and simplifying the line items
  • Getting estimates for revenues and EBIT
  • Modeling a forecast debt repayment schedule from the notes
  • Key ratios
  • Checking the model for reasonableness
  • Formatting and putting the output into a pitch book

Checking a Model for Integrity and Errors

Accordion Arrow Icon
  • Top ten errors
  • Auditing and error checking toolkit
  • Checking your own model
  • Checking someone else’s model

Day 3

Accordion White Arrow Icon

About

 

Equity Value to Enterprise Value Bridge
Explore the concept of enterprise value (operational value) in contrast to equity value. A simple set of multiples is calculated to illustrate why enterprise value multiples are unaffected by leverage.

Trading Comparable Valuation
Put together a set of trading comparables using underlying source documents and market data. At least one company is completed in class.

About

 

Equity Value to Enterprise Value Bridge
Explore the concept of enterprise value (operational value) in contrast to equity value. A simple set of multiples is calculated to illustrate why enterprise value multiples are unaffected by leverage.

Trading Comparable Valuation
Put together a set of trading comparables using underlying source documents and market data. At least one company is completed in class.

Module

Equity Value to Enterprise Value Bridge

Accordion Arrow Icon
  • Calculating equity value
  • Calculating enterprise value
  • Non-core items, debt equivalent items, and non-controlling interests
  • Calculating simple multiples
  • Illustrating the impact of leverage
  • Understand how growth rates, returns and multiples interrelate

Trading Comparable Valuation

Accordion Arrow Icon
  • Choosing a comparable set of companies
  • Calculating enterprise value
  • Calculating LTM EBITDA and EBIT
  • Forward multiples and issues with consensus data
  • Understanding which operational ratios are important for the analysis

Day 4

Accordion White Arrow Icon

About

 

WACC Analysis – Practical Application
Using the trading comparable information you will prepare a grid of WACC estimates for the different case companies.

Discounted Cash Flow Valuation
Using the financial forecast prepared during the modeling module and the completed WACC analysis, learn how to prepare a discounted cash flow valuation for the target company.

About

 

WACC Analysis – Practical Application
Using the trading comparable information you will prepare a grid of WACC estimates for the different case companies.

Discounted Cash Flow Valuation
Using the financial forecast prepared during the modeling module and the completed WACC analysis, learn how to prepare a discounted cash flow valuation for the target company.

Module

WACC Analysis – Practical Application

Accordion Arrow Icon
  • Capital Asset Pricing Model
  • Calculating the WACC from the peer group
  • Interpreting the results
  • Establishing a reasonable cost of capital for the target company

Discounted Cash Flow Valuation

Accordion Arrow Icon
  • Calculating free cash flows
  • Understanding how the operational ratios should develop over the financial forecast period
  • Calculating the steady state and making relevant adjustments to the steady state cash flows
  • Making reasonable assumptions for long-term growth rates
  • Converting the enterprise value into an implied share price, making relevant adjustments for share options and restricted stock units

Day 5

Accordion White Arrow Icon

About

 

M&A Cash Deal
Build a simple model using key information from the trading comparables model to review the key financial effects of a potential acquisition at different prices.

Private Equity Acquisition/LBO Analysis
Starting with a partially complete operational model, build on a debt-financed acquisition model with a complex debt sheet and a section for returns to equity holders.

About

 

M&A Cash Deal
Build a simple model using key information from the trading comparables model to review the key financial effects of a potential acquisition at different prices.

Private Equity Acquisition/LBO Analysis
Starting with a partially complete operational model, build on a debt-financed acquisition model with a complex debt sheet and a section for returns to equity holders.

Module

M&A Cash Deal

Accordion Arrow Icon
  • Estimated acquisition price range based on valuation analysis
  • Impact on earnings per share forecast
  • Impact on credit rating

Private Equity Acquisition/LBO Analysis

Accordion Arrow Icon
  • Revolving credit facility
  • Term loans
  • Cash sweep mechanisms and covenant mechanisms
  • Bullet / high yield loans
  • Credit ratios
  • Calculating returns to equity holders (internal rate of return and money multiples)

Post-Class: The Investment Banker

After your classroom training you can access all of the online courses from The Investment Banker! In addition to The Accountant you will unlock The Modeler, Valuer and Deal Maker so you can certify your skills with an investment banking micro-degree.

After your classroom training you can access all of the online courses from The Investment Banker! In addition to The Accountant you will unlock The Modeler, Valuer and Deal Maker so you can certify your skills with an investment banking micro-degree.

Meet Your Instructors

Join Jonathan Rugg (Ex-Lloyds Private Banking) on 21st September

Qualified chartered management accountant, Jonathan, began his financial training career in 2008. Prior to this, he worked across a variety of sectors, starting in finance at Lloyds Private Banking before moving to Baker Tilly. Jonathan later managed a portfolio valued at $2.2 billion for a commercial real estate company.

Join Gerard Kelly (CFA, Ex-Ernst & Young) on 22-23rd September

Gerard’s speciality lies in teaching accounting, financial analysis, and modeling, having started his career working in tax for Arthur Anderson and then moving to Ernst & Young’s Corporate Finance Department.

Join Andrew Jones (CFA, Ex-Standard Bank) from 25-29th October

Andrew began his career in finance as a chartered accountant with KPMG. He subsequently worked within risk and finance functions at leading investment banks and asset management firms, before moving into training in 2008.

He has taught courses covering all aspects of capital markets and asset management, including derivatives, risk management, financial statement analysis, and market economics.

Interact with Your Instructor via Zoom

Our live sessions are supported by Zoom. This virtual environment enables you to:

  • Meet face-to-face with our Wall Street instructor team
  • View screen shares from Excel files
  • Instant message your instructor
  • Have the opportunity to appear ‘in front of the class’
  • Work collaboratively with the group via whiteboards and annotations
  • Access recordings of the live classroom once it has finished

We strongly recommend you use a webcam and microphone during your class to get the most out of the session.

Get a Wall Street Recognized Certification

Upgrade your résumé with the same certification we use at the world’s top 4 investment banks.

The Investment Banker is made up of 4 skills certificates. Pass each one to unlock your micro-degree. Certification can easily be added to LinkedIn, demonstrating your achievement which will be recognized by the most prestigious firms on Wall Street.

Our Alumni

Demonstrate You're As Good As The Best

By completing this course, you will be able to join our prestigious alumni on LinkedIn alongside hires at the top 4 investment banks. After becoming a member of this elite community, you can unlock exclusive benefits such as course discounts and more.

TESTIMONIALS

What our participants say

Individuals

Oliver Gilkinet

Cass M&A and PE Society Member

Very nicely explained. Difficult and boring concepts are explained in an easy and light way. The exercises are challenging and refreshing.

Firms

Investment Banking Analyst

The Modeler Open Classroom

Very helpful course – thank you very much. Jonathan is a great teacher and I have learned a lot!

View more

Frequently Asked Questions

Is it right for me?

Accordion Arrow Icon

Our virtual classrooms offer distinct learning opportunities. Have your questions answered immediately by our expert instructors. Utilizing years of industry and teaching experience, they will make the learning applicable and vibrant. Reference the learning materials online for 365 days after the live sessions.

What will I need?

Accordion Arrow Icon

A laptop is essential, ideally with a webcam and microphone, and working WiFi. You must have access to Adobe Reader and Microsoft Excel. Each live session will take place on Zoom. Participants will be sent a link in their online classroom hub.

Will I get certification?

Accordion Arrow Icon

Yes! Earn your investment banking micro-degree after the live sessions by passing the 4 exams in The Investment Banker online program. Demonstrate your new capabilities by quickly adding your certification to LinkedIn and join our prestigious alumni to receive exclusive benefits.

Are there any additional fees or costs?

Accordion Arrow Icon

No, everything detailed is included in the price.

Can I download the Excel files and financial modeling templates?

Accordion Arrow Icon

Absolutely, all files and resources are accessible via our intuitive learning platform, designed to support you throughout the program and beyond.

How long do I have to complete the online courses?

Accordion Arrow Icon

We now offer lifetime access to our online courses, so you can progress through them at your own pace.

Are Financial Edge's courses credible?

Accordion Arrow Icon

The 4 leading investment banks, as rated by the FT, hire us to train their incoming analysts. If you are looking to join the best analysts in the world, why not challenge yourself with the same content and certification with the same Wall Street instructors ready to answer your questions.

* Is the instructor the same throughout?

Accordion Arrow Icon

Not always, but at FE we are privileged to have a deep bench of expert Wall Street instructors. If the instructor has to change for any reason we will let you know, but rest assured you will always receive the very best classroom experience.