# Ultimate Banker Bundle

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

#### Included in this bundle

Financial Math for Financial Markets

Gain comfort with the core, fundamental mathematical techniques used throughout the financial industry, with an emphasis on the time value of money.

Accounting Bootcamp: Financial Statement Basics

Familiarise yourself with the three key financial statements, the Income Statement, Balance Sheet and Cash Flow Statement, to understand how the three statements give us a variety of information about the performance and current state of a business. This module introduces financial statements with no assumption of prior knowledge.

Excel Fundamentals - FREE COURSE

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.

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 the 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.

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.

Learn in detail how to perform an accurate and meaningful trading comparables valuation of a target business relative to its publicly traded or ‘listed’ peers. This technique 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.

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.

LBO Modeling

Learn how to structure an LBO and model the impact of the new financing structure. The focus of this course is to build out a fully integrated model with an income statement, balance sheet and cash flow statement, together with a detailed analysis of the financing structures and returns.

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.

M&A Modeling

In this course, you will learn to build a comprehensive, three-statement merger model. All key assumptions required, and outputs of such an analysis will be explored with an emphasis on the impact on the financials of the buyer in a strategic acquisition.

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.

67.75 hours of video content

Estimated 135.5 hours to complete.

#### How to access your course

• Checkout and pay for the course(s).
• 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.