Andy is evaluating a project that require an investment costs of $908,000 has a 6-year life and has no salvage value. This project will require $305,000 in net working capital at the start and subsequently, total net working capital at the end of each year will be about 12% of sales for that year. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 75,000 units per year, and decrease to 65,000 on year 4, 62,000 on year 5 and 61,000 on year 6. Price per unit is $47, and drop to $42 on year 4, 5, and 6. Variable cost per unit is $23, and fixed costs are $850,000 per year. The tax rate is 37%, and this project risk level require 18% return. Referring to chapter 10, answer these problems

a. Prepare the projected income statements table!

b. Prepare the projected cashflow table!

c. Prepare the projected total cashflows table!

d. Make investment decision based on those tables!