Pick up the specialized skills you need for your next position or upcoming deal.
Ingrain new thought patterns that apply only to your industry or niche.
Don’t start from scratch - build off the foundation we’ve set up for you.
Become fluent in all the jargon, acronyms, and Excel formulas in the space.
Professionals tasked with analyzing:
Financial Transactions Internal Business Decisions Investments… or any financial analyst working on live deals.
Build an integrated, self-balancing 3-statement model.
Round it out with a debt sweep and interest schedule to project run-rate profitability over the next 5 years.
Explore the 4 main valuation methodologies, from fundamental to relative.
Put each one into practice with a dedicated valuation model, using real historical data.
Start with reviewing the common deal structures, and how to determine the optimal ones.
After that, model everything: debt capacity, sources & uses, LBO accounting, IRR analysis, and more.
Of course, know the Five C’s of credit. Then, get your hands dirty digging through credit agreements and covenants.
Welcome to the world of distressed firms: that means restructuring, bankruptcy, DIP financing, Section 363 sales, Chapter 11, Chapter 7, 13-week cash flow (TWCF) models, and recaps.
Our industry primers are the most comprehensive overviews you’ll find. Learn just enough to become familiar with the space ASAP.
Then, you’ll build a fully functional model, complete with the standard line items, considerations, and nuances (such as tax treatments and key metrics/ratios).
Our approach is to teach you how to fish, rather than give you a fish.
We don't give a one-way lecture where you memorize every cell and formula.
We nudge you toward uncovering answers on your own by leading with the right questions.
The end result? Longer-term knowledge retention that will last an entire career.
Two things have helped me move out of a senior sales position into an investment analyst job: my CFA Charter studies and the slew of financial modeling classes I’ve taken at WST. … The payoff was instantaneous and WST has made me look very good in front of my boss!
Our Self-Study platform lets you learn at your own pace via instructor-led videos.
For Most Finance Professionals:
We highly recommend one of our focused Tracks. It includes several Packages and selected courses at a discounted price.
Explore TracksOr, if you'd prefer, pick and choose your own mix of courses below:
All prices are in USD and denote six (6) months of access. Terms apply.
Similar to the Accounting Boot Camp above, this program covers the basics of financial accounting including the major financial statements (Income Statement, Balance Sheet and Cash Flow) and the most important components of each as it relates to financial analysis. Concentration is placed on the integration of the financial statements and provides a full integrated grasp of accounting from a finance perspective.
2.5 hours / 4 hours
“How to Analyze a 10-K” builds upon basic accounting and financial statements concepts to focus on the major components of a 10K SEC filing, including the Management Discussion & Analysis, Financial Condition and Results and how to analyze the myriad of footnotes.
It’s simply not enough to merely analyze the financial statements, but especially critical to plow through and understand the footnotes and the management discussion & analysis, where the most of the qualitative information is contained. The challenge is that there are a myriad of footnotes and figuring out which are the important and relevant ones is no small feat. This course provides the overview and analysis for most major common footnotes and gives you a starting point to plow in deeper when we build our financial models. The irony is that in the process of crunching numbers and building numbers, reading comprehension, particularly on the 10K is probably even more important in terms of getting the right inputs.
2 hours / 3 hours
Learn the basic finance concepts that are the backbone of any financial analysis. An understanding of these basic core tools is absolutely critical to mastering any Wall Street analysis. Topics covered include risk / return trade-offs, time value of money, cost of capital, Gordon growth model and basic valuation theories.
Moving beyond the accounting and 10K analysis, this course provides an introduction to the major concepts in finance that many people take for granted. Understanding financial modeling, valuation, and the capital markets in general would be difficult without a full grasp of these fundamental concepts.
1.5 hours / 2 hours
Company profiles are the most basic overview and descriptions of a company being analyzed. Profiles supply the most basic and fundamental, yet probably the most important aspects of a company. Gain an introduction and explanation of the major components of a profile for a publicly traded company.
1 hour / 1 hour
Build very quick financial summary and trading statistics exhibit using historical results, analyst estimates & basic assumptions in Excel. This course will allow you to understand basic structure of building an analysis in Excel and navigating through and becoming efficient in Excel.
1.5 hours / 2 hours
Learn how corporations are valued and the major analytical tools that are used. Go beyond academic theory to real-world methods as used by professionals; includes a crucial primer to Corporate Finance and its non-theoretical application. Apply learning objectives and goals immediately by analyzing a $6 billion+ transaction. Topics covered include: (i) how to value a company (trading comps, deal comps, DCF, LBO, break-up and asset valuation); (ii) importance of Enterprise Value, EBITDA, capital structure, leverage and WACC; (iii) analyze valuation multiples and ratios; why are PE ratios sub-optimal as a valuation metric?; (iv) practical, non-theoretical application of introduction to corporate finance.
2 hours / 2.5 hours
This course builds upon, and implements in Excel, the fundamental financial analysis and valuation topics. Create a top-down, five year income statement projection model and then construct a basic discounted cash flow analysis on top of your projection model.
** Don’t get thrown off by the word “basic” - this Basic Financial Modeling serves as the fundamental basis for all of our additional Excel-based courses. Before you “graduate” onto our advanced modeling courses, we HIGHLY recommend you take this course for the full background on working efficiently in Excel the way we want you to, otherwise you may have a much steeper learning curve in our other classes. **
4 hours / 5 hours
Build upon Corporate Valuation Methodologies with a short, hands-on exercise to hone in the core concepts in practice before diving into the more advanced valuation modeling topics. Translate the valuation concepts into real-life case study that demonstrates and shows the valuation principles.
1.5 hours / 2 hours
Build a fully integrated 5-year financial statement projection model by projecting the Income Statement, Balance Sheet, Cash Flow Statement, the Debt Sweep to balance model and Interest Schedule. This course will allow you to have a complete financial model projecting run-rate profitability, on which you can easily layer valuation and merger models.
3.5 hours / 5 hours
Build upon completed core model and layer on valuation analysis. Construct DCF valuation model, detailed revenue segment build-up, project more precise depreciation schedule, calculate credit & leverage statistics and ratios, construct a reference range and football field summary valuation. This Enhancements course will allow you to have a much more detailed stand-alone financial model and valuation model!
3 hours / 4 hours
Further enhance core integrated financial model by building a detailed tax schedule incorporating NOLs (Net Operating Losses), Section 382 limitations on NOL usage and differences between book and tax depreciation. Dive deep into re-calculating depreciation for tax purposes based on accelerated depreciation - MACRS (Modified Accelerated Cost Recovery System) in the US. Incorporate and flow the accelerated tax depreciation into the larger tax schedule to account for differences in GAAP Pre-Tax Income and Taxable Income. Finish up with a quick Residual Income analysis and EVA (Economic Value Added) analysis, which complements our Enhancements Part I course.
3 hours / 4 hours
Learn how to build detailed revenue and segment build-ups into your larger financial model by quantifying the drivers of growth. Many financial projection models are based off simple revenue growth rate and expense margin assumptions, resulting in reduced precision in the projection model. This course teaches various approaches to true, bottoms-up, fundamental analysis for both publicly trade and listed companies as well as private companies or entities in which you have additional detail. We start by understanding the logic of channel checks and building the case for growth rates based on qualitative analysis and comprehension of industry- and company-specific drivers of growth. We then turn around and quantify our qualitative analysis by incorporating into our financial model on a business and operating segment basis. The results of the build-up analysis rolls into the Income Statement from your core integrated financial projection model. In addition, layer on sensitivity and scenario analysis to easily toggle through various cases, including base (management) case, upside and downside cases.
4 hours / 5 hours
Learn how corporations are valued and the major analytical tools that are used. Go beyond academic theory to real-world methods as used by professionals; includes a crucial primer to Corporate Finance and its non-theoretical application. Apply learning objectives and goals immediately by analyzing a $6 billion+ transaction. Topics covered include: (i) how to value a company (trading comps, deal comps, DCF, LBO, break-up and asset valuation); (ii) importance of Enterprise Value, EBITDA, capital structure, leverage and WACC; (iii) analyze valuation multiples and ratios; why are PE ratios sub-optimal as a valuation metric?; (iv) practical, non-theoretical application of introduction to corporate finance.
2 hours / 2.5 hours
Build a basic, quick and dirty, back-of-the-envelope trading comps analysis (analysis of selected publicly traded companies). This course will allow you to quickly construct a relative valuation analysis and serves as a critical basis for our Complex Trading Comps Analysis course.
1 hour / 1.5 hours
Relative Valuation Basics is an extracted section from Advanced Financial & Valuation Modeling - Enhancements course module. In particular, we construct the reference range and football field analysis to complete the valuation picture. We recommend taking the following courses in order to gain the holistic relative valuation view:
0.5 hour / 1 hour
Build a detailed, thorough trading comps analysis (analysis of selected publicly traded companies) and learn how to properly construct a relative valuation analysis the correct way as well as how to normalize financials for extraordinary items, non-recurring and restructuring charges. This course itself isn’t terribly complex or difficult, but is very tedious, time consuming and at times frustrating as it requires a great deal of patience, attention to detail and reading comprehension. Hence, the first four letters of the title “analyst” ring true - perfection is required to get the right numbers.
4.5 hours / 6.5 hours
Build a deal comps analysis (analysis of selected acquisitions), similar to trading comps analysis, but from an acquisition context using historical transaction data instead of current market valuation data. This course will allow you to properly construct a deal comps analysis the correct way, uncovering some of the nuances related to calculating transaction value and purchase price. This course is not a complex course and in fact, is a relative breeze compared with our Complex Trading Comps course, but builds upon the concepts in the latter course.
1.5 hours / 2 hours
The goals of this course include: (i) understand the major steps and timelines of M&A; (ii) learn how to structure an M&A deal; (iii) explore common deal structures and determine optimal deal structures such as cash vs. stock consideration, stock vs. asset deals; and (iv) accretion / dilution and breakeven analysis. This course provides the fundamental knowledge required to understand, analyze and structure mergers & acquisitions. To hone the concepts learned in this module, be sure to follow-up with our hands-on, Excel-based Merger Modeling Basics course.
2 hours / 2.5 hours
This merger modeling course builds on top of our M&A Deal Structuring course in which you will build an accretion / dilution merger consequences model. This foundational merger modeling course will allow you to quickly understand the fundamental concepts of analyzing merger implications. To maximize your learning in this module, you need to absolutely understand the concepts in our M&A Deal Structuring course! This course serves as the backdrop to our Basic and Advanced Merger as well as our Super-advanced, Complex merger modeling course.
0.6 hour / 0.75 hour
Further enhance core integrated financial model by building a detailed tax schedule incorporating NOLs (Net Operating Losses), Section 382 limitations on NOL usage and differences between book and tax depreciation. Dive deep into re-calculating depreciation for tax purposes based on accelerated depreciation - MACRS (Modified Accelerated Cost Recovery System) in the US. Incorporate and flow the accelerated tax depreciation into the larger tax schedule to account for differences in GAAP Pre-Tax Income and Taxable Income. Finish up with a quick Residual Income analysis and EVA (Economic Value Added) analysis, which complements our Enhancements Part I course.
1.5 hours / 2.5 hours
Our Intermediate/Advanced Merger Modeling course significantly builds upon our Merger Modeling Basics course. We go beyond the simple concepts of accretion /dilution and build additional precision into estimating the correct, pro forma combined earnings. First, enhance the Sources & Uses of Funds to allow for additional clarity in deal structure. Then, dive right into the fine details of the complex FASB 141/142 and IFRS 3 purchase price allocation rules and fair market value tangible assets step-up intertwined with intangibles asset allocation. We tackle and quantify the resulting nuances in deferred tax liabilities and better quantify our synergies estimates. Participants should have mastered the merger concepts and financial modeling techniques covered in our M&A Deal Structuring and Merger Modeling Basics course.
2.5 hours / 4 hours
This course provides a basic overview and introduction to leveraged buyouts, including discussion of rationale for ‘going private’, ideal LBO candidate, drivers of value. The following items are discussed, including description, importance, implications and general thoughts on: valuation, debt capacity, scenario analysis, sources & uses of funds, rollover equity, pro forma capital structure, purchase vs. recap accounting, goodwill treatment and other issues. You will gain some basic & fundamental knowledge required to understand LBO transactions. The purpose of this course is to introduce some of the terminology and concepts required for our Quick & Dirty LBO Modeling and Complex LBO Modeling courses.
1 hour / 1 hour
In the normal course of running a company, the CFO must balance capital requirements with capital sources of funds. Changes to the capital structure are not insignificant as each component of capital has an opportunity cost. In this course, we introduce the impact of changes in capital structure and the resulting impact on a company’s decision to borrow vs. raise equity. We quantify the thought process and the logic that dictates one or the other by examining both extremes of capital structure changes: from a simple small share repurchase to the opposite spectrum, the leveraged buyout. This class examines and incorporates all the major inputs and value drivers of capital structure changes by building a short, quick and dirty LBO analysis, providing an excellent condensed overview and introduction to LBO modeling. As LBOs are risky and complex financial transactions, sometimes, building a full-out, complex LBO model is not necessary or required if one just wants to quickly gauge the feasibility of an LBO.
1 hour / 1.5 hours
Further enhance core integrated financial model by building a detailed tax schedule incorporating NOLs (Net Operating Losses), Section 382 limitations on NOL usage and differences between book and tax depreciation. Dive deep into re-calculating depreciation for tax purposes based on accelerated depreciation - MACRS (Modified Accelerated Cost Recovery System) in the US. Incorporate and flow the accelerated tax depreciation into the larger tax schedule to account for differences in GAAP Pre-Tax Income and Taxable Income. Finish up with a quick Residual Income analysis and EVA (Economic Value Added) analysis, which complements our Enhancements Part I course.
2.5 hours / 4 hours
The goal of this course is quite simple and yet extremely complex in implementation: build an all-out, full combination and merger analysis of target and acquirer company, integrating full projection model for both. This course will allow you to build one of the most dynamic, sophisticated and complex merger models out there, slapping together complete Income Statement, Balance Sheet, Cash Flow Statement, brand new, highly complex Debt Sweep and Interest schedule for the two companies and combined merged entity. Determine deal structure, purchase price allocation and tax deductibility, accretion / dilution and a whole host of issues.
Learning objectives include: (i) calculate Sources & Uses of Funds, post-transaction ownership, accretion / dilution; (ii) combine Target and Acquiror Income Statements and incorporate synergies into pro forma merger model; (iii) calculate pro forma, post-transaction opening Balance Sheet and project future combined Balance Sheet; (iv) derive combined Cash Flow Statement, dept sweep & interest schedule to balance and integrate model.
The core LBO model serves as the beginning model for the target company in this Complex, Super-Advanced Merger Modeling course and as such, you must have completed the Complex LBO Modeling course first to have the model!
5 hours / 10 hours
Layer a complex LBO model on top core standalone projection model and build one of the most dynamic, sophisticated and complex LBO models out there. This is a highly complex and a very advanced modeling class and requires an absolute grasp of all basic and advanced accounting and financial concepts. Your finished LBO model will be a highly versatile and functional financial model able to capture and sensitize a great deal of inputs to project a realistic and more precise outcome including the ability to toggle between status quo, standalone model vs. all-out LBO vs. partial recap. The core LBO model serves as the beginning model for the target company in our Complex, Super-Advanced Merger Modeling course.
Significantly enhance the LBO model by incorporating the following: PIKs (Paid-In-Kind), warrants and partial, less than 100% recapitalization. Further modify LBO model for mezzanine debt, non-cash interest, issue warrants and modify equity acquired. Incorporate all enhancements into end-all IRR analysis by significantly scaling out returns calculation via massive triangulation of cash flows.
8.5 hours / 10 hours
Learn how to analyze and value distressed companies and securities undergoing restructuring or bankruptcy process. First, appreciate and understand the historical perspective and context of the distressed market. Then, explore various opportunities in distressed investing from securities types to investment strategies. Properly identify and isolate the true sources and drivers of returns from supply & demand to operational changes to market rebound to recapitalizations. Quantify and comprehend the dramatic changes to a distressed firm’s capital structure and the implications on the valuation process and realignment of economics. Understand the reorganization and bankruptcy process, including DIP (debtor-in-possession) financing, Section 363 sales (stalking horse), Chapter 11 reorganization, and Chapter 7 liquidation. Fully comprehend the key critical covenants required involved in distressed securities as well as the entire turnaround & restructuring process by identifying key parameters for successful business plan implementation.
2.5 hours / 4 hours
Learn how to model and value distressed companies and securities undergoing restructuring or bankruptcy process. Build upon our Distressed Investing Overview course by quantifying the dramatic changes to a distressed firm’s capital structure and the implications on the valuation process and realignment of economics. Build robust distressed sensitivity financial model. Learning objectives include: model out sample distressed company on a standalone basis, with and without restructuring; incorporate detailed valuation sensitivity to identify key value drivers in a distressed situation; analyze the fulcrum security based on various valuation and leverage scenarios.
3 hours / 5 hours
Balance sheet based companies, such as banks, play by different rules and methodologies based on the unique nature of their business. Focus is placed on our Commercial Banks financial statements primer which dives deep into a bank’s unique financial statement terminology and drivers. Understand how to analyze a bank and why the standard financial analysis and valuation methodologies that apply to most companies do not apply to industries that “use money to make money”. Start with a brief overview of the main banking functions (commercial, investment, asset management) and quickly turn to the quality of book of loans and analysis of net vs gross charge-offs vs provisions, etc. Understand the critical credit ratios and capital adequacy analysis as well as Tier 1 and II definitions and Basel II impact. Crystallize the impact of Interest Rates, importance of term structure and credit spreads and implications on a bank’s profitability. Examine best practices in calculating net interest income via average asset and liability balances on the income statement. Dive into an analysis of Balance Sheet assets & liabilities and articulate the drivers of EPS growth. Wrap up by analyzing valuation parameters: key banking valuation multiples (PE, PEG, Book Value, ROE).
2.5 hours / 4 hours
Build a basic, streamlined bank financial model that builds upon the bank terminology in our Bank Industry Primer course. Before diving deep into the complex nuances of our Advanced Bank Financial Model, really solidify your understanding of developing the logic in loan losses and provisions and its impact on the rest of the larger bank financial statements. Perform quick back-of-the-envelope calculations for key Balance Sheet items such as Interest Earning Assets and Interest Bearing Liabilities, which yield Net Interest Income. Estimate and calculate capital adequacy ratios to wrap up your summary simplified basic bank model.
2 hours / 3 hours
Construct a more robust bank financial model by building a bank balance sheet and derived income statement. Project gross loan balance, provisions for credit losses, gross charge-offs, recoveries, net charge-offs, net loan balance based on important key trends and ratios. Predict the critical funding requirements on the liability side of the balance sheet to support the loans and asset side. Learn the techniques and best practices to balancing the bank model. Examine different techniques to estimate the crucial interest-earning assets and interest-bearing liabilities. Estimate asset yield, funding costs and net interest spread to minimize forecasting error. Identify line items that constitute non-interest fee revenue beyond using simple percent growth rates. Incorporate and integrate provision for credit losses. Calculate compensation and overhead expenses and leave with a completed balance sheet and income statement. Make sure you master the concepts in this Intermediate class before diving into our Advanced Bank Financial Modeling course.
2 hours / 3 hours
The standard financial analysis and valuation methodologies that apply to most companies do not apply to industries that “use money to make money”. Balance Sheet based companies, such as banks, play by different rules and methodologies based on the unique nature of their businesses. First, start off with an interactive primer on commercial banks and their financial statement terminology and drivers. Then, build a fully integrated bank financial model that addresses the key drivers of profitability, cash flow, and valuation. Focus is placed on: projecting the Balance Sheet line items which drive the entire model; estimating interest-earning assets and interest-bearing liabilities which drives profitability; projecting loan portfolio growth, provisions for credit losses, and net charge-offs which determine overall impact on the financial statements. Complete the model by projecting different fee revenue sources and integrating the Cash Flow Statement. Finish the model by calculating and analyzing capital adequacy ratios, financial performance indicators and valuation metrics.
5 hours / 9 hours
Balance sheet based companies, such as insurance companies, play by different rules and methodologies based on the unique nature of their business. Focus is placed on our Insurance Industry primer which dives deep into an insurance company’s unique financial statement terminology and drivers. Distinguish between P&C (Property & Casulaty) and L&H (Life & Health) insurance companies. Comprehend all the major players along the insurance spectrum from retail to wholesale brokers, to MGAs and MGUs and captive carriers and much more. Understand the different types of insurance, reinsurance and their financial statement impact. On the Income Statement, differentiate between the different types of premiums (direct, ceded, net, written, earned); comprehend loss triangles and the main differences between statutory vs GAAP accounting. On the Balance Sheet, understand key assets line items (premiums receivable, reinsurance recoverable, prepaid reinsurance premiums) as well as the liabilities (loss & lae reserve, unearned premium reserve). Understand insurance valuation parameters: key insurance multiples (PE, book value, premium/surplus).
2.5 hours / 4 hours
Build a basic, streamlined insurance company financial model that builds upon the insurance financial statements terminology in our Insurance Industry Primer course. Before diving deep into the complex nuances of our Advanced Insurance Company Financial Model, really solidify your understanding of the major items on an insurance company’s Income Statement and Balance Sheet. Take the time to further immerse yourself with understanding insurance.
1.5 hours / 3 hours
Build a fully integrated, scalable, new insurance company model including detailed build-up by line of business from Gross Written Premiums to Net Premiums down to Underwriting Income. Consolidate the lines of business performance into a GAAP Income Statement with statutory adjustments. Integrate income statement projections with a self-balancing balance sheet, an automated cash flow statement and the balancing cash flow sweep schedule. Learning objectives include: build an integrated set of financials, including LOB, income statement, balance sheet & cash flow; project direct, ceded and net premiums and underwriting income based on assumed loss triangles; consolidate multiple lines of businesses, calculate GAAP and Stat Net Income with Tax Schedule; project self-balancing balance sheet including items such as premiums receivable and recoverables.
5 hours / 9 hours