Using Excel for business and financial modelling : a practical guide

Cover -- Title Page -- Copyright -- Contents -- Preface -- Book Overview -- Acknowledgements -- Chapter 1 What is Financial Modelling? -- What's the Difference Between a Spreadsheet and a Financial Model? -- Types and Purposes of Financial Models -- Tool Selection -- Is Excel Really the Best Option? -- Evaluating Modelling Tools -- 32-Bit versus 64-Bit Microsoft Excel -- What Skills do You Need to be a Good Financial Modeller? -- Spreadsheet and Technical Excel Skills -- Industry Knowledge -- Accounting Knowledge -- Business Knowledge -- Aesthetic Design Skills -- Communication and Language Skills -- Numeracy Skills -- Ability to Think Logically -- The "Ideal" Financial Modeller -- What's the Typical Background for a Financial Modeller? -- Training Courses -- Summary -- Chapter 2 Building a Model -- Model Design -- Practical Example 1: Assumptions Layout -- Practical Example 2: Summary Categorisation -- The Golden Rules for Model Design -- Separate Inputs, Calculations, and Results, where Possible -- Use Each Column for the Same Purpose -- Use One Formula per Row or Column -- Refer to the Left and Above -- Use Multiple Worksheets -- Include Documentation Sheets -- Design Issues -- The Workbook Anatomy of a Model -- Workbook Anatomy Issues -- Project Planning Your Model -- How Long Does it Take to Build a Financial Model? -- Building a Model Under Pressure -- Model Layout Flowcharting -- Practical Exercise: Model Design Customer Support Pricing Model -- Steps to Building a Model -- The Streamlined Version -- The Team Version -- Information Requests -- Version-Control Documentation -- File Structure -- Summary -- Chapter 3 Best-Practice Principles of Modelling -- Document Your Assumptions -- Linking, Not Hardcoding -- Enter Data Only Once -- Avoid Bad Habits -- Use Consistent Formulas -- Format and Label Clearly.