Ultimate Banker Bundle
View video to get a brief overview of the course
Included in this bundle
Gain comfort with the core, fundamental mathematical techniques used throughout the financial industry, with an emphasis on the time value of money.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
- 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.
This course is open to all. To maximize the benefit of this course we recommend an understanding of Microsoft Excel.
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.
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.
Courses in this bundle
- Financial Math for Financial Markets
- Accounting Bootcamp: Financial Statement Basics
- Excel Fundamentals - FREE COURSE
- Financial Statement Analysis (FSA)
- M&A Accounting
- Financial Modelling - Fundamentals
- Financial Modelling - Cash Sweep
- Valuation Fundamentals
- Trading Comparables Valuation
- Transaction Comparables Valuation
- DCF Valuation
- LBO Analysis Fundamentals
- LBO Modeling
- M&A Analysis Fundamentals
- M&A Modeling
- Capital Markets and Corporate Funding
- Debt Capital Markets
- Equity Capital Markets