{"id":15353,"date":"2017-12-15T18:53:47","date_gmt":"2017-12-15T18:53:47","guid":{"rendered":"https:\/\/www.financial-fluency.co.uk\/?page_id=15353"},"modified":"2022-06-29T15:18:38","modified_gmt":"2022-06-29T14:18:38","slug":"financial-forecasting-building-a-spreadsheet-model","status":"publish","type":"page","link":"https:\/\/www.financial-fluency.co.uk\/online-learning\/financial-modelling\/financial-forecasting-building-a-spreadsheet-model\/","title":{"rendered":"Financial Forecasting – Building a spreadsheet model"},"content":{"rendered":"

\"Financial<\/p>\n

Online Course on building a spreadsheet based financial forecast model<\/h2>\n

Excel make it easy to build a spreadsheet forecasting model. The challenge is that the formulas can quickly become very complex, and the structure of the model can get very unwieldy. If your structure is not sound others who may have to use it later may find it impenetrable.<\/p>\n

This online training course explains how to build and operate spreadsheets for forecasting planning and business models.<\/p>\n

The course is a practical guide, which takes a step-by-step approach to building models using Microsoft Excel.<\/p>\n

Our Online Financial Forecasting Modelling Course will enable the learner to:<\/h3>\n

\u2022 Establish the ground rules for building a spreadsheet model, including guiding principles and the core elements
\n\u2022 Build a model including input data, intermediate calculation and output data
\n\u2022 Put together an executive summary of your model along with any appendices necessary
\n\u2022 Use a range of different techniques to assess the impact of potential changes in inputs or variables<\/p>\n

Content of our course on building a forecasting model in Excel<\/h3>\n

Foundations of spreadsheet models<\/strong>
\n\u2022 What are the guiding principles of spreadsheet model building?
\n\u2022 What are the key elements in a spreadsheet model?
\n\u2022 How do we structure the spreadsheet?
\n\u2022 What is the purpose and scope of the model?
\n\u2022 What are the definitions, assumptions and sources of data?
\n\u2022 How do we achieve version control?<\/p>\n

Building the model<\/strong>
\n\u2022 How do we input data?
\n\u2022 What are the intermediate calculations?
\n\u2022 What is the core model?
\n\u2022 What is the output data sheet?
\n\u2022 What about the executive summary?
\n\u2022 What goes into the appendices and user guide?<\/p>\n

Scenario planning and sensitivity analysis<\/strong>
\n\u2022 How do we look at what-ifs and sensitivity analysis?
\n\u2022 What does the sensitivity analysis for our example cashflow forecast look like?
\n\u2022 What about scenario planning?
\n\u2022 How can we use the model for decision making?
\n\u2022 How do we present the outputs of the model?<\/p>\n

Building a spreadsheet model of your business<\/strong>
\n\u2022 What are the key principles of building the business?
\n\u2022 What is the structure of the business model?
\n\u2022 What about revenue streams?
\n\u2022 How do we plan and make decisions using the business model?
\n\u2022 How do we maintain the business model?<\/p>\n

Target audience for our Online Course on Building a Forecasting Model<\/h3>\n

This course is designed to appeal to accounting and finance professionals working at all levels.<\/p>\n

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

\u2022 Corporate Financial Modelling \u2013 The Process<\/a>
\n\u2022 Introduction to Financial Modelling<\/a>
\n\u2022 Building a Financial Model<\/a><\/p>\n

About the Author of our Financial Forecasting – Building a spreadsheet model course<\/h3>\n

\"Ross<\/p>\n

Ross is a highly experienced professional trainer, specialising in throughput accounting, lean service, value-based pricing and process improvement.
\nRoss incorporates many practical examples into his training from his personal experience. Ross Maynard is a Fellow of the Chartered Institute of Management Accountants<\/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

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 spreadsheet based financial forecast model Excel make it easy to build a spreadsheet forecasting model. The challenge is that the formulas can quickly become very complex, and the structure of the model can get very unwieldy. If your structure is not sound others who may have to use it later […]<\/p>\n","protected":false},"author":11,"featured_media":0,"parent":9292,"menu_order":0,"comment_status":"closed","ping_status":"closed","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\/15353"}],"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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/comments?post=15353"}],"version-history":[{"count":4,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/15353\/revisions"}],"predecessor-version":[{"id":18957,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/15353\/revisions\/18957"}],"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=15353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}