Learn essential finance & accounting concepts while building a comprehensive discounted cash flow (DCF) model in Excel. In this 3-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.
“I can honestly say I learned more useful modeling and excel skills from the Financial Modeling Bootcamp then I have through one and a half years of business school. The course effectively conveys key finance, corporate finance, and financial accounting concepts while also offering students the opportunity to build real financial models with real-time data. The 7:1 student to teacher ratio along with the experience and modeling expertise of Mourad offers a unique opportunity for a personalized learning experience. Whether you are a student looking to pursue a career in finance or a current professional simply looking to brush up on your Excel skills, I would highly recommend this course.”
“This was a great refresher course for some of the deeper financial concepts I have not used since undergrad. I think this course is phenomenal for recent college grads starting off their careers in finance or budget. It's a great intro for learning to navigate excel shortcuts. I am 5 years in my career now and have never had the investment banking background but still have been a financial analyst and been involved in raising capital so the concepts covered were a great refresher for me.”
“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 perform 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.
Register for this class
594 Broadway, NYC
This course is offered at our business training school, NYIM Training, in Midtown Manhattan. Register for this course directly on NYIM’s website.