Tuck School of Business at Dartmouth

Modeling for Insight


Chapter 1

Chapter 2

Chapter 3

Chapter 4

Chapter 5

Chapter 6

  1. In the models in this chapter there is a blank cell that leads to an error in the NPV calculation. For example, in M1 the blank cell is in E21, representing the fact that the cash flow in Year 2 is zero. The NPV function ignores the blank cell, thereby discounting cash flows in Years 3-8 to Year 2, not Year 1. The error in this mode version is $12,032, or about 10%.

Chapter 7

Chapter 8

  1. Page 209, Figure 8.9: Cell D1 should be M3, not M2. Also in Figure 8.10.

Chapter 9

Chapter 10

Chapter 11

Chapter 12

Appendix A

Appendix B

Appendix C