Learn essential finance & accounting concepts while building a comprehensive discounted cash flow (DCF) model in Excel. In this 2-day intensive financial modeling class, you’ll go from beginner to advanced in Excel skillset; learn Finance, Accounting, and Corporate Valuation; and build a comprehensive Financial Model on a real company.
Excel Techniques including Data Validation, CHOOSE, Data Tables, Goal Seek and more
Leveraged Buyouts (LBO) Modeling
Real Company Analysis
Setup the Financial Model and model projections
Corporate Valuation and derive a value per share
Analyze the Model Output
Learn Essential Finance & Accounting Concepts
The first day of the financial modeling class will cover the essential finance and accounting concepts necessary to build larger financial models. At the end of the first day you will have a brief take-home assignment to review a public company presentation and certain financial exhibits (we provide the company, and it takes approximately 1 hour to complete).
During the second day you will build a comprehensive financial model using a real company’s data and historical financials. You’ll calculate the financial ratios, project future cash flows, and derive a value per share.
“Took the two day Financial Modeling Bootcamp. Extremely informative and useful. Smaller class size allows for one on one help and enables you to really understand the material you are working through. Additionally you build out a model on an actual company during the course, allowing you to preform the same kind of analysis you would use in a real office setting, as opposed to looking at generic accounting problems. Office itself is very nice, and the professors are extremely well informed. 10/10 would recommend to anyone looking to develop, sharpen, or reestablish their financial modeling skills.”
Attended Financial Modeling Bootcamp
“Great experience, I highly recommend for anyone looking to break into consulting/banking!”
“Smaller class size allows for one on one help and enables you to really understand the material you are working through. Additionally you build out a model on an actual company during the course, allowing you to preform the same kind of analysis you would use in a real office setting, as opposed to looking at generic accounting problems.” Robert F.
Industry Professional Instructors
All of the Financial Modeling instructors are industry professionals who draw on their experience to teach from real-world examples. By the end of the course, you’ll be able to easily apply the finance and accounting concepts you learned to your professional career.