Pls include excel references in solution!!

Capital Investment Excel Assignment Advanced Financial Management 57 58 59 60 Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas....only use cell references to the input data. I will change the input data 1. A firm is considering the two mutually exclusive investments projects. Project Alpha requires an initial outlay of $600 and will return $165 per year for the next seven years, Project Beta requires an initial outlay of $1,100 and will return $355 per year for the next five years. Assuming a 11.5% required return, calculate the NPV, IRR, Payback Period, PI, and MIRR of each project. Which project is preferable and why? 61 62 63 64 65 66 67 68 69 70 71 72 73 Alpha Beta NPV IRR Payback PI MIRR