what would be my sensitivity analysis for scenario 3. using the table provided worst base & best

13.31 Industrial EVEBIDA average Under Recreation: EV/EBITDA NPV $14,410 IRR 31% Payback 7.4 Best Sensitivity Analysis Based on Scenario 3 as The Base Case Worst Base Parameter Sales 20% lower 8.40% Discount Rate 9.00% 8.40% Variable Production Cost 20% higher 8.40% 20% higher 7.70% 20% lower NPV Worst Base Best Parameter Sales Discount rate Variable Production cost 14,410 14,410 14,410 A 0 115 1567 ( Scenario TIL: Asuming the project will last fore ever and NWC will stay at 2,429 after 2020. The continuation value is calculated using EVEBITDA Co Free Cable 01 Optical FM 00 919 557 1943 Cash Flowchar 116 1 1114 63 Cara FirePC. 114 10 113 010 1411 1414 641 Tall 00 11 16 41 610 113 Care ON Total cash flow plus continuation sale (1030) (557) 62 541 SRB 60 60 735 8.40% be odustal CDA 10 under Recreation IV/EBITDA 111 7 NPV $14410 ERR SIN Payback 74 97 33 11466 160 795 75 20 Best Sensitivity Analysis Based on Scenario 3 as The Base Case Worst Base Parameter Sales 20% lower E.OX Dhcount Rate 9.00 8.40 Variable Production Cost 20% higher 8.40% 30 20% higher 7.70% 20% lower NPV 3 14 5 16 87 88 Worst Base Parameter Sales Discount rate Variable Production cost 14,410 14,410 14.410 New Heritage Doll Company: Capital Budgeting Exhibit 1 Selected Operating Projections for Match My Doll Clothing Line Expansion 2011 4.500 2013 2014 23 K. 22 2. 20 10.599 04 2017 11.40 * 2018 12.45 20 2019 1344 NO 2620 14401 RO 5245 KH 995 10 135 58 5,519 Productes Cole Pada pendapat Variable Produtos Cat Depreciation Total Products Cow Setting Admite Total 375 7015 12 2,76 1.155 513 3,000 192 4131 1.715 SA 1992 020 2.101 199 $.419 2.1 692 5521 120 121 1.648 1922 6817 2.60 MO 7079 124 7053 3,16 674 705 2 8.00 1401 13.203 4173 2:40 1.250 1.250 10.463 112 Operating Profit 12 581 994 1377 1,199 1 1,753 1993 2,045 2.200 3.0 10% Bline par Menu Cash Balance Sales Das Sales and dong Duis Potop 3044 02 30 592 * 10 52 12.95 31.08 1914 ons 191 1274 310 10 1923 12.3 31 sons 19 12% 310 23 30 592 12.7 110 392 12 31.08 12.5 31 310 530 Cappenditure 1.420 952 2 192 154 3 134 491 Net Weil NW 135 200 212 272 TAR 293 116 sh 400 1112 1812 1.99 lony 1. 1.35 2.00) 2,141 500 19 433 461 AP SI 699 NWC 393 6:40 2 747 171 41 in NC 1114 14 1511 1.650 1.10 1920 109 439 20 10) 230 122 10 154 je 33 24 Secoario 1: No Continuation Value: Assuming the project will be terminated. There will be ne savage value and networking capital will be recovered in 2021 412 7,34 7 TO 13.31 Industrial EVEBIDA average Under Recreation: EV/EBITDA NPV $14,410 IRR 31% Payback 7.4 Best Sensitivity Analysis Based on Scenario 3 as The Base Case Worst Base Parameter Sales 20% lower 8.40% Discount Rate 9.00% 8.40% Variable Production Cost 20% higher 8.40% 20% higher 7.70% 20% lower NPV Worst Base Best Parameter Sales Discount rate Variable Production cost 14,410 14,410 14,410 A 0 115 1567 ( Scenario TIL: Asuming the project will last fore ever and NWC will stay at 2,429 after 2020. The continuation value is calculated using EVEBITDA Co Free Cable 01 Optical FM 00 919 557 1943 Cash Flowchar 116 1 1114 63 Cara FirePC. 114 10 113 010 1411 1414 641 Tall 00 11 16 41 610 113 Care ON Total cash flow plus continuation sale (1030) (557) 62 541 SRB 60 60 735 8.40% be odustal CDA 10 under Recreation IV/EBITDA 111 7 NPV $14410 ERR SIN Payback 74 97 33 11466 160 795 75 20 Best Sensitivity Analysis Based on Scenario 3 as The Base Case Worst Base Parameter Sales 20% lower E.OX Dhcount Rate 9.00 8.40 Variable Production Cost 20% higher 8.40% 30 20% higher 7.70% 20% lower NPV 3 14 5 16 87 88 Worst Base Parameter Sales Discount rate Variable Production cost 14,410 14,410 14.410 New Heritage Doll Company: Capital Budgeting Exhibit 1 Selected Operating Projections for Match My Doll Clothing Line Expansion 2011 4.500 2013 2014 23 K. 22 2. 20 10.599 04 2017 11.40 * 2018 12.45 20 2019 1344 NO 2620 14401 RO 5245 KH 995 10 135 58 5,519 Productes Cole Pada pendapat Variable Produtos Cat Depreciation Total Products Cow Setting Admite Total 375 7015 12 2,76 1.155 513 3,000 192 4131 1.715 SA 1992 020 2.101 199 $.419 2.1 692 5521 120 121 1.648 1922 6817 2.60 MO 7079 124 7053 3,16 674 705 2 8.00 1401 13.203 4173 2:40 1.250 1.250 10.463 112 Operating Profit 12 581 994 1377 1,199 1 1,753 1993 2,045 2.200 3.0 10% Bline par Menu Cash Balance Sales Das Sales and dong Duis Potop 3044 02 30 592 * 10 52 12.95 31.08 1914 ons 191 1274 310 10 1923 12.3 31 sons 19 12% 310 23 30 592 12.7 110 392 12 31.08 12.5 31 310 530 Cappenditure 1.420 952 2 192 154 3 134 491 Net Weil NW 135 200 212 272 TAR 293 116 sh 400 1112 1812 1.99 lony 1. 1.35 2.00) 2,141 500 19 433 461 AP SI 699 NWC 393 6:40 2 747 171 41 in NC 1114 14 1511 1.650 1.10 1920 109 439 20 10) 230 122 10 154 je 33 24 Secoario 1: No Continuation Value: Assuming the project will be terminated. There will be ne savage value and networking capital will be recovered in 2021 412 7,34 7 TO