Banker Analyst Program Bundle

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.