Please put assignment in excel. All work must be shown

Chapter 10 Assignment - BUSI 5423 1. Find the NPV of each project with the following information. Your WACC is 12%. 0 1 (1500) 150 (2500) 850 Y Z 2. 2 250 760 3 350 570 4 450 580 5 550 490 6 650 480 7 750 470 8 1850 460 Now find NPV for each project with a WACC of 15%. 3. Find the IRR of each project with the information in # 1. 4. Find the MIRR of each project with the information in # 1. 5. Find the MIRR of each project with a WACC of 15%. 6. Now find the profitability index for Y and Z if the cost of capital is 12%? 7. Now find the payback period for each project using the info in part 1. 8. Now find the discounted payback period at 12%