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. 13 Income Statement B D E For the Fiscal Period Ending 14 15 Currency Reclassified 12 months Jul 30-2017 USD Reclassified 12 months Jul-29-2018 USO 12 months Jul 28-2019 USD 12 months Aug 02-2020 USD 12 months Aug-01-2021 USO 5.8370 66150 8.1070 86910 8.4700 5,0370 6,6150 8,107,0 8,6910 8.4780 33910 2.446 0 41540 24610 SO 2,711,0 56630 3,008.0 5.620 2.8140 10000 90 1.1770 910 1,133.0 880 1,5100 920 1,80 840 12400) (2110) 1230 1000 Coco 943.0 16 17 Revere 18 Other Revenue 19 Total Revenue 20 21 Cost Of Goods Sold 22 Gross Profit 23 24 Seling General Admin Exp 25 R&DED 26 Depreciation & Amort 27 Over Operating Expertencome) 28 29 Other Operating Exp. Total 30 31 Operating Income 32 33 Interest Expense 34 interest and travest income 35 Net Interest Exp 36 37 Cuency Exchange Gains (Loss) 38 Omer Non-Operating Inc (Exp 39 EBTExcl. Unusual items 40 41 Restructuring Changes 42 Merger & Related Restruct Charges 43 Impairment of Goodwil 44 Cain (Loss) On Sale of invest 45 in na Income Statement Balance Sheet 1,0570 1,694.0 1.7170 12040 1.5030 1,4040 1.1170 1.2910 1,6100 (1150) (1530) 30 (1800) (100) 3500) 20 (354.01 (115,0) (150) (3450) 40 13410 to (209.01 10 (20) (10) 1,373.0 1.226.0 7030 948.0 1,400.0 148.00 2020) 11070) (1210) (190) (510) 1901 (100) (10) 149.00 Cash Flow 8 00 943.0 D 1.057.0 E 1,6940 F 1,717,0 1,503.0 1.2040 1.4040 1,1170 1,2910 (1150) 1,6100 (183) (115.0) 3.0 (1800) (3500) 20 (354.0) 13450) 40 (341.01 (2100) TO (209.09 (150) 10 (20) 1,3730 (10) 1.225.0 763.0 948.0 (4801 1.4000 (2020) (1070) (1210) 100) (530) 29 Other Operating Exp., Total 30 31 Operating Income 32 33 trest Expense 34 Interest and invest income 35 Net Interest Exp. 36 37 Currency Exchange Gains (0) 38 Other Non-Operating Inc (Exp) 39 EBTExcl Unusual Items 40 41 Rostructuring Charges 42 Merger & Related Restruct. Charges 43 Impairment of Goodwil 44 Gain (Loss) On Sale invest 45 Gain (LOS) On Sale Of Assets 46 Asset Weledown 47 Legal Settlement 48 Other Unusiems 49 EBT Incl. Unusual items 50 51 Income Tax Experte 52 Earnings from Cont Ops 53 54 Earrings of Discontinued Ops 55 Extraord tem & Account Change 56 Net Income to Company 57 58 Mnontynt in Earrings 59 Net Income 60 61 62 Income Statement Balance Sheet 190) (100) (10) (490) 1040) (16.09 (110) (540) (220) 830.0 1,316,0 525.0 766.0 1,3360 3920 924.0 1060 7240 151.0 4740 1740 5920 3280 1,000.0 (370) (1630) (2030) 100 160) 8870 261.0 2110 1,628.0 1,0020 8870 261.0 2110 16280 10020 63 Cash Flow B D Jul-30-2017 USD Reclassified Jul-29-2011 USO Jul-28-2019 USD Aug-02-2020 USD Aug-01-2021 USO 3190 310.0 490 49.0 31.0 31.0 8500 859,0 690 690 500 560 5050 5100 $30 3.0 5250 490 5740 5300 450 575.0 5440 STO 395.0 9020 1740 10000 BST 7970 2.290.0 1710 4900 1,0670 30 000 10350 2.3850 13 Balance Sheet Balance Sheet as of: 14 15 Currency 16 ASSETS 17 Cash Ad Equivalents 18 Total Cash & ST Investments 19 20 Accounts Receivable 21 Other Receivable 22 Total Receivables 23 24 viventory 25 Other Current Assets 26 Total Current Assets 27 28 Cross Property, Pant & Equment 29 Accumulated Depreciation 30 Net Property. Plant & Equipment 31 32 Long term investiments 33 Goodwill 34 Other nangibles 35 Deferred Tax Assets, LT 36 Other Long Term Assets 37 Total Assets 38 39 LIABILITIES 40 Accounts Payable 41 Accrued Exp 42 Short term Borrowings 43 Curr Port of LT Debt 44 CUF Port of Leases 45 Curr Income Taxes Payable 46 Other Current Liabetes 47 Total Current Liabilities 4R Income Statement 0.000 300 2.454.0 6.2100 (2220) 24600 52150 P.MOO 2.485.0 S300 2017 2,6220 6.7240 110 2.695 920 090 2,1150 1.100 300 19:40 7.7260 770 40170 2,4160 3.000 31500 310640 38640 20 21450 10529.0 3.010 12300 12170 13.149.0 290 12.372.0 2100 11.7340 5060 4940 10360 220 10 200 1600 2.3950 7050 4940 1.1.350 3000 1 000 5730 370 8140 5720 8500 5000 210 150 0110 3.3850 +0490 60 2780 9210 700 240 1300 3,0750 100 800.0 3,8940 650 50 1240 1,8140 Balance Sheet Cash Flow B o o D E F 6680 4940 10360 220 10 200 1580 2.395.0 7050 4940 1,1350 3900 8140 5720 8500 5000 210 150 6130 3,3850 1 0490 6030 2780 9210 700 240 10700 5130 370 100 8500 3,5940 650 50 1200 1200 3.0750 18140 79910 2.4920 70 5080 4500 1890 6.081,0 3470 9600 2640 13,155.0 7.1010 20 389 0 9240 2350 12.038.0 4900.0 1880 1820 9140 1740 9,803.0 5-0020 1830 3410 10510 1840 8.580.0 39 LIABILITIES 40 Accounts Payable 41 Accrued Exp 42 Short term Borrowings 43 Curr Port of LT Debt 44 Curr Port of Leases 45 Curr Income Taxes Payable 46 Other Current Liabilities 47 Total Current Liabilities 48 49 Long-Term Debt 50 Long Term Leases 51 Pension & Other Post Retire. Benefits 52 Del Tax Liability. Non-Curr 53 Other Non.Current Liabilities 54 Total Liabilities 55 56 Common Stock 57 Additional Paid In Capital 58 Relined Earnings 59 Treasury Stock 60 Comprehensive ince and Other 61 Total Common Equity 62 63 Minority interest 64 65 Total Equity 66 67 Total Liabilities And Equity 68 69 Supplemental Items 70 Total Shares out on Balance Sheet Date 71 72 Market Price of Stock 73 74 Income Statement Balance Sheet 120 3590 23850 (10660) (520) 1.837.0 120 349 0 2,2240 (11030) (1180) 1,3640 120 3720 19930 (1070) (1980) 1.1030 120 3940 31900 (1.0230) 120 4140 37420 (1021) 50 3.1520 (100) 2,583 0 8.0 90 90 80 20 1.6450 1.373.0 1 1120 2,549,0 3,1540 2.726,0 14,529,0 13.1480 12.372.0 11.734.0 3010 3010 3010 302.0 3020 $46 20 $3945 S4500 $4173 Cash Flow For the Fiscal Period Ending F B Restated 12 months Jul-30-2017 USD C Restated 12 months Jul-29-2018 5 Currency D Restated 12 months Jul-28-2019 USD E Restated 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD USD 7 Net Income 8 Depreciation & Amort 9 Amort of Goodwill and intangibles O Depreciation & Amort, Total 8870 1920 10 1930 251.0 2500 200 2790 211.0 3150 480 363.0 1,628,0 285 0 430 328.0 1,0020 2750 120 317.0 110 100 1160 510 9140 (975) 490 90 610 210 640 180 000 2850 (2050) 280 450 (680) 270) 1,236,0 (308) 560 320 10 470 580 3120 770 (110) 360 1250 (10) 1.250.0 (840) 780 270 1.4100 2040 (300) (200) 1450 20 1,396.0 (910) 200) (770) (1640) 280) 1,035.0 (3380) 2 Gan) Loss From Sale Of Assets 23 (Gan) Loss On Sale Of Invest 24 Asset Wtedown & Restructuring Costs 25 Stock Based Compensation 26 Net Cash From Discontinued Ops 27 Other Operating Activities 28 Change in Acc Receivable 29 Change in inventores 30 Change in Ace Payable 31 Change in Other Net Operating Assets 32 Cash from Ops 33 34 Capital Expenditure 35 Cash Acquisitions 36 Divestitures 37 trest in Marketable & Equity Securt 38 Net (Inc) Dec intoans Orginated Sold 39 Other Investing Activities 40 Cash from investing 41 42 Short Term Debt Issured 43 Long Term Debt issued 44 Total Debt issued 45 Short Term Debt Repard 46 Long Term Debt Report 47 Total Debt Repaid Income Statement Balance Sheet (2750) (4OTO) 10.7810) 100 13940) (470) 310 2900) (110) 2548 100 220) 1110 (200) (368.0) 5810 1090 17.197.01 1530 40 2.7720 80 [1500) 68000 3200 82470 2110 8,458.0 (80020) 4900 (3.492.0) 102720 62240 16.445.0 (9,0440) 1000 110.0070) 5,8390 2980) 0902 16,998.0) 5,6170 10000 6.5170 (6 909 ) R2 (9.177.0) 3200 (5000) 11.501.0) Cash Flow B D D m 010 00D 2060 (2000) 200 40 (480) 0270 1.235.0 010 6140 (3000) 100 (140 700 270 1,410,0 580 3120 770 (1103 300 1250 00) 1,2800 2040 0300 (200 145.0 00 1,396,0 (910) (200) (170) (1040) (20 1,0350 (0) (40703 700) (1840) (470) 310 100 (2000) (110 364110 300 (2750) (203 1110 (100) 13000 (100) 07.1970) MO 1500 2.272.0 (1500) 25 Stock-Based Compensato 26 Net Cash From Discontinued Ops 27 Other Operating cities 28 Change in Acc Receivable 29 Change in inventories 30 Change Ace Pie 31 Change in the Operating Assets 32 Cash from Ops 33 34 Capital Expenditure 35 Cash Acqua 36 Divestre 37 Invest in Marketable & Equity Securt 38 Net (Dec. Loans Originated Sold 39 Other Westing Activities 40 Cash from Investing 41 42 Short Term Dettissued 43 Long Term Debt sued 44 Total Debt issued 45 Short Term Debt Repaid 46 Long Term Debt Repad 47 Total Debt Repaid 48 49 Istance of Common Stock 50 Repurchase of Common Stock 51 52 Coman Dividends Paid 53 Total Dividends Paid 54 55 Special Dividend Paid 56 Other Financing Activities 57 Cash from Financing 58 69 Foreign Exchange Rate AG 60 Net Change in Cash Income Statement Balance Sheet 5.RO 3200 8270 2110 8.4500 (80020) ORO) (8,492.0) 10 2220 0220 16,4460 19,2440) (3) (10,0070) 0,839,0 10.2003 20201 16,998) 50170 10000 6.617,0 (9,0000) 122) (9.177.01 320,0 (5000) (210) (1.001.0) 20 (400) (1000) 230 (120) 20 (510) 4700 (4200) 14200 (426.0) 16220) (423.0) (4260) 1426.01 (4390) (4390) 10 (908) 020 8070 (10 (1.6010) (120) (2,987.0) 11.863.01 110 (29.01 (6.0) 12.0 20 (195.02 10 5100 20 790.02 Cash Flow