Using Excel

Question 4 (30 points) - Timelines of both the Cash Flow (CF) and Discounted Cash Flow (DCF) are required for the solution to this question: What is the Net Present Value (NPV) of the following Cash Flow (CF)? Assume a discount rate of 10.0% Cash Flow 0 1 2 3 4 5 6 7 10 11 -$2,500$1,000 +S1,500+$2,000 +S2,500 +$3,000 +S3,500 $4,000 -S5,000 0 +S4,500 +S5,000