In cell B9, which formula uses NPV with the rate in B2 and the payments in B11:B14 as a single Value argument?

In cell B9, which formula uses NPV with the rate in B2 and the payments in B11:B14 as a single Value argument?

• A. =NPV(B2, B11, B12, B13, B14)
• B. =NPV(B2, B11, B12, B13)
• C. =NPV(B2, B11:B14, B15)
• D. =NPV(B2, B11:B14)

Answer: (D)

The payments should be fed as one sequence to the NPV function, not as separate values. In Excel, the NPV function takes a rate and then a series of cash flows; that series can be provided as individual arguments or as a single range. Using B11:B14 passes all four payments together as one values argument, which matches the requirement of a single Value argument. The other options either list each payment separately or combine a range with an extra value, which isn’t the intended single-argument approach. So the correct formula is =NPV(B2, B11:B14).

The payments should be fed as one sequence to the NPV function, not as separate values. In Excel, the NPV function takes a rate and then a series of cash flows; that series can be provided as individual arguments or as a single range. Using B11:B14 passes all four payments together as one values argument, which matches the requirement of a single Value argument. The other options either list each payment separately or combine a range with an extra value, which isn’t the intended single-argument approach. So the correct formula is =NPV(B2, B11:B14).