Solve the below:
Q: Evaluate each firm's financial performance for the two most recent years available by (1) performing financial ratio analysis using the Microsoft® Excel® Ratio Analysis Worksheet, (2) performing trend analysis on those financial ratios.
Your analysis should include at least eight from the following list:
| Liquidity & Asset Utilization Ratios |
|
This Year |
|
Last Year |
|
|
|
|
|
|
|
| Current Ratio |
|
|
|
|
|
| Current Assets |
|
|
|
|
|
| Current Liabilities |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Quick (Acid-Test) Ratio |
|
|
|
|
|
| Current Assets-Inventory |
|
|
|
|
|
| Current Liabilities |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Inventory Turnover |
|
|
|
|
|
| Cost of Goods Sold |
|
|
|
|
|
| Average Inventory |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Average Collection Period |
|
|
|
|
|
| Accounts Receivable |
|
|
|
|
|
| Average Daily Sales |
|
#DIV/0! |
|
#DIV/0! |
Days |
|
|
|
|
|
|
| Total Asset Turnover |
|
|
|
|
|
| Sales |
|
|
|
|
|
| Total Assets |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
| Debt & Interest Coverage Ratios |
|
|
|
|
|
|
|
|
|
|
|
| Debt to Assets Ratio |
|
|
|
|
|
| Total Liabilities |
|
|
|
|
|
| Total Assets |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Debt to Equity Ratio |
|
|
|
|
|
| Total Debt |
|
|
|
|
|
| Total Equity |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Interest Coverage Ratio |
|
|
|
|
|
| EBIT(Earnings Before Interest & Taxes) |
|
|
|
|
|
| Interest Expense |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profitability Ratios |
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin on Sales |
|
|
|
|
|
| Sales-Cost of Sales |
|
|
|
|
|
| Sales |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
| Net Profit Margin |
|
|
|
|
|
| Net Profit after taxes |
|
|
|
|
|
| Sales |
|
#DIV/0! |
|
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Market Based Ratio |
|
|
|
|
|
|
|
|
|
|
|
| Price-Earnings Ratio |
|
|
|
|
|
| Current Market Value of Common Stock |
|
|
|
|
|
| Earnings Per Share (EPS) |
|
#DIV/0! |
|
#DIV/0! |
|
For both of these years and companies:
Identify the amount of cash generated or used from each of operating, investing, and financing activities.
Use the companies' website or https://moneycentral.msn.com/investor/research.asp