Please Answering using an Excel graph.

28. Abandonment Decisions Consider the following project for Hand Clapper, Inc. The company is considering a four-year project to manufacture clap-command garage door openers. This project requires an initial investment of $12.7 million that will be depreciated straight-line to zero over the project's life. An initial investment in net working capital of $2.028 million is required to support spare parts inventory; this cost is fully recoverable whenever the project ends. The company believes it can generate $10.99 million in pretax revenues with $4.524 million in total pretax operating costs. The tax rate is 21 percent and the discount rate is 16 percent. The market value of the equipment over the life of the project is as follows: Page 284 Market Value Year (in $ millions) 1 $8.80 2 7.96 3 5.30 4 0.00 a. Assuming the company operates this project for four years, what is the NPV? b. Now compute the project NPVs assuming the project is abandoned after only one year, after two years, and after three years. What economic life for this project maximizes its value to the firm? What does this problem tell you about not considering abandonment possibilities when evaluating projects? 28. Abandonment Decisions Consider the following project for Hand Clapper, Inc. The company is considering a four-year project to manufacture clap-command garage door openers. This project requires an initial investment of $12.7 million that will be depreciated straight-line to zero over the project's life. An initial investment in net working capital of $2.028 million is required to support spare parts inventory; this cost is fully recoverable whenever the project ends. The company believes it can generate $10.99 million in pretax revenues with $4.524 million in total pretax operating costs. The tax rate is 21 percent and the discount rate is 16 percent. The market value of the equipment over the life of the project is as follows: Page 284 Market Value Year (in $ millions) 1 $8.80 2 7.96 3 5.30 4 0.00 a. Assuming the company operates this project for four years, what is the NPV? b. Now compute the project NPVs assuming the project is abandoned after only one year, after two years, and after three years. What economic life for this project maximizes its value to the firm? What does this problem tell you about not considering abandonment possibilities when evaluating projects