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

✍ Scribed by Rees, Michael

• Publisher: John Wiley & Sons, Incorporated
• Year: 2018
• Tongue: English
• Edition: 2nd ed
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

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.

✦ Subjects

Corporations--Finance--Mathematical models;Finance--Mathematical models;Visual Basic for Applications (Computer program language);Electronic books;Microsoft Excel (Computer file);Microsoft Office;Finance -- Mathematical models;Corporations -- Finance -- Mathematical models