Workshop on Financial Modeling Using Excel

About Course

Financial Modeling and analysis are among the most highly-respected skills in the business world and job marketplace. From Banks, Accounting, Investment, Insurance and Business Decision-Making rely on complex analytical decisions every day. This financial modelling course will teach candidates to forecast the future performance of a company using a model built in Excel, candidates will learn the fundamentals of accounting, corporate finance, budgeting and forecasting and valuation.

Candidates will learn how to use Excel to produce financial forecasts that can explain the answers to relevant business problems. Candidates will be introduced to best-practice techniques of financial modelling and learn how to integrate income statements, balance sheets, and cash flow and eventually how to make strategic financial decisions.

What Will You Learn?

By the end of this course candidate will be able to:

• Identification and application of advanced excel functions essential for Financial Modeler.
• Dynamic Lookup functions and working with pivot tables.
• Graphical representation through charts and graphs.
• Apply financial modeling best practices.
• Model structure designing based on pre-determined outputs & requirements.
• Apply best practices in capital structure modelling and financial appraisal methods.
• Build and incorporate operating & financial Schedules.
• Valuation, forecasting and strategic financial decision making.
• Financial Statements projection model.

Why Should You Take This?

By taking this course you will not only have specialized knowledge and skill, you’ll also gain.

• More confidence in your career.
• Hands on practice of performing real analysis
• Most sought after skill by industry and employers
• Skill Validation by demonstrating advanced financial modeling skills.
• Personal Development with emerging skills and global certification
• Global Mobility and career flexibility by relevant and highly respected skillset.

Who Should Attend?

• Graduates and Master of Commerce, Business Administration, Accounting and Finance
• Students and members of professional accounting bodies i.e ICAP, ICMAP, ACCA, PIPFA, CIMA, IFA, IPA
• Professionals from accounting, finance, FP&A departments and banks, Insurance Companies & Brokerage Houses
• Young entrepreneurs going to launch a start up
• Business Professionals and others aspiring to learn financial modelling using advanced excel

Workshop Contents

Using Advanced Functions

• Using Complex Excel Functions
• Using Multi-sheet Formulas
• Using What-If-Analysis
• Goal Seek
• Scenario Manager
• Solver
• Dynamic Vlookup, SUMIF, SUMIFS, Index & Match Etc.

Practical Scenario Calculations

• Evaluate project feasibility with IRR (Internal Rate of Return), NPV (Net Present Value) and the payback period
• Income Tax Calculations with multiple IFS functions

Overview of Financial Modeling

• What is Financial Modelling?
• Model Design
• Skills needed for Financial Modelling
• Understanding Financial Statement Analysis
• Accounting fundamentals including financial statement construction and linkages

Revenue and Cost Drivers

• Building revenue model/calculation based on growth drivers
• Calculation of cost of sales based on inflation rate
• Calculations of fixed and variable operating expenses

Incorporate Relevant Schedules

• Fixed Asset Schedule
• Depreciation Schedule
• Loan Amortization/Interest Schedule
• Payroll Calculations

Financial Statement Projections Model

• Preparation of robust and Integrated Financial Statements
• Income Statement
• Balance Sheet
• Cash Flow Statement

Powerful Scenarios

• Understanding of scenarios
• Use of switch to create scenarios and value drivers
• Base, Best and Worst case scenario calculations
• Integration of of base, best and worst case scenarios on financial statements

PROGRAM DURATION

The program is of one full day duration (9:00 AM to 5:00 PM).

Trainers

Abdul Shakoor, CPA, AFA UK

Abdul is working as chief financial officer (CFO) for a leading manufacturing group and is an experienced professional in the field of accounting, finance and financial modeling. He is also Regional Director of Institute of Financial Accountants (IFA) UK for Pakistan and teaches in University of the Punjab as an adjunct faculty member. Previously, he was engaged with PAC group of Colleges, a leading institute for Chartered Accountancy. Professionally, he is:

• Advanced Financial Modeler (AFM) from Financial Modeling Institute (FMI), Canada
• Associate Member of Institute of Financial Accountants (IFA) UK
• Member of Institute of Public Accountants (IPA) Australia,
• Associate Certified Public Accountant (ACPA)
• Chartered Institute of Management Accountants (CIMA) UK (Strategic Case Study to Attempt)
• Master of Philosophy in Management Sciences

Saad Zubair Vohra, AFA, MIPA, CFM UK

Saad Zubair Vohra AFA-MIPA a Trainer, Facilitator and a proud EXCELpreneur, possessed over 5 years’ experience in delivering online, classroom & in-house training/workshops. He is the Founder of Crescent Solutions, offering distinguished services as Business and Tax Consultant, Financial Modeler, Certified Microsoft Office Specialist and Excel Trainer.

With over five years of experience as a CEO of Crescent Solutions, he has helped business leaders with their most complex strategic problems by using advanced technology in financial modelling. He has worked with all layers of business across wide range of industries, therefore, in a very short span of time, he gained the repute of an international level trainer with his knowledge of enabling learning environment & retention in least possible time. Apart from it, he has been actively involved in training & teaching with many organizations and institutions as a visiting faculty member. Professionally he is:

• Certified Financial Modeler (CFM) UK
• Associate Member of Institute of Financial Accountants (IFA) UK
• Member of Institute of Public Accountants (IPA) Australia,