Now Updated For Excel 2016

Includes One Full Day On Essential Excel For Finance

Certificate In Financial Modelling Using Excel Top 5 Learning Objectives 1. Understand the essence of financial models and analyse their applications 2. Discover how to construct reliable and realistic financial models that work and are easy to review 3. Learn to measure, interpret and predict company performance using Excel modelling

Led by Danielle Stein Fairhurst

4. Improve your decision making processes and save time on financial analysis 5. Proficiently use Excel as an analytical tool and enhance your financial abilities

*Book and pay full fee for two colleagues and the third attends for FREE.

15 – 19 May 2016* - 3 for 2 offer Dusit Thani Hotel, Dubai, UAE Take away a complimentary copy of the latest Using Excel for Business Analysis written by your Course Director

9 – 13 October 2016 Dusit Thani Hotel, Dubai, UAE

www.informa-mea.com/excelmodelling

Please bring your laptop loaded with MS Excel

About Your Expert Course Director

The George Washington University School of Business, Informa Middle East’s Academic Partner, is dedicated to excellence: in its teaching and research about management, in the public and private sectors, within the United States and internationally. The school has a 75 year history of preparing men and women for leadership in both the public and private sectors. Known internationally for its dedication to academic excellence, the school draws students from all parts of the United States and around the world. Beyond first class teaching and scholarship, the school’s faculty offers practical experience in the issues and challenges confronting business and government. Its research centres link faculty and students with US and international business and government organisations. Recent distance learning initiatives have expanded the school’s global reach.

Course Requirements And Certificates Delegates must meet two criteria to be eligible for an Informa/GW Certificate of Completion for a course: 1. Satisfactory attendance – delegates must attend all sessions of the course. Delegates who miss more than 2 hours of the course sessions will not be eligible to sit the course assessment. 2. Successful completion of the course assessment Delegates who do not meet these criteria will receive an Informa Certificate of Attendance. If delegates have not attended all sessions, the Certificate will clearly state the number of hours attended.

Course Assessment Delegates are required to submit one of the models built during the course for assessment and to sit for a short exam at the completion of the course.

Would you like to run this course in-house?

Danielle Stein Fairhurst, Principal of Sydney-based consultancy Plum Solutions, is an MBA qualified financial modeller with many years’ experience as a financial analyst. She is the author of “Using Excel for Business Analysis: a Guide to Financial Modelling Fundamentals”, Revised Edition John Wiley & Sons, April 2015. With her professional background and analytical approach, she helps her clients create meaningful financial models in the forms of business cases, pricing models and management reports. She has hands-on experience in a number of industry sectors, including telecoms, information systems, manufacturing and financial services.

This is what delegates have said about Danielle Stein Fairhurst’s previous Certificate In Financial Modelling courses “Danielle has vast experience in financial modelling building, she shared practical experiences with us. I would like to attend another course with her.” Muhammed Arif Masood, Aldar Properties, UAE

“Danielle is an expert in financial modelling.” Dr. Ram Behin, Team Leader Projects Universal Hospital, UAE

Course Materials Delegates will receive a complimentary copy of Using Excel for Business Analysis: a Guide to Financial Modelling Fundamentals, written by your trainer, Danielle Stein Fairhurst, which contains instructions in Excel 2007, 2010 and 2013, and Excel for Mac.

Software Bring your own laptop to the session installed with any version of Microsoft Excel. Although the course includes an overview of the new features in later versions of Excel, delegates should bring their laptops loaded with whichever version they are comfortable using in their everyday work.

Course Prerequisites The in-house training division of Informa Tel: +971 4 4072624 Email: [email protected] www.informa-mea.com/cts

www.informa-mea.com/excelmodelling

The course material includes extensive use of Excel and delegates will gain the maximum benefit from this course if they are already competent spreadsheet users. It is designed for users who use (or will use) Excel on a regular basis, and are comfortable with using its tools and functions.

E: [email protected]

Certificate In Financial Modelling Using Excel 15 – 19 May 2016* Dusit Thani Hotel, Dubai, UAE 9 – 13 October 2016 Dusit Thani Hotel, Dubai, UAE Course Timings: Registration will be from 8:00 on Day One. Each day the course will commence promptly at 8:30 and conclude at 14:30 followed by lunch. Refreshments will be served at approximately 10:30 and 12:30.

