Course Overview
Financial modeling is one of the most sought-after skills required in today’s corporate world. The Advanced Excel with Financial Modeling course delivers a 360-degree insight into Advanced Excel and Financial Modeling techniques. This course focuses on practical learning of the concepts and trains professionals to construct consistent and realistic financial models in MNCs as well as small businesses using MS Excel.
Learning Options
Request for more Information
Schedule Dates
Curriculum
-
Module 1: Basic concept of Excel
-
Module 2: Excel Financial Functions
-
Module 3: Pivot Tables
-
Module 4: Data visualization in Excel
-
Module 5: Data Analysis in Excel
-
Module 6: Financial Modeling Fundamentals
- Financial modeling basics
- What is a financial model?
- Financial modeling – worst practices
- Financial modeling – best practices
- Financial modeling – The types of models
- Financial modeling: level of detail in a model
- Financial modeling: Forecasting guidelines
- Building a complete model – Important consideration
- Modeling the Income statement
- Modeling the Balance sheet
-
Module 7: Corporate Valuation
- The main value drivers when valuing a business
- How to calculate Unlevered Free Cash Flow
- How to calculate Weighted Average Cost of Capital (WACC)
- How to calculate cost of debt
- How to calculate cost of equity
- Forecasting a firm’s financials
- How to obtain Terminal Value
- Discounting cash flows
- How to obtain Enterprise and Equity Value
- Mergers & Acquisitions
-
Module 8: Capital budgeting
