Learning Resources (Presentations & Worksheets)
Introduction to Financial Modeling & Valuation

Understanding and creating a Financial Model template
Case: Formatting the data, summarizing, and creating a presentable format
Formatting the imported file with text to columns
Getting the relevant information from a string of data using Left, Trim
Converting text to numerical using text to columns
Using referencing framework (usage of $) to effectively use formulas
Summarize the sum of sales with Pivot Tables
Converting data into a tabular format
Identify high-profit sales using conditional formatting

Introduction to Financial Statement Analysis
Financial Reporting Mechanics
Understanding Income Statement, Balance Sheet, Cash Flow Statement
Financial Analysis Techniques
Inventories, Long-Lived Assets
Non-Current Liabilities
Financial Statement Application
Ratio analysis of Industries
Du point Analysis
Peer to peer analysis
Preparation of Financial Analysis report on an industry

Time Value of Money Part – I
Time Value of Money Part – 2
Long term financing
Capital Budgeting Part- I
Capital Budgeting Part- II
Cost of Capital
Equity Valuation Part- I
Equity Valuation Part- II
Measure Of Leverage

Why Project evaluations
Stages of project
Construction & development phase
Funding during investment phase
Costs during the investment phase
Life of project; decision making
Cash flow waterfall
Resolving circular reference

Prepare Financial Statement
Analyze Revenue and Costs
Forecast Revenues, Costs, Debt, etc.
Project Future Financial Statements
Performa Adjustments, Compute Margins/Ratios
Valuation- Discounted Cash Flow Method (DCF), Others
Prepare Presentation Sheet, Company Overview, Sector Overview

Report Writing: On the basis of Financial Modeling,
Overview of different sectors such as retail, telecom, IT, Oil & Gas, etc.

Three Statement Model (Operating Activities, Investing Activities, Financing
Activities)
Operating Cash flow
Investing Cash flow
Financing Cash flow
Cash Balance

Data Collection and Data Structuring
Preliminary Scrutiny of the Data and Information
Understand the Business Model and Operating Model
Modeling the Historical Statement
Modeling Assumptions for Future Action
Modeling Revenue Build-up – projecting the future revenues
Modeling Cost Build-up – projecting the future cost
Modeling the Asset Schedule
Modeling the Depreciation Schedule – Book and Income Tax Depreciation
Working Capital and Term Loan Modeling – Debt Infusion
Tax Modeling, MAT, and MAT credit
Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax
Payable
Equity Modeling – Equity Infusion
Modeling Paid Up Capital and Share Premium Account
Modeling Retained Earning Schedule
Modeling the Financial Statements, Ratio Analysis
WACC and Cost of Equity Analysis
Performing Valuation using DCF (FCFF and Enterprise Value) and Comparable
Analysis (Relative Valuation)
Performing Sensitivity/Scenario Analysis
Comparing the Valuation Summary using Different Parameters on a football
field.

Data Collection and Data Structuring
Preliminary Scrutiny of the Data and Information
Understand the Business Model and Operating Model
Modeling the Historical Statement
Modeling Assumptions for Future Action
Modeling Revenue Build-up – projecting the future revenues
Modeling Cost Build-up – projecting the future cost
Modeling the Asset Schedule
Modeling the Depreciation Schedule – Book and Income Tax Depreciation
Working Capital and Term Loan Modeling – Debt Infusion
Tax Modeling, MAT, and MAT credit
Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax
Payable
Equity Modeling – Equity Infusion
Modeling Paid Up Capital and Share Premium Account
Modeling Retained Earning Schedule
Modeling the Financial Statements, Ratio Analysis
WACC and Cost of Equity Analysis
Performing Valuation using DCF (FCFF and Enterprise Value) and Comparable
Analysis (Relative Valuation)
Performing Sensitivity/Scenario Analysis
Comparing the Valuation Summary using Different Parameters on a football
field.