Principles of Financial Modeling : Model design and best practices using Excel and VBA

Intro -- Title Page -- Table of Contents -- Preface -- About the Author -- About the Website -- PART One: Introduction to Modelling, Core Themes and Best Practices -- CHAPTER 1: Models of Models -- INTRODUCTION -- CONTEXT AND OBJECTIVES -- THE STAGES OF MODELLING -- BACKWARD THINKING AND FORWARD CALCULATION PROCESSES -- CHAPTER 2: Using Models in Decision Support -- INTRODUCTION -- BENEFITS OF USING MODELS -- CHALLENGES IN USING MODELS -- CHAPTER 3: Core Competencies and Best Practices: Meta-themes -- INTRODUCTION -- KEY THEMES -- PART Two: Model Design and Planning -- CHAPTER 4: Defining Sensitivity and Flexibility Requirements -- INTRODUCTION -- KEY ISSUES FOR CONSIDERATION -- CHAPTER 5: Database Versus Formulae-driven Approaches -- INTRODUCTION -- KEY ISSUES FOR CONSIDERATION -- PRACTICAL EXAMPLE -- CHAPTER 6: Designing the Workbook Structure -- INTRODUCTION -- GENERIC BEST PRACTICE STRUCTURES -- USING INFORMATION FROM MULTIPLE WORKSHEETS: CHOICE (EXCLUSION) AND CONSOLIDATION (INCLUSION) PROCESSES -- PART Three: Model Building, Testing and Auditing -- CHAPTER 7: Creating Transparency: Formula Structure, Flow and Format -- INTRODUCTION -- APPROACHES TO IDENTIFYING THE DRIVERS OF COMPLEXITY -- OPTIMISING AUDIT PATHS -- IDENTIFYING INPUTS, CALCULATIONS AND OUTPUTS: STRUCTURE AND FORMATTING -- CREATING DOCUMENTATION, COMMENTS AND HYPERLINKS -- CHAPTER 8: Building Robust and Transparent Formulae -- INTRODUCTION -- GENERAL CAUSES OF MISTAKES -- EXAMPLES OF COMMON MISTAKES -- THE USE OF NAMED RANGES -- APPROACHES TO BUILDING FORMULAE, TO TESTING, ERROR DETECTION AND MANAGEMENT -- CHAPTER 9: Choosing Excel Functions for Transparency, Flexibility and Efficiency -- INTRODUCTION -- KEY CONSIDERATIONS -- CHAPTER 10: Dealing with Circularity -- INTRODUCTION -- THE DRIVERS AND NATURE OF CIRCULARITIES -- RESOLVING CIRCULAR FORMULAE.