Problem 2 (20 marks)

You are evaluating a project for The Ultimate recreational tennis racket, guaranteed to correct that wimpy backhand. You estimate the unit sales price of The Ultimate to be $500 and sales volume to be 1,000 units in year 1; 1,250 units in year 2, and 1,450 units in year 3. The project has a three year life. Variable costs amount to $225 per unit and fixed costs, excluding depreciation, are $110,000 per year. The project requires an initial investment of $170,000 which is depreciated straight-line to zero over the three-year project life. The expected scrap value of the asset at the end of year 3 is $35,000. Net working capital investment is initially lowered by $80,000 and it will be fully replaced at the end of the projects life. The tax rate is 34% and the required return on the project is 10%. What is the NPV of this project? Accordingly what is your decision?

(Please provide all the equation and step by step or Excel.xml in google drive )

(Please don't copy from another places, the answer will upload to Turnitin)