Financial modelling with Excel
This exciting workshop offering will teach you how utlise MS Excel - the premier business computational tool - for this process, giving you the flexibility and know-how you need to quickly and efficiently change data elements and immediately provide new answers.
What will be covered on this one-day workshop?
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
Budgeting for revenues and expenses
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
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre in Randburg, Randburg
Cost: R2,350 excl. VAT
Date: 18 April 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre in Randburg, Randburg
Cost: R2,350 excl. VAT
Date: 20 June 2016
Time: 08:30 - 16:30
Venue: Benvenuto Conference Centre, Randburg
Cost: R2,350 excl. VAT