The Investment Banker includes

The Accountant

4.4 STARS

Star Rating
Accordion White Arrow Icon

About

Quickly and confidently interpret financial data and statements, evaluate them and use the calculated information to build high-quality reports. Real company data and the latest rules are covered to ensure the methods used and skills developed are immediately applicable in the workplace.

Completion time

13 Hours

Level

Skills Certificate

About

Quickly and confidently interpret financial data and statements, evaluate them and use the calculated information to build high-quality reports. Real company data and the latest rules are covered to ensure the methods used and skills developed are immediately applicable in the workplace.

Completion time

13 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Financial Accounting Review

33

3

Accordion Arrow Icon

Video minutes33

Excel Exercises3

  • Making entries and ensuring the balance sheet balances
  • Preparing a balance sheet
  • Preparing an income statement from the entries to retained earnings
  • Preparing a cash flow statement from the entries to the cash account
  • A review of the different categorizations on the income statement, balance sheet, and the cash flow statement

Income Statements

61

15

Accordion Arrow Icon

Video minutes61

Excel Exercises15

  • Revenue recognition issues
  • Cost recognition issues
  • Identifying non-recurring items from the income statement, the MD&A, the notes to the accounts and the financial statement press release
  • Calculating EBIT and EBITDA for the historical year, and on an LTM basis

Earnings Per Share

27

11

Accordion Arrow Icon

Video minutes27

Excel Exercises11

  • Basic EPS calculations including weighted average shares
  • Dilutive securities: options (treasury method) and convertibles (as if converted)
  • Calculating recurring EPS

Working Capital

56

12

Accordion Arrow Icon

Video minutes56

Excel Exercises12

  • Inventory accounting including the impact on EBIT of LIFO and FIFO accounting choices (where relevant)
  • Accounts receivable and bad debts (identifying when companies are manipulating sales)
  • Accounts payable and accruals and the difference between them from a due diligence perspective
  • Other items including taxes payable, deferred revenue, and pre-paid items
  • Working capital and operating working capital and the cash impact of changes in operating working capital
  • Credit implications of working capital movements
  • Day ratios

Non-Current Assets

39

11

Accordion Arrow Icon

Video minutes39

Excel Exercises11

  • Gross PP&E, accumulated depreciation, depreciation expense and net PP&E
  • Building a simple forecast of fixed assets
  • Establishing the age of a company’s fixed asset base
  • Finite, and infinite intangibles including goodwill
  • A review of key methods of accounting for financial investments
  • At fair value through the income statement
  • Available for sale
  • Associate (equity method) accounting

Capital Structure

50

14

Accordion Arrow Icon

Video minutes50

Excel Exercises14

  • Debt issues and repurchases
  • Simple yield to maturity and all in cost calculations and understanding Original Issuer Discounts
  • Calculating net debt
  • Equity issuance and repurchases
  • The difference between authorized, issued and outstanding shares and multiple share classes
  • Other capital items: preference shares and convertible bonds
  • Leverage ratios
  • Debt liability maturity analysis

Accounting Ratios

41

5

Accordion Arrow Icon

Video minutes41

Excel Exercises5

  • Profitability ratios, including margins
  • Liquidity ratios, including operating working capital
  • EBIT and EBITDA for the historical year, and on an LTM basis
  • Leverage ratios, including net debt and interest coverage
    Asset ratios

Cash Flow Statements

25

3

Accordion Arrow Icon

Video minutes25

Excel Exercises3

  • Understanding how to categorize cash flows between operating, investing, and financing
  • Deriving a cash flow statement from two balance sheets and an income statement
  • Deriving a balance sheet from a cash flow statement and an income statement
  • Different cash flow statement presentations

Equity Method Investments

9

5

Accordion Arrow Icon

Video minutes9

Excel Exercises5

  • What are equity method investments?
    • Equity affiliates/associates
    • Joint ventures
  • Equity method accounting
    • Income statement
    • Balance sheet
    • Cash flow statement
    • Financial statement integration

Intro to Full Consolidation

68

21

Accordion Arrow Icon

Video minutes68