Course Outline Day One Essential Excel For Finance Specifically designed for business professionals who need to take their Excel skills to the next level, this intensive full day course focusses on the technical Excel skills that will be required for the Financial Modelling course. This very practical day covers everything you need to perform your job. For those who don’t have time to sit through extensive Excel “how to” training, this day will arm you with a range of tools, techniques and formulas essential for finance. Guaranteed to contain “no fluff”, this day will equip you with the skills to produce more efficient and accurate Excel models and increase productivity. Must-Know Tools And Techniques • Key points on upgrading from prior versions of Excel to 2013 and 2016 • Absolute referencing • Named ranges • Time saving shortcuts New Features In Excel 2013 And 2016 • An overview of power pivot • Using sparklines to display trends on dashboards • Applying a slicer to pivot tables Formulas You Simply Can’t Live Without • LOOKUP, VLOOKUP, HLOOKUP • Logical functions eg. IF, AND • Aggregation functions eg. SUMIF, COUNTIF • Financial functions eg. NPV, IRR, PMT • Formula nesting Bullet-Proofing Your Model • Protect data by locking cells • Password protection • Restricting incorrect data entry with data validations • Using worksheet protection to prevent entry • Protecting your file using “Read Only”, and password protection

Charting • Creating and modifying a chart • Making your charts look fabulous • Charting tips, tricks and shortcuts • New charting features of Excel 2013 and 2016 Essential Advanced Tools • Autofilters • Goal seek • Macros • Pivot tables • Array formulas Other Useful Tools • Spin buttons and drop-down menus • Hiding • Working with dates • Hyperlinking • Conditional formatting

Day Two Introduction To Financial Modelling • What is financial modelling? - Typical examples and purposes of financial models • Software selection - Tool selection and advantages and disadvantages of Excel and other software for the purpose of financial modelling • Model design - Model planning and steps in building your model • Skills needed for financial modelling - The technical, design, business and industry knowledge required for financial modelling • Model tools and functions - Which formula or tool is most appropriate in which modelling situation? • Building the business case: issues and logic surrounding the calculation of customer acquisition - Creating the pool of potential customers - Narrowing down the pool - Expected customer acquisition - Lost customers/customer defection - Market penetration

Practical Exercises: Modelling exercises using a range of financial functions and tools. Building a business case utilising financial modelling techniques

www.informa-mea.com/excelmodelling

T: +971 4 335 2437

E: [email protected]

Day Three Financial Modelling Theory And Best Practice • Modelling techniques - What makes a good model? Attributes of a good model such as user-friendly and structural features - Avoiding Excel errors – A wrong calculation in a model can have disastrous consequences! Strategies to reduce errors in financial modelling - Rebuilding an inherited model - Building error checks - Correcting errors - Create a more efficient model with links - Dealing with links and the potential errors they cause • Bullet-proofing your model Retain model integrity and prevent misuse of your model by learning to restrict incorrect inputs - Protection - Locking cells - Restriction of incorrect data entry with data validations • Making a model user-friendly - Formatting - Navigation • Dealing with uncertainty and risk - Economic inputs to model, and modelling fluctuations in external factors - Use of stress testing to validate a model - What-if analysis - Importance of assumptions when assessing risk • Create a best, base and worst case scenario on your model Technical tools for creating scenarios: - Manual sensitivity analysis; drop-down scenarios - Scenario manager - Data tables • Displaying final model results and findings Communicate the results of your model clearly and concisely whilst getting the key message across to the audience - Documentation and source referencing - Writing assumptions - Writing operation instructions

Practical Exercise: Build scenarios and perform sensitivity analysis on financial models. Build a property development scenario model. Build a cash flow funding model, including a P&L, cash flow and balance sheet including scenario analysis.

Practical Exercise: Create a model in Excel which will calculate volume-dependent costs.

Day Five Practical Financial Modelling • Charting and graphing fundamentals – how to build charts • When to use a table or charts; combining tables and charts using chart data table and data bars • Choosing the correct chart to display your findings • Visual design – dos, don’ts and common mistakes in graphical presentation of data and reports • How to present easy to follow information concisely and clearly • Pivot tables and their role in financial modelling

Practical Exercise: Build your own flexible report including a dynamic chart.

Case Studies Demonstration and overview of the following: 1. Tiering tables One of the more complex and widely used calculations in financial modelling. Discussion of two different methods of calculation; a simple and progressive table 2. Pricing models Calculating profitability and break-even points at various prices 3. Dynamic charting Create a user-friendly report with a dynamic chart based on drop-down selections 4. Modelling for risk assessment Assess project risk with a risk assessment model using conditional formatting

Practical Exercise: Forecast a sales cycle based on historical data by calculating the seasonality index and adjusting the forecast accordingly.

