Please answer step by step

RT FIVE Long-Term Investment Decisions HEET EXERCISE Dyno Corporation has two projects that it would like to undertake. However, due to capital restraints, the two projects-Alpha and Beta-must be treated as mutualle exclusive. Both projects are equally risky, and the firm plans to use a 10% apital to evaluate each. Project Alpha has an estimated life of 12 years, and p Beta has an in the following table. cost of estimated life of 9 years. The cash flow data have been prepared as given Cash flows Project Alpha Project Beta CFo -$5,500,000 $6,500,000 CF CF2 CF CF. CFs CF CF7 CFs CFg CF 300,000 500,000 500,000 400,000 600,000 800,000 550,000 1,100,000 1,400,000 800,000 2,000,000 950,000 2,500,000 2,000,000 1,000,000 700,000 1,000,000 1,250,000 1,500,000 2,000,000 10 CF11 CFz 2,500,000 TO DO Create a spreadsheet to answer the following questions. a. Calculate the NPV for each project over its respective life. Rank the projects in descending order on the basis of NPV. Which one would you choose? b. Use the annualized net present value (ANPV) approach to evaluate and rank the projects in descending order on the basis of ANPV. Which one would you choose? c. Compare and contrast your findings in parts a and b. Which project would you recommend that the firm choose? Explain