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

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

Event Details

⇒INTRODUCTION TO EXCEL AND 3 STATEMENT FORECASTING – DAY 1
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
- Understanding circular references and building a circ breaker
⇒ REAL COMPANY AND CASH SWEEP MODELING – DAY 2
This course introduces participants to the 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

Where & When

B06 Sage Hall, Johnson at Cornell University, 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 Registered42 registered

Copy Link  Open as pdf

Hosted By
Investment Banking Immersion

Contact the organizer