Financial Modeling

SECTION ONE: ADVANCED MICROSOFT EXCEL SKILLS

• Introduction – Speed Networking
• Getting Off to a Flying Start!
• Using Excel Functions to Advantage
• Using Power Tools in Excel
• Creating Dashboards, Reports & Charts
• Exercises: You will design and implement a proper dashboard and reporting capability within a model that will inform, enlighten and provide valuable insights for the intended user.

SECTION TWO: MACRO DESIGN & CONSTRUCTION AND OPTIMISATION TECHNIQUES

• Optimisation Techniques in Financial Modelling
• Introduction to Spreadsheet Macros
• More on Programming using VBA
• Creating User-defined Functions
• You will be provided with a number of pre-written functions that are not operating as intended. You will debug the functions to ensure that they are operating correctly.

SECTION THREE: PROFESSIONAL APPROACHES TO MODEL DESIGN & CONSTRUCTION AND FINANCIAL FORECASTING

• Professional Approach to Building a Financial Model
• Forecasting for Modelling Applications
• Forecasting Financial Statements
• Case study
• You will create an application to analyze historical financial statements belonging to a real company and then use the analysis to prepare a one-year forecast of the key numbers on the financial statements.
• Modeling Value at Risk (VaR) Calculations

SECTION FOUR: DESIGN & CONSTRUCTION OF MODELS FOR COMPANY VALUATION & PROJECT APPRAISAL

• Session 1 – Modelling the Weighted Average Cost of Capital (WACC)
• Session 2 – Constructing Models for Project & Investment Appraisal and Decision-Making
• Session 3 – Constructing Models for Company Valuation & Related Applications
• Valuation Modelling Case Study

SECTION FIVE: ADVANCED MODELLING CONCEPTS, TOOLS, AND TECHNIQUES

• Financial Modelling for Leasing Applications
• Exercise: Using the project evaluation model which you created on day four of the course, you will examine the impact of different modes of financing on the financial viability of the project.
• Using Monte Carlo Simulation for Risk Evaluation in Financial Modelling
• Exercise: You will use the project evaluation model which you created on day four of the course to explore the advantages of using Monte Carlo Simulation to analyze the risk profile of the project.
• Financial Options and Options Pricing Models
• Exercise: You will use the Black-Scholes model and the binomial model to price a variety of financial options and then comment on your findings.
• Walking Through Real-life Models
• In this session to wrap-up the course, the course director will walk you through a number of real-life substantive models in order to introduce you to several of the complexities and challenges that modelers face in the workplace. He will also suggest ways in which such complexities and challenges can be managed.