Financial Modeling
For course content Click Here
Course outline of Financial Modeling
| Sn. | Topic |
| 1 | Introduction to Financial Modeling What is financial modeling? Applications in finance, Core principles, Best practices, Excel basics review |
| 2 | Excel Advanced Functions for Modeling Lookup functions (VLOOKUP, XLOOKUP, INDEX‑MATCH), Logical functions, Date functions, Text functions |
| 3 | Excel Advanced Functions for Modeling Lookup functions (VLOOKUP, XLOOKUP, INDEX‑MATCH), Logical functions, Date functions, Text functions |
| 4 | Financial Statement MechanicsIncome statement, Balance sheet, Cash flow statement inter‑relationships, Common‑size analysis |
| 5 | Building a Historical Model Inputting historical financials, Calculating key ratios, Trend analysis, Quality checks |
| 6 | Evaluation of Input historical data, and problem solving and discussion on Source of data |
| 7 | Revenue & Expense Forecasting Top‑down vs. bottom‑up forecasting, Driver‑based assumptions, Seasonality, Growth rate estimation |
| 8 | Revenue & Expense Forecasting Top‑down vs. bottom‑up forecasting, Driver‑based assumptions, Seasonality, Growth rate estimation |
| 9 | Revenue & Expense Forecasting Top‑down vs. bottom‑up forecasting, Driver‑based assumptions, Seasonality, Growth rate estimation |
| 10 | Working Capital & Capex Modeling Net working capital cycles, CAPEX depreciation schedules, PP&E roll‑forward |
| 11 | Debt & Interest Schedules Debt tranches, Interest calculations, Repayment schedules, Circular references handling |
| 12 | Three‑Statement Integration Linking income statement, balance sheet, and cash flow statement, Balancing the model |
| 13 | Scenario & Sensitivity Analysis Data tables, Scenario manager, Goal seek, Sensitivity tables for key drivers |
| 14 | Evaluation of project as class participation |
| 15 | Discounted Cash Flow (DCF) Valuation – I Free cash flow to firm (FCFF) calculation, Terminal value methods (Gordon growth, Exit multiple) |
| 16 | DCF Valuation – II Weighted average cost of capital (WACC), Cost of equity (CAPM), Cost of debt, Present value calculation |
| 17 | Relative Valuation (Comps) Trading comparables, Transaction comparables, Selecting multiples, Normalizing adjustments |
| 18 | Initial Public Offering (IPO) ModelingIPO process, Underwriting fees, Offering size, Post‑IPO capitalization |
| 19 | Python for Financial Modeling – I Data retrieval from APIs (Yahoo Finance), Data cleaning with Pandas, Basic financial calculations |
| 20 | Python for Financial Modeling – II Building a DCF model in Python, Automated sensitivity analysis, Visualization with Matplotlib |
Hi, this is a comment.
To get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.
Commenter avatars come from Gravatar.