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

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, Sage Hall Cornell University, Ithaca, NY 14853, United States

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

Add to Calendar:  Outlook  Google Calendar

Number Tickets Sold50 tickets sold

Copy Link

Hosted By
Investment Banking Immersion

Contact the organizer