Dividends, Payout Ratio and Stock Repurchases
6. a.) What was Campbells 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 Campbells 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.
sell Neview ACIONAL Sllale Insert X LO Arial 8 A Y o Accounting Wrap Text Es Merge & Center 2X Delete Paste BIU a-A- 40.00 $ %) -20 y Ideas Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity H17 X fic =F17*0.03 A B E F G H 1 J K L M D D 5 Campbell Soup Company (NYSE:CPB) > Financials > Income Statement 7 in Millions of the reported currency, except per share items. 6789BHQ2 Template: Period Type: Currency: Units: Standard Annual Reported Currency S&P Capital IQ (Defau Restatement: Order: Conversion: : Decimals: Latest Filings Latest on Right Historical Capital IQ (Default) 10 11 12 13 Income Statement Reclassified 12 months Jul-30-2017 USD Reclassified 12 months Jul-29-2018 USD 12 months Jul-28-2019 USD 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD 6,615.0 8,107,0 8,691.0 8,476.0 254.28 5,837,0 - 5,837.0 6,615.0 8,107.0 8,691.0 8,476.0 3,391.0 2,446.0 4,154.0 2,461.0 5,396.0 2,711.0 5,683.0 3,008.0 5,662.0 2,814.0 For the Fiscal Period Ending 14 15 Currency 16 17 Revenue 18 Other Revenue 19 Total Revenue 20 21 Cost Of Goods Sold 22 Gross Profit 23 24 Selling General & Admin Exp. 25 R & D Exp. 26 Depreciation & Amort. 27 Other Operating Expense/(Income) 28 29 Other Operating Exp., Total 30 31 Operating Income 32 Income Statement 1,090.0 93.0 1,177.0 91.0 1,383.0 88.0 1,519.0 92.0 1,386.0 84.0 (240.0) (211.0) 123.0 106.0 (266.0) 943.0 1,057.0 1,594.0 1,717.0 1,204.0 1,503.0 1,404.0 1,117.0 1,291.0 1,610.0 Balance Sheet Cash Flow + 3 1 Accessibility: Unavailable Type here to search I 5:22 PM 11/27/2021 X #Insert Arial 8 AA = === ab ce Wrap Text Accounting AY O o E 5 Paste a.Ar BIU Ideas y Es Merge & Center 2X Delete Format $ - % y ) -20 Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity H17 X f =F17*0.03 B D E F F G H 1 J K L M (115.0) (183.0) 3.0 (180.0) (356.0) 2.0 (354.0) (345.0) 4.0 (341.0) (210.0) 1.0 (209.0) (115.0) (15.0) 1.0 (2.0) (1.0) 1,373.0 1,225.0 763.0 948.0 1,400.0 (48.0) (121.0) (69.0) (53.0) (202.0) (107.0) (9.0) (10.0) (1.0) (49.0) (64.0) - (11.0) A 32 33 Interest Expense 34 Interest and Invest. Income 35 Net Interest Exp. 36 37 Currency Exchange Gains (Loss) 38 Other Non-Operating Inc. (Exp.) 39 EBT Excl. Unusual Items 40 41 Restructuring Charges 42 Merger & Related Restruct. Charges 43 Impairment of Goodwill 44 Gain (Loss) On Sale Of Invest. 45 Gain (Loss) On Sale Of Assets 46 Asset Writedown 47 Legal Settlements 48 Other Unusual Items 49 EBT Incl. Unusual Items 50 51 Income Tax Expense 52 Earnings from Cont. Ops. 53 54 Earnings of Discontinued Ops. 55 Extraord. Item & Account Change 56 Net Income to Company 57 58 Minority Int. in Earnings 59 Net Income 60 61 -- - (54.0) (22.0) (16.0) -- - 1,316.0 830.0 625.0 766.0 1,336.0 392.0 924.0 106.0 724.0 151.0 474.0 174.0 592.0 328.0 1,008.0 (37.0) (463.0) (263.0) 1,036.0 (6.0) 887.0 261.0 211.0 1,628.0 1,002.0 887.0 261.0 211.0 1.628.0 1.002.0 Income Statement Balance Sheet Cash Flow # X Insert v Arial 8 8 A ab Wrap Text General 48 o LG WS 9X Delete Paste BIU Ideas 6 A A~ y Es Merge & Center $ % Sensitivity 0 Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity B64 fox F G G . 1 J L M Latest Filings Latest on Right Historical Capital IQ (Default) Aug-01-2021 USD 69.0 69.0 A B D D E 5 Campbell Soup Company (NYSE:CPB) > Financials > Balance Sheet 6 In Millions of the reported currency, except per share items. Template: Standard Restatement: 8 Period Type: Annual Order: 9 Currency: Reported Currency Conversion: 10 Units: S&P Capital IQ (Defau Decimals: 11 12 13 Balance Sheet Balance Sheet as of: Reclassified 14 Jul-30-2017 Jul-29-2018 Jul-28-2019 Aug-02-2020 15 Currency USD USD USD USD 16 ASSETS 17 Cash And Equivalents 319.0 49.0 31.0 859.0 18 Total Cash & ST Investments 319.0 49.0 31.0 859.0 19 20 Accounts Receivable 550.0 510.0 525.0 530.0 21 Other Receivables 55.0 53.0 49.0 45.0 22 Total Receivables 605.0 563.0 574.0 575.0 23 24 Inventory 902.0 887.0 863.0 871.0 25 Other Current Assets 74.0 797.0 499.0 80.0 26 Total Current Assets 1,900.0 2,296.0 1,967.0 2,385.0 27 28 Gross Property, Plant & Equipment 6,043.0 5.239.0 5,215.0 5,539.0 29 Accumulated Depreciation (3,589.0) (2,773.0) (2,760.0) (2,917.0) 30 Net Property, Plant & Equipment 2,454.0 2,466.0 2,455.0 2,622.0 31 32 Long-term Investments 69.0 92.0 77.0 33 Goodwill 2,115.0 3,864.0 4,017.0 3,986.0 Income Statement Balance Sheet Cash Flow (+ 544.0 51.0 595.0 933.0 98.0 1,695.0 5,724.0 (3,119.0) 2,605.0 3,981.0 Accessibility: Unavailable Type here to search IH PI X 5:24 PM O )) 11/27/2021 C [ File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Comments X Insert Arial 8 General 47 0 5 LO ' = = = Wrap Text AEEE 3 & Merge & Center AX Delete Paste Ideas BIU y $ %) 40 00 000 Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity B64 fic B D E F G H 1 J K L M 1 6,043.0 (3,589.0) 2,454.0 5,239.0 (2,773.0) 2,466.0 5,215.0 (2,760.0) 2,455.0 5,539.0 (2,917.0) 2,622.0 5,724.0 (3,119.0) 2,605.0 77.0 4,017.0 3,415.0 3,986.0 3,350.0 3,981.0 3,239.0 69.0 2,115.0 1,118.0 36.0 34.0 7.726.0 92.0 3,864.0 3,664.0 2.0 2,145.0 14.529.0 1,217.0 13.148,0 29.0 12.372.0 214.0 11.734.0 27 28 Gross Property, Plant & Equipment 29 Accumulated Depreciation 30 Net Property, Plant & Equipment 31 32 Long-term Investments 33 Goodwill 34 Other Intangibles 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 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 Def. Tax Liability, Non-Curr. 53 Other Non-Current Liabilities 54 Total Liabilities 55 56 Common Stock 705.0 494.0 1,135.0 390.0 1,070.0 513.0 37.0 666.0 494.0 1,036.0 22.0 1.0 20.0 156.0 2,395.0 814.0 572.0 850.0 500.0 21.0 15.0 613.0 3,385.0 1,049.0 603.0 278.0 921.0 70.0 24.0 130.0 3,075.0 10.0 860.0 3,594.0 65.0 5.0 124.0 1,814.0 7,991.0 2,492.0 7.0 508.0 490.0 189.0 6,081.0 347.0 960.0 264.0 13, 156.0 7.101.0 2.0 389.0 924.0 235.0 12,036.0 4,990.0 188.0 462.0 914.0 174.0 9,803.0 5,002.0 188.0 341.0 1,051.0 184.0 8,580.0 12.0 12.0 12.0 12.0 12.0 Income Statement Balance Sheet Cash Flow 3 W + 100 Accessibility: Unavailable Type here to search . I 5:24 PM 11/27/2021 Arial 8 8 General ini Insert 5X Delete - ' ' A A === ab Wrap Text A E Merge & Center FE E LO Paste 2Y Y Sort & Find & Filter Select BIU Ideas 40 00 $ %) Sensitivity Conditional Format as Cell Formatting Table Styles Styles Format Clipboard Font Alignment Number Cells Editing Ideas Sensitivity B64 X B D F F G H 1 J K K L M 7,991.0 2,492.0 7.0 508.0 490.0 189.0 6,081.0 347.0 960.0 264.0 13,156.0 7,101.0 2.0 389.0 924.0 235.0 12.036.0 4,990.0 188.0 462.0 914.0 174.0 9,803.0 5,002.0 188.0 341.0 1,051.0 184.0 8,580.0 12.0 359.0 2,385.0 (1,066.0) (53.0) 1,637.0 12.0 349.0 2,224.0 (1,103.0) (118.0) 1,364.0 12.0 372.0 1,993.0 (1,076.0) (1980) 1,103.0 12.0 394.0 3,190.0 (1,023.0 (10.0) 2,563.0 12.0 414.0 3,742.0 (1,021.0) 5.0 3,152.0 A 48 49 Long-Term Debt 50 Long-Term Leases 51 Pension & Other Post-Retire. Benefits 52 Def. Tax Liability, Non-Curr. 53 Other Non-Current Liabilities 54 Total Liabilities 55 56 Common Stock 57 Additional Paid In Capital 58 Retained Earnings 59 Treasury Stock 60 Comprehensive Inc. 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 75 76 77 8.0 9.0 9.0 6.0 2.0 1,645.0 1,373.0 1,112.0 2.569.0 3.154.0 7.726.0 14,529.0 13.148.0 12.372.0 11.734.0 301.0 301.0 301.0 302.0 302.0 $46.20 $39.45 $45.00 $52.61 $41.73 70 Income Statement Balance Sheet Cash Flow (+ Accessibility: Unavailable I IH Type here to search O A u )) 5:25 PM 11/27/2021 Insert v Arial v8 8 ' ' Wrap Text General 28 O o 5 DX Delete T Paste BIU 40 00 Ideas y Sensitivity E Merge & Center E Y Q $ %) Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity G34 X G . H 1 J K L M 2H22 A B D E F 4 5 Campbell Soup Company (NYSE:CPB) > Financials > Cash Flow 6 7 in Millions of the reported currency, except per share items. Template: Standard Restatement: Latest Filings 8 Period Type: Annual Order: Latest on Right 9 9 Currency: Reported Currency Conversion: Historical 10 Units: S&P Capital IQ (Defau Decimals: Capital IQ (Default) 11 12 13 Cash Flow Restated Restated Restated Restated For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months 14 Jul-30-2017 Jul-29-2018 Jul-28-2019 Aug-02-2020 Aug-01-2021 15 Currency USD USD USD USD USD 16 17 Net Income 887.0 261.0 211.0 1,628.0 1,002.0 18 Depreciation & Amort. 192.0 259.0 315.0 285.0 275.0 19 Amort. of Goodwill and Intangibles 1.0 20.0 48.0 43.0 42.0 20 Depreciation & Amort., Total 193.0 279.0 363.0 328.0 317.0 21 22 (Gain) Loss From Sale Of Assets - 32.0 (975.0) 11.0 23 (Gain) Loss On Sale Of Invest. 10.0 1.0 49.0 24 Asset Write down & Restructuring Costs 18.0 116.0 47.0 9.0 21.0 25 Stock-Based Compensation 60.0 61.0 58.0 61.0 64.0 26 Net Cash From Discontinued Ops 285.0 914.0 312.0 27 Other Operating Activities (206.0) (308.0) 77.0 204.0 (91.0) 28 Change in Acc. Receivable 28.0 56.0 (11.0) (30.0) (20.0) 29 Change In Inventories 46.0 (84.0) 36.0 (77.0) 30 Change in Acc. Payable (48.0) 78.0 125.0 145.0 (164.0) 31 Change in Other Net Operating Assets (27.0) 27.0 (1.0) (3.0) (28.0) | Income Statement Balance Sheet Cash Flow + Accessibility: Unavailable (20.0) + 100 th Type here to search O 5:26 PM 11/27/2021 sell Neview ACIONAL Sllale Insert Arial X LO 8 A Y General 8x 11.11 AY O o
