please help to fill out green boxes. please include cell references as well

1165 fx F G H ENEN Plan B 31.123.000) $3,081,000 59.027,000 SO 56.348,039 0.00 4.68% 10 50% 37.61% 0.00% 22 29 0.00 A B D 21 22 INPUT DATA KEY OUTPUT 23 24 Stock Data Production Plans 25 Stock pro $12.35 25 Number of shares 2.500,000 Pian A 27 EBIT 28 Sales Data Pessimi (5775.000 2 Saling price 51400 Mostly $5.625.000 30 Unit sales and probabies Probably Optic $7.975,000 21 Pessimistic 51,300 25.00 Expected 30 32 Most ikely 28.000 50.00 SD 33 Optimistic 46.36 25.COM CV 0.06 ROL 35 Production Data Post 30N 36. Pan A Most Likely 1720 37 Ann fred costs $5,000,000 Optimi 37.58% 38 Variable costs 51,150 Expected 0.00% 30 Capital needed $21,000,000 SO 14.73% 40 Plana CV 0.00 41 Ann fixed costs 54,400.000 42 Variable 51.110 Al Optimal Capital Sudur 43 Capital needed 524.000.000 44 Debt level $25,000,000 45 Other Dats Cost of capital 0.00% 46 Tax rate 40.00% Expected TIE 47 Loan period tyrol 30 Espected coverage 0.00 48 49 Cost of Debt Cost of Equity Level of Debt 50 0.005 10.00% SO 81 7.00 11.00% 10,000,000 52 12.00% 15,000,000 sa 10.75 16.00 20,000,000 54 14255 2000% 25,000,000 55 50 57 P A EBIT and ROI Cabulations for Question 1 sa 59 Pessimistic Most Lely Opties 00 Sales revenue $15.620.000 $40.460.000 584.620,000 Student Template + 0.00 100% Ready A B E a H 55 886 88 353 Optimist $64.820,000 3.000.000 63.245,000 57,975.000 37.98% 57 Plan A EBIT and ROI Calculations for Question 1 58 50 Pessmusic Most Likely 00 Sales revenue 315.620,000 $40.460,000 61 Fixed cost 3.600,000 3,600,000 62 Variable costs 12.095.000 33.235,000 03 54 ERIT (5775.000 53,625,000 65 ROIG EBIT) 3.60% 17.26% G6 EBIT) 67 SDEDIT + 68 CVEBI 0.86 69 EROI) 70 SDRON 14.73% 71 CV RON 72 73 Plan B EBIT and ROI Calculations 74 75 Pesme Most Levy 76 Sales revenue $15.820,000 $40,460,000 77 Fred costs 4.400,000 4,400,000 78 Variable costs 12.543,000 32,079,000 79 DO EBIT 151,123,000) 53,081,000 31 ROI 4.68% 16.69% 82 EET 83 SEBIT) 55,348,939 34 CVEBIT SEROI 56 SOROU 22.29% 87 CVRON 05 00 Bahaven (BE) Sales 90 Plan A Plan Sunt si 14.400 93 Sales revenue 120,160,000 04 Student Template + Optimoto 564,820,000 4,400,000 51,393.000 $0.027,000 37,61% ESS988 Promo P IM > 6 % 5 16 - Eary Anale Create and Share Adobe PDF D E PARA 2 Unte 3 Sales 000 0000 ABSA ROL ERITA 100 false BO 101 102 PM 103 MAPA Chapter 104 A VIAC 105 parte 19 Unser 100 - 110 111 Castro ETA ERITRE ROTA S. ) 04 1.700,000.00 2.1 0001 1600 310.000.000 $15.000.000 10.000.000 000 | | | | | | | | | | wo 000 osti MO 17.000 1416 122 Capta Cat Aler GO OD MO W OLA Du datu Cat 12 100 DON 08 Student Template - 9 can F G H Cost of Wot Buy Cost of Capital Equity RONO -6.0% -66.7% 1165 XVFX A B C D E 122 Cost of Cal Calculation 123 124 Atterton 125 Castel Weight 126 Delt Det LORY Obit 127 128 0.00% 10.00% $0 30 SOVO 120 4205 1100% $10.000.000 2.51,1021 161 130 4805 12.00% $15.000.000 18,000,000 166.7 131 6456 16 009 132 8.55% 20.00% 125.000.000 110.667 500) 174. 133 134 Expected Tender Pan 13 Nomor below taken from analysis above 136 EBIT $0 137 Optimal debt $25.000000 135 Opal $14.312.000 100 cost of capital 000 140 estate 14255 GS TIE 143 543 For IE-1 144 TERT 145 int 13.582 500 140 Meaning EBIT: $3.562,500.0 147 CITO'P.FO.VO 146 VC UVC 549 S - EBIT.FWPWC 100 TIE- uit 161 152 of Unit Std Dev 12374 unit ang problem, and 153 the releitura 2000 | | | |dflau des bow the mean 155 10 Luthention 05000 the roi that TIE 1 5157 154 15 Expected Coverage under Pan A 109 D G H 1165 x f A C 133 134 Expected the under Pan 135 Numbers below taken from analysis above 130 FRIT so 137 Optima det 525.000.000 138 Optimal valor 514.312500 130 Cost of capita 0.00% 140 strade 14:25% 541 TE 142 143 For TE-1 STIE EBITA 145 int 3,562,50 146 Manny EBIT $3.562,500.00 147 EBITO'P.FC.VC 146 VC UVO 149 SQ-BIT.FCYPXC) 150 for TIE 1 Us 151 152 Ut Std D 12374 unts as given in problem and 153 the expected units sold is 2000 154 1 unit Medve below the mean 155 156 Using 1 minute in function 5000 in the probably that 152 158 190 Expected coverage under Pan 100 161 Onder 526.000.000 EBIT 162 interest rate 1626 103 Loan pered) 30 DELOVI 164 Annual en TVM covenant fra interest rate) 100 Printipal Repyar 50 17 Before tax pacoal repayment 50 100 170 30 171 1165 fx F G H ENEN Plan B 31.123.000) $3,081,000 59.027,000 SO 56.348,039 0.00 4.68% 10 50% 37.61% 0.00% 22 29 0.00 A B D 21 22 INPUT DATA KEY OUTPUT 23 24 Stock Data Production Plans 25 Stock pro $12.35 25 Number of shares 2.500,000 Pian A 27 EBIT 28 Sales Data Pessimi (5775.000 2 Saling price 51400 Mostly $5.625.000 30 Unit sales and probabies Probably Optic $7.975,000 21 Pessimistic 51,300 25.00 Expected 30 32 Most ikely 28.000 50.00 SD 33 Optimistic 46.36 25.COM CV 0.06 ROL 35 Production Data Post 30N 36. Pan A Most Likely 1720 37 Ann fred costs $5,000,000 Optimi 37.58% 38 Variable costs 51,150 Expected 0.00% 30 Capital needed $21,000,000 SO 14.73% 40 Plana CV 0.00 41 Ann fixed costs 54,400.000 42 Variable 51.110 Al Optimal Capital Sudur 43 Capital needed 524.000.000 44 Debt level $25,000,000 45 Other Dats Cost of capital 0.00% 46 Tax rate 40.00% Expected TIE 47 Loan period tyrol 30 Espected coverage 0.00 48 49 Cost of Debt Cost of Equity Level of Debt 50 0.005 10.00% SO 81 7.00 11.00% 10,000,000 52 12.00% 15,000,000 sa 10.75 16.00 20,000,000 54 14255 2000% 25,000,000 55 50 57 P A EBIT and ROI Cabulations for Question 1 sa 59 Pessimistic Most Lely Opties 00 Sales revenue $15.620.000 $40.460.000 584.620,000 Student Template + 0.00 100% Ready A B E a H 55 886 88 353 Optimist $64.820,000 3.000.000 63.245,000 57,975.000 37.98% 57 Plan A EBIT and ROI Calculations for Question 1 58 50 Pessmusic Most Likely 00 Sales revenue 315.620,000 $40.460,000 61 Fixed cost 3.600,000 3,600,000 62 Variable costs 12.095.000 33.235,000 03 54 ERIT (5775.000 53,625,000 65 ROIG EBIT) 3.60% 17.26% G6 EBIT) 67 SDEDIT + 68 CVEBI 0.86 69 EROI) 70 SDRON 14.73% 71 CV RON 72 73 Plan B EBIT and ROI Calculations 74 75 Pesme Most Levy 76 Sales revenue $15.820,000 $40,460,000 77 Fred costs 4.400,000 4,400,000 78 Variable costs 12.543,000 32,079,000 79 DO EBIT 151,123,000) 53,081,000 31 ROI 4.68% 16.69% 82 EET 83 SEBIT) 55,348,939 34 CVEBIT SEROI 56 SOROU 22.29% 87 CVRON 05 00 Bahaven (BE) Sales 90 Plan A Plan Sunt si 14.400 93 Sales revenue 120,160,000 04 Student Template + Optimoto 564,820,000 4,400,000 51,393.000 $0.027,000 37,61% ESS988 Promo P IM > 6 % 5 16 - Eary Anale Create and Share Adobe PDF D E PARA 2 Unte 3 Sales 000 0000 ABSA ROL ERITA 100 false BO 101 102 PM 103 MAPA Chapter 104 A VIAC 105 parte 19 Unser 100 - 110 111 Castro ETA ERITRE ROTA S. ) 04 1.700,000.00 2.1 0001 1600 310.000.000 $15.000.000 10.000.000 000 | | | | | | | | | | wo 000 osti MO 17.000 1416 122 Capta Cat Aler GO OD MO W OLA Du datu Cat 12 100 DON 08 Student Template - 9 can F G H Cost of Wot Buy Cost of Capital Equity RONO -6.0% -66.7% 1165 XVFX A B C D E 122 Cost of Cal Calculation 123 124 Atterton 125 Castel Weight 126 Delt Det LORY Obit 127 128 0.00% 10.00% $0 30 SOVO 120 4205 1100% $10.000.000 2.51,1021 161 130 4805 12.00% $15.000.000 18,000,000 166.7 131 6456 16 009 132 8.55% 20.00% 125.000.000 110.667 500) 174. 133 134 Expected Tender Pan 13 Nomor below taken from analysis above 136 EBIT $0 137 Optimal debt $25.000000 135 Opal $14.312.000 100 cost of capital 000 140 estate 14255 GS TIE 143 543 For IE-1 144 TERT 145 int 13.582 500 140 Meaning EBIT: $3.562,500.0 147 CITO'P.FO.VO 146 VC UVC 549 S - EBIT.FWPWC 100 TIE- uit 161 152 of Unit Std Dev 12374 unit ang problem, and 153 the releitura 2000 | | | |dflau des bow the mean 155 10 Luthention 05000 the roi that TIE 1 5157 154 15 Expected Coverage under Pan A 109 D G H 1165 x f A C 133 134 Expected the under Pan 135 Numbers below taken from analysis above 130 FRIT so 137 Optima det 525.000.000 138 Optimal valor 514.312500 130 Cost of capita 0.00% 140 strade 14:25% 541 TE 142 143 For TE-1 STIE EBITA 145 int 3,562,50 146 Manny EBIT $3.562,500.00 147 EBITO'P.FC.VC 146 VC UVO 149 SQ-BIT.FCYPXC) 150 for TIE 1 Us 151 152 Ut Std D 12374 unts as given in problem and 153 the expected units sold is 2000 154 1 unit Medve below the mean 155 156 Using 1 minute in function 5000 in the probably that 152 158 190 Expected coverage under Pan 100 161 Onder 526.000.000 EBIT 162 interest rate 1626 103 Loan pered) 30 DELOVI 164 Annual en TVM covenant fra interest rate) 100 Printipal Repyar 50 17 Before tax pacoal repayment 50 100 170 30 171