Financial Modeling - Fundamental Analysis and Valuation

Introduction to Financial Modeling

• Steps to financial Modeling
• Introduction to Advanced Excel Functions for Modeling

Vlookup, Max, Min, Pivot table, Data table, Scenario Manager, Goal Seek, Iterative Function (Circularity), Growth, Linear, Forecast, Forecast ETS, IF & Nested IF, Dashboard (with Pivot & Slicer), Charts

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

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 Stand-alone & Consolidated Financials (Balance sheet, Income statement, Cash flow statements

You will be able to analyse historical data, identifying key variables for forecasting and construct financial statements for the forecasted period

Analysis of Financial statements

• Ratios

You will be able to develop models of dashboards and models to facilitate analyses of financial statements based on financial ratios

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)
• IPO Valuation

You will be able to construct valuation models by applying relevant valuation tools

Other Models:

• Tax models
• Loan amortization schedule

You will be able to develop different types of models in diverse business scenarios