Johnson at Cornell University | Groups
Financial modeling and Excel - Stream 2 (Advanced)
Saturday, March 22
8:00am – March 23 at 5:00pm EST
B08 Sage Hall
Johnson at Cornell University, Sage Hall Cornell University, Ithaca, NY 14853, United States
Registration Options

Registration is now closed (this event already took place).

Event Details

Financial modeling and Excel – Stream 2 (Advanced)
? INTRODUCTION TO EXCEL AND 3 STATEMENT FORECASTING – DAY 1 AM
This session will introduce participants to Excel and the fundamentals of 3 statement modeling. Participants will
learn how to forecast the 3 financial statements, balance a model and handle issues related to circularities. Best
practices will be incorporated throughout the course.
? Excel and modeling fundamentals
- Optimal excel settings
- Key shortcuts
- Formula construction
- Matrix integrity
? 3 statement modeling
- Steps to building a model
- Income statement construction
- Supporting calculations and debt schedule
- Balance sheet and cash flow statement construction
- Balancing the model

?REAL COMPANY MODELING – DAY 1 PM
Building on the previous session, this course introduces participants to the complexities associated with a real
company model. Topics covered include:
- Excess and operating cash
- Multiple tranches of debt
- Operating working capital based on days
- Noncontrolling interest
- Equity method investments


? REAL COMPANY AND CASH SWEEP MODELING – DAY 2 AM
This course introduces participants to more complexities associated with a real company model and incorporates a
cash sweep debt schedule.
- Incorporating complex assumptions associated with a real company
- Uses of a cash sweep model
- Steps to building a cash sweep model
- Handling mandatory and accelerated debt payments


?CHECKING A MODEL – DAY 2 PM
Participants will be given several models and asked to identify and correct errors within the models. Emphasis will
be placed on a systematic approach to uncovering all errors and correcting the model. The module will conclude by
giving participants a model filled with errors and they will use a systematic approach to uncover and correct all
errors.
- Methods to identify errors
- Steps to checking a model
- Common modeling errors
- Fixing the model


? EDITING A MODEL – DAY 2 PM
Participants will be given a completed model and asked to make several changes.
- Impact of transactions on the model
- Tracing precedents and dependents
- Impact of each edit on the model
- Best practices for editing the model
 

Where & When

B08 Sage Hall, Johnson at Cornell University, Sage Hall Cornell University, Ithaca, NY 14853, United States

Saturday, March 22, 8:00am – Sunday, March 23 at 5:00pm

Download: Outlook · Google Calendar

Number Registered50 registered

Copy Link

Hosted By
Investment Banking Immersion

Contact the organizer