3M and Dell Co.

See attached file for full problem description.

I need help just with the first 3 problems (Marked in red).

Please include references.

Evaluate the 3M and Dell companies' financial performance using trend and financial ratio analysis, and analyze their most recent statements of cash flows. You may include charts summarizing ratio and cash flow findings but need to analyze and evaluate that data in essay form.
a. Evaluate each firm's financial performance for the two most recent years available by (1) performing financial ratio analysis using Microsoft® Excel® Ratio Analysis Worksheet, (2) performing trend analysis on those financial ratios, and (3) comparing and contrasting the findings in essay form. Be sure to include a citation and reference the source of your financial information. A copy of the financial information can be attached, a URL provided, or re-created.

1) Current ratio
2) Quick ratio
3) Average collection period (days sales outstanding)
4) Inventory turnover ratio (if applicable)
5) Times interest earned
6) Debt-to-equity ratio
7) Net profit margin
8) Return on equity
9) Total asset turnover
10) Return on assets
11) Price-earnings ratio
b. For both of these years and companies:
1) Identify the amount of cash generated or used from each of operating, investing, and financing activities,
2) Identify what business changes occurred altering the company's use of cash from one year to the next;
3) Discuss whether or not the company is generating cash in a sustainable manner, and
4) Make recommendations as to how the company could better manage its cash flows in the future.