This programme will enable participants to create and understand Excel-based valuation models and will provide hands-on experience in building models to help you understand the valuation process so that you can formulate efficient and transparent analyses to optimise your organisation’s decisions.
How You Will Benefit
Various case studies will be discussed and delegates will be required to perform their own valuations to ensure that they extract and are able to apply the relevant insights and techniques. The emphasis will be on the identification and forecasting of cash flow drivers for the business, techniques for valuing terminal cash flows beyond a forecast period, and the identification of the optimal cost of capital.
Key Outcomes:
- Understand the essentials of financial valuation
- Strengthen your ability to build comprehensible valuation models
- Integrate accounting-based concepts with valuation
- Understand cash flow versus accounting numbers and their importance in valuation
- Quantify and understand risks
- Modify your modeling for less-developed financial markets
- Sharpen your advanced Excel skills
Who Should Attend?
Finance professionals who need to build and assess models in Excel or who need to have a better understanding of the valuation process and models created by others. Executives involved with investment and due diligence decision-making processes in their organisations.
Prerequisites
Although this programme includes a thorough review of basic finance concepts, it will be much more meaningful to you if you have a basic understanding of financial analysis, accounting, and Excel. All advanced concepts will be explained during the programme.
Learning Formula
A text will be prescribed for this programme - Principles of Finance with Excel (PFE), 2nd edition by Simon Benninga. Additional materials include cases and hands-on exercises.
Computers and Excel Versions
Participants will be required to attend with a laptop computer that has a recent version of Microsoft Office installed. Excel 2010 for a Windows-based PC will be used. This should be fully compatible with Excel 2007 or Excel 2003. If you use a Macintosh, please install Office 2011 for Mac, which includes VBA.
Faculty
Simon Benninga is Professor of Finance at the Faculty of Management at Tel-Aviv University. He was Dean of the Faculty of Management from 2003 to 2007. Born in Holland and raised in North Carolina, Benninga immigrated to Israel in 1969 after completing his undergraduate education at the University of Michigan. He has advanced degrees from the Hebrew University (M.Sc. in mathematics, 1973) and Tel-Aviv University (Ph.D. in finance, 1977).
Before joining Tel-Aviv University in 1998, Benninga taught at the Hebrew University of Jerusalem and the Wharton School of the University of Pennsylvania. He has held visiting positions at UCLA, Otago University of New Zealand, and the University of Groningen in Holland.
Benninga’s academic areas of interest are corporate finance, term structure, and computational finance. His executive teaching and consulting is in the areas of financial modelling and valuation. He is the author of over forty academic papers and of four books. From 1995 to 2003 Benninga was the editor of the European Finance Review, the journal of the European Finance Association.
Duration: 3 days
Fees: The fee of R19 950 includes tuition, instruction material, textbooks, lunches and refreshments, and is VAT exempt. No registration will be confirmed without payment.
Cancellation Policy
Delegates who cancel their registration after the closing date for registrations, or where there is no closing date, less than 14 days prior to programme commencement, will be liable for 50% of the programme fee. Those who do not arrive for the programme will be liable for the full fee. Notification of cancellation must be sent in writing either via e-mail or via fax. All who cancel or do not attend must return the course material intact.
Contact Us
Tel: 011 771-4313
E-mail:execed@gibs.co.za