This course is designed to provide a comprehensive understanding of financial modelling and valuation techniques, which are essential skills for professionals in the finance industry. The course is structured into eight modules, each covering a specific area of financial modelling and valuation.
Laying the foundation...
Module 1: Basic Microsoft Excel (4 hours)
Introduction to Microsoft ExcelUse of only Keyboard & ShortcutsBasic functions & Formula BuilderIF family functions, Offset, Date, etc.Module 2: Advance Microsoft Excel (4 hours)
VLookUp, HLookUp, Index-Match, XLookUp, etc.Pivot Table, Dynamic ChartsSensitivity analysis, Goal seekIntegrating ChatGPT with ExcelModule 3: Corporate finance & financial reporting (12 hours)
Time value of moneyNPV, IRR, XIRR, MIRR, etc.Insurance & Pension evaluationLoan amortisation, EMI calculatorUnderstanding financial statementsRatio analysisElevating modeling skills...
Module 4: Project financing & Start-ups (16 hours)
Revenue & cost drivers, KPIsManufacturing businessStarting a hotel & Restaurant businessReal estate case studyModule 5: Public companies modeling (20 hours)
Use of Bloomberg, S&P CapIQ, Refinitiv & ScreenerSchedules- Fixed assets, Net Debt bridge, Working capital, etc.Live Indian company modeling & valuationLive Global company modeling & valuationGet set for finance career!
Module 6: Valuations (20 hours)
Discounted cash flowComparable company analysis & comparable transactions analysisFootball field analysisAdjustment of leases- IFRS 16 / ASC 842Reference to Damodaran, Kroll, CFA, etc. materialModule 7: Advance modeling & other topics (8 hours)
Mergers & Acquisitions- Swap ratio, synergies, goodwill, etc.Leverage buyoutsPrivate equity & Pitch book overviewPremium equity research report walkthroughMS Excel Macros overviewMonte Carlo SimulationModule 8: Career Assistance (4 hours)
Real interview questions & answersResume guidanceStrategic approach to job searchingLeveraging LinkedInPersonal referral for top performing candidates