{"id":15348,"date":"2017-12-15T18:48:08","date_gmt":"2017-12-15T18:48:08","guid":{"rendered":"https:\/\/www.financial-fluency.co.uk\/?page_id=15348"},"modified":"2022-06-29T15:18:26","modified_gmt":"2022-06-29T14:18:26","slug":"corporate-financial-modelling-the-process","status":"publish","type":"page","link":"https:\/\/www.financial-fluency.co.uk\/online-learning\/financial-modelling\/corporate-financial-modelling-the-process\/","title":{"rendered":"Corporate Financial Modelling – The Process"},"content":{"rendered":"

\"Corporate<\/p>\n

Online Course on
\nCorporate Financial Modelling<\/h2>\n

This course provides an introduction to applied financial modelling and shows you how to design, develop and build corporate financial models.<\/p>\n

In particular, it demonstrates:
\n\u2022 the benefits of solid model planning and design, and
\n\u2022 how to build models in accordance with international best practice.<\/p>\n

Financial modelling is essential to any business. You may need to build models for budgeting and forecasting, investment analysis, loan sizing, debt restructuring, valuation \u2013 the list is endless.<\/p>\n

Even though financial models are an integral part of business, many models fail due to a lack of planning and poor structure.\"buy<\/a><\/p>\n

Corporate Financial Modelling – The Process – enables the learner to:<\/h3>\n

\u2022 Understand the importance of model planning
\n\u2022 Develop a template from a blank sheet which will be used to build a model for financial analysis
\n\u2022 Identify model errors you may come across and understand how to avoid them
\n\u2022 Learn Excel shortcuts and functions to make the job more efficient
\n\u2022 Build a comprehensive cash flow valuation model in Excel<\/p>\n

Learning outcomes of Corporate Financial Modelling – The Process<\/h3>\n

Modelling and model planning<\/strong>
\n\u2022 What is a financial model?
\n\u2022 What is a spreadsheet?
\n\u2022 What are your outputs?
\n\u2022 What are your standards?
\n\u2022 What are your individual components?
\n\u2022 What are the user requirements?
\n\u2022 Why is it important to plan?
\n\u2022 What can happen if you don’t plan?<\/p>\n

Model errors<\/strong>
\n\u2022 Why is it important to check for errors?
\n\u2022 How are errors made?
\n\u2022 What are input errors?
\n\u2022 What are calculation errors?
\n\u2022 What are output errors?
\n\u2022 How do you test for errors?
\n\u2022 How do you test for inconsistencies?<\/p>\n

Model templates<\/strong>
\n\u2022 How do you set up a template?
\n\u2022 How do you define a new style?
\n\u2022 How do you create a custom format?
\n\u2022 How do you set up data validation?
\n\u2022 How do you name cells and ranges?
\n\u2022 What are the advantages and disadvantages of named cells?
\n\u2022 How do you input notes?
\n\u2022 How do you set up a timeline?
\n\u2022 How do you use masks?
\n\u2022 How should you label sheets?<\/p>\n

Excel shortcuts<\/strong>
\n\u2022 Why use shortcut keys?
\n\u2022 What function keys can you use?
\n\u2022 What letters can you use?
\n\u2022 What number shortcuts can you use?
\n\u2022 Why use operators?
\n\u2022 What do alternative keys do?
\n\u2022 What about Apple shortcuts?<\/p>\n

Entering data<\/strong>
\n\u2022 What are the outputs of the case?
\n\u2022 What are the individual components of the model?
\n\u2022 Where can you find the necessary accounts information?
\n\u2022 What does the income statement look like?
\n\u2022 What does the balance sheet look like?
\n\u2022 How do you use charts?
\n\u2022 How do you use line numbers?<\/p>\n

About the author of Corporate Financial Modelling – The Process<\/h3>\n

\"Alistair<\/p>\n

Alastair Day has worked in the finance industry for more than thirty years and has extensive experience of financial modelling, finance and leasing. Alastair was previously a director of a start-up structured finance company, which grew rapidly and was subsequently sold to a public company.<\/p>\n

Later, Alastair established Systematic Finance as an independent consultancy to concentrate on assignments in structured finance, leasing and financial model development.<\/p>\n

Past projects have included investment analysis, debt restructuring, valuation, aircraft leasing, power and project finance models prepared for a variety of clients. In addition, Alastair designs and delivers courses covering financial modelling, credit analysis and equipment leasing.<\/p>\n

He is the author of standard modelling textbooks such as Mastering Financial Modelling, Mastering Risk Modelling, Mastering Cash Flow and Valuation Modelling and Mastering Financial Mathematics in Excel, together with a number of technical leasing and credit books.<\/p>\n

Alastair has a degree in German and Economics from London University and an MBA. He has held positions as an associate lecturer at the OUBS and the ifs University College (Chartered Institute of Bankers).<\/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 Corporate Financial Modelling This course provides an introduction to applied financial modelling and shows you how to design, develop and build corporate financial models. In particular, it demonstrates: \u2022 the benefits of solid model planning and design, and \u2022 how to build models in accordance with international best practice. Financial modelling is […]<\/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\/15348"}],"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=15348"}],"version-history":[{"count":4,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/15348\/revisions"}],"predecessor-version":[{"id":18956,"href":"https:\/\/www.financial-fluency.co.uk\/wp-json\/wp\/v2\/pages\/15348\/revisions\/18956"}],"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=15348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}