how to solve

PMT472 APPLIED PROJECT MANAGEMENT 1.3 ASSIGNMENT: WEEK 1 EXERCISES CH. 2 EXERCISE 3 A five-year project has a projected net cash flow of $15,000, $25,000, $30,000, $20,000, and $15,000 in the next five years. It will cost $50,000 to implement the project. If the required rate of return is 20 percent, conduct a discounted cash flow calculation to NOTE: Excel formula for NPV is "=negative investment amount + NPV(required rate of return, net cash flow year 1, net cash flow year 2, net cash flow year 3,.)"; i.e. "=-50000+NPV(.2,15000,25000,..)" Year Investment Revenue Stream 0 $50,000 $15,000 2 $25,000 3 $30,000 $20,000 5 $15,000 NPV (Type Excel formula to calculate result)