IBA - Center For Executive Education

Financial Modeling & Business Valuation - December 19, 20 and 21, 2019

Time: 9:00am - 5:00pm Download PDF
Venue: CEE@IBA,Karachi Reg Form
Info: ceeinfo@iba.edu.pk  
Contact: Tel: (0213) 8104700 (Ext: 1809, 1812)  
  • 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 best globally accepted practices.

    Testimonials

    "A learning experience that refined my financial modeling skills."
    Mr. Unser Owais
    Accounts Officer, Sindh Engro Coal Mining Company

    "Course is very good and it enhances the skills to handle the excel without using mouse. After this course I am very pleased to say that my efficiency is increased. Instructor got great knowledge and course material is very much complete."
    Mr. Syed Muhammad Kamran Ali
    Account Officer, Mashreq Bank

    "I found the workshop a valuable experience for the beginners which catered basic excel skills along with requisite, knowledge to excel in financial modeling. Keep arranging workshop like this one, I would be happy to attend more. Good Work! "Ms. Rabia Lalani
    Assistant Manager Investment Research, IGI Pakistan

  • Audience
    • Professionals using MS Excel
    • Professional involved in the construction and use of financial models, including budgets, projections, evaluations, cash flows, projects, etc
    • Professional aspiring to pursue a career in financial advisory
    • Senior executives looking for opportunities to rejuvenate their financial modeling skills
    Past Participating Organizations

    Abbott Laboratories, Aga Khan University, Alfa AdhiSeciruties, Amreli Steels Limited, Aon Insurance Brokers (Pvt.) Ltd., В 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 РТА Ltd., Lucky Cement Limited, Mashreq Bank, MCB Bank Limited, Merit Packaging, NBP, New Horizon, INotre Dame Institute of Education, Omar Jibran Engineering Industries Ltd, Рак Arab Refinery Limited, Рак 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.

  • Faculty
    Saad Usman

    Saad Usman is a fellow member of Institute of Chartered Accountants of Pakistan (ICAP) as well as CGMA – UK. He is a certified director from Pakistan Institute of Corporate Governance (PICG) and is working as a CFO in a local manufacturing company listed on the Pakistan Stock Exchange. He has more than 15 years of experience of working with local as well as multinational companies in middle and senior management roles. Saad is a Microsoft Office Specialist 2016 (MS Excel, MS Word, MS PowerPoint) as well as MOS Expert 2016 (MS Excel).

    Saad is an experienced Financial Modeler and has taught/trained thousands of students and corporate managers on topics of Financial Modelling and Advance Excel for the last ten years.

    At present, he has also been engaged as a visiting faculty at Institute of Business Administration (IBA) Karachi teaching courses such as Advanced Corporate Finance and Financial Modelling.

  • Topics
    Module 1
    • Overview of Financial Modelling
    • Model Design: Model development process; layout and structure
    • Model Inputs: Alternative layouts for model inputs and scenarios
    • Model Calculations: Modelling of capital expenditure; depreciation schedules
    • Model Ouputs: Integrating outputs with the model assumptions and calculations
    • Operations Modelling: Forecasting for revenues, operating expenses & working capital
    • Implementation and use of model: Easy navigation across the model
    Module 2
    • Introduction to Advanced Financial Modelling
    • Model Design: Template approach to ensure consistency
    • Model Inputs: Modelling of corporate taxation; debt financing; time control
    • Model Calculations: Assets acquisitions/disposals; loan disbursements/payments
    • Model Outputs: Creating dashboards, integrating the model
    • Model Review: Error handling, dealing with iterations
    • Others: Sharing best practices in practical modelling
  • Key Objectives

    The course is designed to cover the following key objectives:

    • Follow a logical, structured and disciplined approach towards model building
    • Build a model from start to finish
    • Learn how to translate key financial and commercial aspects into Excel
    • Understand how to tailor the outputs of the model and interpret the results
    • Learn ways to reduce the incidence of modelling errors
  • Key Topics

    Modeling basics Purpose of financial models and the risks associated with financial modeling
    Leading approaches to model building, their benefits and the importance of formatting

    Model designOverall process of model development and model design
    Set a typical layout, structure and flow of the model
    Adopting a template-based approach to achieve consistency between model worksheets

    Layouts and assumptionsAlternative layouts for model inputs and scenarios
    Using range names and data validation to increase model robustness

    Fixed assets and depreciationDifferent ways of modelling capital expenditure relating to different asset classes
    Depreciation methodologies including cases where multiple asset acquisitions take place across the model timeline

    Operations modelingForecasting for revenues, operating and maintenance costs and working capital
    Using indexation factors based on different cash flow timing assumptions

    Debt and equity financingModelling different drawdown approaches to service funding needs
    Costs related to debt financing such as interest
    Different debt repayment methods

    Taxation Different approaches for modelling corporate taxation

    OutputsThe importance of integrated financial statements and how to set them up
    IRR and NPV calculations, using both project and equity cash flows
    Other key output measures such as lending and profitability ratios and industry KPls

    Implementation and use of modelCreating dashboards, hyperlinks and contents pages for easier use and navigation
    Performing stress testing on a model based on designated sensitivities and in-built scenario cases

    Model review and testing Use of checks sheets to automatically detect and identify potential modelling errors
    Common modelling errors including tips on how to spot them

    ValuationIntroduction to company valuation
    Difference between equity and enterprise value
    Stages of a complete DCF valuation

  • Benefits
    • 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
  • Fees
    PKR 60,000 + 5% SST
    • Inclusive of Course material, IBA Workshop Certificate, Lunch, Refreshments & Business networking
  1. Facebook
  2. Twitter
  3. Linkedin