Excel Exercises21

  • M&A accounting overview
  • Balance sheet consolidation
  • Sources and uses of funds
  • Goodwill calculation
  • Income statement consolidation
  • Non controlling interests – NCI

The Modeler

4.6 STARS

Star Rating
Accordion White Arrow Icon

About

Financial modeling is one of the most useful skills in the world of finance. Knowing how to build models quickly and error-free is critical for the decisions and recommendations that they underpin. Our online financial modeling course provides the perfect introduction to building models, developing multiple techniques for a comprehensive and practical understanding of the topic.

Completion time

12 Hours

Level

Skills Certificate

About

Financial modeling is one of the most useful skills in the world of finance. Knowing how to build models quickly and error-free is critical for the decisions and recommendations that they underpin. Our online financial modeling course provides the perfect introduction to building models, developing multiple techniques for a comprehensive and practical understanding of the topic.

Completion time

12 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Introduction to Modeling

55

13

Accordion Arrow Icon

Video minutes55

Excel Exercises13

  • Key settings
  • Formatting and layout standards
  • Building a simple income statement and balance sheet model, on one sheet, then across sheets
  • Balancing the balance sheet using the cash flow statement
  • Preparing the model for handover
  • Key formatting and putting the output into a pitch book

Three Statement Modeling with Iterations

77

10

Accordion Arrow Icon

Video minutes77

Excel Exercises10

  • 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

Three Statement Model Editing

44

6

Accordion Arrow Icon

Video minutes44

Excel Exercises6

  • Steps before editing
  • Inserting a new item
  • Removing an old item
  • After editing
  • Relevant keyboard shortcut keys

Three Statement Model With Estimates

70

12

Accordion Arrow Icon

Video minutes70

Excel Exercises12

  • Cleaning up the income statement and balance sheet and simplifying the line items
  • Getting estimates for revenues and EBIT
  • Building multiple scenarios into a model’s assumption
  • 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

Building a Model with Cash Sweep

71

19

Accordion Arrow Icon

Video minutes71

Excel Exercises19

  • Why banks want to be repaid early
  • Cash sweep mechanisms
  • How to model cash sweeps
  • Building a three statement model with a cash sweep

Checking a Model for Integrity and Errors

36

11

Accordion Arrow Icon

Video minutes36

Excel Exercises11

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

The Valuer

4.5 STARS

Star Rating
Accordion White Arrow Icon

About

Learn how and when to utilize key valuation methodologies and their supporting calculations.

Completion time

12 Hours

Level

Skills Certificate

About

Learn how and when to utilize key valuation methodologies and their supporting calculations.

Completion time

12 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Equity to Enterprise Value Bridge

33

8

Accordion Arrow Icon

Video minutes33

Excel Exercises8

  • 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 Comparables

69

17

Accordion Arrow Icon

Video minutes69

Excel Exercises17

  • Review 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

Transaction Comparables

30

11

Accordion Arrow Icon

Video minutes30

Excel Exercises11

  • Reviewing data sources
  • Understanding different deal contexts
  • Calculating enterprise value and LTM EBITDA
  • Calculating premiums paid based on offer prices where appropriate
  • Calculating the synergies from the transactions as a % of target sales

WACC Analysis

27

8

Accordion Arrow Icon

Video minutes27

Excel Exercises8

  • Capital Asset Pricing Model
  • Calculating the WACC for the peer group
  • Interpreting the results
  • Establish a reasonable cost of capital for the target company
  • WACC approach

Discounted Cash Flow Valuation

50

14

Accordion Arrow Icon

Video minutes50

Excel Exercises14

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

Pulling the Analysis Together

43

13

Accordion Arrow Icon

Video minutes43

Excel Exercises13

  • Reviewing different valuation methods
  • Preparing valuation ranges for each valuation method
  • Summarizing the valuation ranges and interpreting the results

The Deal Maker

4.5 STARS

Star Rating
Accordion White Arrow Icon

About

When should a company acquire another? Is the merger beneficial for the stakeholders? These are just a few of the core M&A questions that The Deal Maker will answer. Not only are mergers and acquisitions calculated and evaluated, the funding sources are examined in detail; such as private equity acquisitions including credit facilities, term loans and more.

