Financial Modeling in Practice : a Concise Guide Using Excel and VBA for Intermediate and Advanced Level

Description

Content: 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. INTRODUCTIONKEY 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 FORMATTINGCREATING 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. ITERATIVE METHODS IN PRACTICEPRACTICAL EXAMPLE SELECTION OF APPROACH TO DEALING WITH CIRCULARITIES: KEY CRITERIA CHAPTER 11: Model Review, Auditing and Validation INTRODUCTION OBJECTIVES PROCESSES, TOOLS AND TECHNIQUES PART Four: Sensitivity and Scenario Analysis, Simulation and Optimisation CHAPTER 12: Sensitivity and Scenario Analysis: Core Techniques INTRODUCTION OVERVIEW OF SENSITIVITY-RELATED TECHNIQUES DATATABLES PRACTICAL APPLICATIONS CHAPTER 13: Using GoalSeek and Solver INTRODUCTION OVERVIEW OF GOALSEEK AND SOLVER PRACTICAL APPLICATIONS. CHAPTER 14: Using VBA Macros to Conduct Sensitivity and Scenario AnalysesINTRODUCTION PRACTICAL APPLICATIONS CHAPTER 15: Introduction to Simulation and Optimisation INTRODUCTION THE LINKS BETWEEN SENSITIVITY AND SCENARIO ANALYSIS, SIMULATION AND OPTIMISATION PRACTICAL EXAMPLE: A PORTFOLIO OF PROJECTS FURTHER ASPECTS OF OPTIMISATION MODELLING CHAPTER 16: The Modelling of Risk and Uncertainty, and Using Simulation INTRODUCTION THE MEANING, ORIGINS AND USES OF MONTE CARLO SIMULATION KEY PROCESS AND MODELLING STEPS IN RISK MODELLING.