33.8k views
4 votes
The comparative statements of Cullumber Company are presented here.

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
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.
Compute the following ratios for 2017. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.)
(a) Earnings per share $
(b) Return on common stockholders’ equity
%
(c) Return on assets
%
(d) Current ratio
(e) Accounts receivable turnover
times
(f) Average collection period
days
(g) Inventory turnover
times
(h) Days in inventory
days
(i) Times interest earned
times
(j) Asset turnover
times
(k) Debt to assets ratio
%
(l) Free cash flow $

1 Answer

1 vote

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

Step-by-step 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

User Ackdari
by
4.3k points