Financial Modelling in Excel

Johannesburg “The greatest and most professional Excel seminar I ever had.” Past delegate, January 2007 E U RO M O N E Y T R A I N I N G E M E A A division of Euromoney Institutional Investor PLC Financial Modelling in Excel Learn how to construct different financial models and analyse their applications and uses: • Model Design and Structure • Monte Carlo Simulations • Optimisation and Targeting • Sensitivity and Risk • Testing and Auditing a Model • Management Reporting and Forecasting On completion of this 3-day training programme delegates will be able to: • Understand the different types of financial models and when each should be applied • Construct models that are financially rigorous linking profit and loss, balance sheet and cash flow statements • Incorporate elements such as risk, sensitivity, optimisation and forecasting into the model • Produce the output in typical VBM formats e.g. bubble charts, waterfall diagrams, flying brick charts Course Director: Alastair Day Date 1: 23 - 25 July 2008 Date 2: 10 - 12 December 2008 Venue: Johannesburg, South Africa This programme is available in-house. For further information please contact Ms Anna Jakimova +44 207 779 8085 emea@euromoneytraining.com Euromoney Training EMEA Public, sponsored and in-house training Financial Modelling in Excel Johannesburg, South Africa COURSE BACKGROUND Euromoney Training EMEA is a division of Euromoney Institutional Investor Plc, a leading world provider of business-tobusiness financial information. We offer over 300 public programmes in more than 40 countries across Europe, Middle East and Africa, with all courses available in-house on request. Public programme calendars are available for each region. Working together – co-host a public programme in your country You will benefit from: • highly cost effective training • a share of the publicity in bringing an international, high level event to your region. Choose any programme from our portfolio and let us know how many people you have - a small group of 3 or up to 30. When looking at any financial opportunity, the ability to perform accurate and realistic analysis is imperative. In today’s ever-changing business environment, the capability to just manipulate spreadsheets is not enough. You have to be able to incorporate all the “what if” scenarios and stress any proposal to its limits. A working financial model can facilitate and improve the reliability and quality of your decisionmaking. Modelling techniques are used in many different areas, such as investment appraisal, capital planning, budgeting, valuation, financial analysis and forecasting. Banks and businesses worldwide rely on the information produced by financial models – for many it is the key to success. COURSE STRUCTURE The course begins by concentrating on the advanced use of Excel. These skills will be applied to the construction of financial, valuation and investment models. Delegates will then learn how to incorporate forecasting, optimisation, risk assessment and sensitivity scenarios into these models. The course is taught using a step-by-step approach so delegates will be able to construct financial models for a wide range of practical scenarios. TEACHING METHODOLOGY The programme is taught using formal lectures combined with practical and interactive case studies and exercises to reinforce the concepts covered in each teaching session. Emphasis is placed on delegates gaining practical, hands-on experience of the design and construction of financial models in Excel. Comprehensive product notes and modelling software will be provided for future reference. The course is very practical with a case study in session four of each day, and other exercises in each of the sessions. The investment model started on day one is added to on days two and three. In-house training Our in-house courses offer a highly cost-effective training option for you and your clients. We can deliver all of our programmes in your chosen location at a time which is convenient for you. For further information, please contact: Ms Anna Jakimova Director of Euromoney Training EMEA Tel: +44 207 779 8543 Fax: +44 207 779 8140 Email: emea@euromoneytraining.com WHO SHOULD ATTEND This course has been designed for: • CFOs • Financial controllers and managers • Financial & business analysts • Risk managers • Accountants • Corporate treasury managers • Middle office staff • General managers Hotel Booking If you require assistance with booking accommodation for one of our courses, please contact our logistics team on +44 207 779 8543 or email emea@euromoneytraining.com indicating the course you will be attending, the venue and the dates you wish to stay. COURSE DIRECTOR: ALASTAIR DAY Alastair Day is a finance professional with extensive experience of business analysis systems, accounting, funding and treasury activities, risk and portfolio management, taxation and documentation for finance and leasing companies. In 1983, Alastair joined the Technology Group Limited (TGL), where he established the treasury function and organised individual transaction funding, together with installing rental receivable and administrative systems for this rapidly expanding leasing company. In addition, Alastair designed a business evaluation system for capturing enquiries, processing deals and payments and producing management reports for sales and accounting purposes. Alastair works as a consultant with Euromoney Training, designing and delivering courses covering financial modelling, accounting, taxation, pricing and structuring and lease evaluation. Alastair has a degree in German and Economics from London University and an MBA from the Open University Business School specialising in corporate finance, performance management and evaluation and medium term forecasting. 5 easy ways to register and obtain further information 1 tel: +44-20-7779 8543 2 fax: +44-20-7779 8140 3 e-mail: emea@euromoneytraining.com 4 web: www.euromoneytraining.com/africa 5 mail to: Euromoney Training EMEA, Nestor House, Playhouse Yard, London EC4V 5EX, UK Financial Modelling in Excel Johannesburg, South Africa Agenda Day One INTRODUCTIONS Introduction and Overview • Overview of the course • Scope of modelling • Objectives of modelling • Different models by application • Useful Excel features • Listing of modelling techniques Exercise: Model review Building a Model 1 • Model design and structure – key steps Exercise: Defining a model plan • • • • • • • • Model objective Flowchart and information flow Defining outputs Defining inputs and variables Setting up modules Menu structure Help Documentation Day Two RISK SCENARIOS AND SIMULATION FORECASTING MODELS Forecasting Models • Review of forecasting methods • Macro forecasting • Linear methods • Smoothing techniques • Seasonal forecasts • Multiple regression Example: Adding a forecast to financial analysis model Risk Techniques • Understanding of risk • Sensitivity table • Scenario analysis • Dynamic what-if • Standard deviation and coefficient of variation • Certainty equivalents Example: Adding risk techniques to financial analysis/valuation model Risk and Simulation • Building a simulation model • Monte Carlo simulations Example: Financial analysis model Practical Exercise: Investment Analysis 2 Adding sensitivity to the investment model Questions and Answers Day Three OPTIMISATION AND REPORTING Optimisation and Targeting • Overview of optimisation and targeting • Goal seek method • Optimisation using Solver • Linear programming Example: Financial analysis / valuation Practical Exercise: Investment Analysis 3 Extend the investment model and calculate optimum net present value Management Reporting • Management summary • Reporting • Consolidations • Summary and pivot tables Example: Monthly management model Example: Consolidation model Practical Exercise: Management Reporting and Forecasting Analysis of company financial data Exercise: Produce a management summary report with charts Questions and Answers Example: Financial analysis model Building a Model 2 • Testing and auditing a model Example: Testing a financial analysis model with cash flows and ratios Exercise: Debugging a financial model Practical Exercise: Investment Analysis 1 Practical investment model exercise Questions and Answers Delegates are encouraged to bring their own laptop computers during the course. If you are unable to bring a laptop, a desktop PC will be provided. www.euromoneytraining.com/africa 5 easy ways to register and obtain further information 1 tel: +44-20-7779 8543 2 fax: +44-20-7779 8140 3 e-mail: emea@euromoneytraining.com 4 web: www.euromoneytraining.com/africa 5 mail to: Euromoney Training EMEA, Nestor House, Playhouse Yard, London EC4V 5EX, UK ©Copyright Euromoney Training 2008 Financial Modelling in Excel Registration and further information Group booking Discounts* I 3 delegates - 10% discount I 4 delegates - 12% discount I 5 delegates - 15% discount *Available for delegates from one organisation attending the same course. Registration Financial Modelling in Excel I 23 - 25 July 2008, Johannesburg, South Africa (EOT4089) I 10 - 12 December 2008, Johannesburg, South Africa (EOT4108) In order to guarantee a place on the course delegates are kindly requested to register at least 6 weeks prior to the course start. Personal Details Please print clearly or attach business card Family Name (Mr/Mrs/Ms) First Name Position Department Company I I would like information on holding this programme in-house Address Postcode Country Course Fees Standard delegate fee: £2,250 Sterling E-mail Telephone Fax I understand and accept the booking terms & conditions Signature Date SAVE MONEY-10% DISCOUNT* Discounted delegate fee: £2,025 Sterling *Discount of 10% for second and subsequent delegates from the same institution on the same programme. This discount can not be used in conjunction with any other offer. Fees include all the tuition, full course documentation, lunches and refreshments for the duration of the programme. Incidental expenses: Euromoney Training EMEA is NOT responsible for covering airfare or other travel costs incurred by registrants. Delegates will be responsible for their own accommodation. Please note that Euromoney Training EMEA reserves the right to refuse admission to the training if proof of payment has not been received prior to the start of the programme. An invoice will be sent upon receipt of registration form. Payment must be received in full prior to the course start. Methods Of Payment I Please Invoice me/my institution. Purchase order no I CHEQUE enclosed with order for £ Euromoney Training. I Bank transfer quoting I EOT4089 or I EOT4108 Account Name: Euromoney Training Account No: Lloyds TSB Bank plc made payable to Cancellation Policy A full refund less an administration fee of £100 will be given for cancellation requests received up to 20 working days before the event. Cancellations must be made in writing (letter or fax) and reach this office before the 20 working day deadline. Delegates who cancel less than 20 working days before the event, or who don't attend, are liable to pay the full course fee and no refunds can be given. However, if you wish to attend the next course, and you have paid your course fee in full, you will only be invoiced for 25% of that course fee. Please note that you can only transfer once. Please note that the next course must take place within 6 months of the initial application. Of course, a replacement is always welcome. Disclaimer Euromoney Training EMEA reserves the right to change or cancel any part of its published programme or teaching faculty due to unforeseen circumstances. Customer Information The information you provide will be safeguarded by the Euromoney Institutional Investor PLC group whose subsidiaries may use it to keep you informed of relevant products and services. We occasionally allow reputable companies outside the Euromoney Institutional Investor PLC group to contact you with details of products that may be of interest to you. As an international group we may transfer your data on a global basis for the purposes indicated above. If you object to contact by telephone I fax I or email I please tick the relevant box. If you do not want us to share your information with other reputable companies please tick this box. I Branch: City Office Address: Po Box 72, Bailey Drive, Gillingham Business Park Kent, ME8 OSl, United Kingdom Account no: 00331851 Please Debit My Credit Card: I MasterCard/Access Card number: Card expiry date: Card holder name: Signature: Cardholder address: Company VAT Registration Number (EU Only): Date: I Visa I Amex I Diners Club Sort Code: 30-00-02 IBAN NUMBER: GB83 LOYD 300002 00331851 5 easy ways to register and obtain further information 1 tel: +44-20-7779 8543 2 fax: +44-20-7779 8140 3 e-mail: emea@euromoneytraining.com 4 web: www.euromoneytraining.com/africa 5 mail to: Euromoney Training EMEA, Nestor House, Playhouse Yard, London EC4V 5EX, UK