|
| Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act. |
|
|
|
| All Front Foot Microsoft workshop presenters are Certified Microsoft Application Specialists. |
|
|
| DETAILS |
Date and Venue:
17th September 2010 at Benvenuto Conference Centre in Randburg
19th October 2010 at Benvenuto Conference Centre in Randburg
18th November 2010 at Benvenuto Conference Centre in Randburg
|
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. |
|
|
|
| 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 YOUR
ORGANISATION'S GROWTH POTENTIAL |
Successful managers can look into the past and predict the future!
The study of financial decision making is inherently a topic requiring lots of computation. On this workshop the computation is done in, and illustrated with Excel, the premier business computational tool. This powerful combination gives you the flexibility and know-how to change the elements of an example and immediately get a new answer.
Practical learning session with templates and exercises
Although this is not an “Excel Course”, your knowledge of both financial issues and Excel will be enhanced, particularly as you will be supplied with prepared Excel models for the exercises, enabling you to concentrate on the logic behind the models. |
|
| REGISTER NOW |
|
| KEY BENEFITS OF ATTENDING |
You will learn how to interpret and use financial information to budget, track performance, determine variances & analyse results. You will also gain a better understanding of business structures and the relationship between risk and return.
By the end of this workshop, you will be more familiar with the major financial statements, the difference between profit and cash flow and concepts in capital expenditure decision analysis. You will also learn different cost element patterns of behaviour and how these affect budget preparation and management. |
|
| WHO SHOULD ATTEND |
| Financial Modelling is for anyone that needs to forecast revenues and expenses, model changes in any of the business inputs and analyze business performance. Good Excel skills are required |
|
| ONE DAY WORKSHOP OUTLINE |
| Working with an Excel model worksheet, you will gain a clear understanding of: |
| The Excel Basics |
 |
Scenarios |
|
Goal Seek |
|
Solver |
|
Conditional Formatting |
|
LOGIC and LOOKUP statements |
|
Calculating Compound Growth Rates |
|
Sensitivity Analysis with the Sense-It Add In |
|
| The Structure of the Model |
|
Drawing Data into the Balance sheet, Income Statement and Cash flow statement |
|
Maintaining balance with EXACT |
|
Using Excel to determine the sales and cost drivers in a business |
|
Calculating the Growth Rate you need with Goal Seek |
|
Setting up the ratios for analysis |
| |
|
The four key ratios |
| |
|
The subsidiary ratios |
| |
|
Profitability ratios |
| |
|
Asset utilisation ratios |
| |
|
Financial leverage |
| |
|
Return on Invested Capital |
| |
|
Sustainable growth |
|
Testing the sensitivity of the profit figure to changes in the budget components |
|
Simulate the possible outcomes |
Budgeting for Revenues and Expenses
Budgets are often “the same as last year, but a bit better.” Now, discover how to produce budgets which are not merely an extrapolation of the past, but are based on scientific methods. |
|
Using Excel to analyse the historical sales trend |
|
Different methods of forecasting the future |
Budgeting for Capital Expenditure
Discover how to assess capital expenditure proposals. Become familiar with the strengths and weaknesses of the various methods used |
|
The Payback method |
|
Net Present Value |
|
Discounted Payback |
|
Internal Rate of Return |
|
Modified Internal Rate of Return |
|
How to determine the Required Rate of Return |
|
|
| OTHER WORKSHOPS YOU MIGHT ENJOY |
|
|
|
Recommend this workshop on Facebook