Day Four Financial Modelling For Budgeting And Forecasting • Practical application of modelling in Excel for the purpose of budgeting for organisations - Advanced forecasting functions; time series, exponential smoothing and regression analysis - Modelling for “stepped” costs when forecasts include both fixed and variable costs - Sales forecasting – predication of likely sales revenue based on drivers - Seasonality – simply and easily spread revenue or expenses throughout the budget period based on season variations - Building an expense budget – based on given assumptions, you will build a budget for 12 months - Contingency planning – calculating a contingency based on assumptions about probability and impact of unexpected events

www.informa-mea.com/excelmodelling

- Budgeting for capital expenditure – capital expenditure is budgeted for cashflow and then depreciated - Cash flow budgeting – translating your profit and loss statement into a cashflow forecast - Reporting against budget; variance analysis – creating a template into which actual and budget can be compared and analysed

Who Should Attend This hands-on course is designed for middle and senior business and finance professionals as well as general managers who need to use financial models to measure business performance, including: • Finance Managers and Controllers • Strategy Directors and Managers • Budget, Corporate, Business and Financial Analysts • Project Managers and Risk Analysts • Investment and Management Accountants • Heads of Business Units and Business Planners • Financial Advisors and Corporate Analysts

T: +971 4 335 2437

E: [email protected]

Certificate In Financial Modelling Using Excel 15 – 19 May 2016* Dusit Thani Hotel, Dubai, UAE 9 – 13 October 2016 Dusit Thani Hotel, Dubai, UAE

FIVE WAYS TO REGISTER +971 4 335 2437 +971 4 335 2438

Informa Middle East PO Box 9428, Dubai, UAE

[email protected] www.informa-mea.com/excelmodelling

Would you like to run this course in-house?

Save training $$ and create learning experiences relevant to your business. To customise this course and increase value and impact, contact Leigh Kendall on +971 4 407 2624 or email the team at [email protected]

Our in-house training division Course Certificate In Financial Modelling Using Excel 15 – 19 May 2016* (BC6145) Course Certificate In Financial Modelling Using Excel 9 – 13 October 2016 (BC6146)

Course Fee Before 28 February 2016

Course Fee Before 20 March 2016

US$ 4,495

US$ 4,995

Course Fee Before 24 July 2016

Course Fee Before 14 August 2016

US$ 4,495

US$ 4,995

Final Fee US$ 5,195

Final Fee US$ 5,195

DISCOUNTS AVAILABLE FOR 2 OR MORE PEOPLE CALL: +971 4 335 2483 E-MAIL: [email protected] Course fees include documentation, luncheon and refreshments. Delegates who attend all sessions and successfully complete the course assessment will receive an Informa/GW Certificate of Completion. All registrations are subject to our terms and conditions which are available at www.informa-mea.com/terms. Please read them as they include important information. By submitting your registration you agree to be bound by the terms and conditions in full.

* Book and pay full fee for two colleagues and the third attends for FREE Not applicable in conjunction with corporate discounts. Payment to be settled before start of the course to avail the offer.

DELEGATE DETAILS First Name:

Surname:

Job Title: Company: Address: Postal Code:

Country:

City:

Tel:

Mobile:

Fax:

Email:

WEB BC6145/BC6146

PAYMENTS A confirmation letter and invoice will be sent upon receipt of your registration. Please note that full payment must be received prior to the event. Only those delegates whose fees have been paid in full will be admitted to the event.

AVOID VISA DELAYS – BOOK NOW Delegates requiring visas should contact the hotel they wish to stay at directly, as soon as possible. Visas for non-GCC nationals may take several weeks to process.

CANCELLATION If you are unable to attend, a substitute delegate will be welcomed in your place. Registrations cancelled more than 7 days before the Event are subject to a $200 administration charge. Registration fees for registrations cancelled 7 days or less before the Event must be paid in full. Substitutions are welcome at any time. All registrations are subject to acceptance by Informa which will be confirmed to you in writing. Due to unforeseen circumstances, Informa reserves the right to cancel the course, change the programme, alter the venue, speakers or topics.

EVENT VENUE: Dusit Thani Hotel, Dubai, UAE ACCOMMODATION DETAILS:

Tel: +971 4 343 3333

We highly recommend you secure your room reservation at the earliest to avoid last minute inconvenience. You can contact the Informa Hospitality Desk for assistance on: Tel: +971 4 407 2693 Fax: +971 4 407 2517 Email: [email protected] SN/MB

FN

Finance

© Copyright Informa Middle East Ltd