• Revision and Solutions of Day 1 Practice sheet
• Basics and Rules for performing Calculation on data
• Understanding cell Referencing
• Naming Groups of Data

• Using basic formulas to calculate values
  • Mathematical Functions (SUM, PRODUCT, POWER, SQRT, ABS ETC.)
  • Text Functions (LOWER, TEXT, SEARCH, LEN, REPLACE, TRIM, LEFT, RIGHT ETC.)
  • Statistical Functions (COUNT, MIN, MAX, AVERAGE, COUNTA, AVERAGEA ETC.)
  • Date & Time Functions (TODAY, NOW, EOMONTH, NETWORKDAYS, YEARFRAC ETC.)
  • Array Functions (SUMPRODUCT)

• Finding and Correcting Errors in Calculations
• Combine data from multiple sources
• Sensitivity Analysis and Data Tables
• Link to data in other worksheets and workbooks using Hyperlink

• PRACTICE SHEETS:
  • Mathematical Functions
  • Text Functions
  • Statistical Functions
  • Date & Time Functions
  • Array Functions

• Revision and Solutions of Day 2 Practice sheet
• Working with Data Validation
• Create Drop down List
• Restrict user to make a wrong entry

• Advance Calculation on data with Formula and Functions:
  • Statistical Functions (SUMIF, COUNTIF, SUMIFS, COUNTIFS, AVERAGEIF ETC.)
  • Informative Functions (ISBLANK, ISNUMBER, ISTEXT, ISERR ETC.)
  • Database Functions (DSUM, DAVERAGE, DCOUNT, DMIN ETC.)
  • Logical functions (IF, Nested IF, IFNA, IFERROR, AND, OR, TRUE, FALSE ETC.)
  • Lookup & Reference Functions (LOOKUP, HLOOPKUP, VLOOKUP, INDIRECT, INDEX, MATCH ETC.)
  • Financial Function (PV, FV, NPV, PMT, CUMIPMT ETC.)

• Working with Array Functions
• Formula Editing Tips and Tricks
• Conditional Formatting

• PRACTICE SHEETS:
  • Conditional Formatting
  • Working with Data Validation
  • Create Drop down List
  • Statistical Functions
  • Database Functions
  • Logical functions
  • Lookup & Reference Functions
  • Restrict user to make a wrong entry

• Revision and Solutions of Day 3 Practice sheet
• Create dynamic worksheets by using PivotTable
• Analyzing data dynamically by using PivotTables
• Creating dynamic Dashboard with using PivotTable & Pivot Charts
• Convert Table into Dynamic Table using Offset Function
• Concept of Data Table
• Protect your workbook and sheet
• Implementing simple business modelling case in Excel
• Introduction to Charts & Graphs

• Charts basics and its elements:
  • Create and Customize charts with Examples (Column and Stacked Column Chart, Bar Chart, Stacked Chart , Line Chart, Pie, Pie of Pie Chart)
  • Combo Chart (Combination of multiple charts)
  • Dynamic Chart
  • Many More
• Design a dynamic Dashboard using offset function, charts and graphs

• PRACTICE SHEETS:
  • Create dynamic worksheets by using PivotTable
  • Analyzing data dynamically by using PivotTables
  • Creating dynamic Dashboard with using PivotTable & Pivot Charts
  • Protect your workbook and sheet
  • Introduction to Charts & Graphs

• Revision and Solutions of Day 4 Practice sheet
• Introduction to Macros & Advanced Application Building in Excel
• Key Concepts in Macros
• Recording macros
• Run macros
• Set macros setting
• Personal Macro workbook
• Assigning Shortcuts to Macro Programs
• Understand Excel VBA Objects
• Assigning a Macro to a Button.

• Understanding Income Statement, Balance Sheet, Cash Flow Statement
• How Financial Statements are inter-related
• Different Measures of Profitability
• Reading the Annual Reports
• Ratio Analysis including liquidity, asset management, debt management and profitability
• DuPont Analysis
• Investment Decision Analysis
• Case Studies based on Live Companies

• Market Capitalization
• Enterprise Value
• Key Trading Multiples
• Determine Valuation
• Discussion on Valuation Multiples
• Methods of Consolidation
• Non controlling interest
• Investment in Joint Ventures and Equity Method Accounting
• Relative Approach V/s Fundament Approach of Valuation
• Understanding the concept of Implied Valuation
• Estimating Target Price

• Introduction to Comparable Companies Analysis
• Select the Universe of Comparable Companies
• Locate the Necessary Financial Information
• Spread Key Statistics, Ratios, and Trading Multiples
• Determine Valuation using Comparable Companies
• Introduction to Precedent Transactions Analysis
• Select the Universe of Comparable Acquisitions
• Locate the Necessary Deal-Related and Financial Information
• Spread Key Statistics, Ratios, and Transaction Multiples
• Benchmark the Comparable Acquisitions
• Determine Valuation using Comparable Acquisitions
• Normalization of EBIT, EBITDA and Net Income
• Adjustments of Options, Warrants and Restricted Stock Units
• Case Studies based on Live Companies

• Understand the Business Model and Operating Model
• Modelling the Historical Statement
• Modelling Assumptions for Future Action
• Revenue Schedule
• Operating Cost Schedule
• Capex / Depreciation Schedule
• Income Tax Schedule
• Working Capital Schedule
• Debt Schedule
• Equity Schedule
• Assets Schedule
• Modeling the Future Financial Statement
• Case Studies based on Live Companies

• Introduction to Discounted Cash Flows (DCF)
• Free Cash Flow to Firm (FCFF)
• Free Cash Flow to Equity (FCFE)
• Present Value on FCFF and FCFE
• Understanding Cost of Capital (WACC)
• Cost of Debt (Kd)
• Cost of Equity (Ke)
• Capital Asset Pricing Model
• Beta Model
• Levered, Unlevered and Re-levered Beta
• Terminal Value
• Exit Multiple Method
• Perpetuity Growth Method
• Computing Valuation using DCF
• Football Field Model
• Estimating Target Price
• Case Studies based on Live Companies

• Merger v/s Acquisitions
• Types of mergers
• Case Studies on different types of Mergers
• Motives behind M&A
• Synergies
• Bootstrapping
• Accretion / Dilution Modeling

It has survived not only five centuries, but also the leap into electronic typesetting. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur.

It has survived not only five centuries, but also the leap into electronic typesetting. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur.