Please help me to complete requirement 1 and 2

Kerwin Industries is deciding whether to automate one phase of its production process. The manufacturing equipment has a six-year life and will cost $910,000. Projected net cash inflows are as follows: (Click the icon to view the projected net cash inflows.) (Click the icon to view the present value table.) (Click the icon to view the future value table.) Read the requirements. (Click the icon to view the present value annuity table.) (Click the icon to view the future value annuity table.) Requirement 1. Compute this project's NPV using Kerwin Industries' 14% hurdle rate. Should Kerwin Industries invest in the equipment? Why or why not? Begin by computing the project's NPV (net present value). (Round your answer to the nearest whole dollar. Use parentheses or a minus sign for negative net present values.) Net present value Data table Year 1... Year 2... Year 3... Year 4... Year 5... Year 6... Print .... $261,000 $254,000 $223,000 $213,000 $201,000 $178,000 Done - X Requirements 1. Compute this project's NPV using Kerwin Industries' 14% hurdle rate. Should the company invest in the equipment? Why or why not? 2. Kerwin Industries could refurbish the equipment at the end of six years for $105,000. The refurbished equipment could be used one more year, providing $73,000 of net cash inflows in Year 7. In addition, the refurbished equipment would have a $52,000 residual value at the end of Year 7. Should Kerwin Industries invest in the equipment and refurbish it after six years? Why or why not? (Hint: In addition to your answer to Requirement 1, discount the additional cash outflow and inflows back to the present value.) Print Done X