1.5 1.1 Selected risk ratios are presented for 2011 and 2010 for Techtron Company. Also, refer to the financial statement data for the company. 2011 2010 Revenues to Cash Ratio 6.8 7.7 Days Revenues Held in Cash 47 Current Ratio Quick Ratio Operating Cash Flow to Average Current Liabilities Ratio 55.7% Days Accounts Receivable Days Inventory 51 Days Accounts Payable 47 Net Days Working Capital 72 Liabilities to Assets Ratio 0.559 0.621 Liabilities to Shareholders' Equity Ratio 1.266 Long-Term Debt to Long-Term Capital Ratio 0.330 0.418 Long-Term Debt to Shareholders' Equity Ratio 0.492 0.720 Operating Cash Flow to Total Liabilities Ratio 0.243 0.242 Interest Coverage Ratio 5.6 2.31 73 68 639 Financial Statements INCOME STATEMENT (in millions) 2012 $2.500 (1.252) 2011 $3,139 (1 288) 2010 $ 2,816 (1,099) Fiscal year end Sales Cost of Goods Sold Selling, General & Admin. Exp. Advertising Research and Development Royalty Expense Other Selling and Administrative Interest expense Income tax expense Net income (387) (157) (223) (385) (364) (143) (248) (799) (53) (69) $175 (297) (154) (296) (788) (78 (29) $ 75 (32) _64) $ 196 2012 2010 2009 R Balance Sheet Fiscal year end ASSETS (in millions) Cash Accounts Receivable Inventories Prepayments Total current assets Property, plant & equipment Other Assets Total assets $ 625 579 195 219 $1.618 $421 607 169 S 496 555 1 90 $1,409 $1,432 572 217 346 $1,368 236 1.765 $3.369 207 1,416 $3.241 $3.163 $3.143 JU LIABILITIES Accounts payable Short-term borrowing Other current liabilities $ 168 342 $ 159 $ 166 $123 36 584 24 749 578 599 $1,094 $939 $ 967 $ 158 303 687 1,166 Total current liabilities Long-term debt Other noncurrent liabilities Total liabilities 149 $1,546 141 $1,767 128 $1.952 $2,016 $ 105 381 1,776 $ 105 398 1,558 82 Common stock Additional Paid-in Capital Retained earnings Accumulated Other Comprehensive Income Treasury Stock Total Shareholders' equity Total Liabilities & Shareholders' Equity $ 105 458 1.430 (47) (755) $1 191 $3.143 $ 105 455 1,622 (68) (761) $1,353 $3.369 (649) $1,695 $3.241 (695) $1,396 $3.163 STATEMENT OF CASH FLOWS (in millions) 2012 $ 196 2010 $75 146 2011 $ 175 164 (52) 184 28 (26) (90) (147) $59 Operations Net Income Depreciation & Amortization (Increase) Decrease Accounts Receivables (Increase) Decrease Inventories (Increase) Decrease Prepayments (Decrease) Increase Accounts Payable & Other Current Liabilities Net Addbacks and Subtractions from operations Cash flows from operations Investing Property Plant and Equipment acquired Other Investing Transactions Cash Flows from Investing Financing Increase in Common Stock Increase (Decrease) in Short-term Borrowing Increase (Decrease) in Long-term Borrowing Acquisition of Common Stock Dividends Other Financing Transactions Cash flow from Financing Change in Cash Cash - Beginning of Year Cash-End of Year (579) ($85) ($62) (318) (384) (187) 309 199 (170) 60 (21) 243 ($311) $75 879 (21) (250) 496 $ 625 $ 421 233 $ 496 Required: Use the spreadsheet below to provide your calculations and answers on the appropriate columns a. Calculate the amounts of these ratios for 2012 b. Assess the changes in the short-term liquidity risk of Techtron between 2010 and 2012 and the level of that risk at the end of 2012. c. Assess the changes in the long-term solvency risk of Techtron between 2010 and 2012 and the level of that risk at the end of 2012