IN India Master's Degree
Financial Modelling and Valuation
Build a three-statement model and value a business you can defend.
What the course covers
8 modules, 32 topics. Open any one to see what sits inside it.
-
- 1.1 What a Financial Model Is and What It's For
- 1.2 Types of Financial Models
- 1.3 The Modelling Process End-to-End
- 1.4 Model Design Principles and Best Practice
-
- 2.1 Layout: Inputs, Calculations, Outputs
- 2.2 Formatting and Colour Conventions
- 2.3 Timelines, Periods and Flexible Dates
- 2.4 Assumptions, Drivers and Documentation
-
- 3.1 Modelling Revenue and Costs
- 3.2 Building the Income Statement
- 3.3 Building the Balance Sheet
- 3.4 Building the Cash Flow Statement
-
- 4.1 Fixed Assets and Depreciation Schedule
- 4.2 Debt Schedule and Interest
- 4.3 Working Capital Schedule
- 4.4 Equity, Tax and Linking It All Together
-
- 5.1 Balancing the Model and Fixing Circularity
- 5.2 Error Checks and Integrity Tests
- 5.3 Scenario and Sensitivity Analysis
- 5.4 Model Review and Auditing
-
- 6.1 Forecasting Techniques and Assumptions
- 6.2 Growth Drivers and Revenue Build-Ups
- 6.3 Cost Behaviour and Margin Forecasting
- 6.4 Testing Forecast Reasonableness
-
- 7.1 Valuation Approaches Overview
- 7.2 Discounted Cash Flow and Free Cash Flow
- 7.3 Cost of Capital, WACC and Terminal Value
- 7.4 Comparable Company and Transaction Multiples
-
- 8.1 Project Finance and Capital Budgeting Models
- 8.2 Startup and Fundraising Models
- 8.3 M&A and LBO Model Basics
- 8.4 Presenting a Model: Outputs, Dashboards and Case Study
What you will be able to do
By the end of this course you will be able to explain and apply:
- What a Financial Model Is and What It's For
- Layout: Inputs, Calculations, Outputs
- Modelling Revenue and Costs
- Fixed Assets and Depreciation Schedule
- Forecasting Techniques and Assumptions
- Project Finance and Capital Budgeting Models
Why take it
Who it is for
Designed for
- Master's Degree students in India
- Studying: M.Com, MBA Finance, MA Economics, CA / CMA / CS professional routes
- Recent graduates strengthening a CV
- Anyone working in this field without a formal qualification
What you need
- No prior course needed
- A phone, tablet or computer
- About two hours in total
- Each of the five courses stands alone
Questions
-
About two hours in total — eight modules of roughly fifteen minutes. You can do it in one sitting or spread it across a week. Your place is saved either way.
-
No. There is no prerequisite course and no software to install. A phone, tablet or computer with an internet connection is enough.
-
Yes. This course is placed at Master's Degree for India, and the content is written for that level. If you are at a different stage, change your level at the top of the page and the courses will change with it.
-
A certificate for the course, carrying an ID that your college or an employer can check on our verification page. You keep access to the material afterwards.
-
Yes — ₹450 for this course on its own, or ₹1,450 for all five in this set, which works out cheaper if you want more than one.
-
There is a short quiz at the end of each module so you can check what stuck. It is not timed and you can retake it.
-
Change your country using the picker at the top. Level names, degree names and prices all switch to that country, and the courses adjust to its education system.
Wording shown for India. Pick a different country at the top and the terms, currency and programme names change with it.