Western India Regional Council of
The Institute of Chartered Accountants of India

(Set up by an Act of Parliament)

Workshop on Excel: A Intelligence Tool for Financial Modeling (Students)

Fees: Members & Students ₹1000                          

Event Details

Event Date 24-07-2020 6:00 pm
Event End Date 26-07-2020 9:00 pm

‘Financial Modeling’ has attained the status of a ‘language’ in the domain of finance. It is a pre-requisite skill set for professionals to excel in the field of Investment Banking, Equity Research, Credit Rating Analysis, Financial Planning & Analysis, Project Finance and Alternative Investments amongst others.
The 3-day webinar series aims to equip the professionals to comprehend the art behind making the financial models from scratch and apply them for better investment decisions.

Day I: Financial Statement Analysis
Day II: Building a Financial Model
Day III: Financial Modeling & Valuation

Topic

Speaker

24.07.2020

Day I: Financial Statement Analysis:

Analysis of Statement of Profit & Loss: 

  • Comprehending the business model
  • Understanding revenue drivers and correlating them with the industry
  • Analysing the topline from the perspective of Y-o-Y growth, CAGR growth and Industry CAGR growth
  • Analysing the cost structure

Analysis of Balance Sheet:

  • Analysing the working capital cycle by establishing linkages between line items in statement of profit & loss and balance sheet
    Analysing capital expenditure and line items pertaining to plant, property and equipment
    Analysing the capital structure

Analysis of Cash Flow Statement:

  • Comprehending the various linkages between line items in statement of profit & loss, balance sheet and cash flow statement

Overall Macro Analysis:

  • Ratio Analysis (Profitability Ratios, Liquidity Ratios, Solvency Ratios and Investment Ratios

Case Studies:

  • Case Study I: Analysis of historical financial statements incorporating the perspective of investors, lenders and the managment
  • Case Study II: Identification of early warning signals pertaining to a debt trap

 

 

 

 

 

 

 

CA. Nitesh Bhuta

25.07.2020

Day II: Building a Financial Model

  • Inputs & Assumptions
  • Revenue Build up
  • Cost Build Up
  • Working Capital Schedule
  • Asset Schedule
  • Debt Schedule
  • Projected Statement of Profit & Loss
  • Projected Balance Sheet
  • Projected Cash Flow Statement
  • Case Study III: Building a financial Model for a manufacturing entity

 

 

 

 

CA. Nitesh Bhuta

26.07.2020

Day III: Financial Modeling & Valuation

Case Study IV: Building a financial model for a service entity

Valuation - Income Approach (Discounted Cash Flows):

  • Computation of Cost of Equity & Cost of Capital
  • Computation of Terminal Value
  • Free Cash Flows to Firm
  • Free Cash Flows to Equity
  • Sensitivity Analysis

Valuation - Market Approach: 

Comparable Companies Methodology (CCM) & Comprable Transactions Methodology (CTM)

 

 

 

 

CA. Nitesh Bhuta

 

Co-ordinators:

CA. Shweta Jain 9920737198

CA. Archika Agarwal 9867423075 

CA. Vikas Jain 9029110210

Note: Once the Registration is confirmed you will receive a Goto webinar link one day before (for each day) the Program from WIRC to view the Webinar/program. Please note the link should not be shared with anyone. If any queries related to this program, if link not received, kindly email us on wircevents@icai.in