Udemy - Build a Financial Statement Model

Build and analyze financial models the way it's done on the job. Includes a complete Financial Statement model in Excel.

Course Description

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

What are the requirements?

The program assumes an introductory knowledge of accounting and corporate finance, as well as proficiency in Excel.
What am I going to get from this course?

Over 59 lectures and 11 hours of content!
At course completion, you will have developed a comprehensive "Wall Street quality" three-statement model using various supporting schedules.

What is the target audience?

Investment banking professionals and students seeking a lucrative finance career