Excel & Financial Modeling Fundamentals teaches you Excel and financial modeling from the ground up – everything you need to ace your investment banking and private equity interviews.
The course is based on a case study of Apple and Research in Motion, using real SEC filings and equity research from investment banks such as Credit Suisse.
You’ll learn everything from Accounting 101 and Valuation all the way up through Merger Models and PE interview-ready LBO Models.
On the Excel side, you’ll start with navigation basics and formatting and go all the way up to formulas, macros, and advanced topics like pivot tables.
You’ll also get to practice yourself with the exercises included within each course – and all the videos are captioned with the key Excel shortcuts you need.
What do you get when you sign up for the course?
✓Financial Modeling Fundamentals Lessons cover Accounting, 3-Statement Projections, Equity Value, Enterprise Value & Multiples, Valuation, Discounted Cash Flow Analysis, Merger Models, and Basic and More Advanced LBO Modeling.
✓Excel Lessons cover navigation, manipulating data and worksheets, formatting, formulas, and advanced topics like lookup functions, pivot tables, macros, and custom shortcuts.
✓148 videos total (27 hours of footage).
✓Both Excel 2003 and Excel 2007 / 2010 shortcuts are covered.
✓11 lessons on data manipulation, 10 lessons on formatting, and 12 lessons on formulas.
✓24 lessons on Accounting fundamentals and over a dozen accounting interview questions; 15 lessons on building 3-statement models and balancing a balance sheet.
✓12 lessons on Equity Value, Enterprise Value & Multiples and 11 lessons on public company comparables, precedent transactions, and valuation.
✓14 Discounted Cash Flow lessons covering projections, terminal value, discount methodology, and calculating WACC.
✓14 Merger Model lessons on accretion / dilution, synergies, pro-forma balance sheet adjustments, and sensitivity tables.
✓25 LBO Model lessons covering both a basic model (no balance sheet) and a more advanced model with all 3 statements, pro-forma balance sheet, and debt schedules with 5 tranches of debt from Revolver to PIK.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Free lifetime updates and support.
Full Course Price: $197
Here’s a bonus for you!!
If you enroll to this program through this page, you will get :
✓ PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
