Project A and Project B cash flows are given in the spreadsheet below.

Recreate the Data Table in cells A21:C37 and create the graph. Notice that the Data Table headers in cells B21:C21 have been hidden (there is a note in the exercise file on how to do this).

What is the crossover point of the two lines? (You can use the data table to do this, but you can also refer to Chapter 3 for a better solution.)

Transcribed Image Text:

1 A 2 Discount rate. B D E TWO INVESTMENTS AND THEIR NPVS 15% 3 Project A Project B 4 Year cash flow cash flow 5 0 -1,000 -1,000 6 1 220 300 7 2 220 300 8 3 220 300 9 4 220 300 10 5 220 300 11 6 220 100 12 7 220 100 13 8 220 100 14 9 220 100 15 10 220 100 16 17 NPV 18 IRR F G H 104.13 17.68% 172.31 20.64%