Financial Modelling & Valuation

June 17, 2022Financial Modelling & Valuation

  • Overview
  • Course Outline
  • Workshop Fee & Instructions:
  • Testimonials

Overview

Financial modelling is a powerful tool which can be utilized for projecting the future financial performance of any company or a project. The course of financial modelling is meant to cover intricacies of preparing a financial model in MS Excel using the best modelling practices and using that for performing suitable business performance analysis. The course shall provide a practical insight into business valuation using the internationally accepted valuation methodology, viz. Discounted Cash Flows (DCF).

Our Affiliations:

Course Outline

Financial Template: Understanding & gathering information

  • Understanding accounting basics double entry and creating (P&L and B/S).
  • Creating a consistent financial model template.
  • Historical financial statement modeling (P&L and B/S):-
    • Data Gathering from Annual Reports & Management Discussion.
    • Creating the historical statements and linking derived numbers
  • Calculating growth drivers:-
    • Gathering Data for growth drivers from research reports and other sources (Revenue – Costing – expenses)
    • Calculating P&L growth numbers/ CAGR.
    • Calculating P&L ratios.
    • Calculating B/S ratios.

Forecasting & Projections of FS:

  • Building assumptions and projections:-
    • Building assumptions for P&L and B/S.
    • Linking assumptions for P&L.
    • Linking assumptions for B/S.
  • Building schedules:-
    • Fixed Assets and depreciation schedule.
    • Debt & Interest schedule.
  • Understand & Build forecasted Profit and loss statement.
  • Understand & Build forecasted balance sheet.
  • Understand & Build Cash flow statement.
  • Building interest on excess cash and cash revolver.
    • Using Excel for Iteration – Goal Seek & circular referencing.

Financial analysis ratios & Valuation

  • Understand & Build liquidity and profitability ratios for analysis.
  • Updating integrated model for valuation analysis:-
    • Understanding and building trading comparatives.
    • Understanding and building transaction comparatives.
    • Understanding and building DCF
    • Building free cash flow to firm & equity
    • Understanding and estimating beta
    • Understanding & estimating WACC
    • Using data-validation to improve sheet structure
    • Building Football field chart to decide which share price (company’s value) to consider.

Workshop Fee & Instructions:

  • July 25-26, 2022 – 10:00 am – 03:00 pm (GST)
  • Regular Fee: USD 680 Per Participant (Exclusive of VAT)
  • Team Offer: Pay for 2 and register 3rd for free
  • Includes: Courseware, and SIMFOTIX Certificate
  • For registration (s) send us your Name, Designation, Organization, and Mobile Number to register@simfotix.com
  • For More Information please contact: Qazi Waqas Ahmed Mobile: +971 56 309 0819; Email: waqas@simfotix.com

Testimonials

Share