Completion time

8.5 Hours

Level

Skills Certificate

About

When should a company acquire another? Is the merger beneficial for the stakeholders? These are just a few of the core M&A questions that The Deal Maker will answer. Not only are mergers and acquisitions calculated and evaluated, the funding sources are examined in detail; such as private equity acquisitions including credit facilities, term loans and more.

Completion time

8.5 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Merger Analysis Cash Deal

75

18

Accordion Arrow Icon

Video minutes75

Excel Exercises18

  • Nature of an acquisition
  • Valuation in an M&A context
  • Financing a transaction
  • Sources and uses of funds
  • Transaction fees
  • Consolidation
  • Offer terms – equity financing
  • Deal analysis

Merger Model

22

9

Accordion Arrow Icon

Video minutes22

Excel Exercises9

  • Equity to enterprise value bridge
  • Sources and uses of funds
  • Share issuance and dilution
  • Relative PEs
  • EPS accretion dilution
  • Debt rating
  • Synergies vs. premiums paid
  • Return on invested capital

Earnouts

15

1

Accordion Arrow Icon

Video minutes15

Excel Exercises1

  • Contingent consideration – structures
  • Accounting for deferred consideration
  • Examples of earnouts

Leveraged Buyouts

75

18

Accordion Arrow Icon

Video minutes75

Excel Exercises18

  • LBO – definition
  • Internal Rate of Return (IRR) and Value Analysis
  • LBO analysis models
    • LBO analysis model map
    • Assumptions
    • Sources of funds
    • Operating forecasts and cash sweeps
    • Model outputs
    • Levered valuation

Acquisition Finance Debt Capacity

32

5

Accordion Arrow Icon

Video minutes32

Excel Exercises5

  • Multiple based debt capacity analysis
  • Dangers of using multiples
  • Cash flow based debt capacity analysis
  • Calculating free cash flows
  • Debt tranching
  • Seniority and subordination

Breaking into Banking Interview: Your Top Questions Answered

5 STARS

Star Rating
Accordion White Arrow Icon

About

Are you looking to land a full-time position at a top investment bank? Wondering how to set yourself up for success? Watch our Q&A session with Anish K. Mitra, ex-Head of IBD Learning & Development (Americas) at Goldman Sachs, who answers the top 8 questions every aspiring analyst has.

Completion time

1 hour

Level

Completion Certificate

About

Are you looking to land a full-time position at a top investment bank? Wondering how to set yourself up for success? Watch our Q&A session with Anish K. Mitra, ex-Head of IBD Learning & Development (Americas) at Goldman Sachs, who answers the top 8 questions every aspiring analyst has.

Completion time

1 hour

Level

Completion Certificate

Module

Video Minutes

Excel Exercises

Breaking into Banking Interview

30

0

Accordion Arrow Icon

Video minutes30

Excel Exercises0

  • What is the secret sauce for high-performing analysts?
  • What top three qualities do recruiters look for?
  • What advice do you have for interview preparation?
  • What top tips do you have for upcoming interns?
  • What are the bests ways to stand out on virtual internships?
  • Given the choice, how would you choose between teams?
  • What were the highs and lows of being an analyst?
  • What would you say people who don’t get offers typically do wrong?

M&A Banking Expert Interview

18

0

Accordion Arrow Icon

Video minutes18

Excel Exercises0

  • Key skills
  • Biggest challenges in deals
  • Industry insights
  • Cross Border vs Domestic Deals
  • Top tips for a successful career in M&A Banking

Financial Data Tools

4.4 STARS

Star Rating
Accordion White Arrow Icon

About

Discover how to use the three Financial Data Tools investment bankers use everyday including, BamSEC, FactSet, and Felix to improve your problem-solving abilities and efficiency.

Completion time

2 Hours

Level

Completion Certificate

About

Discover how to use the three Financial Data Tools investment bankers use everyday including, BamSEC, FactSet, and Felix to improve your problem-solving abilities and efficiency.

