RATIO ANALYSIS SPREADSHEET Company BALANCE SHEET RATIOS: Stability (Staying Power) 1 Current 2 Debt-to-Equity Current Assets Current Liabilities 5 Net Margin Total Liabilities Stockholder's Equity INCOME STATEMENT RATIOS: Profitability (Earning Power) 3 Gross Margin 4 Operating Profit Margin Gross Profit Revenue Operating Income Revenue 7 Return on Assets 8 Return on Equity 13 Net Income Revenue ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios 6 Earnings Quality Cash flow from Operations Net Income Net Income Total Assets Net Income Stockholder's Equity ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios 9 Inventory Tumover 10 Inventory Tum-Days Cost of Revenue/Goods Sold Inventory Inventory Tumover 11 Accounts Receivable Turnover Revenue Accounts Receivable 12 Accounts Receivable Turn-Days Enter data in highlighted fields only 360 360 Accla. Rec. Turnover Accounts Payable Turnover 14 Average Payment Period 20 Cost of Revenue/Goods Sold OUDIS Accounts Payable 360 Accts. Pay Tumover 360 HOTLINE 360 360 Industry Average Access csimarket.com and query by stock symbol-use TTM (trailing twelve months) data under Industry column n/a After accessing Yahoo finance financial statements, click on EXPAND ALL (top right side of statement) ra Ability to meet current obligations Proportion of equity and debt used to finance a company's assets. Gross Profit expressed as a % of Sales Operating Income expressed as a % of Sales Net Income expressed as a % of Sales Measures cash generated from sales; higher % the better Measures the profitability of using the assets Measures the profitability of the stockholders investment Measures the efficiency of moving the inventory Average # of days it takes to move inventory Measures the efficiency of collecting Accounts Receivable Average # of days it takes to collect Accounts Receivable Measures the efficiency of paying Accounts Payable Average # of days it takes to pay Accounts Payable

choose a company and fill out the spreadsheet.