2-DAY PUBLIC SESSION | 3-DAY VIRTUAL SESSION
Financial Modeling Boot Camp
More details about this course:Step-by-Step – Your Modeling Skills Come Together With Ease
This rigorous, hands-on class will cover the essentials step-by-step, and you will quickly discover how to put the power of what you know into building a dynamic, robust financial model. Confidently, you’ll know how to:
- Logically plan, design and layout a model that works in your environment
- Use Excel to it’s fullest potential to help in the building process
- Build a Financial Model, Integrating Financial Statements
- Create Financial Forecasts Based On Your Model
- Analyze And Value a Company Or Project
- Test and retest your results for robustness and accuracy
- Confidently present your results to management and make informed decisions
Immediately Useful Benefits of Attending This Two-day Boot Camp
- Learn to logically arrange the parts of your model and understand the design principles behind good modeling
- Learn how to create macros for your repetitive modeling functions and how to record them
- Understand how to use Excel Macros to their fullest potential in your model building to save you time and frustration
- Gain the comprehensive skills sets you need to become a capable Financial Modeler
- Know what toolbox functions you’ll need and which to customize to suit your needs
- Understand scenario testing and other testing techniques you will need before you go “live” with any model
- Know how to accurately record historical and projected operating assumptions into your model
- Know how to confidently combine all valuation methodologies into your financial modeling process
- Easily link your income statement, balance sheet and statement of cash flows
- Know how to quickly detect errors in formulas and how to correct them without adverse effects
- Incorporate the best designs for usable spreadsheets, using input cells, cell names and financial functions
- Understand how to accurately import all of your financial data into your model
- Create a flexible and robust financial model that can easily incorporate your own needs, changes and modifications over time
- Become a pro at sensitivity analysis using the data tools available to you
- Incorporate graphics and logical layout to create a “Presentable” model to professionally communicate results to others
- Know how to link all of your worksheets for interactive modeling and valuation
- Master the skills to create a model that will work for all types of valuations in all types of business and industry
- Learn to rely on the Excel financial functions and tools that are already available to you
- Learn from a renowned course developer and course instructor with years of successful investment experience and solid teaching abilities
- Quickly get up to speed as you "learn by doing” in this hands-on class — enjoy a fast-paced, boot camp approach to learning
|