Our website is updated regularly. Please refresh your pages.

Fees per delegate
R6 995.00 (excluding VAT)

Included in the fees

• Course material
• Parking
• Refreshments
• Lunch
• Certificate of Attendance

Enquiries

E-mail Hennie or phone him on (011) 726-3040

Payment

Electronic Transfers
Name: Equity Compliance and Solution
Bank: FNB
Branch: Northcliff
Branch Code: 253 705
Account No: 62063883964

Cheques to be made payable to Equity Compliance and Solution.

Please fax a copy of the deposit slip together with the registration form to Hennie on (011) 726 2400.

Please do not mail payments.

Excel Applications in Financial Management and Modeling
A Two-day PC-based Event
An opportunity to have the power of Excel revealed, designed to take you through the functions and applications of Excel when dealing with financial data

FOR A BROCHURE & REGISTRATION FORM IN PDF FORMAT ... [ click here ]

Introduction

It is well know that many users of Excel working with financial data do not make optimal use of what the Excel package offers. The following are some of the inefficiencies that result:

• Time is wasted
• Undetected errors in worksheets with numerous negative implications
• Decisions based on scanty information which has not been fully analysed

This two-day course is an opportunity to have the power of Excel revealed. It is designed to take participants through the functions and applications of Excel which have application when dealing with financial data. It is aimed at providing an opportunity to enhance understanding of the value drivers in business, financial acumen and skills to use financial models and enable more informed and justified proposals and decisions.

Training Methodology

This is essentially a hands-on programme. Each delegate is requested to bring their own laptop computer with Microsoft Office 2007. The programme facilitator will explain financial theory and Excel applications. A series of workbooks with application cases will be completed by delegates following the demonstrations. Each case will include the completed solution to enable the delegates to refer to the Excel functions being used. A number of financial models will thus be developed by delegates.

It is worth noting that skill in Excel requires repetitive practice. While length constraints of the course may not always provide the time needed for all delegates, the models which will be taken from the course will enable practice in particular interest areas to continue. Also, Excel itself contains an extensive Help Menu, which can be called up at any time and relevant sections can be printed. In addition, delegates will be given copies of the PowerPoint presentation.


Competencies Emphasized

This course emphasizes two competencies. The dual objectives are firstly the understanding of the financial principles that underlie the topic under discussion and secondly that of enhancing ability and competency using Excel, for the purpose of financial modeling, forecasting and scenario building. 


Course Contents

There are four sessions each day for two days. Objectives and content for each session are listed in the course outline. A financial modeling case study is set for each of the eight sessions of the course duration. The order of the course presentation is as follows:

1. Finding your way around the Excel Ribbons
2. Building models and finding your way around Excel Worksheets
3. Analyzing Budgeting Models
4. Financial Statement Preparation and Analysis
5. Dealing with Tables of Data
6. Decisions with limiting constraints
7. The Time Value of Money, Loans and Business Valuation
8. Determining the cost of capital and analyzing capital investment projects

Course Prerequisites

Delegates on this course should have a basic working knowledge of Excel (how to enter formula and how to work with cell references). The first session, however, does not assume too much prior knowledge and offers a quick review of Excel functionality in an attempt to proceed with all delegates having confidence that the basics have been mastered. 

PROGRAMME

Session 1: Finding your way around the Excel Ribbons Definition of a Financial Model. Different types of Financial Models The Ribbon Tabs of Excel [Home, Insert, Page Layout, Data, Review, View and Developer] Excel Options [Customize, Quick Access Toolbar] Spreadsheet design and structure [Data, Variables, Output] CASE: Building a Quick Access Toolbar

Session 2: Build models and find your way around Excel Worksheets Structure of a File, Worksheet and Tabs Entering and viewing formula Formatting and conditional formatting Basic Audit Tools Inserting Comments Finding, replacing, sorting and filtering data Financial and Statistical functions  CASE: Preparing a Model for Monthly Sales, Copying and Anchoring Cells

Session 3: Analyzing Budgeting Models Principles of preparing operating budgets Naming cells and ranges Inserting Charts and graphs Data Validation Alternative scenarios using What if Analysis and Goal Seek CASE: Preparing a short budget, using Goal Seek and Scenario Manager

Session 4: Financial Statement Preparation and Analysis Review of the Income Statement, Balance Sheet and Cash Flow Statement Identifying and calculating key performance indicators Return on Investment, Return on Assets, EBITDA as indicators of performance Writing a report of business performance. Embedding Excel worksheets in a to an MSWord report CASE: A model for financial analysis and interpretation of the output

Session 5: Dealing with Tables of Data Dealing with data in tables Writing a Macro for downloaded data Filtering and using Pivot tables Collecting data from one table for inserting in another The Lookup functions Introducing checks on accuracy of model output CASES: Writing a Macro, using pivot tables and VLookup

Session 6: Decisions with limiting constraints Principles of forecasting Listing, applying and changing assumptions in models Use of Trendline functions and charting Basic application of Solver when there are limiting factors The behaviour of costs. Fixed and Variable Determining the break even point and margin of safety in planning CASES: Using Solver where there are limiting factors, Building a Break Even Model

Session 7: The Time Value of Money, Loans and Business Valuation Principles of Time Value - the 4 tables in the mathematics of finance Lump sum and Annuity calculations Debt repayment schedules Basic business valuation principles Using listed company data to value private companies Growth models and discounted cash flows CASES: Discounted cash flows to value a business

Session 8: The cost of capital and analyzing capital investment projects Principles of cost of equity, cost of debt and weighted average cost of capital Establishing the WACC Discounted cash flows in capital investment appraisal Establishing the Net Present value of a project Establishing the Payback period of a project Comparing the hurdle rate with the Internal Rate of Return of a project Sunk costs and opportunity costs Dealing with inflation in forecasting Application of scenario analysis to capital investment appraisal. CASE: Forecasting cash flows, determining NPV and IRR

ABOUT YOUR EXPERT PRESENTER

Professor David Flynn holds degrees from a number of South African universities in the area of business, finance and accounting. He is currently employed both as a consultant and as an Associate Professor in the School of Management Studies at the University of Cape Town and a visiting professor at Rhodes Investec Business School.

He has served as an academic, being the Head of the School of Accounting which prepares chartered accountants. The School has a staff of over 70 academics and more than 3 000 registered students. During that time, he authored and co-authored a number of texts in the field of financial accounting and financial management. He also held a sabbatical academic position at the University of Windsor in Canada.

Following a career in academia, David served as Head of Research at Old Mutual Asset Managers, a company listed on the JSE and London Securities Exchanges, and also as Chief Operating Officer of an Investment company listed on the JSE Stock Exchange. More recently he works as an academic, an author, a practitioner and as a seminar presenter. He travels widely in order to present seminars and has most recently served as a facilitator in Kuwait, Kuala Lumpur, Johannesburg, Manila, Shanghai and Sao Paulo.

	ENQUIRIES ABOUT OUR CONSULTING SERVICES E-mail Lungile Nxumalo or phone Lungile on (011) 726-3040
	ENQUIRIES ABOUT OUR WORKSKOPS AND SEMINARS E-mail Hennie Oosthuizen or phone Hennie on (011) 726-3040
	ENQUIRIES ABOUT OUR CONFERENCE CENTRE E-mail Caroline Chamboko or phone Caroline on (011) 726-3040
	ENQUIRIES ABOUT OUR CONFERENCES E-mail Ryan Muller or phone Ryan on (011) 726-3040