Feb 2012
| 22/02/2012 - 24/02/2012 08:00 -17:00 |
Financial Modelling Masterclass Cape Town, Cape Town |
| 22/02/2012 - 24/02/2012 08:00 -17:00 |
Risk Management Masterclass Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 27/02/2012 - 29/02/2012 08:00 -17:00 |
Marketing Strategy Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
Mar 2012
| 01/03/2012 - 02/03/2012 08:00 -17:00 |
Specialised Excel Techniques for Modelling Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 05/03/2012 - 06/03/2012 08:00 -17:00 |
Balanced Leadership Programme Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 05/03/2012 - 06/03/2012 08:00 -17:00 |
Equity Analysis Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 07/03/2012 - 09/03/2012 08:00 -17:00 |
Financial Modelling Masterclass Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 07/03/2012 - 08/03/2012 08:00 -17:00 |
HR Business Partner Programme Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 12/03/2012 - 13/03/2012 08:00 -17:00 |
Specialised Excel Techniques for Modelling Hilton Hotel, Durban, Durban |
| 12/03/2012 - 14/03/2012 08:00 -17:00 |
Treasury Risk Management Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 14/03/2012 - 16/03/2012 08:00 -17:00 |
Financial Modelling Masterclass Hilton Hotel, Durban, Durban |
| 15/03/2012 - 16/03/2012 08:00 -17:00 |
Mergers and Acqusitions Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 19/03/2012 08:00 -17:00 |
Emotional Intelligence Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 20/03/2012 - 20/05/2012 08:00 -17:00 |
Presenting with Presence and Power Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 26/03/2012 - 28/03/2012 08:00 -17:00 |
Social Media for Business Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
Apr 2012
| 02/04/2012 - 03/04/2012 08:00 -17:00 |
Portfolio Management Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 18/04/2012 08:00 -17:00 |
The Neuropsychology of Selling Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
May 2012
| 02/05/2012 - 04/05/2012 08:00 -17:00 |
Trading Psychology Boot Camp Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 05/05/2012 - 27/05/2012 08:00 -17:00 |
CFA® 1 Exam Preparation Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 09/05/2012 - 11/05/2012 08:00 -17:00 |
Managing Service Providers Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 14/05/2012 - 15/05/2012 08:00 -17:00 |
Specialised Excel Techniques for Modelling Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 15/05/2012 - 16/05/2012 08:00 -17:00 |
Build the Brand - A Company Called ME Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 21/05/2012 - 23/05/2012 08:00 -17:00 |
Financial Modelling Masterclass Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 28/05/2012 - 29/05/2012 08:00 -17:00 |
Introduction to Derivatives Markets Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 31/05/2012 - 01/06/2012 08:00 -17:00 |
Fundamentals of Financial Markets Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
Jun 2012
| 04/06/2012 - 05/06/2012 08:00 -17:00 |
Client Relationship Management Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 06/06/2012 - 08/06/2012 08:00 -17:00 |
Budgeting and Forecasting Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 18/06/2012 - 20/06/2012 08:00 -17:00 |
Financial Modelling for Mining Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 20/06/2012 - 22/06/2012 08:00 -17:00 |
Social Media for Business Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 25/06/2012 - 27/06/2012 08:00 -17:00 |
Strategic Planning for Banking and Finance Professionals Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 26/06/2012 08:00 -17:00 |
Financial Report Writing Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
| 27/06/2012 - 29/06/2012 08:00 -17:00 |
Financial Modelling Masterclass Paton 4th Floor, Hyde Park Corner, Johannesburg Gauteng |
Loading Map....
Date/Time
Date(s) - 15 Feb 2012 until 17 Feb 2012
8:00 AM - 5:00 PM
Location
Paton 4th Floor, Hyde Park Corner
Category(ies)
This highly practical 3-day workshop teaches delegates how to effectively prepare and structure financial models. It also provides useful modelling techniques that can immediately be applied in the work place. Delegates must be familiar with Excel’s advanced functions pertaining to Financial Modelling.
The following topics are covered in detail:
-
The process of building a financial model from scratch, understanding the importance of model specifications, structure and setting up the required sheets and financial statements.
-
The interaction between Income Statements, Balance Sheets, and Cash Flow statements in financial models, and the necessity for utilising this approach.
-
Specialised Excel techniques so far as they pertain to financial models, e.g. sensitivity analyses, create scenarios and data tables, etc.
-
Discussions and exercises on the Weighted Average Cost of Capital (WACC), Net Present Values (NPVs) and Internal Rates of Return (IRR), and the importance of these measurements.
-
Knowledge related to setting up “switches” in their models, allowing users to investigate the effect of different alternatives.
-
Insight into the preparation of a valuation model (DCF) and the structure of M&A models incorporating the relevant Excel techniques and functions.
-
Optimisation models utilising Excel’s “Solver” function
-
Random probabilities, regression analysis and Monte Carlo simulations
For more information OR to request a course brochure please contact Gabby Noche on 011 325 5400 or e-mail gabby@patontraining.com