subtracted to calculate the answer. Notice that we added cell C9 because it is already negative.

In our spreadsheet example, notice that we have provided two answers. By comparing the answers to that found in Example 9.1, we see that the first answer is wrong even though we used the spreadsheet's NPV formula. What happened is that the "NPV" function in our spreadsheet is actually a PV function; unfortunately, one of the original spreadsheet programs many years ago got the definition wrong, and subsequent spreadsheets have copied it! Our second answer shows how to use the formula properly.

The example here illustrates the danger of blindly using calculators or computers without understanding what is going on; we shudder to think of how many capital budgeting decisions in the real world are based on incorrect use of this particular function. We will see another example of something that can go wrong with a spreadsheet later in the chapter.

0 0

Post a comment