Liquidity Ratios RATIO ANALYSIS ON TARGET CORPORATION Historical for the Fiscal Years 2011-2015 2011 2012 2013...

Transcribed Image Text:

Liquidity Ratios RATIO ANALYSIS ON TARGET CORPORATION Historical for the Fiscal Years 2011-2015 2011 2012 2013 2014 2015 Current ratio 1.7 1.2 1.2 0.9 1.2 Quick ratio 0.96 0.60 0.60 0.26 0.45 Inventory to net working capital 1.06 3.66 3.35 -6.88 3.74 Cash ratio 0.17 0.06 0.06 0.05 0.19 Profitability Ratios Net profit margin 4.3% 4.2% 4.1% 2.8% -2.3% Gross profit margin 32.1% 31.5% 31.0% 29.8% 29.4% Return on investment (ROI) 6.7% 6.3% 6.2% 4.4% -4.0% Return on equity (ROE) 18.9% 18.5% 18.1% 12.1% -11.7% Earnings per share (EPS) $4.03 $4.31 $4.57 $3.10 ($2.58) Activity Ratios Inventory turnover 8.9 8.8 9.3 8.6 8.3 Asset turnover 1.5 1.5 1.5 1.6 1.8 Fixed asset turnover 2.6 2.4 2.4 2.7 2.8 Average collection period (days) 33.3 31.0 29.1 0.0 0.0 Accounts receivable turnover 0.26 0.24 0.23 0.00 0.00 Leverage Ratios Debt-to-asset ratio 26.9% 35.3% 33.5% 28.2% 30.9% Debt-to-equity ratio 76.0% 104.2% 97.5% 77.5% 91.4% Long-term debt to capital structure 75.2% 85.0% 88.5% 70.4% 90.8% Times interest earned 6.9 6.6 8.4 4.9 5.1 Fixed-charge coverage no data for property leasing in balance sheet Other Ratios Price/earnings ratio Dividend payout ratio Dividend yield on common stock no data on market price per share in income statement no data on dividends per share in income statement no data on market price per share in income statement Liquidity Ratios RATIO ANALYSIS ON TARGET CORPORATION Historical for the Fiscal Years 2011-2015 2011 2012 2013 2014 2015 Current ratio 1.7 1.2 1.2 0.9 1.2 Quick ratio 0.96 0.60 0.60 0.26 0.45 Inventory to net working capital 1.06 3.66 3.35 -6.88 3.74 Cash ratio 0.17 0.06 0.06 0.05 0.19 Profitability Ratios Net profit margin 4.3% 4.2% 4.1% 2.8% -2.3% Gross profit margin 32.1% 31.5% 31.0% 29.8% 29.4% Return on investment (ROI) 6.7% 6.3% 6.2% 4.4% -4.0% Return on equity (ROE) 18.9% 18.5% 18.1% 12.1% -11.7% Earnings per share (EPS) $4.03 $4.31 $4.57 $3.10 ($2.58) Activity Ratios Inventory turnover 8.9 8.8 9.3 8.6 8.3 Asset turnover 1.5 1.5 1.5 1.6 1.8 Fixed asset turnover 2.6 2.4 2.4 2.7 2.8 Average collection period (days) 33.3 31.0 29.1 0.0 0.0 Accounts receivable turnover 0.26 0.24 0.23 0.00 0.00 Leverage Ratios Debt-to-asset ratio 26.9% 35.3% 33.5% 28.2% 30.9% Debt-to-equity ratio 76.0% 104.2% 97.5% 77.5% 91.4% Long-term debt to capital structure 75.2% 85.0% 88.5% 70.4% 90.8% Times interest earned 6.9 6.6 8.4 4.9 5.1 Fixed-charge coverage no data for property leasing in balance sheet Other Ratios Price/earnings ratio Dividend payout ratio Dividend yield on common stock no data on market price per share in income statement no data on dividends per share in income statement no data on market price per share in income statement