Additional Funds Needed Campbell wants to increase its sales/revenue after year 2021. A. What are the additional funds needed (AFN) if the company wants to grow sales/revenue by 4.5% after year 2021? B. What is the Internal Growth Rate? C. What is the Sustainable Growth Rate? Los B D E Income Statement For the Fiscal Period Ending 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 68370 6,6150 81070 86910 84760 5,837.0 5.5150 8.107.0 8,691,0 8.475.0 33910 2.446,0 4.154.0 2.451.0 5900 2.7110 5.683.0 3.0080 50620 2.8140 13980 15 Currency 16 7 Revenue 18 Other Revenue 19 Total Revenue 20 21 Coul of Goods Sold 22 Gross Profit 23 24 Seling General & Admin Exp 25 R&D Exp 26 Depreciation & Amort 27 Other Operating Expense/income) 28 29 Other Operating Exp. Total 30 1 Operating income 32 33 Interest Expense 84 Interest and Invest Income 35 Net Interest Exp. 1.0900 930 1.177.0 910 13830 BRO 15190 920 SEO 2400) (2110) 1220 1000 (2000) 9430 5,0570 1,5940 1.7170 1 2040 1,5030 1.4040 1.117,0 1.291.0 1,610.0 (1150) (1830) 30 (1800) (3580) 20 (3540) (3450) 40 (3410) (2100) 10 (209.0) (115.0) (150) 10 (20) (10) 1,373.0 1.225.0 783.0 9480 1.400.0 (480) (1210) (2020) (1070) (530) (630) 37 Currency Exchange Gans (Loss) 38 Other Non-Operating Inc (p) 89 EBT Excl. Unusual Items 90 1 Restructuring Charges #2 Merger & Related Restruct Charges 23 iament of Goodwill 14 Gain (Loss) On Sale Of Invest 5 Gain (Loss) On Sale Of Assets 46 Asset Widedown Set Income Statement Relat (90) (100) (10) (490) (640) (110) (160) (540) 22.0 Blow D m F G 1,3730 1,225.0 763.0 9480 1.4000 (480) (1210) (600) (2020) (1070) (530) (90) (10) (490) (540) (550) (100) 1540) (220) (160) 1,3160 830.0 6250 7560 1.3360 20 9240 1000 7240 1510 4740 1740 6920 2200 1.000.0 (370) (403) (2630) 10360 160) 39 EBT Exel Unusual items 40 41 Restructuring Charge 42 Werger Related Res Charges 43 power of Good 44 On Loss On Sale of invest 45 cans On Sale Of A 46 As Wedown 47. Semant 48 Other Unters 49 EBT Incl. Unusual Items 50 61 compe 62 Earnings from Cent Ops 53 54 cod Ops 65 ander A Change 56 Net Income to Company 57 58 Minority in Eng 69 Net Income 60 51 62 63 64 65 66 67 68 69 70 71 72 73 74 6870 261.0 2110 1.628.0 1,0020 8870 2010 2110 1.5280 1.002.0 Income Statement Balance Sheet Cash Flow B C D E G Jul 30 2017 USD Reclassified Jul 29 2018 USO Jul-28-2019 USD Aug 02 2020 USD Aug-01 2021 USD 319.0 319,0 490 350 310 690 369.0 293.0 200 541 55.0 505.0 510,0 520 53.0 5250 490 STUS 5300 50 5750 510 5950 902.0 740 1.900.0 8870 7970 2290 3630 4990 1.960 at 800 285.0 9330 930 1.695.0 G0410 2.5.09.03 245400 52390 2.7720 5.215 GOOD 20170 2.622.0 5.7240 0.0190 2.605.0 13 Balance Sheet Balance Sheet as of 14 15 Currency 18 ASSETS 17 Cash And Equivalent 18 Total Cash & ST Investments 19 20 Accounts Receivable 21 Other Receivable 22 Total Receivables 23 24 nentory 25 Other Current Assets 26 Total Current Ames 27 28 Crons Property. Planten 29 Accurred Depreciation 30 Net Property. Plant & Equipment 31 32 Long term investments 33 codil 34 Other intangible 35 Delenied Tax Asses 30 Other Long Tam Aile 37 Total Assets 38 39 LIABILITIES 40 Accounts Payable 41 Accrued E 42 Short-term Bonowings 43 Curr Port of LT Dett 44 Curr Port of La 45 Curt Income Taxes Payable 40 Other Current Liabilities 47 Total Current Liabilities 48 49 Long Term Dett 50 Long-Term Cases 51 Pension & Other Post Reture Benes 52 Dol Tax Liability. Non-Cum Income Statement 770 40170 920 18640 16610 20 21450 2060 100 60 21150 1.100 360 340 2.726,0 3,9010 3.2390 > 52170 20 12.12 2140 11. 7050 4940 1.1350 1900 16700 5130 370 6660 4940 10360 220 10 200 1560 2,195,0 31 5720 50 5000 21 15 6130 ESTO 1049 503 27 9210 700 240 1300 1,0750 0 100 3600 3,594.0 50 1240 110 7,9910 71010 2492 0 7.0 5060 4900 4.990 180 LEO 9140 5.002.0 1880 3410 10510 3470 960 0 3890 9240 Balance Sheet Cash Flow B D E G 360 1.0 126,0 20 2.105 2.2.0 2170 1140 290 2140 7050 4440 1.1350 3900 0 HO 10360 220 10 200 1560 395.0 10700 5110 70 8140 5720 1000 1000 210 160 5130 3.385,0 10190 1920 2780 9210 70.0 240 100 160 0 3,590.0 50 120 1.8140 3,0750 7910 71010 20 2,4920 70 5000 4900 18190 6,061.0 360 960 0 2640 13,194.0 Kao 22350 12.0360 4900 1000 4620 9140 1940 3,00) 5.6020 100 MO 10510 1840 3,500.0 35 Deferred Tax Asus, LT 36 Other Long Term Assets 37 Total Assets 30 30 LIABILITIES 40 Accounts Payable 41 Acond 42 hort term Bows 43 Curr Port LTD 44 Our Portes 45 Cur cum Toe Pytle 46 Other end 47 Total Current Liabile 48 49 Long Term Debt 50 Long Term Leses 51 Pension Poster Benests 52 Dal Tax Lisbilly Non-Car 53 Other Non Cum Labs 54 Total Liabilities 55 56 Common Stock 57 Aditional Paid in Capital 58 Retained 59 Treasury Stock 60 Comprehensive in and Other 31 Total Common Equity 02 03 Minority 04 65 Total Equity 67 Total Liabilities And Equity 00 69 Supplemental tema 70 Total Share Out once Sheet Di 71 72 Market Price of Stock 73 74 75 Income Statement 120 0 120 3590 2300 11.0660) 1030 1,6370 120 190 22110 11.1030) (1910 1,3640 120 1120 1,9920 (1.075 (1889 1.100.0 3.1900 (10230) 110 2,563.0 120 414 1420 (102103 SO 2152.0 3.0 90 60 20 1.645,0 1.3730 11120 25622 31540 7.226,0 1052 110 ILIS 3010 3010 3010 302.0 146 20 5.1945 $45.00 56261 $123 Balance Sheet Cash Flow + B 13 Cash Flow D E Restarted 12 months Jul 30 2017 USD Restated 12 months Jul 29 2018 USD Restated 12 months Jul 28 2019 USD Restafed 12 months Aug 02 2020 USD 12 months Aug 01 2021 USD 887.0 1920 10 193.0 251.0 2590 20.0 279.0 211.0 3150 480 363,0 1,628.0 2850 430 328.0 1.002.0 275.0 420 317.0 (9750) 110 490 90 61.0 210 540 For the Fiscal Period Ending 14 15 Currency 16 17 Net Income 18 Depreciation & Amort 19 Amort of Goodwill and intangibles 20 Depreciation & Amort, Total 21 22 (Gain Loss From Sale Of Assets 23 (Gain) Lons On Sale Of Invest 24 Asset Whitedown & Restructuring Costa 25 Stock-Based Compensation 26 Net Cash From Discontinued Op. 27 Other Operating Activities 28 Change in Acc Receivable 29 Change In Inventories 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 Invest in Marketable & Equity Securt 38 Net (Inc) Dec in Loans Onginated/Sold 39 Other Investing Activities 40 Cash from Investing 41 42 Short Term Debt Issued 43 Long Term Debt issued 44 Total Debt Issued 45 Short Term Debt Repaid 46 Long-Term Debt Repaid 47 Total Debt Repaid 48 49 issuance of Common Stock 50 Repurchase of Common Stock 180 60.0 2850 (2060) 280 46 0 (480) (270) 1.236.0 10.0 1160 610 9140 (3080) 56.0 (840) 780 270 1.410.0 320 10 470 580 3120 770 (110) 360 1250 (10) 1.250.0 2040 30.0) (200) 1450 13.0) 1.396.0 (910) (200) (170) (1640) (28.0) 1.035.0 (3380) (407) 16,7810 100 (3840) (470) 310 299.0 (110) 2.5480 30.0 275 0 (20) 1110 (30.0) (368,0) (190 (7.197.0) 5630 153.0 40 2,2720 8.0 (158.0) 5,8390 3200 8.2470 2110 8,458.0 (80020) (490) (8.492.0) 10 2220 6.224.0 16,446.0 (9.944.0) (630) (10,007.01 5,839.0 16,2960) (7020) (6,998.01 5,6170 1,0000 5,617,0 16,9090) 22680) 19.177.0) 120.0 (580,0) (9210) 11.501.02 20 (4590) 230 (120) 20 (510) (1090) (80) 51 Income Statement Balance Sheet Cash Flow B (0,492.0) (10,0070) D 16.990,0) E F 09.177. 11,5010) 20 (4590) (1030) 230 160 (120 20 (510 (4200) 1420.00 (4260 (426.01 14:20 101.09 (4260 (476.09 40 (490) 47 Total Debt Repaid 48 49 Issuance of Common Stock 50 Repurchase of Common Stock 51 52 Common Odends Paid 53 Total Dividends Paid 54 55 Special Dividend Pard 56 Other Financing Acties 57 Cash from Financing 58 59 Forwign Exchange Rate Ad 60 Net Change in Cash 61 62 03 64 65 66 87 68 30 0908.09 1970) 5,8070 10 11.5510 (120) 27. (1.600 110 129.01 UD 1220 (70 . (10) 1290.01 70 71 72 73 74 75 16 77 28 79 30 31 32 23 34 35 37 Income Statement Balance Sheet Cash Flow Additional Funds Needed Campbell wants to increase its sales/revenue after year 2021. A. What are the additional funds needed (AFN) if the company wants to grow sales/revenue by 4.5% after year 2021? B. What is the Internal Growth Rate? C. What is the Sustainable Growth Rate? Los B D E Income Statement For the Fiscal Period Ending 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 68370 6,6150 81070 86910 84760 5,837.0 5.5150 8.107.0 8,691,0 8.475.0 33910 2.446,0 4.154.0 2.451.0 5900 2.7110 5.683.0 3.0080 50620 2.8140 13980 15 Currency 16 7 Revenue 18 Other Revenue 19 Total Revenue 20 21 Coul of Goods Sold 22 Gross Profit 23 24 Seling General & Admin Exp 25 R&D Exp 26 Depreciation & Amort 27 Other Operating Expense/income) 28 29 Other Operating Exp. Total 30 1 Operating income 32 33 Interest Expense 84 Interest and Invest Income 35 Net Interest Exp. 1.0900 930 1.177.0 910 13830 BRO 15190 920 SEO 2400) (2110) 1220 1000 (2000) 9430 5,0570 1,5940 1.7170 1 2040 1,5030 1.4040 1.117,0 1.291.0 1,610.0 (1150) (1830) 30 (1800) (3580) 20 (3540) (3450) 40 (3410) (2100) 10 (209.0) (115.0) (150) 10 (20) (10) 1,373.0 1.225.0 783.0 9480 1.400.0 (480) (1210) (2020) (1070) (530) (630) 37 Currency Exchange Gans (Loss) 38 Other Non-Operating Inc (p) 89 EBT Excl. Unusual Items 90 1 Restructuring Charges #2 Merger & Related Restruct Charges 23 iament of Goodwill 14 Gain (Loss) On Sale Of Invest 5 Gain (Loss) On Sale Of Assets 46 Asset Widedown Set Income Statement Relat (90) (100) (10) (490) (640) (110) (160) (540) 22.0 Blow D m F G 1,3730 1,225.0 763.0 9480 1.4000 (480) (1210) (600) (2020) (1070) (530) (90) (10) (490) (540) (550) (100) 1540) (220) (160) 1,3160 830.0 6250 7560 1.3360 20 9240 1000 7240 1510 4740 1740 6920 2200 1.000.0 (370) (403) (2630) 10360 160) 39 EBT Exel Unusual items 40 41 Restructuring Charge 42 Werger Related Res Charges 43 power of Good 44 On Loss On Sale of invest 45 cans On Sale Of A 46 As Wedown 47. Semant 48 Other Unters 49 EBT Incl. Unusual Items 50 61 compe 62 Earnings from Cent Ops 53 54 cod Ops 65 ander A Change 56 Net Income to Company 57 58 Minority in Eng 69 Net Income 60 51 62 63 64 65 66 67 68 69 70 71 72 73 74 6870 261.0 2110 1.628.0 1,0020 8870 2010 2110 1.5280 1.002.0 Income Statement Balance Sheet Cash Flow B C D E G Jul 30 2017 USD Reclassified Jul 29 2018 USO Jul-28-2019 USD Aug 02 2020 USD Aug-01 2021 USD 319.0 319,0 490 350 310 690 369.0 293.0 200 541 55.0 505.0 510,0 520 53.0 5250 490 STUS 5300 50 5750 510 5950 902.0 740 1.900.0 8870 7970 2290 3630 4990 1.960 at 800 285.0 9330 930 1.695.0 G0410 2.5.09.03 245400 52390 2.7720 5.215 GOOD 20170 2.622.0 5.7240 0.0190 2.605.0 13 Balance Sheet Balance Sheet as of 14 15 Currency 18 ASSETS 17 Cash And Equivalent 18 Total Cash & ST Investments 19 20 Accounts Receivable 21 Other Receivable 22 Total Receivables 23 24 nentory 25 Other Current Assets 26 Total Current Ames 27 28 Crons Property. Planten 29 Accurred Depreciation 30 Net Property. Plant & Equipment 31 32 Long term investments 33 codil 34 Other intangible 35 Delenied Tax Asses 30 Other Long Tam Aile 37 Total Assets 38 39 LIABILITIES 40 Accounts Payable 41 Accrued E 42 Short-term Bonowings 43 Curr Port of LT Dett 44 Curr Port of La 45 Curt Income Taxes Payable 40 Other Current Liabilities 47 Total Current Liabilities 48 49 Long Term Dett 50 Long-Term Cases 51 Pension & Other Post Reture Benes 52 Dol Tax Liability. Non-Cum Income Statement 770 40170 920 18640 16610 20 21450 2060 100 60 21150 1.100 360 340 2.726,0 3,9010 3.2390 > 52170 20 12.12 2140 11. 7050 4940 1.1350 1900 16700 5130 370 6660 4940 10360 220 10 200 1560 2,195,0 31 5720 50 5000 21 15 6130 ESTO 1049 503 27 9210 700 240 1300 1,0750 0 100 3600 3,594.0 50 1240 110 7,9910 71010 2492 0 7.0 5060 4900 4.990 180 LEO 9140 5.002.0 1880 3410 10510 3470 960 0 3890 9240 Balance Sheet Cash Flow B D E G 360 1.0 126,0 20 2.105 2.2.0 2170 1140 290 2140 7050 4440 1.1350 3900 0 HO 10360 220 10 200 1560 395.0 10700 5110 70 8140 5720 1000 1000 210 160 5130 3.385,0 10190 1920 2780 9210 70.0 240 100 160 0 3,590.0 50 120 1.8140 3,0750 7910 71010 20 2,4920 70 5000 4900 18190 6,061.0 360 960 0 2640 13,194.0 Kao 22350 12.0360 4900 1000 4620 9140 1940 3,00) 5.6020 100 MO 10510 1840 3,500.0 35 Deferred Tax Asus, LT 36 Other Long Term Assets 37 Total Assets 30 30 LIABILITIES 40 Accounts Payable 41 Acond 42 hort term Bows 43 Curr Port LTD 44 Our Portes 45 Cur cum Toe Pytle 46 Other end 47 Total Current Liabile 48 49 Long Term Debt 50 Long Term Leses 51 Pension Poster Benests 52 Dal Tax Lisbilly Non-Car 53 Other Non Cum Labs 54 Total Liabilities 55 56 Common Stock 57 Aditional Paid in Capital 58 Retained 59 Treasury Stock 60 Comprehensive in and Other 31 Total Common Equity 02 03 Minority 04 65 Total Equity 67 Total Liabilities And Equity 00 69 Supplemental tema 70 Total Share Out once Sheet Di 71 72 Market Price of Stock 73 74 75 Income Statement 120 0 120 3590 2300 11.0660) 1030 1,6370 120 190 22110 11.1030) (1910 1,3640 120 1120 1,9920 (1.075 (1889 1.100.0 3.1900 (10230) 110 2,563.0 120 414 1420 (102103 SO 2152.0 3.0 90 60 20 1.645,0 1.3730 11120 25622 31540 7.226,0 1052 110 ILIS 3010 3010 3010 302.0 146 20 5.1945 $45.00 56261 $123 Balance Sheet Cash Flow + B 13 Cash Flow D E Restarted 12 months Jul 30 2017 USD Restated 12 months Jul 29 2018 USD Restated 12 months Jul 28 2019 USD Restafed 12 months Aug 02 2020 USD 12 months Aug 01 2021 USD 887.0 1920 10 193.0 251.0 2590 20.0 279.0 211.0 3150 480 363,0 1,628.0 2850 430 328.0 1.002.0 275.0 420 317.0 (9750) 110 490 90 61.0 210 540 For the Fiscal Period Ending 14 15 Currency 16 17 Net Income 18 Depreciation & Amort 19 Amort of Goodwill and intangibles 20 Depreciation & Amort, Total 21 22 (Gain Loss From Sale Of Assets 23 (Gain) Lons On Sale Of Invest 24 Asset Whitedown & Restructuring Costa 25 Stock-Based Compensation 26 Net Cash From Discontinued Op. 27 Other Operating Activities 28 Change in Acc Receivable 29 Change In Inventories 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 Invest in Marketable & Equity Securt 38 Net (Inc) Dec in Loans Onginated/Sold 39 Other Investing Activities 40 Cash from Investing 41 42 Short Term Debt Issued 43 Long Term Debt issued 44 Total Debt Issued 45 Short Term Debt Repaid 46 Long-Term Debt Repaid 47 Total Debt Repaid 48 49 issuance of Common Stock 50 Repurchase of Common Stock 180 60.0 2850 (2060) 280 46 0 (480) (270) 1.236.0 10.0 1160 610 9140 (3080) 56.0 (840) 780 270 1.410.0 320 10 470 580 3120 770 (110) 360 1250 (10) 1.250.0 2040 30.0) (200) 1450 13.0) 1.396.0 (910) (200) (170) (1640) (28.0) 1.035.0 (3380) (407) 16,7810 100 (3840) (470) 310 299.0 (110) 2.5480 30.0 275 0 (20) 1110 (30.0) (368,0) (190 (7.197.0) 5630 153.0 40 2,2720 8.0 (158.0) 5,8390 3200 8.2470 2110 8,458.0 (80020) (490) (8.492.0) 10 2220 6.224.0 16,446.0 (9.944.0) (630) (10,007.01 5,839.0 16,2960) (7020) (6,998.01 5,6170 1,0000 5,617,0 16,9090) 22680) 19.177.0) 120.0 (580,0) (9210) 11.501.02 20 (4590) 230 (120) 20 (510) (1090) (80) 51 Income Statement Balance Sheet Cash Flow B (0,492.0) (10,0070) D 16.990,0) E F 09.177. 11,5010) 20 (4590) (1030) 230 160 (120 20 (510 (4200) 1420.00 (4260 (426.01 14:20 101.09 (4260 (476.09 40 (490) 47 Total Debt Repaid 48 49 Issuance of Common Stock 50 Repurchase of Common Stock 51 52 Common Odends Paid 53 Total Dividends Paid 54 55 Special Dividend Pard 56 Other Financing Acties 57 Cash from Financing 58 59 Forwign Exchange Rate Ad 60 Net Change in Cash 61 62 03 64 65 66 87 68 30 0908.09 1970) 5,8070 10 11.5510 (120) 27. (1.600 110 129.01 UD 1220 (70 . (10) 1290.01 70 71 72 73 74 75 16 77 28 79 30 31 32 23 34 35 37 Income Statement Balance Sheet Cash Flow
