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:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000Mi 4500
001 on1030027207
003 OCoLC
005 20241006213017.0
006 m o d
007 cr |n|---|||||
008 180331s2018 xx o 000 0 eng d
040 |a EBLCP  |b eng  |e pn  |c EBLCP  |d YDX  |d OCLCQ  |d IDB  |d OCLCF  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL 
019 |a 1029480943  |a 1029567680  |a 1029639957 
020 |a 9781118904008 
020 |a 1118904001 
020 |z 9781118904015 
020 |z 111890401X 
035 |a (OCoLC)1030027207  |z (OCoLC)1029480943  |z (OCoLC)1029567680  |z (OCoLC)1029639957 
050 4 |a HG106  |b .R447 2018eb 
049 |a HCDD 
100 1 |a Rees, Michael. 
245 1 0 |a Financial Modeling in Practice :  |b a Concise Guide Using Excel and VBA for Intermediate and Advanced Level. 
250 |a 2nd ed. 
260 |a Somerset :  |b John Wiley & Sons, Incorporated,  |c 2018. 
300 |a 1 online resource (616 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
588 0 |a Print version record. 
505 0 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
500 |a USING EXCEL AND VBA TO IMPLEMENT RISK AND SIMULATION MODELS. 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 0 |a Microsoft Office. 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
630 0 7 |a Microsoft Office  |2 fast 
650 0 |a Finance  |x Mathematical models. 
650 0 |a Corporations  |x Finance  |x Mathematical models. 
650 0 |a Visual Basic for Applications (Computer program language) 
650 7 |a Corporations  |x Finance  |x Mathematical models  |2 fast 
650 7 |a Finance  |x Mathematical models  |2 fast 
650 7 |a Visual Basic for Applications (Computer program language)  |2 fast 
758 |i has work:  |a Financial modeling in practice (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCGGtHqtGxwMg9cqm3JXPQq  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Rees, Michael.  |t Financial Modeling in Practice : A Concise Guide Using Excel and VBA for Intermediate and Advanced Level.  |d Somerset : John Wiley & Sons, Incorporated, ©2018  |z 9781118904015 
856 4 0 |u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=5326886  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD