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

Fees: Members & Students ₹1000         

Please Pay your Attention here: Separate Link will be sent each day for Joining Webinar, Link for Previous day will not work for next Day Webinar. Link will be shared on the email id submitted while carrying out registration. 

To ensure timely receipt of link, kindly: 1. White list email from wirc@icai.in /customercare goto webinar.com. 2. Check Spam Box. 3. Incase of non-receipt of link & technical difficulty write email with payment details on wircevents@icai.in 

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

For Students Registration click on https://wirc-icai.org/student/students-events-registration