|
| Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the National Qualifications Framework Act, 2008. |
|
|
| DETAILS |
Date and Venue:
No future dates have been scheduled for this workshop. Please contact us for more information. |
Maps:
Click Here |
Maps:
Click Here |
Time:
8:30 AM |
Duration:
1 Day |
Cost Per Delegate:
| R2 180.00 |
ex VAT |
| R2 485.00 |
incl VAT |
|
Surcharges:
R50 (Incl VAT) per delegate, per day for Strictly Halaal and Kosher Meals |
Group Bookings:
Bookings of 2 or more delegates qualify for a 10% discount.
|
Out-of-town Delegates:
If you are flying in from out-of-town in order to attend, we will give you a 15% discount on the cost of the workshop.
Contact us to find out more. |
Please Note:
This training is conducted on Microsoft version 2003, if you are using version 2007, kindly bring this to our attention. |
|
|
|
|
| IN HOUSE |
This workshop is also available under Front Foot’s in-house menu.
Front Foot is proud to offer you a comprehensive array of customised in-house training solutions that are focused on your unique business needs. For more information in this regard, please contact us. |
|
|
|
| UNDERSTAND AND ANALYSE WITH EASE |
Comprehensive array of topics and step by step training
This distinctive one-day workshop offers a unique insight into how Excel can assist you in assessing capital investment opportunities. A comprehensive array of topics - from basic, everyday concepts to advanced techniques such as Monte Carlo Analysis - are clearly presented, using a guided, step-by-step training methodology.
Advanced and specialised Excel functionality
Aimed at further enhancing your knowledge of Excel for the purposes of advanced functionality, this intensive one-day workshop enables you to utilise normally uncharted territory in the one of Microsoft’s most powerful Office Suite offerings.
Please note: This course specifically targets specialised and advanced Excel functions. In order to maximise the benefit of this course, delegates are required to already have a good working knowledge of the basic functions available on Excel. Where delegates do not meet this criterion, Front Foot offers comprehensive Excel training in our popular “Get the Best Out of Excel” Workshop. In order to facilitate personalised attention, and maximum lecturer interaction, seats are limited. |
|
| REGISTER NOW |
|
| Front Foot courses are compiled and presented by subject matter experts and industry specialists to ensure the highest and most current standard of excellence in all our workshops and training |
| WHAT WILL YOU LEARN |
 |
Discover the underlying assumptions of time value of money calculations |
|
Discover how to determine the appropriate discount rate |
|
Discover the strengths and weaknesses of alternative methods |
|
Discover which cash flows should be included and which should be excluded from the assessment exercise |
|
Discover how to use Decision Trees to assess projects which have more than one possible outcome |
|
Discover how to perform Sensitivity Analyses to determine the effects of variations from expected outcomes |
|
Discover how to perform Monte Carlo Analyses to measure the risks involved in the investment |
|
| WHO SHOULD ATTEND |
|
Project Managers |
|
Financial Managers |
|
Marketing Managers |
|
Chief Information Officers |
|
Planning Officers |
|
Business Analysts |
|
| ONE DAY WORKSHOP OUTLINE |
| Net Present Value |
|
Issues in Capital Budgeting |
 |
The Basic Time Value of Money Relationship |
|
The One- and Multi-Period Cases |
|
What Discount Rate is Appropriate? |
|
Simplifications |
|
Exercises |
|
|
|
Sunk Costs |
|
Incremental Cash Flows |
|
Inflation and Capital Budgeting |
|
Investments of Unequal Lives: The Equivalent Annual Cost Method |
|
Exercises |
|
| Alternative Investment Rules |
|
Strategy and Analysis |
|
Why Use Net Present Value? |
|
The Payback Period Rule |
|
The Discounted Payback Period Rule |
|
The Average Accounting Return |
|
The Internal Rate of Return (IRR) |
|
Problems with the IRR Approach |
|
Using Modified Internal Rate of Return (MIRR) as an alternative to IRR |
|
The Profitability Index |
|
The Practice of Capital Budgeting |
|
Exercises |
|
|
|
Decision Trees |
|
Sensitivity Analysis, Scenario Analysis, and Break-Even Analysis |
|
Monte Carlo Analysis |
|
Exercises |
|
|
| OTHER WORKSHOPS YOU MIGHT ENJOY |
|
|
|
