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

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

Saved in:
Bibliographic Details
Main Author: Rees, Michael
Format: eBook
Language:English
Published: Somerset : John Wiley & Sons, Incorporated, 2018.
Edition:2nd ed.
Subjects:
Microsoft Excel (Computer file)
Microsoft Office.
Microsoft Office
Finance > Mathematical models.
Corporations > Finance > Mathematical models.
Visual Basic for Applications (Computer program language)
Corporations > Finance > Mathematical models
Finance > Mathematical models
Online Access:Click for online access
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.

Similar Items