Build a 3-Statement Financial Model with Valuation in 3 Phases:
- Populate Historical Data
- Forecast Financial Performance
- Perform DCF Valuation
Learn to build client-ready deliverables from scratch (literally, we start with Ctrl N) and in every phase become better with:
- Excel Shortcuts
- Industry Best Practices
- Time-Saving Tips & Tricks
- Important Do’s & Don’ts
What will you learn in this Financial Modeling Course?
Overview of Financial Modelling
What is Financial Modelling? What is Financial Statement Analysis? What is Absolute vs Relative Valuation? What is Ratio Analysis?
Building the Structure
Build an integrated Financial Model which means the cells are linked across different sheets so a change in one cell impacts the entire flow of numbers in the Financial Model.
Formatting Protocols
Choosing the font, size, color, labeling, margin, etc. to create a report like presentation. Formatting in Financial Model is like punctuation in a language.
Statements with Schedules
Create Income Statement, Balance Sheet, Cash Flow Statement with respective schedules for each line item. Complement your statements with CAGR, Horizontal and Vertical Analysis.
Forecast Drivers
Learn the fundamental drivers of each line-item in their respective schedules which will strengthen the accuracy and financial soundness of the Financial Model.
Absolute Valuation
Perform Discounted Cash Flow Valuation where you learn to calculate FCFF and WACC (CoE and CoD) and complete it with a 2-Variable Sensitivity Analysis Data Table.
Check out the Course Curriculum for the complete list of videos in this course.
