Introduction to Excel and 3 Statement Modeling

Overview

This course 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