Introduction

This introductory course is suitable for a two-day live training course and a nine-hour online webinar style programme. The essence of the course is to provide delegates with an introduction to the basic topics that everyone with an interest in financial model must be aware of.

The course content and practical exercises are centered around Microsoft Excel and a significant number of Excel functions and techniques will be reviewed during the course.

Training methodology

Whether the course is provided as live training or as an online experience, the training methodology is essentially the same:

We will follow what is essentially a Tool Box Approach in that we present to you many functions, formulas and features of financial modelling throughout the course. This approach will help you to appreciate things that you did not know and you will feel energised into working out where and how you can apply your new skills.

The trainer will introduce each topic with a discussion and/or practical exercise and the delegates will then be provided with a follow up exercise to complete on their own. The final result will be shared with everyone either by confirmatory discussion during the session or by means of sharing the trainer’s completed Excel file.

All delegates will receive a full set of training notes and Excel files: both delegate and trainer versions. There will also be PowerPoint slides and other support materials that will form an integral part of the course.

Online Presentation

Because of the remote nature of online training, the intimacy of physical presence is lost: there is little chance for familiarity. Initially, at least, whilst it is relatively easy for the trainer to work in as normal a way as possible, the remoteness of distance is often a barrier, at least in the initial stages of the course.

3 Sessions of Up to 3 hours each (total of up to 9 hours Singapore Time Zone):

3 Aug 2020 - 9:00 AM to 12:00 NN

5 Aug 2020 - 9:00 AM to 12:00 NN

7 Aug 2020 - 9:00 AM to 12:00 NN

*Similar live in-person program investment is US$ 1995 to 2995 per person

Workshop prerequisites

• Delegates should have a good working knowledge of Microsoft Excel: you don’t need to be an advanced user, just aware of and be confident in the use of basic Excel

• Delegates should also be in possession of their laptops loaded with Office365/Excel 2016

• You will also need to ensure that Power Query and Power Pivot are fully operational: you will receive a delegates’ pack in advance of the course and full instructions will be given then

Required Outcomes

After completing this workshop, the delegate should be able to:

• Construct financial statement-based models together with other financial models using Excel

• Train, Test and demonstrate the models you are given or that you build.

• Produce output from a model for use at work and in presentations.

PART I: Design and Efficiency

In this first part we will take a specific look at the overall design of a financial model, providing insight into the usage of spreadsheet features, formatting and calculations. This section will provide a hands-on focal point for the designing of your own financial model using Excel.

Section One

Producing and Publishing Model Output for effective communication and workability

• Style, formatting and layout

o Fonts colours, backgrounds and borders

o Formatting

o Colour coding

• Comments and Notes

o Comment

o Note

• Sign convention

Part II: Financial Analysis Models

In Part two we undertake a review of data that organisations provide for us: the data normally comes from the financial reporting process. We then undertake a systematic and interactive review of the data we have gathered. A comprehensive examination of the key components of financial statements and financial management will assist in developing effective models that will be vital as you create a world class financial model using Excel.

Systematically analysing financial statements for improved model performance

Section Two

• Financial Statements

o Appreciating the structure and content of Income Statements and Balance Sheets

o Improving displays by using Power Query and Power Pivot

• Financial Ratios

o Calculating and interpreting financial ratios

o DuPont analysis of Return on Equity

• Financial Forecasting

o An example of forecasting earnings from components of ROE

• Time Value of Money

o PV (Present Value) and FV (Future Value) Calculations

- from first principles and using PV and FV functions

• Rates of Return

o Internal Rates of Return

Highlighting key financial management principles underpinning effective model development

Section Three

• Cost of Capital

o Cost of Equity

o Cost of Debt

o Tax impact on Cost of Capital

o Calculating the Weighted Average Cost of Capital (WACC) and Hurdle rates

o Marginal WACC curve and finding break points

• Reviewing Capital Budgeting

o Cash flow modelling

o Decision modelling, including:

o Payback Period

o NPV (Net Present Value): NPPV, XNPV

o IRR (Internal Rate of Return): IRR, MIRR, XIRR

o Sensitivity analysis

o Optimum Capital Budget

About the trainer:

Mr. Duncan Williamson

Distinguished Trainer & International Consultant

Highlights: Duncan combines his extensive academic and training experience with significant manufacturing and commercial work. In addition to working as a teacher and trainer, Duncan has experience of working in a wide variety of settings, ranging from working as a management accountant in process industries in the UK to product cost consulting in several industries in Eastern Europe and the oil and gas industry in the Middle East. Duncan has worked in and around a number of oil and gas-based companies over recent years.

He has published books, articles and case studies. His latest books Introduction to Power Pivot and Introduction to Power BI for Desktop to be published by www.bookboon.com

Countries of Work Experience: Bosnia and Herzegovina, Kyrgyzstan, Kazakhstan, Uzbekistan, Romania, United Kingdom, Afghanistan, Dubai, Abu Dhabi, Kuwait, Oman, Saudi Arabia, Switzerland, Hungary, Thailand, Singapore, Vietnam, Philippines, Malaysia, Pakistan, Holland, Sudan, Albania, Qatar, Mexico, Angola

Significant Areas of Expertise: cost and management accounting, financial accounting and bookkeeping, financial reporting under IFRS, financial modelling, spread sheet modelling, and product cost modelling.

Disclaimer, Terms & Conditions:

• Location is subject to change
• Minimum number of participants has to be reached prior to confirmation of event
• Please note that trainers and topics were confirmed at time of publishing, however, CTS may necessitate substitution, alterations or cancellations. CTS reserves the right to change or cancel any part of its published programmed due to unforeseen circumstances.
• Registrations should be made 2 weeks prior to training date
• Full payment for the course should be made 3-4 weeks prior to training date
• Cancellation 3 weeks prior to event date or no shows are liable to pay the full course with no refund, however you may substitute delegates at any time with notice
• Participants are required to attend at least 80% of the course program prior receipt of Certificate
• Rates are exclusive of taxes unless otherwise indicated in the invoice
• Receipt of this email to participate and/or register in any of the learning activities organized by CTS should not in any way be taken as a promise for employment or contract of employment of any kind.
• Force Majeure: Should for any reason outside the control of CTS, the trainer changes his dates or event cancels due to the act of terrorism, extreme weather conditions, industrial action or epidemic, CTS shall reserve the rights to replace the trainer or reschedule the event but the client hereby indemnifies and holds CTS harmless from and against any and all costs, damages and expenses, which are incurred by the client.