Course Detail

Stay ahead...Enhance your technical skills through our world class training programs



Financial Modelling With MS Excel

Financial modelling, more than any other activity, provides the foundation for meaningful budgets and project evaluation. Surveys have however consistently demonstrated that more than 80% of models/spreadsheets contain significant errors – suggesting the possibility of major business decisions being made on the basis of incorrect information! Through this intensive 3-day course, learn to develop robust, consistent and error-free financial models that increase the accuracy of forecasts/ budgets and assist in investment decisions.

Introduction

  • The Modelling Process
  • Modelling Best Practices
    • Separation, Consistency, Integrity, Protection, Colour Coding, Modular technique

Defining Input/Assumptions

  • Macro-economics
  • Project Cost
  • Financing
  • Estimating the Explicit Forecast period
  • Revenue
  • Expenditure
  • Setting-up Scenarios

Setting-up the Reports

  • Statement of Profit or Loss
  • Statement of Financial Position (Balance Sheet)
  • Statement of Cash Flows
  • Summaries/KPIs
  • Charts

Forecasting - Detailed build-up of revenues and expenditure using the Modular technique

  • Revenues
  • CAPEX
  • OPEX
  • Depreciation
  • Loan Amortisation and Interest
  • CAPM and WACC
  • Demonstrate inter-relationships between input, calculation modules and reports
  • Double Entry
  • Error checks

Financial Ratios and Key Performance Indicators

  • Liquidity Ratios
  • Activity Ratios
  • Coverage Ratios

Investment Appraisal/DCF Valuation

  • Free Cash Flows
  • Cost of Capital Fundamentals
  • DCF Valuation Model
  • IRR, NPV and Pay-back Analysis
  • Enterprise Valuation
  • Equity Valuation

Sensitivity Analysis/Tables

  • Data Tables

Scenario Analysis

  • Adding and using Form controls on worksheets

Simulations

  • Break-Even Analysis
  • Monte Carlo Simulation

Optimization and Targeting

  • Goal Seek and Solver

We offer discounts for group bookings (i.e group of delegates attending the same course at the same time) as follows:

    3-5 participants - 5% discount
    6-9 participants - 7.5% discount
    10 or more participants - 10% discount