Session 1: Excel
● Understanding and creating a financial model template
● Refreshing important Excel functions to be used in financial modelling and valuation
-String Function
-Offset function
-Data table
-Goal seek
-Linking multiple sheets and files etc.
-Macros
-Learning Custom formatting peculiar to creating financial models
-Learning referencing (usage of $) and its significance in the financial model
Session 2 : Basic Business Model
● Understanding Business Models
Session 3: Financial Statements
● Working on historical statements
● Assumptions
● Forecast
Session 4 : Valuation
● Applying DCF
Session 5 : Financial Model - Data:
● Data Collection
● Data Structuring
● Preliminary Scrutiny of the Data and Information
Session 6 : Modelling
● Working on Historical Statements
● Modelling Assumptions for Future Action
● Revenue Build-up - projecting the future revenues
● Cost Build-up - projecting the future cost
● Asset Schedule
● Depreciation Schedule - Book and Income Tax Depreciation
● Working Capital and Term Loan Modelling - Debt Infusion
● Modelling Impact of Accumulated Losses, Current Tax and Deferred
● Tax on Tax Payable
● Equity Modelling - Equity Infusion
● Modelling Paid Up Capital and Share Premium Account
● Cash Flow Statement Projection
Session 7 : Valuation
● Cost of Equity - CAPM
● Net cost of Debt
● WACC
● Absolute Valuation: Performing Valuation using DCF (FCFF and Enterprise Value)
● Relative Valuation: Comparable Analysis
● Performing Sensitivity/Scenario Analysis
Session 8 : Project Valuation - Introduction
● Introduction and context
● Understanding an integrated financial Model
Session 9 : Project Valuation - Creating a Model for NPV & IRR
● Understanding basics
● Building flexibility for cash flow at unpredictable time
● Building flexibility in Model
Session 10 : Modelling Delays
● Date arithmetic and creating flexible template
● Lookup revenues and costs
● Quarterly to Yearly Revenue consolidation using SumIf
Session 11 :Project Valuation - Circular Logic and looping
● Interest During Construction
● Interest and Cash
Session 12 : Project Valuation - Creating EPC Schedule
● Finding out different cost involved in the project
● Calculating complete project cost
Session 13 : Project Valuation - CAPEX Schedule
● Finding out the total capex required for the project
● Converting monthly items to annual
Session 14 :Project Valuation - P&L
● Working on different sources of revenue
● Calculating expenses
● Using DCF
● Calculating IRR
Session 15 : Project Valuation - Asset Schedule
● When, what is required?
Session 16 : Project Valuation - Valuation
● Using DCF
● Calculating IRR
Session 17 : Project Valuation - GANTT Chart
● Tracking progress of the project
Session 18 : Visualization - Interactive Excel Dashboard
● Introduction
● Dashboard design tips
● Data Sources
● Possible data sources
● Format data in table
● Building dashboard
● Pivot for the line chart
● Bar Chart
● Pie Pivot
● Sparklines Pivots
● Map Pivots
● Interactivity with slicers
● Dynamic titles
● Design and Layout
Session 19 : M&A - Introduction
● Meaning and Categories of M&A
● Merger Motivations
● Forms of Payment in a Merger Deal
Session 20 : M&A - Evaluation
● Evaluating a Merger Bid
● Case: Estimating fair acquisition price of the target company in M&A
● Identifying assumptions for estimating future cash flows
● Calculating FCFF, discount and terminal rate and NPV
● Comparable Companies
● Defining comparative value metric
● Estimating takeover premium and calculating takeover price
● Comparable transactions and defining comparative value metric
● Calculating the valuation of the company
Session 21 : M&A - Valuation
● Case: Live Case
● Why this case
● Finding out rationale for the transaction
● Searching and researching relevant reports
● Understanding the usage of 10K and 10Q
● Collecting and projecting numbers
● Merger Analysis - Key Drivers and Inputs
● Projecting both companies' numbers
● Find out the impact of deal announcement on share price
● Creating high level merger accounting for goodwill - Pooling method
● Accretion/Dilution Analysis and Modelling a Financing Plan
● Performing Sensitivity Analysis on Acquirer's EPS, Contribution Analysis