linkedin

Financial Modelling Masterclass

Dates: 23 July 2012 - 25 July 2012
Venue: IIR Training House, Rosebank, Johannesburg
Contact: This email address is being protected from spambots. You need JavaScript enabled to view it.

iir-register-now iir-tell-a-friend iir-brochure-download iir-pricing iir-subscribe-to-updates


Take the Self-Assessment Test

This course is based entirely on Microsoft Excel, the spreadsheet package that has become the standard analytical tool in business. However, Excel has many specific analytical limitations. Therefore, this course includes several Excel add-ins that greatly enhance Excel’s capabilities. The add-ins will enable you to perform:

  • Risk simulations
  • Assess the sensitivity of your model to changes in the inputs
  • Assess the expected value of projects overall and at critical milestones

These add-ins comprise what is arguably the most impressive assortment of spreadsheet based software accompanying any financial modeling course on the market. (Note: the software is not time limited.)

 Common uses of financial modelling include the following:

  • Data Analysis. Analysing current data to optimize operations – either minimize costs or maximize profits
  • Forecasting. Analysing historical data and using the results to predict future trends.
  • “Monte Carlo” simulation. Inserting random data into a model to measure the impact of uncertainty on the outcome of a project.

BENEFITS TO THE DELEGATE

  • Learn the most effective ways to design and structure your financial models to evaluate risk
  • Learn how to assess probabilities in business
  • Learn how to use Excel’s own advanced functions and cutting edge Excel Add-ins to evaluate risk
  • Solve your financial modelling problems in uncertain times
  • Learn how to chart data to gain insight into complex relationships
  • Gain practice using Excel advanced functions and Add-ins                                

BENEFITS TO THE DELEGATE’S ORGANISATION

  • Gain insight into the risks and uncertainties in your company’s industry
  • Gain quantitative measures of the risks in your industry
  • Understand both the upside and downside risks when making decisions
  • Gain insights into what really drives Sales, Costs and hence Profits