| Ratio Analysis Spreadsheet |
| Use this spreadsheet for the ratio analysis required in the Units 4 and 5 Individual Projects. |
| Company Name |
| Year of the company's MOST RECENT annual report (10-K) |
| Liquidity Ratios: How well can a company pay its current debts quickly if the need arises? |
| Enter the following information to calculate your company's liquidity ratios. |
| Current Assets (located on the balance sheet) | | | | | | | This Year | | | | Caution: Use Current Assets, not Total Assets. |
| | | | | | | | Last Year |
| Current Liabilities (located on the balance sheet) | | | | | | | This Year | | | | Caution: Use Current Liabilities, not Total Liabilities. |
| | | | | | | | Last Year |
| Cash Balance (located on the balance sheet) | | | | | | | This Year | | | | Note: This may be listed as Cash and Cash Equivalents. |
| | | | | | | | Last Year |
| Net Receivables (located on the balance sheet) | | | | | | | This Year | | | | Note: This may be listed as Accounts Receivable or simply Receivables. |
| | | | | | | | Last Year |
| Marketable Securities (located on the balance sheet) | | | | | | | This Year | | | | Note: This may be listed as Short Term Investments. |
| | | | | | | | Last Year |
| Efficiency (Control) Ratios: How well is a company utilizing its current resources to generate assets? |
| Enter the following information to calculate your company's efficiency ratios. |
| Accounts Receivable (located on the balance sheet) | | | | | | | This Year | | | | Note: This may be listed as Accounts Receivable or simply Receivables. |
| | | | | | | | Last Year |
| Sales (located on the income statement) | | | | | | | This Year | | | | Note: This may be listed as Revenues on the income statement. |
| | | | | | | | Last Year | | | | Note: If multiple revenue sources, use sales (if it exists) or total revenues. |
| Cost of Goods Sold (located on the income statement) | | | | | | | This Year | | | | Note: This may be listed as Cost of Sales or Cost of Revenues. |
| | | | | | | | Last Year |
| Inventory (located on the balance sheet) | | | | | | | This Year | | | | Note: If there is no inventory, put an X in the yellow box in cell A37. |
| | ¬ put an X in this box if there is no inventory listed | | | | | | Last Year |
| Fixed Assets (located on the balance sheet) | | | | | | | This Year | | | | Note: This may be listed as property, plant, and equipment (net). |
| | | | | | | | Last Year |
| Leverage (Debt) Ratios: How much is the company relying on debt? Can the company meet its interest obligations? |
| Enter the following information to calculate your company's leverage ratios. |
| Total Liabilities (located on the balance sheet) | | | | | | | This Year | | | | Caution: Use total liabilities, not current liabilities. |
| | | | | | | | Last Year |
| Total Assets (located on the balance sheet) | | | | | | | This Year | | | | Caution: Use total assets, not current assets. |
| | | | | | | | Last Year |
| Total Stockholder's Equity (located on the balance sheet) | | | | | | | This Year | | | | Caution: Use the total amount, not just the amount listed as stock. |
| | | | | | | | Last Year |
| Earnings Before Interest and Taxes (located on income stmt.) | | | | | | | This Year | | | | Note: This is usually reported right below operating income. |
| | | | | | | | Last Year | | | | Note: If you don't see EBIT, use the income/loss reported right before interest expense. |
| Interest Expense (located on the income statement) | | | | | | | This Year |
| | | | | | | | Last Year |
| Profitability Ratios: Is the company profitable? |
| Enter the following information to calculate your company's profitability ratios. |
| Total Revenues (located on the income statement) | | | | | | | This Year | | | | Note: This may simply be listed as Net Sales or Net Revenues. |
| | | | | | | | Last Year |
| Gross Profit (located on the income statement) | | | | | | | This Year | | | | Note: This is usually reported right below Cost of Sales or Cost of Revenue. |
| | | | | | | | Last Year |
| Operating Profit (located on the income statement) | | | | | | | This Year | | | | Note: This may be reported as Operating Income or Income from Continuing Operations. |
| | | | | | | | Last Year |
| Net Income (located on the income statement) | | | | | | | This Year | | | | Note: This may be listed as net income from continuing operations. |
| | | | | | | | Last Year | | | | Note: This may be listed as net income attributable to common shareholders. |
| Total Assets (located on the balance sheet) | | | | | | | This Year | | | | Caution: Use total assets, not current assets. |
| | | | | | | | Last Year |
| Total Stockholder's Equity (located on the balance sheet) | | | | | | | This Year | | | | Caution: Use the total amount, not just the amount listed as stock. |
| | | | | | | | Last Year |
Jalessa25
copy_of_ratio_analysis_workbook.xlsx
