Top 5 Learning Objectives1. Understand the essence of financial models and analyse their applications2. Discover how to construct reliable and realistic financial models that work and are easy to review3. Learn to measure, interpret and predict company performance using Excel modelling4. Improve your decision making processes and save time on financial analysis5. Be able to use Excel as an analytical tool and enhance your financial abilities

Throughout the course:There will be a mixture of specific and general models to considerDelegates will be introduced to a wide range of functions and formulas

As much individual attention as possible will be given to each delegate and it is the aim of the course that new topics will not be started until delegates have mastered the previous one

IntroductionThis course is an intensive two day course for financial managers and others with a need to con-sider or use financial models. The course assumes that all delegates will have at least a basic level of Excel knowledge and ability as it begins by using at least some intermediate level techniques and functions.The course will be run in the following way:To begin with delegates will be introduced to the fundamental aspects of spread sheeting that all financial modelers need to know: Definition of models Principles of financial models Best practice and spread sheeting standardsAll subsequent topics are introduced in a step by step and fully interactive way: the presenter works through a topic and delegates work along; the delegates are then given time to explore the topicFully worked solutions to all examples introduced during the course will be handed over to delegates by the end of the courseAdditional examples, models and templates will be provided along with all worked examples

Learning ObjectivesBy the end of this course delegates will be able to• Understand and apply the definitions of model, financial model and the fundamental stand-ards of spread sheeting best practice• Build and analyse basic financial models• Carry out an analysis of financial performance• Prepare and evaluate forecasts of financial and other data• Use the What if? Techniques built into Microsoft Excel• Use and evaluate various financial functions• Build regression analysis models and employ them in forecasting and decision making• Use and report on the ANOVA technique• Create Pivot Table based reports for financial modelling• Develop discounted cash flow models for capital budgeting decisions• Present Excel reports that communicate effectively

Who should attend?Financial managers Financial Analysts CFOsAccountants Credit Managers Treasury Managers Risk ManagersNon-financial managers with financial modelling responsibilitiesAspiring financial and non-financial managers

Benefits of AttendingAs a result of attending this seminar, delegates will be able to return to work and immediately apply the tips, tricks and techniques that will be demonstrated.

Ahmed Yasir Khan is a qualified MBA (MIS) and has possesses 20 years of diversified industry exposure in the field of finance & IT. Currently he is working as Manager e-support in FBR. He is a member of Trainer FBR Trained Professional Govt. sector as well as Private organization. He has conducting in-house training also Public workshop and seminar. He is member of Pakistan Institute of Management, and also an approved trainer of National Productivity Organization (NPO), Government of Pakistan. He has specialty in Import, Export, Supply Chain, E-Filling (IGM, Import, Export, Sales Tax Return), e-Support, Income Tax, Sales tax, Customs, ERP’s & Database (SAPR3, SAP B1 ,Microsoft Dynamics AX, Oracle e-business suite

R12 ,Oracle11g, Tally ERP, Quick book2012, Peachtree2010, Advanced Excel2010/2013, Access 2010/13, SQL SERVER2008R2/2012).Microsoft office Application Specialist, SharePoint 2010,CBAP,PMP,ITILV3,Corporate Finance, Analysis of Financial Statement, Strategic in Financial Management , Excel Dashboard Reporting, KPI, Financial Planning & Budgeting, Excel VBA Programming, Financial Modeling, Process Modeling, Workflow, computerized Accounting, Software Project Management, ERP Implementer, PMO, IT Audit, & SQA.

As part from diversified development assignment. He has been actively involved in training and teaching Profes-sional with many Institutions as visiting faculty member, and taught thousands of Professionals. He is a trainer of repute for his unique training style which enables maximum learning & retention in least possible time.

He trained large number of employees of prestigious organizations such as MAERSK, PAF, SSGC, KESC, BP Pakistan, HUBCO, BOC Pakistan, WAPDA, State Bank of Pakistan, University of Karachi, IBA, NUST, Hamdard University, Pakistan Tobacco Company, Makro, PEMRA, Philips Pakistan, Mitsubishi Corporation, TRG, State Life Insurance, NAFA Fund, Arif Habib Ltd., MCB Bank Ltd, IGI Investment Bank, Dubai Islamic Bank, First Women Bank, Fatima Group, Shield Corporation, Zafa Pharmaceutical, Askari Cement Ltd, Master Group, PTCL, UNDP,ITL,PARCO, Silk Bank, Services , Hilton Pharma , Bosch , Atlas Honda , Metro , HBL , Agri Auto , Interna-tional Textile Mills LTD , ENGRO , BYCO, MCB, Agha Khan , NBP , JS BANK, Karachi stock exchange , Abott , DP World Karachi, Geo, SHVERION, Glaxo Smith, Punjab TV, TAPAL,BOP, HSBC, Dalda foods etc.

Course OutlineBasic definitions of a model, financial model and the fundamentalStandards of spread sheetingBest practice Building and analyzing basic financial models, includingDepartmental budgets• Divisional budgets• Project budgets• Basic income statement and balance sheet budgets• Cash flow budgetsCarrying out analyses of financial performance• Ratio analysis including specific ratios for specific industries• Common size statements• Rates of Change ratiosForecasts of financial and other data, including• Production forecasts• Sales forecasts• Manpower planning forecastsUse the What if? Techniques built into Microsoft Excel• Scenario manager• Goal Seek• SOLVERRegression analysis models and their use in forecasting and decision makingPivot Table based reports for financial modelingDiscounted cash flow models for capital budgeting decisionsRegression analysis models and their use in forecasting and decision making• Descriptive statistics• Ordinary Least Squares• Multiple Regression• Correlation MatricesThe ANOVA techniquePivot Table based reports for financial modellingDiscounted cash flow models for capital budgeting decisions• Compounding and discounting• Present value• Net present value• Internal rate of return• Modified internal rate of returnArray Formulas for the efficient execution of modelsPresent Excel reports that communicate effectively• Layout• Colour communications• Conditional formatting Data validation Scroll Bars Various formulas Data Tables (What-If Utility) Goal Seek (What-If Utility) Graphs & Charts Macros and using different ways to run them and allocating button to Macros Naming Names and its pros and cons Some customization Analysis Tool Pack Add-ins