pleases show all work and formulas used. please use pen and paper to show how you solved the problem and show excel format as well please

7. The Shakespeare Coffee Company is evaluating the within-plant distribution system for its new roasting, grinding, and packing plant. The two alternatives are (1) a conveyor system with a high initial cost but lower annual operating costs and (2) several forklift trucks, which cost less but have considerably higher operating costs. The decision to construct the plant has already been made, and the choice here will have no effect on the overall revenues of the project. The cost of capital for the plant is 9%, and the projects' expected net costs are listed in the following table: (10) Expected Net Cost Year Conveyor Forklift -$500,000 $200,000 0 -120,000 -150,000 2 -120,000 -150,000 3 -120,000 -150,000 4 -120,000 -150,000 -20,000 -150,000 a. What is the IRR of each alternative? If you can't find the IRR, explain why you can't b. What is the present value of the costs of each alternative? Which method should be chosen