{"id":8697,"date":"2015-03-11T23:19:39","date_gmt":"2015-03-11T23:19:39","guid":{"rendered":"https:\/\/www.financial-fluency.co.uk\/?page_id=8697"},"modified":"2022-06-29T15:19:27","modified_gmt":"2022-06-29T14:19:27","slug":"building-a-financial-model","status":"publish","type":"page","link":"https:\/\/www.financial-fluency.co.uk\/online-learning\/financial-modelling\/building-a-financial-model\/","title":{"rendered":"Building a Financial Model"},"content":{"rendered":"

\"BuildingOnline Course on Building a Financial Model<\/h2>\n

This is course number two in a series of four courses.<\/em><\/p>\n

Every financial model is built on the same foundations: an understanding of its purpose,
\nwho it is for, and its scope.<\/p>\n

This course explains how to set up the Excel spreadsheet and complete the initial steps of:
\n\u2022 building a financial model,
\n\u2022 structuring calculations
\n\u2022 looking into costs and revenues,
\n\u2022 time periods,
\n\u2022 cash balances and
\n\u2022 reporting.<\/p>\n

\"buy<\/a><\/p>\n

Understanding Building a Financial Model
\nenables the learner to:<\/h3>\n

\u2022 Set up and build a comprehensive financial model
\n\u2022 Calculate costs and revenues
\n\u2022 Decide which time periods you need to use and when and where to use flags
\n\u2022 Create understandable and useful reports<\/p>\n

\n\n\n\n\n\n\n\n\n
Rating: \"5<\/td>\n100% said it met their professional development objectives<\/td>\n<\/tr>\n
Reviews:<\/td>\n<\/tr>\n
\n

“I frequently prepare financial models, this course highlighted several modelling improvements I can use in future.”<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

“Very useful guidelines to use in any type of project going forward.”<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

“It built upon the knowledge\/practice gained from the introductory course and provided me with a better understanding of modelling that I can use in my everyday work.”<\/span><\/p>\n<\/td>\n<\/tr>\n

You can review this course using the questionnaire in the course completion area.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Learning outcomes of Building a Financial Model<\/h3>\n

Setting up a Financial Model<\/strong>
\n\u2022 Who uses a financial model?
\n\u2022 How should I set up a financial model?
\n\u2022 What are the MS Excel settings for financial model build?
\n\u2022 What should be included in a template?
\n\u2022 How should I incorporate FAST principles?
\n\"Building<\/a><\/p>\n

Costs and Revenues<\/strong>
\n\u2022 What are the different ingredients required to calculate the operating costs?
\n\u2022 What would the concept diagram look like?
\n\u2022 How do I build a calculation that I can use to quickly model the operating costs?
\n\u2022 What would be different in the calculation on the revenue?
\n\u2022 How do I build a calculation to quickly model the revenue?
\n\"costs<\/a><\/p>\n

Time Periods<\/strong>
\n\u2022 What time periods should I use?
\n\u2022 What do I need to know about flags?
\n\u2022 Which ingredients are required to calculate the forecast period flag?
\n\"Building<\/a><\/p>\n

Cash Balances<\/strong>
\n\u2022 Why is the cash balance particularly important?
\n\u2022 What is a \u201cbalance corkscrew\u201d?
\n\u2022 What should I know about interest?
\n\u2022 How is interest calculated?
\n\"Building<\/a><\/p>\n

Reporting<\/strong>
\n\u2022 What will the recipient want from the summary report?
\n\u2022 Should I use the same rules for building output sheets?
\n\u2022 How do I construct the output sheet?
\n\"Building<\/a><\/p>\n

Target audience for Building a Financial Model<\/h3>\n

Accounting and finance professionals in practice and in industry.<\/p>\n

About the author of Building a Financial Model<\/h3>\n

\"GrantGrant Thornton UK LLP specialise in developing, building and reviewing financial models for clients.<\/p>\n

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.<\/p>\n

Flexible learning<\/h3>\n

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.<\/p>\n

You might also be interested in<\/h3>\n

Introduction to Financial Modelling
\nFinancial Control in SMEs<\/a>
\nMaking Budgeting Work in the Real World<\/a>
\nAlternative Finance<\/a><\/p>\n

Please review our Frequently Answers Questions<\/a> (FAQs) for answers to the most common questions we receive (opens in a new window).<\/p>\n

\"\"<\/a><\/p>\n

<\/a><\/p>\n

\"4\"Financial
\n 
\nUse promo code FF101<\/strong><\/font> at checkout to receive the Financial Fluency special price<\/em>
\nUse promo code FF20<\/strong><\/span> at checkout to receive \u00a3100 discount on 5 or more courses<\/em><\/p>\n <\/p>\r\n

<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Online Course on Building a Financial Model This is course number two in a series of four courses. Every financial model is built on the same foundations: an understanding of its purpose, who it is for, and its scope. This course explains how to set up the Excel spreadsheet and complete the initial steps of: […]<\/p>\n","protected":false},"author":15,"featured_media":0,"parent":9292,"menu_order":1,"comment_status":"closed","ping_status":"open","template":"pagetemplate2.php","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/8697"}],"collection":[{"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/comments?post=8697"}],"version-history":[{"count":21,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/8697\/revisions"}],"predecessor-version":[{"id":18959,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/8697\/revisions\/18959"}],"up":[{"embeddable":true,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/9292"}],"wp:attachment":[{"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/media?parent=8697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}