Here is the spread sheet provided no need to fill it out, just provided it to help in solving the problem.

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ Project B: $ b. What is each project's IRR? Round your answer to two decimal places. Project A : % Project B: % Project A : % Project B: % d. From your answers to parts a-c, which project would be selected? If the WACC was 18%, which project would be selected? f. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. Do not round your intermediate calculations. 10 g. What is each project's MIRR at a WACC of 18% ? Round your answer to two decimal places. Do not round your intermediate calculations. Project A: % Project B: Capital budgeting criteria WACC Project A Project B Project NPV Calculations: NPVA NPVB Project IRR Calculations: IRRA IRRB Project MIRR Calculations: MIRRA Alternatively, MIRRA can be calculated as: Project A PV of Year 1 Outflow PV of Year 2 Outflow PV of Year 3 Outflow PV of Year 7 Outflow Sum of Outflow PVs N PV PMT FV I/YR=MIRRA MIRR8 Alternatively, MIRRB can be calculated as: Project B Sum of Outflow PVs \begin{tabular}{|l|} \hline N \\ \hline PV \\ \hline PMT \\ \hline FV \\ \hline \end{tabular} I/YR=MIRRB Project Acceptance: WACC Accept WACC NPVA NPVB Accept \#N/A \#N/A \begin{tabular}{lll} 0 & 1 & 2 \\ \hline$300 & $387 & $193 \end{tabular} $1003 $6004 $600 $8506 $1807 HN/A $135 Formulas \#N/A \#N/A \#N/A \#N/A FV of Year 6 Inflow at Year 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflow at Year 7 Sum of Inflow FV/s Formulas \#N/A #N/A \#N/A \#N/A \#N/A FV of Year 6 Inflow at Year 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflow at Year 7 FV of Year 3 Inflow at Year 7 FV of Year 2 Inflow at Year 7 FV of Year 1 Inflow at Year 7