How to do in excel

Paste Format Painter BIU - MAY 3BEEE Merge & Center 00 -0 Formatt Clipboard Font Alignment Number A26 X V J NPV A B E G 4 Name: 5 6 For full credit, you must show your work 7 8 Main Capital Incorporated is considering two mutually exclusive projects. The company's discount rate is 10% 9 and its payback period is 3 years. 10 11 Using excel, calculate the payback period, NPV and IRR for each project. 12 13 Determine whether Main Capital should accept or reject the projects under each technique. Explain why. 14 15 16 17 Cash Flows Project A Project B Initial cash 19 outflow 400,000 600,000 20 Yr 1 55,000 300,000 21 Yr 2 55,000 300,000 22 Yr 3 55,000 50,000 23 Yr 4 225,000 50,000 24 Yr 5 225,000 49,000 25 26 27 28 Accept? 29 30 Why? 31 32 33 34 35 36 37 Sheet1 Select destination and press ENTER or choose Paste Type here to search x