Question

Crane Company has these comparative balance sheet data:

CRANE COMPANY Balance Sheets December 31

2020 2019

Cash $33,900 $67,800
Accounts receivable (net) 158,200 135,600
Inventory 135,600 113,000
Plant assets (net) 452,000 406,800
$779,700 $723,200
Accounts payable $113,000 $135,600
Mortgage payable (15%) 226,000 226,000
Common stock, $10 par 316,400 271,200
Retained earnings 124,300 90,400
$779,700 $723,200

Additional information for 2020:

1. Net income was $29,200.
2. Sales on account were $379,100. Sales returns and allowances amounted to $28,000.
3. Cost of goods sold was $203,800.
4. Net cash provided by operating activities was $58,000.
5. Capital expenditures were $27,500, and cash dividends were $19,600.

Compute the following ratios at December 31, 2017. Round current ratio to 2 decimal places, and all other answers to 1 decimal place, Use 365 days for calculation.


a. Current ratio _______:1
b. Accounts receivable turnover _______times
c. Average collection period _______days
d. Inventory turnovefr _______times
e. Days inventory _______days
f. Free cash flow $_______

Answer 1

Answer and Explanation:

A. Current ratio= current assets/current liabilities

= 33900+158200+135600/113000 = 2.9

B. Account Receivable Turnover = Sales/ Average account receivables

= 379100 -28000/158200+135600/2) = 2.39

c) Average collection period =

365/ account receivable turnover

= 365/2.39 =

152.72 days

D. inventory turnover = cost of goods sold / average inventory

= 203800/135600+113000/2 = 1.64

E. Days in inventory = 365/inventory turnover=

365/1.64 = 222.561 Days

F. Cash debt coverage

= cash from operating activities - dividend / total debt

= (58000 - 19600 )/(226000) = 0.17

G. Current cash debt coverage = net cash provided by the operating activities / average current liabilities

=58000 /113000 + 135600/2) = 0.467

H. Cash flow available = cash flow from operating activities - Capital Expenditure- Cash Dividend

$(58000-27500-19600)

= $10900