Wall Street Oasis has partnered with the Breaking Into Wall Street Financial Modeling Training Program to teach 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.
***NOTE: If you use the "Sign Me Up!" button below and enter your e-mail, as a Wall Street Oasis reader, when you sign up for one of the packages you will also get the full PowerPoint tutorial free! (normally costs $47)***
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 in 2008 – and you'll see 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.
Here's the full run-down:
•Financial Modeling Training covers Accounting 101 up through 3-Statement Models,Valuation, DCF Analysis, Merger Models, and LBO Models.
•206 videos total (53 hours of footage).
•33 Excel videos (7 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 shortcuts are covered.
•77 Financial Modeling Fundamentals videos (10 hours of footage).
•96 Advanced Financial Modeling Microsoft / Yahoo! Case Study videos (36 hours of footage).
•Operating Model lesson cover how to create a detailed operating model, including revenue and expense builds, complex 3-statement model, and PP&E schedule.
•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.
•Sample Excel Video – Cleaning Up Data.
•Sample Financial Modeling Training Video – Sensitivity Tables.
•Sample Yahoo! Video – Search Advertising Revenue Model.
•Sample Yahoo! Video – Valuing Yahoo's Net Operating Losses (NOLs).
•Sample Yahoo! Video – Microsoft / aQuantive Precedent Transaction.
•Sample Yahoo! Video – Advanced Purchase Price Allocation.
•Sample Yahoo! Video – Book vs. Cash Taxes & Section 382 NOLs.
•Sample Yahoo! Video – Debt Schedules: Mandatory Repayments.
•Full Financial Modeling Training Course Outline & Offer.
previous post