Using Financial Modelling for Analysis and Valuation

Program

A financial model is a tool used to forecast a business’ financial performance in the future. The forecast is typically based on the company’s historical performance, assumptions about the future, and requires preparing an income statement, balance sheet, cash flow statement, and supporting schedules (known as a 3 statement model). From there, more advanced types of models can be built such as discounted cash flow analysis (DCF model), leveraged-buyout (LBO), mergers and acquisitions (M&A), and sensitivity analysis.


This course will equip you with knowledge and skills to use financial models to perform company analysis and valuation.

Pre-requisites:

1. A basic knowledge of excel

2. A basic knowledge of economics or finance

SESSION 1: Creating a Financial Model template using Excel - I

  • • Formatting the data, summarizing, and creating a presentable format
  • • Manipulating Text and Numerical Data
  • • Using Pivot Tables to Sumerize Data

SESSION 2: Creating a Financial Model template using Excel - II

  • • Converting data into tabular format
  • • Identify high profit sales using conditional formatting
  • • Excel Best Practises

SESSION 3: Financial Model for a New Business - I

  • • Inputs/Assumptions Worksheet
  • • Preparing the 3 Financial Statements

SESSION 4: Financial Model for a New Business - II

  • • Preparing Depreciation & Amortization Schedule
  • • Preparing Debt Schedule
  • • Other Working Notes

SESSION 5– Modeling Case Study - I

  • • Understand the Business Model and Operating Model
  • • Modeling the Historical Statement
  • • Modeling Assumptions for Future Action

SESSION 6 – Modeling Case Study - II

  • • 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 Modelling – Debt Infusion
  • • Equity Modelling – Equity Infusion

SESSION 7– Analysis and Valuation - I

  • • WACC and Cost of Equity Analysis
  • • Performing Valuation using DCF

SESSION 8– Analysis and Valuation - II

  • • Performing Sensitivity/Scenario Analysis
  • • Comparing the Valuation Summary using Different Parameters
  • 1. Business analysts
  • 2. Researchers
  • 3. Controllers
  • 4. Consultants
  • 5. Small and medium business owners
  • 6. Startups founders
  • 16 Hours

    Rs. 12,000

    For further details regarding contents,
    E-mail: training@bseindia.com