Online Financial Modelling Course
– Accounting for Real World Complexities in Financial Models
This is course number three in a series of four courses.
Financial models are powerful tools but not without their limitations.
Ignoring the complexities and uncertainties of the real world can lead to unrealistic results.
This course explains how to decide which complexities to include in your financial models and how to include them.
You’ll be looking at what effect variable inputs, economic factors and scenario based inputs can have on models. The course also takes a look at the vital importance of the way in which data is presented, and how this can be a strength rather than a weakness.
Financial Modelling of Real World Complexities
enables the learner to:
• Recognise what ‘real world complexities’ are and why businesses
are concerned about them
• Understand how financial models can deal with unpredictable inputs
• Learn how economic factors affect financial models and reflect the real world
• Test your financial model efficiently to include a variety of assumptions
• Identify the best way to report your financial model to different
“Building upon other financial modelling courses it improved my ability and understanding of financial modelling and will be very useful in my work.”
|You can review this course using the questionnaire in the course completion area.|
Learning outcomes of Financial Modelling of Real World Complexities
Introduction – Levels of Complexity
• What are real world complexities?
• Why are businesses concerned about these real world complexities?
• What challenges do real world complexities present?
• Can I test a model to determine the effects of real world complexities?
• Which complexities are particularly difficult to include in a business financial model?
• What are variable inputs in relations to modelling real world complexities?
• How can the model deal with unpredictable or “actual” inputs?
• Should I include non-financial calculations to drive the costs and/or revenues?
• Which ingredients are required to calculate the sales revenue?
• How are the calculation blocks for the sales revenues constructed?
• What economic factors is a financial model likely to include?
• Which ingredients are required to calculate the escalation factor?
• How is the calculation block for the inflation factor constructed?
• What should I consider when modelling cash flows which are denominated in different currencies?
• How do I set up the model to deal with different currencies?
• What do I need to know about interest rates?
• Why might you want to test different scenarios in a model?
• What if my assumptions turn out to be inaccurate?
• How can I efficiently use my model to test a variety of assumptions?
• What calculations need to be included?
• How can I gain experience of using the model in this way?
• What do I need to know about reporting?
• Does FAST apply the same rules to presentational sheets?
• How can I incorporate the non-financial data in the output presentation?
• What is a “dashboard” in the context of financial modelling?
Target audience for Financial Modelling of Real World Complexities
Anyone involved in creating or interpreting financial models.
About the author of Financial Modelling of Real World Complexities
Grant Thornton UK LLP specialise in developing, building and reviewing financial models for clients.
Grant Thornton is one of the world’s leading organisations of independent assurance, tax and advisory firms. Over 38,500 Grant Thornton people, across 120 countries, are focused on making a difference to clients, colleagues and the communities in which they live and work.
Learners take their own route through the topics covered in the course. They will learn at their own pace through a variety of activities designed to accommodate a range of learning styles.
Register now for free module
To purchase a course or to try a free module please register. Registration is free and there is no obligation to purchase. Just click the button below:
Please review our Frequently Answers Questions (FAQs) for answers to the most common questions we receive (opens in a new window).