Financial Modeling - Fundamental Analysis and Valuation

Course Description

Sr No.	Content
1	Introduction to Financial Modeling Steps to financial Modeling Introduction to Advanced Excel Functions for Modeling Vlookup, Max, Min, Scenario Manager, Iterative Function (Circularity), Growth, Linear, Forecast, Forecast ETS, IF & Nested IF, Dashboard (with Pivot & Slicer), Charts Learning Outcome: You will be able to understand the various aspects of financial Modeling, use and apply certain advanced commands of Excel in various financial and accounting scenarios
2	Forecasting Financial Statements: Collecting and Analyzing Historical Data Selecting the Key Forecast Drivers Forecasting Revenue and Cost, Capital Structure, Capex, Working capital and other relevant parameters Modelling Financial Statements (Balance sheet, Income statement, Cash flow statements) Learning Outcomes: You will be able to analyse historical data, identifying key variables for forecasting and construct financial statements for the forecasted period
3	Analysis of Financial statements Ratios Learning Outcome: You will be able to develop models of dashboards and models to facilitate analyses of financial statements based on financial ratios
4	Valuation Models Equity - Multi stage valuation models-Dividend Discount Models, Free Cash Flows to Firm and Equity (FCFF and FCFE), Relative Valuation (including cost of capital models) Basics of IPO Valuation Learning Outcome: You will be able to construct valuation models by applying relevant valuation tools
5	Other Models: Tax models Loan amortization schedule Learning Outcome: You will be able to develop different types of models in diverse business scenarios

Meet Your Instructor

CA Vishal Zawar

He is a qualified Chartered Accountant and holds 5+ years of experience of teaching Financing Management, Financial Modeling, Financial statement analysis. He has worked as Financial Analyst with Medical solutions India private limited. He has excellent command over MS Excel and he has been conducting sessions on Advanced Excel. His practical approach towards teaching Finance makes students understand concepts deeply and make them market ready.

₹2999 (Incl. of GST)

Enroll Now

Start Date: 03 October 2026

End Date: 01 November 2026

Time: 07 PM - 10 PM

Medium: Hinglish

Course feature :