please share excel spreadsheet and formulas

Question #L.NPY. (3) A. Which cash flow below generates the Largest NPV? Which cash flow below generates the largest IRR? What is the value of the largest NPV? (3) B. Which cash flow below generates the Lowest NPV? Which cash flow below generates the Lowest IRR? What is the value of the Lowest IRR? (2) C. Name two forces that were at play that caused one cash flow to generate the Largest NPV and the other cash flow to generate the Lowest NPV? (1) D. If you were the business owner, which cash flow (CF1 through CF10) would you prefer, assuming you can replicate the investment as many times as $5,000,000 in available capital could cover? YRO YRS Initial Investment MARR YRI YR2 YR3 YR4 YR6 YR7 NPV IRR CF1 8% $1,000,000 $100,960 $460,030 $372,525 $174,955 $80,456 $ 79,055 $52,000 NPV1 IRR1 CF2 7% -$500,000 $141,327 $209,404 $202,468 $280,864 $379,055 $379,055 $379,055 NPV2 IRR2 CF3 13% -$450,000 $102,494 $126,316 $189,814 $263,310 $355,364 $355,364 $55,364 NPV3 IRR3 CF412% $250,000 $70,663 $104,702 $101,234 $140,432 $189,527 $189,527 $189,527 NPV4 IRR4 CFS 11% -$400,000 $117,920 $174,721 $168,934 $234,346 $316,274 $316,274 $316,274 NPVS IRR5 CF6 17% -$250,000 $41,372 $109,404 $252,017 $280,864 $379,055 $379,055 $300,055 NPV6 IRR6 CF7| 15% -$500,000 $176,659 $261,755 $253,085 $351,081 $473,819 $473,819 $473,819 NPVZ IRRY CF8| 19% -$100,000 $20,018 $14,472 $14,324 $15,999 $18,096 $180,096 $100,069 NPVS IRR8 CF9 15% $1,000,000 $852,000 $279,055 $180,456 $174,955 $372,525 $560,030 $509,603 NPV9 IRR9 CF10 18% $500,000 $147,216 $218,129 $210,904 $292,567 $394,849 $394,849 $394,849 NPV1O IRR10