AC499_Unit4_Practice_Solutions.xlsx - This sheet provides...

This sheet provides the answers to the PRACTICE Problem based on the Rainbow Paint Company Data
The sheet titled "Detail Computations" gives the specific ratio computations.
Ratio Solution
1 Working capital $750,000.00
2 Current ratio 2
3 Quick ratio 1
4 Accounts receivable turnover 13.33 Times
5 Number of days' sales in receivables 27.38 Days
6 Inventory turnover 5.67
7 Number of days' sales in inventory 64.41 Days
8 Ratio of fixed assets to long-term liabilities 1.73
9 Ratio of liabilities to stockholders' equity 1.04
10 Number of times interest charges earned 6.19 Times
11 Number of times preferred dividends earned 6.13 Times
12 Ratio of net sales to assets 1.43
13 Rate earned on total assets 6.98%
14 Rate earned on stockholders' equity 13.59%
15 Rate earned on common stockholders' equity 3.93%
16 Earnings per share on common stock $4.10
17 Price-earnings ratio 6.1
18 Dividends per share of common stock $0.90
19 Dividend yield 3.60%

Rainbow Paint Co. Comparative Income Statement For the Years Ended Decem
2013
Sales $5,125,000
Sales returns and allowances 125,000
Net sales $5,000,000
Cost of goods sold 3,400,000
Gross profit $1,600,000
Selling expenses $650,000
Administrative expenses 325,000