This Premium Financial Modeling Program includes the 2 core products – Excel & Modeling Fundamentals and Advanced Modeling – and teaches you everything you need to know about financial modeling, from how to use Excel to Accounting 101, to how to model and value companies, and how to create merger models and LBO models.
In addition to learning everything you need for interviews, internships, and full-time work, you’ll also go back in time and pretend the Microsoft-Yahoo acquisition happened – and you’ll learn how to build a detailed operating model, value the company, and complete advanced merger/LBO models, using real 10-K/10-Q filings and real equity research from Morgan Stanley, Credit Suisse, and other banks.
Program Modules
Module 1: Navigation & Data Manipulation
Module 2: Formatting
Module 3: Formulas
Module 4: Accounting Fundamentals
Module 5: Creating 3-Statement Projections
Module 6: Equity Value, Enterprise Value & Multiples
Module 7: Valuation Overview & Comparables
Module 8: Discounted Cash Flow Analysis
Module 9: Valuation Summary
Module 10: Merger Model
Module 11: LBO Model
Module 12: More Advanced LBO Model
Module 13: Advanced Financial Modeling: Yahoo! Operating Model
Module 14: Advanced Financial Modeling: Yahoo! Valuation
Module 15: Advanced Financial Modeling: Microsoft / Yahoo! Merger Model
Module 16: Advanced Financial Modeling: Yahoo! LBO Model
Module 17: Advanced Financial Modeling: Deal Commentary & Pitch Book
What do you get when you sign up for the course?
✓Financial Modeling lessons cover Accounting 101 up through 3-Statement Models,Valuation, DCF Analysis, Merger Models, and LBO Models.
✓248 videos total (63 hours of footage).
✓Excel lessons include navigation, data manipulation, formatting, formulas, and advanced topics like pivot tables, macros, and custom shortcuts.
✓Both Excel 2003 and Excel 2007 / 2010 shortcuts are covered.
✓Operating Model lessons teach you how to create a detailed 3-statement model, including revenue and expense builds, noncontrolling and equity interests, PP&E schedules, deferred taxes, and quarterly projections.
✓Valuation lessons cover how to spread comps, adjust for non-recurring charges, calendarize financials, how to value NOLs and equity investments, and how to complete advanced DCF analysis including mid-year discounts and stub periods; you’ll also learn future share price analysis, sum-of-the-parts valuation, and liquidation valuation.
✓Advanced Merger Model covers how to combine all 3 statements, multiple scenarios, advanced purchase price allocation, how to calculate revenue and expense synergies by segment, and book taxes, cash taxes, and Section 382 NOLs.
✓Advanced LBO Model covers how to modify an operating model to make it into an LBO model, 7 debt tranches, multiple capital structure scenarios, and an advanced debt schedule with mandatory and optional repayments.
✓Includes sample pitch book and PowerPoint crash course as well as commentary on the deal.
✓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 : $347
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 through and get the bonus.
