Basic Financial Modelling

Customized Training Solutions Pte Ltd

The course is an introduction to the basic topics that everyone with an interest in financial model must be aware of.

Please send us an email at enquiries@ctsolutionsglobal.com and we will update you on the next schedules.

IntroductionThis introductory course is suitable for a two day live training course and an eight 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 centred around Microsoft Excel and a significant number of Excel functions and techniques will be reviewed during the course.Training methodologyWhether the course is provided as live training or as an online experience, the training methodology is essentially the same: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.Workshop prerequisitesDelegates should have a good working knowledge of Microsoft Excel: you don’t need to be an advance user, just aware of and be confident in the use of basic ExcelDelegates should also be in possession of their laptops loaded with Office365/Excel 2016You 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 thenRequired OutcomesAfter completing this workshop the delegate should be able to:<ul><li>Construct financial statement based models together with other financial models using Excel</li><li>Train, Test and demonstrate the models you are given or that you build.</li><li>Produce output from a model for use at work and in presentations.</li></ul>Course ContentPART I: Design and EfficiencyIn this first Part we will take a specific look at the design of a financial model, providing insight into the usage of spreadsheet maps, formatting and calculations. This section will provide a hands on focal point for designing of your own financial model using Excel.Section OneProducing and Publishing Model Output for effective communication and workability<ul><li>Style, formatting and layout</li><li>- Fonts colours, backgrounds and borders</li><li>- Pivot Tables</li><li>- Using symbols and equations</li><li>- Using graphs and figures</li><li>Error capturing</li><li>Technical issues to be considered</li><li>Documentation</li><li>File formats and compatibility</li><li>Size and memory consideration</li><li>Object embedding</li></ul>Part II: Financial Analysis ModelsIn 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.Section TwoSystematically analysing financial statements for improved model performance<ul><li>Financial Statements</li><li>Appreciating the structure and content of Income Statements and Balance Sheets</li><li>Improving displays by using Power Query and Power Pivot</li><li>Financial Ratios</li><li>Calculating and interpreting financial ratios</li><li>DuPont analysis of Return on Equity</li><li>Financial Forecasting</li><li>An example of forecasting earnings from components of ROE</li><li>Time Value of Money</li><li>PV (Present Value) and FV (Future Value) Calculations</li><li>from first principles and using PV and FV functions</li><li>Rates of Return</li><li>Arithmetic, Geometric and Continuous Compounding</li><li>Yields on uneven returns</li><li>Internal Rates of Return</li></ul>Section ThreeHighlighting key financial management principles underpinning effective model development<ul><li>Cost of Capital</li><li>Cost of Equity</li><li>Cost of Debt</li><li>Tax impact on Cost of Capital</li><li>Calculating the Weighted Average Cost of Capital (WACC) and Hurdle rates</li><li>Marginal WACC curve and finding break points</li><li>Reviewing Capital Budgeting</li><li>Cash flow modelling</li><li>Decision modelling, including:</li><li>Payback Period</li><li>NPV (Net Present Value): NPPV, XNPV </li><li>IRR (Internal Rate of Return): IRR, MIRR, XIRR</li><li>Sensitivity analysis</li><li>Optimum Capital Budget</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Ticket sales have ended

Basic Financial Modelling

More events from Customized Training Solutions Pte Ltd

Discover more events from Customized Training Solutions Pte Ltd, from Business to other experiences you might love.

Ticket sales have ended

Basic Financial Modelling

More events from Customized Training Solutions Pte Ltd

Discover more events from Customized Training Solutions Pte Ltd, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.