Build a Financial Statement Model

Course details

Financial Statement Modeling is an essential skill for students embarking on a career in finance and for IB professionals looking to set themselves apart. Learn how to build complete, dynamic financial statement projection models in Excel from scratch, using a real-life Apple case study. Lessons Include:

• Excel shortcuts and functions frequently used in financial modeling
• Excel settings and formatting best practices for financial modeling
• Creating model plugs via the revolver and cash sweep
• How to efficiently check models for errors, accuracy and integrity
• Building a fully integrated three statement model using established conventions for forecasting and schedule design
• Dealing with circularities in the model
• Balancing the model and inserting automated checks
• Perform sensitivity & scenario analysis