Which of the following is a correct EXCEL formula to solve for the net present value of a project. A)=NPV (k,CF_1, CF_2,^...CFn)+CF₀ B)=NPV (k,CF_0,CF_1, CF_2,^...CFn) C)=NPV (CF_0,CF_1, CF_2,^...CFn) D)=NPV (CF_1, CF_2,^...CFn)+CF₀

Question

Quizplus · Accepted Answer

The correct formula for calculating the net present value (NPV) of a project in Excel is:=NPV(k,CF1,CF2,...CFn)+CF0where:k is the discount rateCF0 is the initial investment or cash outflowCF1, CF2, ... CFn are the cash inflows in each period

Which of the Following Is a Correct EXCEL Formula to Solve