Using the Table and NPV formulas: Time CF PV 1. Type in your cash flows in cells D99 through D102. 0 0 0 2. Type in your discount rate in cell D104 1 3. In cell E99 type: PV($D$104,C99,0,-D99) 1 2 4. Copy to cells E100:E102. 2 3 5. In cell E106 type: -SUM(E99:E102) 3 6. You should get $810.95 as the NPV with the 14 rate inputs from the previous problem 5 06 NPV 6183.21 07 08 09 Test your skills: 10 What is the net present value of a cash flow of $4,000 today. $3,000 at the end of the next year (time-1), -11 $2,000 at the end of year 2, and $2,000 at the end of year 3, discounted at 7% (rate-.072 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 122