Overview
Utilizing an annual report and Excel, participants will spread historicals for both the income statement and balance sheet and derive assumptions, after which participants will build the model using the techniques learned in prior sessions.
- Setting up a flexible model template
- How to properly group accounts
- Cleaning earnings
- Determining forecast assumptions (key drivers, equity research estimates and consensus)
- Operating model structures
- Cash sweep vs. non-cash sweep
- Detailed revenue build