Question: Data for Robert Company in 2011 and 2010 follow. These data should be used in Conjunction with the data in P1. Selected balances at the
Data for Robert Company in 2011 and 2010 follow. These data should be used in Conjunction with the data in P1.
.png)
Selected balances at the end of 2009 were accounts receivable (net), $103,400; inventory, $273,600; total assets, $732,800; accounts payable, $193,300; and stockholders' equity, $320,600. All Robert's notes payable were current liabilities, all its bonds payable were long-term liabilities.
Required
Performa a comprehensive ratio analysis following the steps outlined below. Round all answers to one decimal place.
1. Prepare a profitability analysis by calculating for each year the
(a) Current ratio,
(b) Quick Ratio,
(c) Receivable turnover
(d) Day's sales uncollected
(e) Inventory turnover,
(f) Days inventory on hand,
(g) Payable turnover, and
(h) Day's payable
2. Prepare a profitability analysis by calculating for each year the
(a) Profit margin,
(b) Asset turnover
(c) Return on assets, and
(d) Return on equity.
3. Prepare a long-term solvency analysis by calculating for each year the
(a) Debt to equity ratio and
(b) Interest coverage ratio
4. Prepare a cash flow adequacy analysis by calculating for each year the
(a) Cash flow yield
(b) Cash flows to sales,
(c) Cash flows to assets, and
(d) Free cash flow.
5. Prepare a market strength analysis by calculating for each year the
(a) Price/earnings (P/E) ratio and
(b) Dividends yields.
6. After making the calculations, indicate whether each ratio improved or deteriorated from 2010 to 2011. (use F for favorable and U for unfavorable and consider changes of 0.1 or less to beneutral)
2011 2010 Net capital expenditures Dividends paid Number of common shares Market price per share Net cash flows from operating activities (S98,000) 72,000 $20,000 532,500 $22,000 $17,200 20,000 30 20,000 S18
Step by Step Solution
3.24 Rating (173 Votes )
There are 3 Steps involved in it
These analyses indicate the apparently favorable or unfavorable change ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
95-B-M-A-P-E (305).xlsx
300 KBs Excel File
