AutoSave O Off) Bounty Case Study - Hand Out 2022 (1) v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Design Layout References Mailings Review View Help Comments Share Procter & Gamble Bounty Case Study Adapted for UKZN, 2022 Material Presented is for Educational Purposes Only Question 3: Do you recommend the launch of Bounty Basic in Germany over a 5-year project horizon? Your project analysis should include: A. A Financial evaluation: a. Determine the optimum promotional strategy under each of the two plans provided and include the information from your chosen strategies in your financial evaluation. b. Calculate the accounting profit before tax for each of the 5 Years. Evaluate the launch using the Home Currency approach. Clearly set out how you calculated the appropriate exchange rates and WACC used in your analysis. B. Sensitivity analysis: P&G is concerned that the COGS is underestimated and would like you to perform a sensitivity analysis should the actual COGS be 60% of revenue received by P&G Please perform the sensitivity analysis and interpret your findings in an email to the project team. Your email must form part of your project content and should include a high-level summary as to the: a. impact on your promotional strategy b. impact on the NPV of the project . strategies that P&G could use to mitigate the risk of uncertainty exposed through your sensitivity analysis C. Qualitative analysis a. Would you deem a 5-year time line to be appropriate for this project? b. Provide and describe the relevance of six long term (3-5 years from the time of the investment) risk factors that you think could impact the longevity of this project: i. 2 country risk factors ii. 2 company risk factors ii. 2 factors which could impact the success of this product vs competing products Page 5 of 8 2608 words English (United States) 1% Accessibility: Investigate Focus . + 100% O 15:20 Type here to search 7z 9 X W 23.C Cloudy A $ GENG 55 2022/11/1.AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Table Design Comments Share LO Calibri v 11 AA ab Wrap Text General Ex AY O Paste BIU~ E Merge & Center Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting * Table Styles Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis C31 X V fic sales rev B C D E F G H J K L M N O P Q R S T U V W 25 -2600000 881078 942689 914034 914667 1015311 26 27 28 le 29 30 31 sales rev 2023 2024 2025 2026 2027 32 sales rev 1896654 2041620 1974199 1975686 1977203 33 34 % CHANGE COGS 50% VS COGS 60% (TOTAL SUM) NPV COG5 50 . COG5 60 -189% OCF 5919217 493268 4667779 -41% NPAT 3829223 2432681 -419% PBIT 2067779 1446144,902 R 930 624,84 1229225 R 332 906,71 TOTAL COST 2046 47 6096 -409 -209% 2096 409% 48 TOTAL COST PBIT NPAT DCF NPV 49 50 vol calc and pricing WACC yr 1 promo year 2 promo NPV BASE sensitivey analysis ... Ready 1x Accessibility: Investigate Average: 1973072,451 Count: 12 Sum: 9865362,255 + 80% 6:09 H Type here to search O 7z O W 16*C Mostly sunny A & GENG 2022/11/15Search (Alt+Q) X AutoSave O Off) DATA FOR BOUNTY v thembekacele111@gmail.com T File Home Insert Page Layout Formulas Data Review View Help Table Design Comments Share LO Calibri v 11 AA ab Wrap Text General Ex AYO .00 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Paste BIU~ E Merge & Center Formatting Table Styles Filter * Select v Data Alignment Number Styles Cells Editing Analysis Clipboard Font B1 X V Column1 E F G H I J K L M N O P Q R S B C D Column1 volume uplifts sales rev cogs 60% pat npv npv COGS 60% W N - 10000 37235 106864 64119 32059 17805,28 -20000 86882 249351 149611 74805 44603,72 400000,00 -30000 153078 439334 263600 131800 83392,79 350000,00 -40000 235824 676815 406089 203044 134173,23 577073 288537 196943,58 300000,00 -50000 335118 961789 -60000 455098 1306131 783679 391839 274702,04 250000,00 -70000 537843 1543609 926166 463083 325481,75 200000,00 -80000 570941 1638601 983160 491580 340289,55 150000,00 10 -90000 612314 1757341 1054405 527202 361093,03 11 100000 637137 1828583 1097150 548575 369905,15 100000,00 12 -110000 661961 1899828 1139897 569948 378718,00 50000,00 13 14 WACC 0,0901 0.00 2 3 4 5 6 7 8 9 10 11 15 16 17 18 19 Cost no of rolls Cons reached con re no purchasing units purch sales rev cogs 60% NPAT NPV 20 2500 500 0,35 1750 350 4200 12054 7232 3616 3317 31 10no0 2500 700 ann 7227 yr 1 promo year 2 promo NPV BASE sensitivey analysis sensitivity analysis Q1.Q2 NPV + ... + Ready Ex Accessibility: Investigate Average: 451003,157 Count: 72 Sum: 29766208,36 + 100% 06:10 Type here to search O 7z W 16*C Mostly sunny A $ GENG 2022/11/15AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X Formulas Data Review View Help Table Design Comments Share File Home Insert Page Layout LO Calibri v 11 AA ab Wrap Text General Ex AYO .00 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Paste BIU~ E Merge & Center Formatting Table Styles Filter * Select v Data Cells Editing Analysis Clipboard Font Alignment Number Styles B1 X V Column1 B C D E F G H I J K L M N O P Q R S Column1 volume uplifts sales rev cogs 60% pat npv npv COGS 60% W N - 10000 37235 106864 64119 32059 17805,28 -20000 86882 249351 149611 74805 44603,72 400000,00 -30000 153078 439334 263600 131800 83392,79 350000,00 -40000 235824 676815 406089 203044 134173,23 -50000 335118 961789 577073 288537 196943,58 300000,00 -60000 455098 1306131 783679 391839 274702,04 250000,00 -70000 537843 1543609 926166 463083 325481,75 200000,00 -80000 570941 1638601 983160 491580 340289,55 527202 150000,00 10 -90000 612314 1757341 1054405 361093,03 11 100000 637137 1828583 1097150 548575 369905,15 100000,00 12 -110000 661961 1899828 1139897 569948 378718,00 50000,00 13 14 WACC 0,0901 0.00 2 3 4 5 6 7 8 9 10 11 15 16 17 18 19 Cost no of rolls Cons reached con re no purchasing units purch sales rev cogs 60% NPAT NPV 20 2500 500 0,35 1750 350 4200 12054 7232 3616 3317 31 10no0 2500 700 ann 7227 yr 1 promo year 2 promo NPV BASE sensitivey analysis sensitivity analysis Q1.Q2 NPV + ... + + 100% Ready Ex Accessibility: Investigate Average: 451003,157 Count: 72 Sum: 29766208,36 06:10 Type here to search O 7z W 16*C Mostly sunny A $ GENG 2022/11/15X Search (Alt+Q) thembekacele111@gmail.com T AutoSave O Off) DATA FOR BOUNTY v Comments Share Table Design File Home Insert Page Layout Formulas Data Review View Help General Ex AYO ab Wrap Text LO Calibri v 11 AA Cell Insert Delete Format Sort & Find & Analyze Paste BIU~ E Merge & Center [ ~ % " Conditional Format as Formatting * Table Styles v Filter * Select v Data Styles Editing Analysis Number Cells Clipboard Font Alignment B1 X V Column1 K M N P Q R S T U V W X B C D E F G H L 18 19 no of rolls Cons reached con re no purchasing units purch sales rev cogs 60% NPAT NPV 5000 0,35 1750 350 4200 12054 7232 3616 3317 20 2500 21 5000 10000 0,35 3500 700 3400 24108 14465 7232 6635 22 7500 15000 0,35 5250 1050 12600 36162 21697 10849 9952 13269 23 10000 20000 0,35 7000 1400 16800 48216 28930 14465 15639 24 12500 25000 0,33 8250 1650 19800 56826 34096 17048 17629 25 15000 30000 0,31 9300 1860 22320 64058,4 38435 19218 26 3500 1960 67502,4 4050 20251 18577 17500 0,28 9800 23520 1328 20664 18956 27 20000 40000 0,25 10000 2000 24000 68880 28 22500 45000 0,22 9900 1980 23760 68191,2 40915 20457 18766 29 25000 50000 0,19 9500 1900 22800 65436 39262 19631 18008 30 27500 5500 0,16 8800 1760 21120 60614,4 36369 18184 16681 31 30000 60000 0,13 7800 1560 18720 53726,4 32236 16118 14786 12321 32 5000 0,1 6500 1300 15600 44772 26863 13432 32500 33 70000 0,07 4900 980 11760 33751,2 20251 10125 9288 35000 34 75000 600 12398 37500 0,04 3000 7200 20664 6199 5687 35 40000 0,01 800 160 1920 5510,4 3306 1653 1516 -0,02 -3223 36 35000 -1700 -340 7026 -3513 42500 -4080 -11709,6 -9299 -8530 45000 9000 -0,05 -4500 -900 -10800 -30996 18598 38 47500 9500 -0,08 -7600 -1520 -18240 -52348,8 -31409 -15705 -14407 39 -0,11 -11000 -2200 -75768 -45461 -22730 -20852 50000 100000 -26400 40 52500 105000 -0,14 -14700 -2940 -35280 -101254 -60752 -30376 27865 41 110000 -0,17 -18700 -3740 -44880 -128806 77283 -38642 35448 55000 43599 42 57500 115000 -0,2 -23000 -4600 -55200 158424 95054 -47527 43 120000 0,23 -27600 5520 -66240 -190109 -114065 -57033 -52319 60000 yr 1 promo year 2 promo NPV BASE sensitivey analysis sensitivity analysis Q1.Q2 NPV P ... + Average: 451003,157 Count: 72 Sum: 29766208,36 + 80% Ready 1Xx Accessibility: Investigate 06:10 Type here to search O 7z O W 16*C Mostly sunny A BENG 2022/11/15AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Comments Share LO Calibri v 11 YA* A ab Wrap Text General Ex AY O Paste BIU~ E Merge & Center [ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting " Table Styles Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis H38 X V fc A C D E F G H J K L M N O P 14 15 16 NPV COGS 50% 2022 2023 2024 2025 2026 2027 17 sales E 1 896 653,85 E 2 041 620,42 E 1 974 198,67 E 1 975 686,08 E 1 977 203,24 18 cost E 948 326,93 E 1 020 810,21 E 987 099,33 E 987 843,04 E 988 601,62 19 (DEP) E 500 000,00 $ 500 000,00 E 500 000,00 E 500 000,00 E 500 000,00 20 PBIT E 448 326,93 E 520 810,21 E 487 099,33 E 487 843,04 E 488 601, 62 21 TAX(15%) E 67 249,04 E 78 121,53 E 73 064,90 E 73 176,46 E 73 290,24 22 PAT E 381 077,89 E 442 688,68 E 414 034,43 E 414 666,58 E 415 311,38 23 DEP E 500 000,00 E 500 000,00 E 500 000,00 $ 500 000,00 E 500 000,00 24 WC -E 100 000,00 E 100 000,00 25 10 E 2 500 000,00 26 OCF -E 2 600 000 E 881 078 E 942 689 E 914 034 E 914 667 E 1 015 311 27 OCF 30D R R -45 809 400,00 R 15 908 107,94 R 17 442 003,01 R 17 330 549,88 R 17 771 971,72 R 20 215 966,35 28 OCF 90D R R -44 894 200,00 R 15 617 369,86 R 17 123 185,69 R 17 013 836,94 R 17 447 173,61 R 19 846 494,54, 29 30 NPV VALUE 31 NPV FOREIGN E 930 624,84 32 NPV HOME 30D R 16 000 463,00 33 NPV HOME 90D R 15 777 828,15 34 NPV BASE sensitivey analysis sensitivity analysis Q1.Q2 NPV HOME CURRENCY project life ... + : Ready Accessibility: Investigate + 100% 06:10 Type here to search O 22 W X C 16*C Mostly sunny ~ $ENG 2022/11/15AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Comments Share LO Calibri v 11 YA* A ab Wrap Text General Ex AYO Paste BIU~ E Merge & Center [ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting " Table Styles v Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis L19 X V A B C D E F G H J K M N P Q R S T U W X Y Z AA 1 NPV COGS 5 2022 2023 2024 2025 2026 2027 NPV COGS 5 2022 2023 2024 2025 NPV COGS 51 2022 2023 2024 2025 2026 2027 2028 2029 2 sales 2E+06 2E+06 2E+06 26+06 ZE+0E sales 2E+06 2E+06 2E+06 sales 2E+06 2E+06 2E+06 2E+06 2E+06 2E+06 ZE +DE cost 948327 1E+06 987099 987843 988602 cost 948327 IE+06 987099 cost 948327 1E+06 987099 987843 988602 18+06 18+06 4 (DEP) 500000 500000 500000 500000 500000 (DEP) 500000 500000 500000 [DEP) 500000 500000 500000 500000 500000 500000 500000 PBIT 448327 520810 487099 487843 488602 PBIT 448327 520810 487099 PBIT 448327 520810 487099 487843 488602 508374 528541 6 TAX(15%) 67249 78122 73065 73176 73290 TAX(15%) 67249 78122 73065 TAX(15%) 67249 78122 73065 73176 73290 76256 79281 7 PAT 381078 442689 414034 414667 415311 PAT 381078 442689 414034 PAT 381078 442689 414034 414667 415311 432118 449260 8 DEF 500000 500000 500000 500000 500000 DEF 500000 500000 500000 DEP 500000 500000 500000 500000 500000 500000 500000 9 -18+05 100000 WC -18+05 100000 WC -18+05 100000 10 10 3E+06 10 -3E+06 10 -3E+06 11 OCF -3E+06 881078 942689 914034 914667 18+06 OCF -3E+06 881078 942689 18+06 OCF -3E+06 881078 942689 914034 914667 915311 932118 18+06 12 R 1306 805,69 14 930624,8382 R-197 820,40 9,01% WACC 17 18 19 20 21 22 23 24 25 26 27 28 29 30 . . . sensitivey analysis sensitivity analysis Q1.Q2 NPV HOME CURRENCY project life span + D Ready 1% Accessibility: Investigate + 70% 06:11 Type here to search O 72 W X C 16*C Mostly sunny ~ $ENG 2022/11/15AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Comments Share X LO Calibri 11 YA* A ab Wrap Text General Ex AYO Paste BIU~ E Merge & Center ~ [ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting " Table Styles v Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis G17 X V A B C D E F G H I J K M N O P Q R S T 1 volume (new entrant) 202 2024 2025 2026 2027 2 units 25354 25405 25913 26431 26960 midtier vol = 25000 in 2021 3 Uplifts yr 1strat 661961 661961 661961 661961 661961 expected to grow by 5.5% in 2022 =25000(1.055)=2637.5/2638 4 uplifts yr 2 24000 expcted to grow by 0.001in 2023 5 cannablisim -26460 0 0 0 =2638*1.001=2640.6/2641 6 total 660855 711366 687874 688392 688921 convert to units 7 sales rev 1896654 2041620 1974199 1975686 1977203 =2641*24=63384 units price in EU MKTS Cost to tl Retailer VAT Shelf Pri 10 ( ex VAT) new entrant vol = 40% midtier 11 Austria 4,25 0,2 0,1 5,61 2023=63384*.04 12 Sweden 4,68 0,19 0,12 6,24 =25353.6/25354 units 13 France 4,91 0,2 0,055 6,22 will grow by 0.02 (2%)in 2024 14 Switzerland 4,5 0,2 0,175 6,35 =25354*1.002=25404.7/25405 unit 15 Germany 4,35 0,2 0,19 6,2 we assumed it will continue to grow 16 german price E 2,87 by 0.02 over remaining life span of 17 project 18 19 20 21 vol calc and pricing WACC yr 1 promo year 2 promo NPV BASE sensitivey analysis ...+ : 0 Ready Accessibility: Investigate + 100% 6:08 H Type here to search O W X Humid A &ENG 2022/11/15AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Table Design Comments Share X LO Calibri v 11 AA ab Wrap Text General Ex AY O Paste BIU~ E Merge & Center Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting * Table Styles Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis A28 X V fix WACC A B C D E F G H J K L M N O P Q F - 1 COST OF EQUITY VALUE 2 CAPM=Rf+B*(Rm-Rf) 3 Rf 1,58% 4 B 0,34 5 Rm 29,46% https://finance.yahoo.com/quote/PG/key-statistics?p=PG 6 ERP 27,88% https://www.upmyinterest.comasdaq100/ 11,06% 9 COST OF DEBT VALUE P&G FINANCIAL STATEMENTS 10 11 long term debt 2022 $ 31 493 000,00 12 long term debt 2021 $ 31 988 000,00 13 average debt $ 31 740 500,00 14 int paid 2022 439 000,00 15 int cost (RD) 1,38% 16 17 Income before tax 2027 17955000 18 tax expense 2022 3202000 19 tax rate 17,83% 20 21 vol calc and pricing WACC yr 1 promo year 2 promo NPV BASE sensitivey analysis ... + Ready 1x Accessibility: Investigate Average: 0,090138849 Count: 4 Sum: 0,090138849 + 100% 6:08 Type here to search O 7z O W Humid 2022/11/15AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Table Design Comments Share LO Calibri v 11 AA ab Wrap Text General Ex AYO Paste BIU~ E Merge & Center Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting * Table Styles Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis A28 X V WACC A B C D E F G H J K L M N O P Q R S Co LO COST OF DEBT VALUE P&G FINANCIAL STATEMENTS 10 11 long term debt 2022 12 long term debt 2021 13 average debt 14 int paid 2022 $ 439 000,00 15 int cost (RD) 1,38% 16 17 Income before tax 2022 17955000 18 tax expense 2022 3202000 19 tax rate 17,83% 20 21 22 Share price (ave 1yr ) 148,1830769 23 shares outstanding 239000 24 market cap 3288600000 https://finance.yahoo.com/quote/PG/key-statistics?p=PG 25 weight of equity 99,05% https://finance.yahoo.com/quote/PG/key-statistics?p=PG 26 weight of debt 0,95% 27 28 WACO VALUE 29 wacc 9,01% 30 vol calc and pricing WACC yr 1 promo year 2 promo NPV BASE sensitivey analysis ... (+ Ready x Accessibility: Investigate Average: 0,090138849 Count: 4 Sum: 0,090138849 + 90% Type here to search O 6:09 7z O W Humid 2022/11/15AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Comments Share LO Calibri v 11 YA* A ab Wrap Text General Ex AYO Paste BIU~ E Merge & Center ~ [ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting Table Styles Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis 115 X V A B C D E F G H 1 J K L M N O P Q R 1 Print Media Cost Volume Uplift (units) Sales revenue COGS NPAT NPV 10000 37235 106864,45 53432,23 45417,39 29046,43 W N -20000 86882 249351,34 124675,7 105974,3 70833,16 -30000 153078 439333,86 219666,9 186716,9 129606,6 40000 235824 676814,88 338407,4 287646,3 205367,9 -50000 335118 961788,66 480894,3 408760,2 298114,8 60000 455098 1306131,26 653065,6 555105,8 412094,9 -70000 537843 1543609,41 771804,7 656034 487855,1 -80000 570941 1638600,67 819300,3 696405,3 512655,1 10 -90000 612314 1757341,18 878670,6 746870 545949 11 -100000 637137 1828583,19 914291,6 777147,9 562255,1 12 -110000 661961 1899828,07 949914 807426,9 578562,2 13 14 15 16 17 18 19 20 21 vol calc and pricing WACC yr 1 promo year 2 promo NPV BASE sensitivey analysis ...+ 0 Ready Accessibility: Investigate + 100% 6:0 H Type here to search O O W X Humid A &ENG 2022/11/15X thembekacele111@gmail.com T Search (Alt+Q) AutoSave O Off) DATA FOR BOUNTY v Comments Share Formulas Data Review View Help Table Design File Home Insert Page Layout Ex AYO 11 ab Wrap Text General Calibri A Sort & Find & Analyze LO Conditional Format as Cell Insert Delete Format Filter * Select v Data Paste BIU~ E Merge & Center Formatting * Table Styles Cells Editing Analysis Alignment Number Styles Clipboard Font A1 X V Cost N P Q R S T U V W X E F G H K L M A B C D NPV units purch Cost no of rolls con re no purchasing sales rev cogs 50% NPAT Cons reached 7232 4520 4147 2500 5000 0,35 1750 350 4200 12054 8293 0000 0,35 3500 700 8400 24108 14465 9041 5000 0,35 5250 1050 12600 36162 21697 13561 12440 UT A W N 7500 15000 1680 48216 28930 18081 16587 20000 0,35 7000 1400 10000 34096 21310 19548 12500 25000 0,33 8250 1650 19800 56826 22320 64058 38435 24022 22036 15000 30000 0,31 9300 1860 3500 0,28 9800 1960 23520 57502 40501 25313 23221 1750 4000 58880 41328 5830 23695 2000 20000 40000 D.25 10OO 40915 25572 23458 22500 45000 0,22 9900 1980 23760 68191 1900 22800 65436 39262 24539 22510 25000 5000 0,19 9500 21120 60614 36369 22730 20852 12 27500 55000 0, 16 8800 1760 53726 32236 20147 18482 30000 0,13 7800 1560 18720 26863 16790 15402 32500 35000 0, 1 6500 1300 1560 44772 33751 20251 12657 11611 35000 0,07 4900 980 11760 Sa LAW 7109 37500 75000 0,04 3000 600 7200 20664 12398 7749 800 160 1920 5510 3306 2066 1896 40000 80000 0,01 -4080 -11710 -7026 -4391 -4028 42500 35000 -0,02 -1700 -340 45000 -4500 -10800 -30996 -18598 -11624 -10663 -0,05 -900 -19631 -18008 20 47500 95000 -0,08 -7600 -1520 -18240 -52349 -31409 -26400 -75768 -45461 -28413 -26065 50000 100000 -0,11 -11000 -2200 37970 -34832 52500 105000 -0,14 -14700 -2940 35280 -101254 -60752 22 -3740 44880 -128806 77283 -48302 -44310 55000 110000 -0,17 -18700 57500 115000 -0,2 -23000 -4600 -55200 -158424 95054 -59409 -54499 24 -5520 66240 -190109 -114065 -71291 -65398 25 60000 120000 -0,23 -27600 D 26 year 2 promo NPV BASE sensitivey analysis ... + vol calc and pricing WACC yr 1 promo + 80% Average: 9150,732895 Count: 250 Sum: 2196175,895 6:09 Ready Ex Accessibility: Investigate 16*C Mostly sunny A $ ENG W 2022/11/15 Type here to search O 7zthembekacele111@gmail.com X Search (Alt+Q) T AutoSave O Off) DATA FOR BOUNTY v Help Table Design Comments Share File Home Insert Page Layout Formulas Data Review View Ex AY O LO Calibri v 11 AA ab Wrap Text General Cell Insert Delete Format Sort & Find & Analyze Paste BIU~ E Merge & Center [ ~ % " Conditional Format as Formatting * Table Styles Filter * Select v Data Number Styles Cells Editing Analysis Clipboard Font Alignment C31 X V sales rev W B C D E F G H I J K L M N O P Q R S T U V 1 2022 2023 2024 2025 2026 2027 9% 1896654 2041620 1974199 1975686 1977203 wacc NPAT DCF NPV 1137992 1224972 1184519 1185412 1186322 SENSITVITI TOTAL COST PBIT UI A W N 500000 500000 500000 500000 500000 COGS 50 4932681 2432681 2067779 4667779 R 930 624,84 258662 316648 289679 290274 290881 COGS 60 5919217 1446145 1229223 3829223 R 332 906,71 38799 47497 43452 43541 43632 247249 PBIT 246733 % CHANGE TOTAL COST NPAT DCF NPV 219862 269151 246228 64% 500000 500000 500000 500000 % CHANGE -41% 18% 500000 20% 41% LD CO -100000 100000 10 2500000 11 2600000 719862 769151 746228 746733 847249 12 COGS 50% 2023 2024 2025 2026 2027 13 R 332 906,71 COST 948327 1020810 987099 987843 988602 14 PBIT 448327 520810 487099 487843 488602 15 2022 2023 2024 2025 2026 2027 NPAT 381078 442689 414034 414667 415311 16 1896654 2041620 1974199 1975686 1977203 OCF 881078 942689 914034 914667 1015311 17 948327 1020810 987099 987843 988602 COGS 60% 2023 2024 2025 2026 2027 18 500000 500000 500000 500000 500000 1137992 1224972 1184519 1185412 1186322 19 448327 520810 487099 487843 488602 COST PBIT 258662 316648 289679 290274 290881 20 67249 8122 73065 73176 73290 269151 246228 246733 247249 21 381078 442689 414034 414667 415311 NPAT 219862 719862 769151 746228 746733 847249 500000 500000 500000 OCF 22 500000 500000 23 -100000 100000 24 2500000 25 2600000 881078 942689 914034 914667 1015311 26 vol calc and pricing WACC yr 1 promo year 2 promo NPV BASE sensitivey analysis ... Average: 1973072,451 Count: 12 Sum: 9865362,255 + 80% Ready Ex Accessibility: Investigate 6:09 A & GENG Type here to search O 7z W 16C Mostly sunny 2022/11/15AutoSave O Off) DATA FOR BOUNTY v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Comments Share X LO Calibri 11 YA* A ab Wrap Text General Ex AYO Paste BIU~ E Merge & Center ~ [ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting " Table Styles v Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis G17 X V A B C D E F G H I J K M N O P Q R S T 1 volume (new entrant) 202 2024 2025 2026 2027 2 units 25354 25405 25913 26431 26960 midtier vol = 25000 in 2021 3 Uplifts yr 1strat 661961 661961 661961 661961 661961 expected to grow by 5.5% in 2022 =25000(1.055)=2637.5/2638 4 uplifts yr 2 24000 expcted to grow by 0.001in 2023 5 cannablisim -26460 0 0 0 =2638*1.001=2640.6/2641 6 total 660855 711366 687874 688392 688921 convert to units 7 sales rev 1896654 2041620 1974199 1975686 1977203 =2641*24=63384 units price in EU MKTS Cost to tl Retailer VAT Shelf Pri 10 ( ex VAT) new entrant vol = 40% midtier 11 Austria 4,25 0,2 0,1 5,61 2023=63384*.04 12 Sweden 4,68 0,19 0,12 6,24 =25353.6/25354 units 13 France 4,91 0,2 0,055 6,22 will grow by 0.02 (2%)in 2024 14 Switzerland 4,5 0,2 0,175 6,35 =25354*1.002=25404.7/25405 unit 15 Germany 4,35 0,2 0,19 6,2 we assumed it will continue to grow 16 german price E 2,87 by 0.02 over remaining life span of 17 project 18 19 20 21 vol calc and pricing WACC yr 1 promo year 2 promo NPV BASE sensitivey analysis ...+ : 0 Ready Accessibility: Investigate + 100% 6:08 H Type here to search O W X Humid A &ENG 2022/11/15