Johnson at Cornell University | Groups
Financial modeling and Excel - Stream 1 (Basic)
Saturday, March 22
8:00am – March 23 at 5:00pm EST
B06 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

⇒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, 8:00am – Sunday, March 23 at 5:00pm

Download: Outlook · Google Calendar

Number Registered42 registered

Copy Link

Hosted By
Investment Banking Immersion

Contact the organizer