Altman Z-Score (Bankruptcy) Calculate the Altman Z-Score for Campbell for each year from 2017 through 2021. Do you see any concern that Campbell way be heading to bankruptcy?
Answer please with an explanation and details. thanks
Jul-30-2017 USD Jul-29-2018 USD Jul-28-2019 USD Aug-02-2020 USD Aug-01-2021 USD Currency ASSETS Cash And Equivalents Total Cash & ST Investments 3190 319.0 49.0 49.0 31.0 31.0 859.0 859.0 69.0 69.0 Accounts Receivable Other Receivables A19 Total Receivables 550.0 55.0 605.0 510.0 530 563.0 5250 49.0 574.0 530.0 45.0 575.0 544.0 51.0 595.0 Inventory Other Current Assets Total Current Assets 902.0 74 0 1,900.0 887.0 797.0 2.296.0 8630 499.0 1,967. 871.0 80.0 2.385.0 933.0 98.0 1,695.0 Gross Property Plant & Equipment Accumulated Depreciation Net Property. Plant & Equipment 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.5390 (2.917.0) 2.622.0 5,724.0 (3.1190) 2.605.0 69.0 77.0 4,017.0 3.415.0 920 38640 3.664.0 20 2.1450 3.986.0 3,350.0 Long-term Investments Goodwill Other Intangibles Deferred Tax Assets, LT Other Long-Term Assets Total Assets 3.981.0 3.239.0 2.115.0 1.1180 360 34.0 1.217.0 29.0 214.0 11 1124 6660 494.0 1.036 0 LIABILITIES Accounts Payable Accrued Exp. Short-term Borrowings Curr. Port of LT Debt Curr. Port. of Leases Curr.Income Taxes Payable Other Current Liabilities Total Current Liabilities 705.0 494.0 1.135.0 3900 1.070.0 513.0 37.0 220 814.0 5720 850.0 5000 21.0 15.0 6130 3.385.0 1,049.0 603.0 278.0 9210 70.0 24.0 130.0 3.075.0 1.0 20.0 156.0 2.395.0 10.0 8600 3.594.0 65.0 5.0 124.0 1,814.0 7.991.0 Long-Term Debt Long-Term Leases Pension & Other Post. Retire Benefits Dot. Tax Liability. Non-Curr. Other Non-Current Liabilities Total Liabilities 2492 0 7.0 508.0 490.0 1890 6,081.0 3470 9600 264.0 13,156.0 7.101.0 20 389.0 9240 235.0 12.036.0 4.990.0 188.0 4620 914.0 174.0 9.8010 5.0020 1880 341.0 1.051.0 184.0 8.580.0 Common Stock Additional Paid In Capital Retained Earings Treasury Stock Comprehensive Inc. and Other Total Common Equity 120 359.0 2385.0 (1.066 01 (530) 1,637.0 120 349.0 2 2240 (1.103.01 (118.01 1,364.0 120 3720 1.993.0 (1.076.0) (1980) 1,100.0 120 394.0 3.190.0 (1.023.0) (10.01 2.5419 120 414.0 3.742.0 (1.021.01 5.0 3,1520 Minority Interest 8.0 9.0 9.0 20 Total Equity 1.645.0 1.373.0 1.112.0 11.14 Total Liabilities And Equity 27 11.7244 Supplemental ilms Total Shares Out. on Balance Sheet Date 301.0 301.0 301.0 3020 3020 Market Price of Stock $46.20 $39.46 $45.00 $52.61 $41.73 Cash Flow For the Fiscal Period Ending Restased 12 months Jul-30-2017 USD Restased 12 months Jul-29-2010 USD Restated 12 months Jul-28-2019 USD Restated 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD Currency 887.0 1920 1.0 193.0 251.0 259.0 200 279.0 211.0 3150 48.0 1,628.0 2850 43.0 328.0 1.002.0 2750 420 3170 143.0 11.0 10.0 Net Income Depreciation & Amort Amort of Goodwill and Intangibles Depreciation & Amort. Total (Gain) Loss From Sale Of Assets (Gain) Loss On Sale Of Invest. Asset Writedown & Restructuring Costs Stock-Based Compensation Net Cash From Discontinued Ops Other Operating Activities Change in Acc. Receivable Change in Inventories Change in Acc. Pavable Change in Other Net Operating Assets Cash from Oos. (975.0) 49.0 9.0 61.0 21.0 64.0 18.0 60.0 2850 (2060) 28.0 46.0 (480) 127.01 1,236.0 116.0 61.0 9140 (308 01 56.0 (84.0) 780 27.0 1,410.0 320 1.0 47.0 58.0 3120 77.0 (11.01 36.0 125.0 (1.01 1.250.0 204.0 (30.01 (200) 145.0 (3.0) 1,3960 (910) (2001 (77.00 (164.0) (28.01 1.035.0 (338.01 (407.01 (6.781.0) 10.0 - (384.01 (470) 31.0 (299,0) (11.01 2.5480 Capital Expenditure Cash Acquisitions Divestitures Invest. in Marketable & Equity Securt. Not inc. Dec. in Loans OlginatedSold Other Investing Activities Cash from investing (275.01 (20) 1110 (2001 (368.0) (19.01 (7.197.0) 553.0 153.0 4.0 2.272.0 8.0 (158.0) 5.839.0 3200 Short Term Debe issued Long-Term Debt Issued Total Debt Issued Short Term Debt Repaid Lono-Term Debt Repaid Total Debt Repaid 8 247.0 211.0 8.458.0 (8 002 01 (490.00 (8.492.0) 10.2220 6.224.0 16,445.0 (9.94401 16101 (10.007.0) 5.839.0 (6 29.01 (702.0 15.998.0) 5.617.0 1,000.0 6,617.0 (6 90901 2 268.00 (9.177.0) 320.0 (580,0) 1921.00 (1.501.0) Issuance of Common Stock Repurchase of Common Stock 20 (459.01 23.0 (120) 20 (51.0) (109.01 (80) Common Dividends Paid Total Dividends Paid (420.01 (4200) (426.01 (426.0) (423.01 (423.0) (426.01 (426.0) (4390) (439.0) Special Dividend Paid Other Financing Activities Cash from Financing 3.0 (998.01 (970) 5,807.0 (1.0) (1.591.0) (12.01 (2.987.09 (1.669.0) 11.0 (80) 7. (1.0) 20 Foreign Exchange Rate Ad. Net Change in Cash alance Sheet alance Sheet as of Jul-30-2017 Reclassified Jul-29-2010 USD Jul-28-2019 USD Aug-02-2020 USD Aug-01-2021 USD USD 600 3190 319.0 49.0 49.0 310 31.0 859.0 859.0 69.0 arrency SSETS ash And Equivalents Total Cash & ST Investments ccounts Receivable her Receivables Total Receivables 5440 550.0 55.0 605.0 5100 530 563.0 525.0 49.0 574.0 5300 45.0 575.0 51.0 595.0 ventory her Current Assets Total Current Assets 9020 74.0 1,900.0 8870 797.0 2.296.0 863.0 499.0 1.967.0 871.0 80.0 2.385.0 933.0 98.0 1,695.0 moss Property Plant & Equipment ccumulated Depreciation Net Property, Plant & Equipment 6.043.0 (3.5890) 2.454.0 5.239.0 (2.7730) 2.466.0 5.215.0 (2.7600) 2.455.0 5.5390 (2.917.0) 2.6220 5.724.0 (3.119.01 2.605.0 69.0 77.0 4,017.0 3.415.0 3.986.0 3.350.0 3.581.0 3.239.0 ong-term Investments odwill her Intangibles oferred Tax Assets, LT ther Long Term Assets stal Assets 2. 115.0 1.1180 36.0 34.0 92.0 3.864.0 3.664.0 20 2.145.0 44344 29.0 2140 1.217.0 12:41 705.0 4940 1,135.0 3900 1.070.0 513.0 370 ABILITIES ccounts Payable ccrued Exp mort-term Borrowings urr. Port of LT Debt arr. Port of Leases arr. Income Taxes Payable her Current Liabilities Total Current Liabilities 6660 4940 10360 22.0 1.0 20.0 1560 2.395.0 814.0 5720 850.0 5000 21.0 15.0 6130 3.385.0 1.0490 6000 278.0 9210 70.0 24.0 130.0 3.075.0 10.0 8600 3.594.0 65.0 50 1240 1.8140 7.991.0 ong-Term Debt ong-Term Leases ansion & Other Post-Rebire. Benefits of Tax Liability. Non-Curr. her Non-Current Liabilities otal Liabilities 2.4920 7.0 5080 490.0 189.0 6.081.0 347.0 9600 264.0 13,156.0 7.101.0 20 3890 9240 235.0 12.036.0 4.990.0 1880 4620 914.0 174.0 9,803.0 5.002 0 1880 341.0 1.051.0 1840 8.580.0 ommon Stock dditional Paid In Capital stained Eaming easury Stock omprehensive Inc. and other Total Common Equity 120 359.0 2385.0 (1.066.0) (53.0) 1,637.0 12.0 349.0 2 224.0 (1.103.01 (118.0] 1,364.0 12.0 3720 1.993.0 (1.076.0) (1980) 1,103.0 120 394.0 3.1900 (1.023.0) (10.01 2.563.0 120 414.0 3.7420 (1.021.01 5.0 3,152.0 inority Interest 8.0 9.0 9.0 60 20 otal Equity 1.4450 1.373.0 2.154.0 tal Liabiles And Equity supplemental Items tal Shares out on Balance Sheet Date 301.0 301.0 301.0 302.0 302.0 arket Price of Stock $46.20 $39.45 $45.00 552 61 $41.73 Altman Z-Score (Bankruptcy) Calculate the Altman Z-Score for Campbell for each year from 2017 through 2021. Do you see any concern that Campbell way be heading to bankruptcy? Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.OE Where: A = working capital - total assets B = retained earnings + total assets C = earnings before interest & taxes - total assets D = market value of equity - total liabilities E = sales = total assets Jul-30-2017 USD Jul-29-2018 USD Jul-28-2019 USD Aug-02-2020 USD Aug-01-2021 USD Currency ASSETS Cash And Equivalents Total Cash & ST Investments 3190 319.0 49.0 49.0 31.0 31.0 859.0 859.0 69.0 69.0 Accounts Receivable Other Receivables A19 Total Receivables 550.0 55.0 605.0 510.0 530 563.0 5250 49.0 574.0 530.0 45.0 575.0 544.0 51.0 595.0 Inventory Other Current Assets Total Current Assets 902.0 74 0 1,900.0 887.0 797.0 2.296.0 8630 499.0 1,967. 871.0 80.0 2.385.0 933.0 98.0 1,695.0 Gross Property Plant & Equipment Accumulated Depreciation Net Property. Plant & Equipment 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.5390 (2.917.0) 2.622.0 5,724.0 (3.1190) 2.605.0 69.0 77.0 4,017.0 3.415.0 920 38640 3.664.0 20 2.1450 3.986.0 3,350.0 Long-term Investments Goodwill Other Intangibles Deferred Tax Assets, LT Other Long-Term Assets Total Assets 3.981.0 3.239.0 2.115.0 1.1180 360 34.0 1.217.0 29.0 214.0 11 1124 6660 494.0 1.036 0 LIABILITIES Accounts Payable Accrued Exp. Short-term Borrowings Curr. Port of LT Debt Curr. Port. of Leases Curr.Income Taxes Payable Other Current Liabilities Total Current Liabilities 705.0 494.0 1.135.0 3900 1.070.0 513.0 37.0 220 814.0 5720 850.0 5000 21.0 15.0 6130 3.385.0 1,049.0 603.0 278.0 9210 70.0 24.0 130.0 3.075.0 1.0 20.0 156.0 2.395.0 10.0 8600 3.594.0 65.0 5.0 124.0 1,814.0 7.991.0 Long-Term Debt Long-Term Leases Pension & Other Post. Retire Benefits Dot. Tax Liability. Non-Curr. Other Non-Current Liabilities Total Liabilities 2492 0 7.0 508.0 490.0 1890 6,081.0 3470 9600 264.0 13,156.0 7.101.0 20 389.0 9240 235.0 12.036.0 4.990.0 188.0 4620 914.0 174.0 9.8010 5.0020 1880 341.0 1.051.0 184.0 8.580.0 Common Stock Additional Paid In Capital Retained Earings Treasury Stock Comprehensive Inc. and Other Total Common Equity 120 359.0 2385.0 (1.066 01 (530) 1,637.0 120 349.0 2 2240 (1.103.01 (118.01 1,364.0 120 3720 1.993.0 (1.076.0) (1980) 1,100.0 120 394.0 3.190.0 (1.023.0) (10.01 2.5419 120 414.0 3.742.0 (1.021.01 5.0 3,1520 Minority Interest 8.0 9.0 9.0 20 Total Equity 1.645.0 1.373.0 1.112.0 11.14 Total Liabilities And Equity 27 11.7244 Supplemental ilms Total Shares Out. on Balance Sheet Date 301.0 301.0 301.0 3020 3020 Market Price of Stock $46.20 $39.46 $45.00 $52.61 $41.73 Cash Flow For the Fiscal Period Ending Restased 12 months Jul-30-2017 USD Restased 12 months Jul-29-2010 USD Restated 12 months Jul-28-2019 USD Restated 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD Currency 887.0 1920 1.0 193.0 251.0 259.0 200 279.0 211.0 3150 48.0 1,628.0 2850 43.0 328.0 1.002.0 2750 420 3170 143.0 11.0 10.0 Net Income Depreciation & Amort Amort of Goodwill and Intangibles Depreciation & Amort. Total (Gain) Loss From Sale Of Assets (Gain) Loss On Sale Of Invest. Asset Writedown & Restructuring Costs Stock-Based Compensation Net Cash From Discontinued Ops Other Operating Activities Change in Acc. Receivable Change in Inventories Change in Acc. Pavable Change in Other Net Operating Assets Cash from Oos. (975.0) 49.0 9.0 61.0 21.0 64.0 18.0 60.0 2850 (2060) 28.0 46.0 (480) 127.01 1,236.0 116.0 61.0 9140 (308 01 56.0 (84.0) 780 27.0 1,410.0 320 1.0 47.0 58.0 3120 77.0 (11.01 36.0 125.0 (1.01 1.250.0 204.0 (30.01 (200) 145.0 (3.0) 1,3960 (910) (2001 (77.00 (164.0) (28.01 1.035.0 (338.01 (407.01 (6.781.0) 10.0 - (384.01 (470) 31.0 (299,0) (11.01 2.5480 Capital Expenditure Cash Acquisitions Divestitures Invest. in Marketable & Equity Securt. Not inc. Dec. in Loans OlginatedSold Other Investing Activities Cash from investing (275.01 (20) 1110 (2001 (368.0) (19.01 (7.197.0) 553.0 153.0 4.0 2.272.0 8.0 (158.0) 5.839.0 3200 Short Term Debe issued Long-Term Debt Issued Total Debt Issued Short Term Debt Repaid Lono-Term Debt Repaid Total Debt Repaid 8 247.0 211.0 8.458.0 (8 002 01 (490.00 (8.492.0) 10.2220 6.224.0 16,445.0 (9.94401 16101 (10.007.0) 5.839.0 (6 29.01 (702.0 15.998.0) 5.617.0 1,000.0 6,617.0 (6 90901 2 268.00 (9.177.0) 320.0 (580,0) 1921.00 (1.501.0) Issuance of Common Stock Repurchase of Common Stock 20 (459.01 23.0 (120) 20 (51.0) (109.01 (80) Common Dividends Paid Total Dividends Paid (420.01 (4200) (426.01 (426.0) (423.01 (423.0) (426.01 (426.0) (4390) (439.0) Special Dividend Paid Other Financing Activities Cash from Financing 3.0 (998.01 (970) 5,807.0 (1.0) (1.591.0) (12.01 (2.987.09 (1.669.0) 11.0 (80) 7. (1.0) 20 Foreign Exchange Rate Ad. Net Change in Cash alance Sheet alance Sheet as of Jul-30-2017 Reclassified Jul-29-2010 USD Jul-28-2019 USD Aug-02-2020 USD Aug-01-2021 USD USD 600 3190 319.0 49.0 49.0 310 31.0 859.0 859.0 69.0 arrency SSETS ash And Equivalents Total Cash & ST Investments ccounts Receivable her Receivables Total Receivables 5440 550.0 55.0 605.0 5100 530 563.0 525.0 49.0 574.0 5300 45.0 575.0 51.0 595.0 ventory her Current Assets Total Current Assets 9020 74.0 1,900.0 8870 797.0 2.296.0 863.0 499.0 1.967.0 871.0 80.0 2.385.0 933.0 98.0 1,695.0 moss Property Plant & Equipment ccumulated Depreciation Net Property, Plant & Equipment 6.043.0 (3.5890) 2.454.0 5.239.0 (2.7730) 2.466.0 5.215.0 (2.7600) 2.455.0 5.5390 (2.917.0) 2.6220 5.724.0 (3.119.01 2.605.0 69.0 77.0 4,017.0 3.415.0 3.986.0 3.350.0 3.581.0 3.239.0 ong-term Investments odwill her Intangibles oferred Tax Assets, LT ther Long Term Assets stal Assets 2. 115.0 1.1180 36.0 34.0 92.0 3.864.0 3.664.0 20 2.145.0 44344 29.0 2140 1.217.0 12:41 705.0 4940 1,135.0 3900 1.070.0 513.0 370 ABILITIES ccounts Payable ccrued Exp mort-term Borrowings urr. Port of LT Debt arr. Port of Leases arr. Income Taxes Payable her Current Liabilities Total Current Liabilities 6660 4940 10360 22.0 1.0 20.0 1560 2.395.0 814.0 5720 850.0 5000 21.0 15.0 6130 3.385.0 1.0490 6000 278.0 9210 70.0 24.0 130.0 3.075.0 10.0 8600 3.594.0 65.0 50 1240 1.8140 7.991.0 ong-Term Debt ong-Term Leases ansion & Other Post-Rebire. Benefits of Tax Liability. Non-Curr. her Non-Current Liabilities otal Liabilities 2.4920 7.0 5080 490.0 189.0 6.081.0 347.0 9600 264.0 13,156.0 7.101.0 20 3890 9240 235.0 12.036.0 4.990.0 1880 4620 914.0 174.0 9,803.0 5.002 0 1880 341.0 1.051.0 1840 8.580.0 ommon Stock dditional Paid In Capital stained Eaming easury Stock omprehensive Inc. and other Total Common Equity 120 359.0 2385.0 (1.066.0) (53.0) 1,637.0 12.0 349.0 2 224.0 (1.103.01 (118.0] 1,364.0 12.0 3720 1.993.0 (1.076.0) (1980) 1,103.0 120 394.0 3.1900 (1.023.0) (10.01 2.563.0 120 414.0 3.7420 (1.021.01 5.0 3,152.0 inority Interest 8.0 9.0 9.0 60 20 otal Equity 1.4450 1.373.0 2.154.0 tal Liabiles And Equity supplemental Items tal Shares out on Balance Sheet Date 301.0 301.0 301.0 302.0 302.0 arket Price of Stock $46.20 $39.45 $45.00 552 61 $41.73 Altman Z-Score (Bankruptcy) Calculate the Altman Z-Score for Campbell for each year from 2017 through 2021. Do you see any concern that Campbell way be heading to bankruptcy? Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.OE Where: A = working capital - total assets B = retained earnings + total assets C = earnings before interest & taxes - total assets D = market value of equity - total liabilities E = sales = total assets
