Please note: Each daily session goes from 8AM – 5PM EST View Full Syllabus
Day 1 | FINANCIAL STATEMENT MODELING
You will develop a 3-statement model completely from scratch, inputting historical data and assumptions to project out financial statements by selecting, locating, and developing appropriate projection drivers.
Day 2 | DCF MODELING
Participants learn how to value the company step-by-step, including how to estimate the weighted average cost of capital (WACC) in the real world, how to implement commonly used approaches to calculating terminal value, and how to use data tables to analyze a broad range of scenarios given different assumptions.
Day 3 | M&A MODELING
Participants will build a merger model in Excel to reflect the pro forma impact of various acquisition scenarios. Key topics covered include a quick test of accretion / dilution in all-stock deals, pricing structures (exchange ratios, collars, “walk-away” rights), purchase accounting, and the step-by-step allocation of purchase price.
Online | PRE-SEMINAR EXCEL TRAINING
This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.
Online | POST-SEMINAR ONLINE ACCESS
Enrollment includes lifetime access to the following online course(s): Financial Statement Modeling, DCF Modeling, Comps Modeling, M&A Modeling, LBO Modeling