Completion time

2 Hours

Level

Completion Certificate

Module

Video Minutes

Excel Exercises

BamSEC Series

9

0

Accordion Arrow Icon

Video minutes9

Excel Exercises0

  • Guide to using BamSEC
  • Document Search
  • Tables
  • Links to Text and Highlights
  • Watched Companies

FactSet Workstation

35

0

Accordion Arrow Icon

Video minutes35

Excel Exercises0

  • Using the search bar
  • Comps report and adjusting the report
  •  Modifying user settings
  •  Saving and exporting reports
  •  Running a search
  •  Idea screening
  •  Filings wizard
  •  Bookbuilder tool

FactSet Charting

18

0

Accordion Arrow Icon

Video minutes18

Excel Exercises0

  •  Interactive charting overview
  • Creating charts and yield curves
  • Formatting charts
  • Downloading charts to Excel
  • Create a portfolio of companies
  • Create a chart and index composite from a portfolio

Factset - Finding and Extracting Data

43

0

Accordion Arrow Icon

Video minutes43

Excel Exercises0

  • How to find company information, filings and news
  • How to find and extract actual and forecast income statement and balance sheet data
  • How to find and extract equity and credit market pricing information
  • Using FactSet formulas in Excel
  • Using the Factset screening tool

Get a Wall Street Recognized Certification

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

Our exams are similar to assessments at the top firms. This means they are going to challenge you. Our online courses will teach you everything you need to know to succeed.
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.

What Our Students Say

Authored by Industry Experts

Meet Gerard Kelly, the voice of The Investment Banker

Gerard’s speciality lies in teaching financial analysis and modeling, having worked in Ernst & Young’s Corporate Finance Department. After qualifying as an accountant and CFA (all 3 levels), Gerard moved into financial training in 2008. Since then, he has delivered global training programs for the top 4 investment banks.

This course was also authored by expert instructors Alastair Matchett, Petter Ljunggren, Jonathan Rugg, and Andrew Jones.

 

THIS MICRO-DEGREE HAS BEEN REVIEWED BY

Colin Evans

Managing Director at J.P. Morgan

Colin Evans is a Managing Director at J.P. Morgan and leads the financial institutions coverage team globally for Corporate Banking

Dr. Bridget Lyons

Professor of Finance

Professor of Finance at the Jack Welch College of Business at Sacred Heart University and Associate Instructor

Chris Bishko

CFO

CFO with over 25 years experience as an operator, investor and investment banker in technology and financial services.

Frequently Asked Questions

What tech do I need?

Accordion Arrow Icon

Access your course across desktop, laptop, tablet or phone; either via our web portal or the dedicated mobile app. While we have optimized our video quality and size, we recommend a broadband connection to enable uninterrupted video playback. A PDF reader and spreadsheet application are required to open the supporting resources.

Is it right for me?

Accordion Arrow Icon

This online program reflects the training new analysts receive at the leading investment banks. It’s challenging, but if you want to demonstrate you are as good as the best in the industry then this is the course for you. The top investment banks will recognize our certification, making this perfect for graduates looking to land a job in investment banking or a professional preparing for a new role. We also reserve the right to introduce our best students to recruiters at the top 4 investment banks.

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.

Will this course help me get a job at an Investment Bank?

Accordion Arrow Icon

Absolutely. Develop practical skills you can use to impress at interviews, whether you’re looking to break into finance or change roles.

How long do I have to complete the courses?

Accordion Arrow Icon

We are delighted to announce that we now offer lifetime access on all online courses! Fit studying around your schedule. Learn at your own pace with on-demand video, practical examples to download and expert instructor support.

Are there any hidden costs?

Accordion Arrow Icon

No. Everything you need to earn your micro-degree is included, from instructor-led videos and Excel exercises to the exam.

What is CPD?

Accordion Arrow Icon

All Financial Edge online courses are CPD accredited. CPD stands for Continuing Professional Development and makes demonstrating your commitment to learning easy. Your institution or accrediting body may track CDP points through activities, units or hours. Check with the relevant party to find out how you should be monitoring your progress.