Use the income statements and balance sheet statements to perform the following ratio analysis: (a) Liquidity_current...

 

Transcribed Image Text:

Use the income statements and balance sheet statements to perform the following ratio analysis: (a) Liquidity_current ratio, quick ratio, cash ratio (b) Asset Utilization _ A/R Turnover, Inventory Turnover, DSO, DIO, DPO, Operating Cycle, Cash Conversion Cycle. (c) Solvency Debt to Equity (d) Coverage Times Interest Earned (e) Profitability Profit margin, ROA, ROE (f) Market Metrics_ EPS (basic), P/E CPB Campbell Soup Co Fiscal Year End: 2020-07-31 DATE Income Statement (Annual) Revenue Cost of Goods Sold Gross Profit SG&A Expense Research and Development Expense Operating Income Non-Operating Interest Expense Non-Operating Interest Income Other Income (Expense) Earnings from continuing operations before taxes Provision for Income Taxes Net Earnings From Continuing Operations Net Earnings From Discontinued Operations Net Earnings Earnings Attributable to NonControlling Interest Extraordinary Items Net Income Attributable to Campbell Soup Co Special Income (Charges) Normalized Net Income Additional Items (Annual) EBIT Reconciled Depreciation EBITDA Normalized EBIT Normalized EBITDA Average Basic Shares Outstanding Average Diluted Shares Outstanding EPS Basic EPS Diluted Dividend Per Share Price Normalized EPS Basic Normalized EPS Diluted 2014-07-31 2015-07-31 CY2014 CY2015 8268 5297 2971 1505 122 1326 122 3 (59) 1148 374 774 81 855 11 0 866 866 1270 305 1575 1270 1575 314 316 2.76 2.74 1.25 41.59 2.76 2.74 8082 5300 2782 1485 117 1163 108 3 (109) 949 283 666 0 666 0 0 666 666 1057 303 1360 1057 1360 312 313 2.13 2.13 1.25 49.31 2.13 2.13 2016-07-31 2017-07-31 2018-07-31 CY2018 CY2016 CY2017 7961 5033 2928 1427 105 1376 115 4 (416) 849 286 563 0 563 0 0 563 563 964 308 1272 964 1272 309 311 1.82 1.81 1.25 62.27 1.82 1.81 5837 3395 2442 1123 93 1225 115 0 206 1316 392 924 (37) 887 0 0 887 887 1431 318 1749 1431 1749 305 307 2.91 2.89 1.40 52.83 2.91 2.89 6615 4241 2374 1291 91 972 183 3 38 830 106 724 (463) 261 0 0 261 261 1013 394 1407 1013 1407 301 302 0.87 0.86 1.40 40.90 0.87 0.86 2019-07-31 CY2019 8107 5414 2693 1452 91 1102 356 2 (123) 625 151 474 (263) 211 0 0 211 211 981 446 1427 981 1427 301 302 0.70 0.70 1.40 41.34 0.70 0.70 CPB Campbell Soup Co Fiscal Year End: 2020-07-31 DATE Balance Sheet (Annual) Assets (Annual) Cash and Equivalents Short Term Investments Accounts Receivable Other Receivables Inventories Other Current Assets Total Current Assets Net PP&E Goodwill and Intangibles Other Long Term Assets Total Long Term Assets Total Assets Liabilities (Annual) Accounts Payable Other Payables Accrued Expenses Current Debt & Capital Lease Obligation Other Current Liability Total Current Liabilities Non-Current Portion of LTD and Capital Lease Obligation Non Current Deferred Liability Other Long Term Liabilities Total Long Term Liabilities Total Liabilities Shareholder's Equity (Annual) Total Capital Stock Retained Earnings Additional Paid In Capital Treasury Stock Preferred Stock Unrealized Gain or Loss - Total Minimum Pension Liabilities Adjustments for Foreign Currency Translation Other Equity Adjustments Accrued Comprehensive Inc Noncontrolling Interest Shareholders Equity CY2014 232 0 585 85 1016 182 2100 2318 3608 87 6013 8113 527 138 299 1771 254 2989 2244 657 620 3521 6510 12 2198 330 356 0 0 0 0 0 (569) (12) 1603 CY2015 253 0 557 90 995 198 2093 2347 3549 88 5984 8077 544 130 322 1543 267 2806 2539 609 746 3894 6700 12 1754 339 556 0 0 0 0 0 (168) (4) 1377 CY2016 296 0 554 72 940 46 1908 2407 3415 107 5929 7837 610 122 325 1219 279 2555 2314 496 939 3749 6304 12 1927 354 664 0 0 0 0 0 (104) 8 1533 CY2017 319 0 550 55 902 74 1900 2454 3233 139 5826 7726 666 131 277 1037 284 2395 2499 586 601 3686 6081 12 2385 359 1066 0 0 0 0 0 (53) 8 1645 CY2018 49 0 510 53 887 797 2296 2466 7528 2239 12233 14529 705 117 351 1525 896 3594 7991 1050 521 9562 13156 12 2224 349 1103 0 0 0 0 0 (118) 9 1373 CY2018 31 0 525 49 863 499 1967 2455 7432 1294 11181 13148 814 122 367 1371 711 3385 7103 1003 545 8651 12036 12 1993 372 1076 0 0 0 0 0 (198) 9 1112 Use the income statements and balance sheet statements to perform the following ratio analysis: (a) Liquidity_current ratio, quick ratio, cash ratio (b) Asset Utilization _ A/R Turnover, Inventory Turnover, DSO, DIO, DPO, Operating Cycle, Cash Conversion Cycle. (c) Solvency Debt to Equity (d) Coverage Times Interest Earned (e) Profitability Profit margin, ROA, ROE (f) Market Metrics_ EPS (basic), P/E CPB Campbell Soup Co Fiscal Year End: 2020-07-31 DATE Income Statement (Annual) Revenue Cost of Goods Sold Gross Profit SG&A Expense Research and Development Expense Operating Income Non-Operating Interest Expense Non-Operating Interest Income Other Income (Expense) Earnings from continuing operations before taxes Provision for Income Taxes Net Earnings From Continuing Operations Net Earnings From Discontinued Operations Net Earnings Earnings Attributable to NonControlling Interest Extraordinary Items Net Income Attributable to Campbell Soup Co Special Income (Charges) Normalized Net Income Additional Items (Annual) EBIT Reconciled Depreciation EBITDA Normalized EBIT Normalized EBITDA Average Basic Shares Outstanding Average Diluted Shares Outstanding EPS Basic EPS Diluted Dividend Per Share Price Normalized EPS Basic Normalized EPS Diluted 2014-07-31 2015-07-31 CY2014 CY2015 8268 5297 2971 1505 122 1326 122 3 (59) 1148 374 774 81 855 11 0 866 866 1270 305 1575 1270 1575 314 316 2.76 2.74 1.25 41.59 2.76 2.74 8082 5300 2782 1485 117 1163 108 3 (109) 949 283 666 0 666 0 0 666 666 1057 303 1360 1057 1360 312 313 2.13 2.13 1.25 49.31 2.13 2.13 2016-07-31 2017-07-31 2018-07-31 CY2018 CY2016 CY2017 7961 5033 2928 1427 105 1376 115 4 (416) 849 286 563 0 563 0 0 563 563 964 308 1272 964 1272 309 311 1.82 1.81 1.25 62.27 1.82 1.81 5837 3395 2442 1123 93 1225 115 0 206 1316 392 924 (37) 887 0 0 887 887 1431 318 1749 1431 1749 305 307 2.91 2.89 1.40 52.83 2.91 2.89 6615 4241 2374 1291 91 972 183 3 38 830 106 724 (463) 261 0 0 261 261 1013 394 1407 1013 1407 301 302 0.87 0.86 1.40 40.90 0.87 0.86 2019-07-31 CY2019 8107 5414 2693 1452 91 1102 356 2 (123) 625 151 474 (263) 211 0 0 211 211 981 446 1427 981 1427 301 302 0.70 0.70 1.40 41.34 0.70 0.70 CPB Campbell Soup Co Fiscal Year End: 2020-07-31 DATE Balance Sheet (Annual) Assets (Annual) Cash and Equivalents Short Term Investments Accounts Receivable Other Receivables Inventories Other Current Assets Total Current Assets Net PP&E Goodwill and Intangibles Other Long Term Assets Total Long Term Assets Total Assets Liabilities (Annual) Accounts Payable Other Payables Accrued Expenses Current Debt & Capital Lease Obligation Other Current Liability Total Current Liabilities Non-Current Portion of LTD and Capital Lease Obligation Non Current Deferred Liability Other Long Term Liabilities Total Long Term Liabilities Total Liabilities Shareholder's Equity (Annual) Total Capital Stock Retained Earnings Additional Paid In Capital Treasury Stock Preferred Stock Unrealized Gain or Loss - Total Minimum Pension Liabilities Adjustments for Foreign Currency Translation Other Equity Adjustments Accrued Comprehensive Inc Noncontrolling Interest Shareholders Equity CY2014 232 0 585 85 1016 182 2100 2318 3608 87 6013 8113 527 138 299 1771 254 2989 2244 657 620 3521 6510 12 2198 330 356 0 0 0 0 0 (569) (12) 1603 CY2015 253 0 557 90 995 198 2093 2347 3549 88 5984 8077 544 130 322 1543 267 2806 2539 609 746 3894 6700 12 1754 339 556 0 0 0 0 0 (168) (4) 1377 CY2016 296 0 554 72 940 46 1908 2407 3415 107 5929 7837 610 122 325 1219 279 2555 2314 496 939 3749 6304 12 1927 354 664 0 0 0 0 0 (104) 8 1533 CY2017 319 0 550 55 902 74 1900 2454 3233 139 5826 7726 666 131 277 1037 284 2395 2499 586 601 3686 6081 12 2385 359 1066 0 0 0 0 0 (53) 8 1645 CY2018 49 0 510 53 887 797 2296 2466 7528 2239 12233 14529 705 117 351 1525 896 3594 7991 1050 521 9562 13156 12 2224 349 1103 0 0 0 0 0 (118) 9 1373 CY2018 31 0 525 49 863 499 1967 2455 7432 1294 11181 13148 814 122 367 1371 711 3385 7103 1003 545 8651 12036 12 1993 372 1076 0 0 0 0 0 (198) 9 1112

Answer rating: 100% (QA)

To perform ratio analysis using income statements and balance sheet statements we need specific fina... View the full answer