Please show your work using EXCEL SPREADSHEET.

B.D. Jones Co. is considering two Mutually Exclusive Projects Project Alpha-1 is expected to generate cash flows of $3,250 each year of its 5 year life. The project will cost $11,000. Project Beta-2 is expected to produce $8,000 in cash flows per year. It also has a 5 year life, and costs $27,750. The Cost of Capital is 12% and these projects are of normal risk. 1. Calculate the NPV, IRR, and MIRR for each of the projects. 2. Given that they are mutually exclusive, which project should be selected based on each ranking method? 3. Now explain which project should be chosen and why.