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.

• 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.

• 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

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.

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

• 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

PKR 36,000/participant each module

• Inclusive of Course material, IBA Workshop Certificate, Lunch, Refreshments & Business networking