Dividends, Payout Ratio and Stock Repurchases A: What was Campbell's dividend payout ratio and retention ratio for each of the last five years (2017-2021). B: What is the total cumulative common stock repurchases over the last five years (2017- 2021)? C: Assume that at the end of 2021 Campbell's stock was trading at $41.73, and it declares a 3- for-1 stock split. What is the projected new stock price and the projected new shares outstanding? TH B Income Statement C D For the Fiscal Period Ending Reclassified 12 months Jul-30-2017 USD Currency Reclassified 12 months Jul-29-2018 USD 12 months Jul-28-2019 USO 12 months Aug-02-2020 USD 12 months Aug-01-2025 USD leven Other Roven Total Revenue 5,8370 6,6150 8.1070 8,6970 8,4760 25 5.8370 6,615.0 8.107.0 8,691,0 8.476,0 Cost Of Goods Sold Gross Profit 3,3910 2,446.0 4,1540 2461.0 53000 2,711,0 5.683.0 3.008.0 50020 2,8140 Selling General & Admin Exp R&D EX Depreciation & Amor Other Operating Expenso income 1,0000 330 1,1770 010 1.383.0 0 1,5190 920 1.300 340 (2400) (211) 123.0 1050 C600 Other Operating Exp.. Total 943.0 1,057.0 1.500 1.7170 12040 Operating Income 1.503.0 1.404.0 1.117,0 1.291.0 1,810.0 (1150) interest Expense interest and invest Income Net Interest Exp 4 Income Statement (583.0) 30 (1800) (3560) 20 (354.0) (3450) 40 (3410) 260.00 10 (209.0) (1160) Balance Sheet Cash Flow A B D E G H (150) 10 12.01 (to Currency Exchange Gains (Loss 8 Other Non-Operating inc (EX) 9 EBT Excl. Unusual Items 1.373.0 1225.0 763.0 9448.0 1.400.0 (480) (121.0) (600) C202.01 (1070) 19.03 (100) (10) 1 Retinacturing Chorges 2 Merger & Related Restruct Chargers 3 impart of Goodwill 4 Gan (Loss) On Sale Of Invest 5 Gan ) One Of Assets 6 Ace Window 7 Lol Soomets -8 Other Unusuales 59 EBT Inc. Unusual Items (490) (540) 11.09 (540) (220) 1160) 1.316.0 8300 6250 766.0 13360 3020 924.0 1000 724,0 1510 4740 1740 5920 1,0080 Income Tax Expense Eaminge from Cont. Op 3 54 Lam of Descond Ops Extraord Toms Account Chenon 56 Net Income to Company (370) (4630) (2630) 10360 160 8870 2010 2110 16260 $8 Monty Int in Earrings 59 Net Income 50 8870 2610 2010 16280 170020 Income Statement Balance Sheet Cash Flow Workbook Statistics Give Feed -30-2017 USO Plecassified Jul-20-2018 USO Al-28-2019 USD Aug-02-2020 USD Aug-01-2021 3100 3190 400 490 310 31.0 60.0 853.0 09 6270 1) Balance Sheet Balance sheet as of 14 15 Currency 16 ASSETS 17 Cash And Events 18 Total Cash & ST Investments 19 20 Accounts Rece 21 Recor 22 Total Receivable 22 24 story 25 Other Current Assets 26 Total Current Assets 27 Gross Property Plant Ecument 29 Aculated Depreciation 30 Net Property, Plant & Equipment 50 500 550 5050 5100 530 6630 250 400 5740 5300 150 3750 STO 5950 9020 740 18000 8870 7070 3030 4000 1907 710 800 230510 0330 90 1060 5,1240 000 135000 24540 52300 12.7730) 24600 52150 2.7800 24560 55300 201701 26220 2,6050 ARBARA 000 2.1150 1.1180 360 Long term westments Goodal Other intangibles 35 Deferred Tax ASSET Othe 4 Income Statement 920 58840 30640 20 770 40170 3150 3.000 3,3500 to 3290 13 Balance Sheet Cash Flow Workbook Statistics Type here to watch Give Feedback 13 3 B C D G 000 2.1150 1.1180 360 340 12200 3000 920 3.8840 3,6640 20 2.1450 TO 770 40170 4150 23500 32300 200 12170 13166.6. 2140 0660 10700 31 32 Long term investment 33 Cloodwill 34 other tongus 35 Deferred Tax Ass LT 36 Other Long Term Assets 37 Total Aston 38 39 LIABILITIES 40 Accounts Payable 41 Academ 42 Shoom Borrowings 43 Curr Port of Debt 44 Cunt Port of me 45 CUT Income Times Pablo 46 Omer Current Limba 47 Total Current Liabilities 48 49 Long-Term Deo 50 Long Term Leases 51 Poison & Other Post Autor Bonetits 52 Do Taxibaly. Non-Curr 50 Or Non-Current des 54 Total Liabiti 55 7050 4940 1.1350 300 4040 10360 220 10 200 1560 2.395.0 8140 5720 2500 5000 210 150 6130 3,38550 10090 0000 278.0 9210 700 240 100 3600 3750450 1300 370750 050 50 1240 18140 70910 2.4820 70 50 a 1900 1890 6.081.0 3470 5000 2640 13,156,0 7,1010 20 3800 940 2350 12.036.0 49900 1880 1020 9140 174.0 18030 5000 to 10 10510 1840 8.5800 Income Statement Balance Sheet Cash Flow C D F H 55 56 Common Stock 57 Additional Pardin Capital 58 Rotamed Eags 69 Troury Stock 50 Comprehensive in and other 57 Total Common Equity 120 3500 2.3850 (1.006) (530) 1,63770 120 3400 22240 (1.10309 (1180) 1,364.0 120 3720 1,0930 (1.0760) (1980) 1,103,0 120 1940 31000 1,093 ) (10.02 2,083.0 120 4140 120 1991 50 11520 30 90 60 20 1.6450 1,373.0 1.112.0 31540 7.7200 14 5290 13.148.0 123720 117440 3 Minority interest 54 55 Total Equity 6 7 Total Liabilities And Equity 3 9 Supplementations Total Shoes Out on Balance Sheet Date 1 2 Marko Price of Stock 3 -4 5 6 3010 3010 3010 5020 20 563.20 53045 $45.00 $52.01 8 Income Statement Real Cabo Low D H Rostated 12 months -30-2017 USO Rostated 12 months Jul-29-2018 USD Restatud 12 months -26-2019 USD Rastated 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD 8870 1920 10 193.0 2010 2500 200 27,0 211,0 3150 480 1.628.0 2850 450 10020 2750 00 3170 TO 320 100 170 For the Fiscal Period Ending 14 15 Currency 16 17 Net Income 18 Deprecation & Amort 19 Amort of Goodwill and intangibles 20 Depreciation & Amort. Total 21 22 anos From Sale Of Assets 23an Los On Sale Of west 24 Anse tedown Restructuring Costs 25 Stock Band Compematon 26 North From Descontinued us 27 Other Operating Active 28 Change in Ao Receivable 29 Chung in love ones 30 Change in Ace Patio 31 Change in the Net Operating Assets 32 Cash from Ops 33 34 Cact Expenditure Cash Acousins 4 Income Statement 180 000 1160 1320 10 470 500 3120 770 (110 300 (075) 400 90 010 210 040 OTO 9140 (3000) >> 500 (40 780 270 1/410,0 (2000) 200 100 1410) (270) 1.236.0 2040 (300) (2009 1450 1250 (010 (200) (170) (1640) (280) 1,0350 1.250.0 1000 1,300.0 (180 (40703 (6 7810 (3040) 14703 (2000) (11 01 2750) 12.01 Balance Sheet Cash Flow Workbook Statistics General D E 360 (070) 167810) 100 040) (470 310 2900 (110) 2,500 2730 02.00 500 (003 360) (190) (1970) 5530 1530 40 22720 10 (150) 58300 34 Capital Expenditure 35 Cash Aqinitions 36 Divers 27 est in Marble & Equity Securt 38 Not in Due in Loans Ongod sold 89 Otherwing Activities 40 Cash from Investing 41 42 Short Tom Deos 43 Long Term Debt Issund 44 Total Debt sued 45 Short Term Not Repad 46 Long Term Det 47 Total Debt Repaid 48 49 Issuance of Canon Stock 50 Repurchase of common stock 51 52 Common Dividends Paid 3 Total Dividends Paid 54 SS Social Dividend Paid 56 Other Financing Activities 57 Cash from Financing 32470 2110 8/4560 10.002.0 49000 (6,48270) 102220 6,2240 16,8460 394409 6.0 11000703 > 5.300 (0.206.09 (70201 (6.630) 56170 10000 678170 16.00 22580 (1770 15200 21.th 20 (1000) (30) 210 1120) (51 (4200) (42601 (426) 14.2001 (230 (423.0) (4200 4390 (4300 3.0 (9000) 1970) 5,8070 (10) (1.501.02 (120) 2,987.0) (1,009.0) Income Statement Balance Sheet Cash Flow 14 A D E Special Dividend Pad Other Financing Activities Cash from Financing Formgn Exchange Rate Ad Net Change in Cash 30 (908.09 (970) 5.8070 (10) (1,5010) (120) (270) (1.000 110 (290) 28.0) 120 (20) (1190 11.09 5800 20 000 Dividends, Payout Ratio and Stock Repurchases A: What was Campbell's dividend payout ratio and retention ratio for each of the last five years (2017-2021). B: What is the total cumulative common stock repurchases over the last five years (2017- 2021)? C: Assume that at the end of 2021 Campbell's stock was trading at $41.73, and it declares a 3- for-1 stock split. What is the projected new stock price and the projected new shares outstanding? TH B Income Statement C D For the Fiscal Period Ending Reclassified 12 months Jul-30-2017 USD Currency Reclassified 12 months Jul-29-2018 USD 12 months Jul-28-2019 USO 12 months Aug-02-2020 USD 12 months Aug-01-2025 USD leven Other Roven Total Revenue 5,8370 6,6150 8.1070 8,6970 8,4760 25 5.8370 6,615.0 8.107.0 8,691,0 8.476,0 Cost Of Goods Sold Gross Profit 3,3910 2,446.0 4,1540 2461.0 53000 2,711,0 5.683.0 3.008.0 50020 2,8140 Selling General & Admin Exp R&D EX Depreciation & Amor Other Operating Expenso income 1,0000 330 1,1770 010 1.383.0 0 1,5190 920 1.300 340 (2400) (211) 123.0 1050 C600 Other Operating Exp.. Total 943.0 1,057.0 1.500 1.7170 12040 Operating Income 1.503.0 1.404.0 1.117,0 1.291.0 1,810.0 (1150) interest Expense interest and invest Income Net Interest Exp 4 Income Statement (583.0) 30 (1800) (3560) 20 (354.0) (3450) 40 (3410) 260.00 10 (209.0) (1160) Balance Sheet Cash Flow A B D E G H (150) 10 12.01 (to Currency Exchange Gains (Loss 8 Other Non-Operating inc (EX) 9 EBT Excl. Unusual Items 1.373.0 1225.0 763.0 9448.0 1.400.0 (480) (121.0) (600) C202.01 (1070) 19.03 (100) (10) 1 Retinacturing Chorges 2 Merger & Related Restruct Chargers 3 impart of Goodwill 4 Gan (Loss) On Sale Of Invest 5 Gan ) One Of Assets 6 Ace Window 7 Lol Soomets -8 Other Unusuales 59 EBT Inc. Unusual Items (490) (540) 11.09 (540) (220) 1160) 1.316.0 8300 6250 766.0 13360 3020 924.0 1000 724,0 1510 4740 1740 5920 1,0080 Income Tax Expense Eaminge from Cont. Op 3 54 Lam of Descond Ops Extraord Toms Account Chenon 56 Net Income to Company (370) (4630) (2630) 10360 160 8870 2010 2110 16260 $8 Monty Int in Earrings 59 Net Income 50 8870 2610 2010 16280 170020 Income Statement Balance Sheet Cash Flow Workbook Statistics Give Feed -30-2017 USO Plecassified Jul-20-2018 USO Al-28-2019 USD Aug-02-2020 USD Aug-01-2021 3100 3190 400 490 310 31.0 60.0 853.0 09 6270 1) Balance Sheet Balance sheet as of 14 15 Currency 16 ASSETS 17 Cash And Events 18 Total Cash & ST Investments 19 20 Accounts Rece 21 Recor 22 Total Receivable 22 24 story 25 Other Current Assets 26 Total Current Assets 27 Gross Property Plant Ecument 29 Aculated Depreciation 30 Net Property, Plant & Equipment 50 500 550 5050 5100 530 6630 250 400 5740 5300 150 3750 STO 5950 9020 740 18000 8870 7070 3030 4000 1907 710 800 230510 0330 90 1060 5,1240 000 135000 24540 52300 12.7730) 24600 52150 2.7800 24560 55300 201701 26220 2,6050 ARBARA 000 2.1150 1.1180 360 Long term westments Goodal Other intangibles 35 Deferred Tax ASSET Othe 4 Income Statement 920 58840 30640 20 770 40170 3150 3.000 3,3500 to 3290 13 Balance Sheet Cash Flow Workbook Statistics Type here to watch Give Feedback 13 3 B C D G 000 2.1150 1.1180 360 340 12200 3000 920 3.8840 3,6640 20 2.1450 TO 770 40170 4150 23500 32300 200 12170 13166.6. 2140 0660 10700 31 32 Long term investment 33 Cloodwill 34 other tongus 35 Deferred Tax Ass LT 36 Other Long Term Assets 37 Total Aston 38 39 LIABILITIES 40 Accounts Payable 41 Academ 42 Shoom Borrowings 43 Curr Port of Debt 44 Cunt Port of me 45 CUT Income Times Pablo 46 Omer Current Limba 47 Total Current Liabilities 48 49 Long-Term Deo 50 Long Term Leases 51 Poison & Other Post Autor Bonetits 52 Do Taxibaly. Non-Curr 50 Or Non-Current des 54 Total Liabiti 55 7050 4940 1.1350 300 4040 10360 220 10 200 1560 2.395.0 8140 5720 2500 5000 210 150 6130 3,38550 10090 0000 278.0 9210 700 240 100 3600 3750450 1300 370750 050 50 1240 18140 70910 2.4820 70 50 a 1900 1890 6.081.0 3470 5000 2640 13,156,0 7,1010 20 3800 940 2350 12.036.0 49900 1880 1020 9140 174.0 18030 5000 to 10 10510 1840 8.5800 Income Statement Balance Sheet Cash Flow C D F H 55 56 Common Stock 57 Additional Pardin Capital 58 Rotamed Eags 69 Troury Stock 50 Comprehensive in and other 57 Total Common Equity 120 3500 2.3850 (1.006) (530) 1,63770 120 3400 22240 (1.10309 (1180) 1,364.0 120 3720 1,0930 (1.0760) (1980) 1,103,0 120 1940 31000 1,093 ) (10.02 2,083.0 120 4140 120 1991 50 11520 30 90 60 20 1.6450 1,373.0 1.112.0 31540 7.7200 14 5290 13.148.0 123720 117440 3 Minority interest 54 55 Total Equity 6 7 Total Liabilities And Equity 3 9 Supplementations Total Shoes Out on Balance Sheet Date 1 2 Marko Price of Stock 3 -4 5 6 3010 3010 3010 5020 20 563.20 53045 $45.00 $52.01 8 Income Statement Real Cabo Low D H Rostated 12 months -30-2017 USO Rostated 12 months Jul-29-2018 USD Restatud 12 months -26-2019 USD Rastated 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD 8870 1920 10 193.0 2010 2500 200 27,0 211,0 3150 480 1.628.0 2850 450 10020 2750 00 3170 TO 320 100 170 For the Fiscal Period Ending 14 15 Currency 16 17 Net Income 18 Deprecation & Amort 19 Amort of Goodwill and intangibles 20 Depreciation & Amort. Total 21 22 anos From Sale Of Assets 23an Los On Sale Of west 24 Anse tedown Restructuring Costs 25 Stock Band Compematon 26 North From Descontinued us 27 Other Operating Active 28 Change in Ao Receivable 29 Chung in love ones 30 Change in Ace Patio 31 Change in the Net Operating Assets 32 Cash from Ops 33 34 Cact Expenditure Cash Acousins 4 Income Statement 180 000 1160 1320 10 470 500 3120 770 (110 300 (075) 400 90 010 210 040 OTO 9140 (3000) >> 500 (40 780 270 1/410,0 (2000) 200 100 1410) (270) 1.236.0 2040 (300) (2009 1450 1250 (010 (200) (170) (1640) (280) 1,0350 1.250.0 1000 1,300.0 (180 (40703 (6 7810 (3040) 14703 (2000) (11 01 2750) 12.01 Balance Sheet Cash Flow Workbook Statistics General D E 360 (070) 167810) 100 040) (470 310 2900 (110) 2,500 2730 02.00 500 (003 360) (190) (1970) 5530 1530 40 22720 10 (150) 58300 34 Capital Expenditure 35 Cash Aqinitions 36 Divers 27 est in Marble & Equity Securt 38 Not in Due in Loans Ongod sold 89 Otherwing Activities 40 Cash from Investing 41 42 Short Tom Deos 43 Long Term Debt Issund 44 Total Debt sued 45 Short Term Not Repad 46 Long Term Det 47 Total Debt Repaid 48 49 Issuance of Canon Stock 50 Repurchase of common stock 51 52 Common Dividends Paid 3 Total Dividends Paid 54 SS Social Dividend Paid 56 Other Financing Activities 57 Cash from Financing 32470 2110 8/4560 10.002.0 49000 (6,48270) 102220 6,2240 16,8460 394409 6.0 11000703 > 5.300 (0.206.09 (70201 (6.630) 56170 10000 678170 16.00 22580 (1770 15200 21.th 20 (1000) (30) 210 1120) (51 (4200) (42601 (426) 14.2001 (230 (423.0) (4200 4390 (4300 3.0 (9000) 1970) 5,8070 (10) (1.501.02 (120) 2,987.0) (1,009.0) Income Statement Balance Sheet Cash Flow 14 A D E Special Dividend Pad Other Financing Activities Cash from Financing Formgn Exchange Rate Ad Net Change in Cash 30 (908.09 (970) 5.8070 (10) (1,5010) (120) (270) (1.000 110 (290) 28.0) 120 (20) (1190 11.09 5800 20 000