Boston College

Excel’s NPV function will make this calculation with one qualification. We can enter the value of the discount rate as the Rate argument in the function, and the values of the future cash flows cash flows C1, … CT as the Value1, …, ValueT arguments, respectively. In fact, we don’t have to enter the future cash flows one by one. ................
................