T bounty data updated - Protected View v Search (Alt+Q) thembekacele111@gmail.com X AutoSave O Off) Comments Share File Home Insert Page Layout Formulas Data Review View Help X PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing N10 X V fx F G H K L M N O P Q R S T A B C D E Cost no of rolls Cons reached cons reache purchasing co units purch sales rev COGS 50 NPAT NPV 5000 0,35 .750 350 20 12054 7232 $520 4147 2500 0,35 3500 700 24108 9041 293 5000 10000 8400 14465 15000 0,35 5250 1050 12600 36162 21697 13561 12440 7500 10000 20000 0,35 7000 1400 16800 48216 28930 18081 16587 0,33 8250 1650 19800 56826 34096 21310 19548 12500 25000 15000 30000 0,31 9300 1860 22320 64058 38435 24022 22036 35000 0,28 1960 67502 25313 23221 17500 9800 23520 10501 LD CO - 20000 40000 0,25 10000 2000 24000 58880 41328 25830 23695 0,22 9900 1980 23760 68191 10915 25572 23458 10 22500 45000 11 25000 50000 0,19 9500 1900 22800 65436 39262 24539 22510 20852 12 27500 55000 0,16 8800 1760 21120 50614 36369 22730 13 30000 60000 0,13 7800 1560 18720 53726 32236 20147 18482 32500 65000 0,1 6500 1300 15600 44772 26863 16790 15402 14 15 35000 70000 0,07 4900 980 11760 33751 20251 12657 11611 7200 20664 12398 7749 16 37500 75000 0,04 3000 600 7109 17 40000 80000 0,01 800 160 1920 5510 3306 2066 1896 -7026 -4391 4028 18 42500 85000 -0,02 -1700 340 -4080 11710 19 45000 90000 -0,05 -4500 -900 10800 -30996 -18598 -11624 10663 20 47500 95000 0,08 -7600 -1520 18240 -52349 31409 -19631 -18008 21 50000 100000 -0,11 -11000 -2200 -26400 -75768 -45461 -28413 -26065 22 52500 105000 -0,14 -14700 -2940 35280 -101254 -60752 -37970 -34832 23 55000 110000 -0,17 -18700 -3740 -44880 -128806 -77283 -48302 -44310 115000 0,2 -23000 4600 -55200 -158424 -95054 .59409 54499 24 57500 25 60000 120000 0,23 -27600 -5520 -66240 -190109 -114065 -71291 -65398 26 27 VOL CALC and NPV YR 1PROMO YR 2 PROMO sensitivity npv sensitivity yr 1 promo SE ... (+ + 90% Ready 15:11 O 7z O 24C Cloudy A & ENG Type here to search 2022/11/14X AutoSave O Off) bounty data updated - Protected View v Search (Alt+Q) thembekacele111@gmail.com T File Formulas Review Help Share Home Insert Data View Comments Page Layout X 1 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing J22 X V fx G K L M N O P O R S T U 4 A B C D E F H J 2027 NPV COGS 60% 2022 2023 2024 2025 2026 2027 1 NPV COGS 50% 2022 2023 2024 2025 2026 1540435 1685402 1617980 1619467 1620985 sales 1540435 1685402 1617980 1619467 1620985 2 sales 808990 809734 810492 924261 1011241 970788 971680 972591 3 cost 770218 842701 cost 500000 (DEP) 500000 500000 500000 500000 500000 4 (DEP 500000 500000 500000 500000 5 PBIT 270218 342701 308990 309734 310492 PBIT 116174 174161 147192 147787 148394 40532,6 51405,1 46348,5 46460,1 1 46573,8 TAX(15%) 17426,1 26124,1 22078,8 22168 22259,1 6 TAX (15% 7 PAT 229685: 291296 262642 263274 263918 PAT 98748 148037 125113 125619 126135 500000 500000 500000 500000 500000 DEP 500000 500000 500000 500000 500000 8 DEP WC -100000 100000 9 WC 100000 100000 10 10 2500000 10 -2500000 11 OCF -2600000 729685 791296 762642 763274 863918 OCF -2600000 598748 648037 625113 625619 726135 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 VOL CALC and NPV YR 1PROMO YR 2 PROMO sensitivity npv sensitivity yr 1 promo SE ... + : 0 + 90% Ready 15:11 Type here to search O 7z O 24C Cloudy A B ENG 2022/11/14bounty data updated - Protected View v Search (Alt+Q) thembekacele111@gmail.com T X AutoSave O Off) Comments Share File Home Insert Page Layout Formulas Data Review View Help Enable Editing X PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. N14 X V fx B C D E F G H K L M N O P Q R S T U A con re no purchasing units purch sales rev NPAT NPV no of rolls cogs 60% Cost Cons reached 2500 5000 0,35 1750 350 20 12054 7232,4 3616,2 3317,31 5000 10000 0,35 3500 700 8400 24108 14464,8 7232,4 6634,62 7500 15000 0,35 5250 1050 12600 36162 21697,2 10848,6 9951,93 10000 20000 0,35 7000 1400 16800 48216 28929,6 14464,8 13269,2 12500 25000 0,33 8250 1650 19800 56826 34095,6 17047,8 15638,7 15000 30000 0,31 9300 1860 22320 64058,4 38435,04 19217,5 17629,1 17500 35000 0,28 9800 1960 23520 67502,4 40501,44 20250,7 18576,9 20000 40000 0,25 10000 2000 24000 68880 41328 20664 18956,1 10 22500 45000 0,22 3900 1980 23760 68191,2 40914,72 20457,4 18766,5 11 25000 50000 0,19 9500 1900 22800 65436 39261,6 19630,8 18008,3 12 27500 55000 0,16 8800 1760 21120 60614,4 36368,64 18184,3 16681,3 13 30000 60000 0,13 7800 1560 18720 53726,4 32235,84 16117,9 14785,7 14 32500 65000 0,1 6500 1300 15600 44772 26863,2 13431,6 12321,4 15 35000 70000 0,07 4900 980 11760 33751,2 20250,72 10125,4 9288,47 16 37500 75000 0,04 3000 600 7200 20664 12398,4 6199,2 5686,82 17 40000 80000 0,01 800 160 1920 5510,4 3306,24 1653,12 1516,48 18 42500 85000 -0,02 -1700 340 -4080 -11709,6 -7025,76 -3512,88 -3222,53 19 45000 90000 -0,05 -4500 -900 10800 -30996 -18597,6 -9298,8 -8530,23 20 47500 95000 0,08 -7600 -1520 -18240 -52348,8 -31409,28 -15704,6 -14406,6 21 50000 100000 -0,11 -11000 -2200 -26400 -75768 -45460,8 -22730,4 -20851,7 22 52500 105000 -0,14 -14700 -2940 35280 -101254 -60752,16 -30376,1 -27865,4 23 55000 110000 -0,17 -18700 -3740 -44880 -128806 -77283,36 -38641,7 -35447,8 24 57500 115000 0,2 -23000 -4600 55200 -158424 -95054,4 -47527,2 -43598,9 25 60000 120000 0,23 -27600 -5520 -66240 -190109 -114065,3 -57032,6 -52318,7 26 27 YR 2 PROMO sensitivity nov sensitivity yr 2 promo ... (+) ... YR 1PROMO sensitivity yr 1 promo + 90% Ready 15:11 A $ GENG E3 Type here to search O 7z 24C Cloudy 2022/11/14AutoSave O Off) bounty data updated - Protected View v Search (Alt+Q) thembekacele111@gmail.com T X File Home Insert Page Layout Formulas Data Review View Help Comments Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X B34 X V fx A B C D E F G H J K L M N 0 P Q R S T U W X 1 RATES GER RSA 2 inflation rate 0,05 0,076 wacc 3,01% 11,71% httpsiltradingeconomics.com/south africa/inflation-cpitt:"text= South/.20Africa>.20Inflation/20Rate>.20Softens rangeZ.20ofZ 203%.25%.2016%.25. 4 kd 11,71% forex PPP 2023 2024 2025 2026 2027 30'((1+h1)/[1+h2)n't forex r 300 8,05528 18,5024 8,9605 19,43 9,911 forex r 900 17,7253 8.1642 8.614 19,0749 19.5472 10 1 RIEL 30days 30 days 12 average 17,619 17,267 13 https:www.ke.comourrenovconverter convert/?Amount= 18.From=EUBB.To=ZAB 14 15 16 NPV COGS - 2022 * 2023 - 2024 - 2025 - 2026 - 2027 ADJUST SALES AND NPV FOR THE YR1 PROMO 17 1540435,1 1685401,76 1617980,007 1619467.419 1620984.579 CHANGE.* * *# 18 cost 770217.595 842700,88 808990,0035 809733,7095 810492,2896 19 [DEP 500000 500000 500000 500000 500000 20 PBIT 270217.595 342700,88 308930,0035 309733,7095 310492,2896 21 TAX(15%) 40532,63925 51405,132 46348,50053 46460,05642 46573,84343 22 PAT 229684,9558 291295.748 262641,503 263273,653 263918,4461 23 DEP 500000 600000 500000 500000 500000 24 WC -100000 100000 25 10 2500000 26 OCF 2600000 729684,9558 791295,748 762641,503 763273.653 863918,4461 27 300 45809400 13174666,19 14640870,45 14460064,22 14830407,08 17201566,57 28 900 -44894200 12933884.75 14373254.23 14195808,94 14559368,6 16887186,65 29 30 NPV VALUE 31 NPV FOREIGN | 390570,77 32 NPV HOME 30D R6 715 173,87 33 NPV HOME 90D R 6 662 240,60 34 35 . .. sensitivity nov sensitivity yr 1 promo sensitivity yr 2 promo NPV HOME CURRENCY (2) + D Ready + 70% Type here to search O 15:12 Fi [7z O 24*C Cloudy A $ENG 2022/11/14 73AutoSave 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