please show all work in excel if possible.

9. m u me Duiger has an opportunity cost of 15%. (NPV & IRR) Two projects, Alpha and Beta have free cash flows listed below. The firm has a cost of capital of 15%. Calculate the NPV and IRR of Alpha and Beta and determine if these independent projects should be selected: Alpha Beta Year 0 1 -$25,000 $55,000 Year 1 $5,000 $10,000 Year 2 $5,000 $10,000 $5,000 $10,000 Year 4 $5,000 $10,000 Year 5 $5,000 $10,000 Year 6 $5,000 $10,000 Year 3