Financial Modelling using Excel Training

• 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

• Long term financing

• Cost of capital

• 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.

• 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 from Public Sources

• Understanding the Business Profile of the Company

• Modeling Revenue and Expenses Drivers

• Modeling Income Statement

• Modeling Implied EBITDA

• Balance Sheet Projections

• Cash Flow Statement Projection

• Performing Valuation and Sensitivity Analysis

• Calculating Enterprise Value and Implied Market capitalization