IBA - Center For Executive Education

Financial Modeling (Module 3) - November 6-7 2015

Time: 9:00am - 5:00pm Download PDF
Venue: CEE@IBA,Karachi Reg Form
Info: ceeinfo@iba.edu.pk  
Contact: Tel: (0213) 8104700 (Ext:1804, 1807, 1809)  
  • Introduction

    The objective of the course is to provide comprehensive overview of the latest analytical tools used by financial advisors and industry consultants for developing financial statements, while applying globally accepted best practices.

  • Audience
    • Professionals using MS Excel
    • Professionals involved in construction, use and analysis of financial models for effective decision making
    • Professionals aspiring to pursue a career in financial advisory
    • Senior executives looking for opportunity to rejuvenate their financial modeling skills
    Past Participating Organizations

    Abbott Laboratories, Aga Khan University, Alfa AdhiSeciruties, Amreli Steels Limited, Aon Insurance Brokers (Pvt.) Ltd., B Braun Pakistan (Pvt.) Ltd., CBM, Chevron, China NLC, Dawood Engg., e2e Supply Chain Management Pvt. Ltd., Engro Eximp (Pvt.) Ltd., Engro Foods Ltd., Engro Polymer, Enrnst & Young, Fauji Fertilizer Company Limited, Fauji Oil Terminal and Distribution Co. Ltd., GAC Pakistan (Pvt.) Ltd., Global Oil Industries, HBL Asset Management, HSBC, ICI Pakistan, IGI Pakistan, Inbox Tech, Intech Process Automation, Kahota Research Labs, KnS Institute of Business Studies, KSBL, Linde Pakistan Limited, Loreal, Lotte Pakistan PTA Ltd., Lucky Cement Limited, Mashreq Bank, MCB Bank Limited, Merit Packaging, NBP, New Horizon, Notre Dame Institute of Education, Omar Jibran Engineering Industries Ltd, Pak Arab Refinery Limited, Pak Libya Holding, PPL, Saif Textile Mills Limited, Shell, Silk Bank Limited, Sindh Engro Coal Mining Company, State Life Insurance Corporation, Transworld, Tufail Chemical Industry, UBL, Uch Power, USAID, WindRose Consultancy.

  • Learning Outcomes
    • Construct a financial model, real-time, under the guidance of a seasoned investment professional
    • Identify and incorporate Globally Accepted Best Practises pertaining to financial modelling
    • Learn the necessary tool-kit required to prepare decision making dash-boards
    • Discuss business cases with a focus on identifying Key Value Drivers required to understand business mechanics
  • Faculty
    Muhammad Tauseef Ansari

    ACCA, is currently working as the Head of Corporate Finance & Investment Banking at Pakistan Kuwait Investment Company (Pvt.) Limited – a joint venture DFI between Governments of Pakistan & Kuwait. With a total experience of 18+ years, his past assignments includes working for Barclays Bank, Morgan Stanley - KSA, BMA Capital, AKD Securites, The World Bank, Unilever and A.F.Ferguson & Co Chartered Accountants (member firm of PWC). He is also the Adjunct Faculty in NED University of Engineering & Technology, Karachi.

  • Topics
    Module 1
    • Overview of Financial Modeling
    • Excel Best Practices
    • Thebes Airport: Situation Overview
    • Income Statement and Operating Model
    • Capital Expenditures and D&A Schedules
    • Financial Model Set Up
    • Working Capital Schedule
    • Shareholder's Equity Schedule
    • Introduction to Valuation and Preliminary Returns Analysis
    • Control Page and Sensitivity Analysis
    Module 2
    • Overview of Advanced Financial Modeling
    • Kadmos Modeling Framework
    • Thebes Airport: Situation Overview
    • Income Statement Projections
    • Tax Depreciation and Deferred Tax Liability
    • Options and Treasury Stock
    • Building Scenarios
    • Running Finance Facilities
    • Utilization of TEXT functions and Data Tables to build scenarios
  • Benefits
    • Enhance the financial modeling techniques to address real world problems
    • Prepare, understand and comprehend the projected financial statements
    • Value a company using different methods and with various perspectives
    • Use financial modeling as a Decision Making Tool
  • Fees
    PKR 36,000/participant each module
    • Inclusive of Course material, IBA Workshop Certificate, Lunch, Refreshments & Business networking
  1. Facebook
  2. Twitter
  3. Linkedin