Please use and show excel formulas

Assignment 6-Capital Budgeting Part 1 Submit using Assignment tab in elearning by uploading your completed excel file. Open a new (fresh) excel workbook to perform you calculations and make sure to highlight each of your final answers. Your excel file has to be named to reflect your name and the assignment number (for example I may name my file: elashmawiamalA6) You are allowed only one submission, so please make sure it is the correct one. Work independently and do not use class exercise template (or any other template) This assignment is due before midnight on 10/4 The deadline for late submission and partial credit is midnight 10/5. No submission will be accepted beyond that date and time. You are considering the following three projects. A & B are mutually exclusive while C is independent. Following are their expected cash flows project A Project B year Project C -40,000.00 -60,000.00 -20,000.00 40,000.00 35,000.00 2 40,000.00 82,000.00 30,000.00 2,000.00 20,000.00 60,000.00 10,000.00 -40,000.00 20,000.00 Assuming no capitol rationinga required rate of return (cost of capital) of 12 % for all three projects. 1) Calculate NPV for each project. 2) Calculate IRR(s) for each project. 3) Calculate Pl for each project. 4) Using cost of capital, as a financing and reinvestment rate, calculate MIRR for each project. 5) If A&B profiles cross, calculate the exact crossover point between project A & B 6) Which of the three projects, if any, should be accepted and why? Please highlight and label each of your answers on the spread sheet. Format all your answers to show 2 decimal places. USPrepare A table showiny the relationship between discvnt rat and for all three proj c cts . V se th ATAll three p rojects on the same shovld encomyass all IRRspr all hree projects table to grAph the NPVproe Sam graph. Your se leckd discovnt rat