The Complete Step-By-Step Financial & Valuation Modeling Program
Complete Modeling Package. Everything you might want to grasp monetary modeling: Learn DCF, Comps, M&A, LBO and Financial Statement Modeling on this all-in-one assortment of modeling programs.
Everything you might want to grasp monetary modeling!
Used broadly at funding banks and monetary establishments globally, the Premium Package is designed for college students and professionals pursuing careers in Investment Banking, Private Equity, Corporate Finance and Equity Research. The step-by-step program makes use of an actual case examine method and is designed to imitate the expertise of a monetary analyst.
What You’ll Learn
Financial Statement Modeling
Financial Statement Modeling is the muse of all subsequent valuation modeling modules. Trainees learn to construct full, dynamic monetary assertion projection fashions in Excel from scratch, utilizing actual case research, business greatest practices, and sensitivity analyses. Simple, intuitive, step-by-step directions reinforce theoretical instinct whereas instructing the mechanics of the mannequin constructing course of.
DCF Modeling
Build a whole, working discounted money movement (DCF) mannequin in Excel from scratch, utilizing an actual case examine, business greatest practices, and sensitivity analyses. DCF evaluation is each academically revered and broadly used on Wall Street as a major methodology of valuation. Many finance interview questions particularly take a look at a candidate’s understanding of each the lecturers and mechanics behind the DCF.
Accretion Dilution (M&A) Modeling
How do professionals at funding banks, personal fairness companies and different monetary establishments analyze the impression of mergers & acquisitions? In this course, you’ll learn to construct an actual M&A (accretion/dilution) mannequin in Excel from scratch. In addition, you’ll construct a contribution, synergy and change ratio evaluation, and study key M&A accounting ideas.
LBO Modeling
LBO fashions are used broadly by funding banks and personal fairness companies to evaluate investor returns in addition to to worth a enterprise within the occasion of a buyout. You will construct an actual leveraged buyout (LBO) mannequin from scratch, utilizing actual case research, business greatest practices, and sensitivity analyses.
Trading Comps Modeling
“Comps” evaluation is the quickest, most generally used valuation methodology, and basic a part of the core valuation talent set of funding bankers and finance professionals. In this course, trainees learn to choose and “scrub” comparables, decide the suitable multiples and construct dynamic comps fashions in Excel from scratch, utilizing actual case research, business greatest practices, and sensitivity analyses.
Transaction Comps Modeling
Transaction comps (aka deal or transaction comps) is a variant of comparables valuation. Value of the agency is derived by assessing the worth of comparable firms not too long ago acquired. In this step-by-step, actual case examine course, you’ll learn to choose comparable acquisitions, discover necessary disclosures in filings, unfold the info and construct a whole transaction comps mannequin in Excel.