DISCLOSURE: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.
- How much do you know about accounting?
- Can you walk me through a valuation?
- What happens in a merger model or LBO model when you adjust the assumptions...
- How would you describe your financial modeling skills?
 |
| Financial Modeling and Valuation From Beginner to Pro |
When you master real-world techniques and case studies, you have a significantly better chance of landing prime jobs and internships with the top investment banks, private equity firms, and hedge funds.
Excel & Financial Modeling Fundamentals lets you gain all that real-world knowledge via video-based training created by investment bankers.
You'll get a total of 120 videos – everything you need to beat the competition in interviews and get a head start before you start working.
MUCH MORE THAN THEORY
We base everything in the Excel & Financial Modeling Fundamentals course on what investment bankers actually do in real life:
- The Excel lessons are based on two real-life case studies: how to format, manipulate, and analyze customer due diligence data, and how to build and format a 3-statement model and valuation of Apple.
- The Financial Modeling Fundamentals lessons are based on cases studies involving companies such as Apple,
Through these case studies, you'll discover how to:
- Use Excel and master all the shortcuts – in any modern version of Excel, on both the PC and Mac.
- Build a 3-statement projection model and answer accounting questions in interviews.
- Value a company – how to find public comps and precedent transaction and get the right data, and how to build a DCF model to value a company based on its future cash flows. And then how to use the valuation output in a stock pitch, a pitch book, and an equity research report.
- Create a merger model – learn what happens when one company acquires another one, how to evaluate accretion/dilution and other metrics, and how to use the financial metrics to advise your clients on what to do.
- Build LBO models – how to set up the assumptions, create debt schedules, model interest and principal repayments, and calculate the IRR and MoM multiples... and then make an investment recommendation.
Who this course is for:
- anyone interested in Investment and finance
- Business Students
- Finance Students
- Investment
- Financial Modeling & Analysis
- Accounting
- Economics
- Investing & Trading
- Get the course
