Please help me solve the empty colored boxes with formulas (on second photo). Thank you!

A NPV profiles 1 2 3 4 5 (Dollars in Millions) 6 Plan A 7 8 9 10 Project NPV Calculations: 11 NPVA 12 NPVB 13 WACC Plan B 14 Project IRR Calculations: 15 IRRA 16 IRRB 17 18 NPV Profiles: 19 Discount Rates 20 21 22 23 24 25 26 27 0% 5% 10% 15% 20% 22% 25% B 11.00% 0 -$39.00 NPVA -$13.00 15.00% =IRR(C6:W6) 21.96% = IRR(C8:W8) $10.61 $85.60 $38.64 $14.04 $0.00 -$8.66 -$11.21 -$14.37 Formulas $10.61 =NPV(B3, D6:W6)+C6 $10.17 =NPV(B3,D8:W8)+C8 NPVB D $10.17 $45.20 $23.27 $11.77 $5.21 $1.17 -$0.02 -$1.49 E 1 2 $6.23 $6.23 F 3 $6.23 $2.91 $2.91 $2.91 G 4 $6.23 $2.91 H 6 5 $6.23 $6.23 $2.91 $2.91 J 7 $6.23 K 8 $6.23 L 9 $6.23 $2.91 $2.91 $2.91 M 10 $6.23 $2.91 N O P 11 12 13 14 $6.23 $6.23 $6.23 $6.23 $2.91 $2.91 $2.91 $2.91 R 15 $6.23 $2.91 S 16 $6.23 $2.91 T 17 $6.23 U 18 $6.23 V 19 $6.23 $2.91 $2.91 $2.91 W 20 $6.23 $2.91 27 28 29 30 31 32 33 $100.00 $80.00 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Plan B 50 $60.00 $40.00 $20.00 $0.00 -$20.00 A Plan A 0% 25% B -$14.37 Calculation of Crossover Rate: 51 Project Delta 52 53 54 55 Crossover Rate = IRRA 5% Formulas -$1.49 10% 0 -$39.00 -$13.00 #N/A Formula #N/A D E NPV Profiles 15% #N/A LL F 1 3 $6.23 $6.23 $6.23 $2.91 $2.91 $2.91 #N/A #N/A 20% G 4 $6.23 $2.91 #N/A H 22% 5 $6.23 1 J 25% K 6 7 8 $6.23 $6.23 $6.23 L #N/A #N/A #N/A #N/A 9 $6.23 $2.91 $2.91 $2.91 $2.91 $2.91 #N/A M 10 $6.23 $2.91 #N/A N O 11 12 13 $6.23 $6.23 $6.23 #N/A P $2.91 $2.91 $2.91 #N/A #N/A R #N/A S $2.91 $2.91 $2.91 #N/A 14 15 16 17 18 19 $6.23 $6.23 $6.23 $6.23 $6.23 $6.23 T #N/A U #N/A V $2.91 $2.91 $2.91 #N/A #N/A W 20 $6.23 $2.91 #N/A