About the Author |
|
ix | |
About the Technical Reviewer |
|
xi | |
Acknowledgments |
|
xiii | |
Introduction |
|
xv | |
|
Part 1 Business Case Analysis with R |
|
|
1 | (102) |
|
Chapter 1 A Relief from Spreadsheet Misery |
|
|
3 | (6) |
|
Why Use R for Business Case Analysis? |
|
|
3 | (5) |
|
|
8 | (1) |
|
|
8 | (1) |
|
Chapter 2 Setting Up the Analysis |
|
|
9 | (38) |
|
|
9 | (2) |
|
|
9 | (1) |
|
|
10 | (1) |
|
Abstract the Case Study with an Influence Diagram |
|
|
11 | (4) |
|
Set Up the File Structure |
|
|
15 | (1) |
|
|
16 | (2) |
|
Write the Deterministic Financial Model |
|
|
18 | (20) |
|
|
18 | (3) |
|
|
21 | (6) |
|
|
27 | (3) |
|
|
30 | (1) |
|
|
31 | (2) |
|
|
33 | (5) |
|
|
38 | (2) |
|
Conduct Deterministic Sensitivity Analysis |
|
|
40 | (7) |
|
Chapter 3 Include Uncertainty in the Financial Analysis |
|
|
47 | (32) |
|
Why and How Do We Represent Uncertainty? |
|
|
47 | (2) |
|
What Is Monte Carlo Simulation? |
|
|
49 | (3) |
|
The Matrix Structure of Business Case Simulation in R |
|
|
52 | (1) |
|
Useful Distributions for Expert Elicited Assumptions |
|
|
53 | (14) |
|
Discrete Distributions: McNamee-Celona and Swanson-Megill |
|
|
53 | (3) |
|
|
56 | (11) |
|
Modify the Influence Diagram to Reflect the Risk Layer |
|
|
67 | (2) |
|
|
69 | (10) |
|
Chapter 4 Interpreting and Communicating Insights |
|
|
79 | (24) |
|
Cash Flow and Cumulative Cash Flow with Probability Bands |
|
|
79 | (5) |
|
|
84 | (2) |
|
The Cumulative Probability Distribution of NPV |
|
|
86 | (2) |
|
The Waterfall Chart of the Pro Forma Present Values |
|
|
88 | (2) |
|
The Tornado Sensitivity Chart |
|
|
90 | (11) |
|
|
101 | (2) |
|
|
103 | (30) |
|
Chapter 5 "What Should I Do?" |
|
|
105 | (8) |
|
Three Tools to Clarify Your Thoughts |
|
|
106 | (2) |
|
The Full Scope of Effective Decision Making |
|
|
108 | (2) |
|
|
110 | (2) |
|
|
112 | (1) |
|
Complementary Resource: Integrated Decision Hierarchy and Strategy Table Template |
|
|
112 | (1) |
|
Chapter 6 Use a Decision Hierarchy to Categorize Decision Types |
|
|
113 | (8) |
|
Chapter 7 Tame Decision Complexity by Creating a Strategy Table |
|
|
121 | (4) |
|
Chapter 8 Clearly Communicate the Intentions of Decision Strategies |
|
|
125 | (4) |
|
Chapter 9 What Comes Next |
|
|
129 | (4) |
|
|
129 | (1) |
|
|
130 | (3) |
|
Part 3 Subject Matter Expert Elicitation Guide |
|
|
133 | (36) |
|
Chapter 10 "What's Your Number, Pardner?" |
|
|
135 | (6) |
|
|
140 | (1) |
|
Chapter 11 Conducting SME Elicitations |
|
|
141 | (24) |
|
|
141 | (2) |
|
|
143 | (1) |
|
Define the Uncertain Event |
|
|
144 | (1) |
|
Identify the Sources of Bias |
|
|
144 | (1) |
|
Postulate and Document Causes of Extrema |
|
|
145 | (3) |
|
Measure the Range of Uncertain Events with Probabilities |
|
|
148 | (1) |
|
Discrete Binary Uncertainties |
|
|
149 | (7) |
|
|
156 | (6) |
|
Document the SME Interview |
|
|
162 | (1) |
|
It's Just an Opinion, Right? |
|
|
162 | (3) |
|
Chapter 12 Kinds of Biases |
|
|
165 | (4) |
|
Part 4 Information Espresso |
|
|
169 | (52) |
|
Chapter 13 Setting a Budget for Making Decisions Clearly |
|
|
171 | (4) |
|
|
174 | (1) |
|
Chapter 14 A More Refined Explanation of VOI |
|
|
175 | (12) |
|
|
175 | (5) |
|
|
180 | (3) |
|
|
183 | (4) |
|
Chapter 15 Building the Simulation in R |
|
|
187 | (34) |
|
|
188 | (12) |
|
|
200 | (6) |
|
|
206 | (12) |
|
|
206 | (3) |
|
|
209 | (9) |
|
|
218 | (3) |
|
|
219 | (1) |
|
|
219 | (1) |
|
|
219 | (2) |
|
Appendix A Deterministic Model |
|
|
221 | (10) |
|
|
231 | (18) |
|
Appendix C Simulation and Finance Functions |
|
|
249 | (8) |
|
Appendix D Decision Hierarchy and Strategy Table Templates |
|
|
257 | (4) |
|
Decision Hierarchy Worksheet |
|
|
257 | (4) |
|
|
257 | (2) |
|
|
259 | (1) |
|
Strategy Rationales Worksheet |
|
|
260 | (1) |
|
Appendix E VOI Code Samples |
|
|
261 | (16) |
|
|
261 | (1) |
|
|
261 | (16) |
|
|
262 | (5) |
|
|
267 | (1) |
|
|
268 | (3) |
|
|
271 | (2) |
|
Value of Information 1: Coarse |
|
|
273 | (1) |
|
Value of Information 2: Fine |
|
|
274 | (3) |
Index |
|
277 | |