Question: For the table given below construct a spreadsheet and compute both the net present value (NPV). Assume that the project is being evaluated over 5

 For the table given below construct a spreadsheet and compute both

For the table given below construct a spreadsheet and compute both the net present value (NPV). Assume that the project is being evaluated over 5 years. Construct the appropriate formulas for computing the present values, then scale your yearly present values by multiplying them by a discount factor. The given discount rate for the project is 5% (hint: use this rate to compute your discount factors for each year). Submit your spreadsheet on this assignment. To receive full credit you are expected to have the appropriate formulas in your spreadsheet for calculating the NPV. DF for each year (1/(1+DF)^i, where i represents the year Year Cumulative Costs and Benefits Cumulative Costs Benefits Costs 50,000 50,000 3,000 17,000 67,000 28,000 Cumulative Benefits 0 3,000 1 31.000 2 18,450 85,450 31,000 62,000 3 104,450 96,000 19,000 20,500 34,000 37,000 4. 124,950 133,000 5 21,000 145,950 40,000 173.000 6 22,000 167,950 43,000 216,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!