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 mutually exclusive. Both projects are equally risky, and the firm plans to use a 10% cost of capital to evaluate each. Project Alpha has an estimated life of 12 years, and project Beta has an estimated life of 9 years. The cash flow data have been prepared as given in the following table.

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.

Cash flows Project Alpha Project Beta -45,500,000 300,000 CF. -$6,500,000 400,000 CF 500,000 600,000 CF 500,000 800,000 CF. CFs CF. 550,000 1,100,000 700,000 1,400,000 800,000 2,000,000 CF 2,500,000 2,000,000 950,000 CF CF, CF CF CF 1,000,000 1,250,000 1,500,000 1,000,000 2,000,000 2,500,000