1) Using an Excel spreadsheet, you will create a three-year ratio trend analysis from the financial statements for Campbell soup. The trend will consist of the following ratios:

Current Ratio and the Quick Ratio from the I. Short term solvency, or liquidity, ratios category Return on Assets Ratio and the Return on Equity Ratio from the IV. Profitability ratios category Price Earnings Ratio and the Price Sales Ratio from the V. Market value ratios category. Then provide a one-page (minimum) discussion about what each trend indicates for your assigned corporation. Is the trend good or bad, why?

2) Using the ready ratios dot com study guide Download ready ratios dot com study guide, find the industry ratios for campbell soup. Note that the ratios provided in investing.com for your assigned corporation may not match your part (1) calculations exactly.

Compare your calculated ratios for your assigned corporation to the industry ratios. Then provide a one-page (minimum) discussion that details whether your assigned corporation is performing better or worse than the industry based on the definitions of the six ratios. Are your calculated trends from part (1) moving closer to or farther away from the industry averages? Is this good or bad?