Banker Analyst Program Bundle

Courses included - Financial Statement Analysis; M&A Accounting; Financial Modeling - Fundamentals; Financial Modeling - Cash Sweep; Valuation Fundamentals; Trading Comparables Valuation; Transaction Comparables Valuation; DCF Valuation; LBO Analysis Fundamentals; Capital Markets and Corporate Funding; Debt Capital Markets and Equity Capital Markets

View video to get a brief overview of the course

Included in this bundle

Financial Statement Analysis (FSA)

This module is designed for participants with some familiarity with the basics of accounting but wishing to deepen their understanding of the three key financial statements. You will learn how they are constructed, how they can be forecasted and how we use them to calculate ratios to better understand how businesses compare to one another. Confidence with FSA will enable you to apply this knowledge in areas including valuation and forecast modeling.

M&A Accounting

Develop an understanding of the line items on financial statements that arise when a business makes investments in other businesses. The course covers investments ranging from small, non-influential equity stakes, to full acquisitions and all key related accounting impacts. Confidence with this material is essential for many real-world valuation and modeling tasks.

Financial Modelling - Fundamentals

Learn to build a detailed, fully integrated three statement forecast model for a corporate. You will learn best practice in formula construction and how to use keyboard shortcuts to eliminate use of the mouse. Throughout the training you will learn the tried and tested habits and techniques to minimize errors, and make models easy to interpret, adapt and audit.

Financial Modelling - Cash Sweep

Learn to build a detailed, fully integrated three statement forecast model for a corporate with high leverage, as well as how to model an automated, debt pay-down such that the business will reduce its debt as fast as possible, without impacting the operational needs of the firm. You will learn best practice in formula construction and how to use keyboard shortcuts to eliminate use of the mouse, whilst learning tried and tested habits and techniques to minimize errors, and make models easy to interpret, adapt and audit.

Valuation Fundamentals

Learn the basics of the three main techniques used to value businesses and shares - Relative Value, Discounted Cash Flow (DCF) and Levered or LBO Valuation. In doing so you will also learn the distinction between equity value and enterprise value, and when each is appropriate to analyze.

Trading Comparables Valuation

Learn the basic mechanics of Excel, how to use Excel to complete a variety of financial tasks and how to build a functional model that involves a variety of related metrics and assumptions. You will learn Excel best practice throughout, and how to use Excel shortcuts to make you more efficient.

Transaction Comparables Valuation

In order to value a business that might be bought or sold, we learn how to look at historical acquisitions of similar businesses, to estimate a fair transaction or takeover value of a business. This session is complementary to Trading Comparables Valuation, but rather than listed peers, looks at recent historical deals where control was achieved by the buyer, to give a sense or fair value in a transaction context. This technique is used in M&A advisory and Private Equity to estimate the value of an entire business and the synergies that might be achieved by a buyer, rather than a small parcel of shares.

DCF Valuation

Learn to follow best practices in generating a forecast model and Discounted Cash Flow (DCF) valuation of a business using ‘fundamental valuation’ techniques. DCF can be used on a wide variety of business and is used by equity research and institutional investors as well as parties valuing entire businesses such as corporate or ‘strategic’ buyers/ sellers, Private Equity (PE) funds and financial sponsors and advisory firms.

LBO Analysis Fundamentals

Learn how financial sponsors select appropriate target businesses, the typical funding structures they use to acquire these target businesses and the way they generate a return, or IRR for their investors through a sale or ‘exit’ at the end of the LBO.

M&A Analysis Fundamentals

This course covers the basic steps of analyzing an acquisition - covering the impact of a deal on the financial statements with a particular focus on EPS, PE and contribution analysis. By the end of the course, you will build an accretion / dilution model using EPS forecasts and acquisition assumptions, proforma leverage ratios and a proforma balance sheet.

Capital Markets and Corporate Funding

Explore the way in which capital markets connect the world’s issuers, to the world’s investors, with the assistance of the financial industry. The major global investors and issuers are covered in some detail, along with the main features of the key funding instruments; debt and equity. You will then examine some of the ways in which the corporate makes decisions on the equity and debt mix in their business.

Debt Capital Markets

This course covers the main debt products available to corporates. Using a case company, the debt capacity is calculated before different funding options. Both long and short term, and public and private financing options are explored. Finally, the bond issuance process and key documentation are discussed.

Equity Capital Markets

This course will cover the main products of the equity capital markets. Using a case company, you will tour through the equity capital markets, embracing IPOs, secondary offerings, and different share classes. Finally, listing rules and some of the subtleties of the pricing of equities are examined.

41 hours of video content.

Estimated 82 hours to complete.

How to access your course

  • Checkout and pay for the course(s).
  • Your course(s) will be added to your DELTA account.
  • You will then receive an email with joining instructions.
  • You will have 12 months access from date of purchase.

Pre-requisites

This course is open to all. To maximize the benefit of this course we recommend an understanding of Microsoft Excel.

Technical Requirements

You will need an Internet connected device to access the videos and download supporting resources. Supporting resources can be used offline, which require Microsoft Excel 2003 or later and a PDF reader.

Comprehensive Resources

You’ll be able to easily access all of the materials you need through our learning management system DELTA

  • Bite-size trainer led HD videos detailing step by step techniques and best practices.
  • Download the slides and files as used in the videos, which can be completed while watching or saved for later.
  • Open forum for quick problem solving.

Public courses available for