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

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

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.

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

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

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

• 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

PKR 60,000 + 5% SST

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