Answer:
Cullumber Company
(a) Earnings per share = Net Income / No. of outstanding common shares
= $ 206,900/58,000
$
3.57
(b) Return on common stockholders’ equity = Net Income/Equity
= $ 206,900/603,400 * 100
= 34.29%
(c) Return on assets = Net Income/Assets * 100
= $206,900/$1,050,800 * 100
= 19.69%
(d) Current ratio = Current Assets/ Current Liabilities
= $387,800/213,400
= 1.82
(e) Accounts receivable turnover = Sales /Average Receivable
= $1,899,240/119,000
= 15.96 times
Average receivable = (126,500 + 111,500)/2 = 119,000
(f) Average collection period = Average Receivable/Sales * 365
= 119,000/1,899,240 * 365
= 22,87 days
(g) Inventory turnover = cost of goods sold/average inventory
= 1,067,240/121,950
= 8.75 times
Average Inventory = )127,200 + 116,700
)/2 = 121,950
(h) Days in inventory = 365/8.75
41.71 days
(i) Times interest earned = EBIT/Interest Expense
= $323,300/23,200
= 13.94 times
(j) Asset turnover = Sales/Average Assets
= 1.97 times
(k) Debt to assets ratio = Total Liabilities/Total Assets
= $447,400/$1,050,800 * 100
= 42.58%
(l) Free cash flow
= Operating Cash Minus CAPEX
= $246,000 - $135,000 = $111,000
= $111,000
Explanation:
a) Data:
CULLUMBER COMPANY
Income Statements
For the Years Ended December 31
2017 2016
Net sales $1,899,240 $1,759,200
Cost of goods sold 1,067,240 1,014,700
Gross profit 832,000 744,500
Selling and administrative expenses 508,700 487,700
Income from operations 323,300 256,800
Other expenses and losses
Interest expense 23,200 21,200
Income before income taxes 300,100 235,600
Income tax expense 93,200 74,200
Net income $ 206,900 $ 161,400
CULLUMBER COMPANY
Balance Sheets
December 31
Assets 2017 2016
Current assets
Cash $ 60,100 $ 64,200
Debt investments (short-term) 74,000 50,000
Accounts receivable 126,500 111,500
Inventory 127,200 116,700
Total current assets 387,800 342,400
Plant assets (net) 663,000 534,300
Total assets $1,050,800 $876,700
Liabilities and Stockholders’ Equity
Current liabilities
Accounts payable $ 168,700 $154,100
Income taxes payable 44,700 43,200
Total current liabilities 213,400 197,300
Bonds payable 234,000 214,000
Total liabilities 447,400 411,300
Stockholders’ equity
Common stock ($5 par) 290,000 300,000
Retained earnings 313,400 165,400
Total stockholders’ equity 603,400 465,400
Total liabilities and
stockholders’ equity $1,050,800 $876,700
Others:
All sales were on account. Net cash provided by operating activities for 2017 was $246,000. Capital expenditures were $135,000, and cash dividends were $58,900
b) Explanation:
Asset Turnover = Sales/Average Assets
= $1,899,240/$963,750
= 1.97 times
Average assets = ($1,050,800 + $876,700
)/2 = $963,750
Debit to asset ratio = Total Liabilities/Total Assets
= $447,400/$1,050,800 * 100
= 42,58%
Free Cash Flow = Operating Cash Minus CAPEX
= $246,000 - $135,000 = $111,000
