Participants will learn how to build a three statement model using a detailed revenue forecast with price and volume drivers. A full debt schedule, including a cash sweep, is incorporated into the model. In addition to the main class case model, participants are given exercises to help them understand more complex modeling issues (e.g. detailed depreciation schedules and working capital items). Common errors are covered from balancing a non-balancing balance sheet to debugging a model that is non-intentionally circular.
In reality, more time is wasted trying to find out why your model does not balance than the time you took to build it in the first place. This program focuses on useful tips and tricks that can be used to interrogate the data in financial models and useful methods for finding errors quickly. It will also provide tips and tricks to reduce errors in the first place.