Question

In: Accounting

Crane Company has these comparative balance sheet data: CRANE COMPANY Balance Sheets December 31 2022 2021...

Crane Company has these comparative balance sheet data:

CRANE COMPANY
Balance Sheets
December 31

2022

2021

Cash

$ 27,105

$ 54,210

Accounts receivable (net)

126,490

108,420

Inventory

108,420

90,350

Plant assets (net)

361,400

325,260

$623,415

$578,240

Accounts payable

$ 90,350

$ 108,420

Mortgage payable (15%)

180,700

180,700

Common stock, $10 par

252,980

216,840

Retained earnings

99,385

72,280

$623,415

$578,240


Additional information for 2022:

1. Net income was $27,900.
2. Sales on account were $382,300. Sales returns and allowances amounted to $29,000.
3. Cost of goods sold was $207,500.
4. Net cash provided by operating activities was $57,000.
5. Capital expenditures were $28,900, and cash dividends were $17,900.


Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83 and all other answers to 1 decimal place, e.g. 1.8. Use 365 days for calculation.)

(a) Current ratio.

enter current ratio rounded to 2 decimal places

:1
(b) Accounts receivable turnover.

enter accounts receivable turnover in times rounded to 1 decimal place

times
(c) Average collection period.

enter average collection period in days rounded to 1 decimal place

days
(d) Inventory turnover.

enter inventory turnover in times rounded to 2 decimal places

times
(e) Days in inventory.

enter days in inventory rounded to 1 decimal place

days
(f) Free cash flow.

$enter free cash flow in dollars rounded to 1 decimal place

Solutions

Expert Solution

Answer to (a) Computation of Current Ratio for 31st December , 2022

Current Ratio = Current Assets / Current Liabilities

Here, Current Assets = Cash + Accounts Receivable (net) + Inventory

= 27,105 + 1,26,490 + 108,420

= $262,015

and Current Liabilities = Accounts Payable = $90,350

Mortgage payable is seemed to be long term because the balance is same balance as 2021 and no change so , mortgage payable is a long term laibility and the interest payable on mortage is also not accrued , its paid.Mortgage payable balance remains same as 2021. So interest payable on mortgage is not current liability.

Then, Current Ratio = 262015/90350 = 2.9 =2.9:1

Answer to (b) Computation of Accounts Receivable Turnover

Accounts Receivable Turnover = Net Credit Sales / Average Accounts Receivable

= (382,300 - 29000) / (126490+108420)/2

= 353300/117455

=3.0 = 3 times

Answer to (c) Computation of Average Collection Period

Average Collection Period = 365 / Accounts Receivable Turnover = 365/ 3 = 121.7 days

Answer to (d) Computation of inventory turnover

Inventory Turnover = Cost of goods sold / Average Inventory = 207500 / (108420+ 90350)/2

= 207500/ 99385

=2.09 ( 2 places of decimal)

= 2.09 times


Related Solutions

Sunland Company Comparative Balance Sheets December 31 Assets 2022 2021 Change Increase/Decrease Cash $94,400 $57,600 $36,800...
Sunland Company Comparative Balance Sheets December 31 Assets 2022 2021 Change Increase/Decrease Cash $94,400 $57,600 $36,800 Increase Accounts receivable 99,200 35,200 64,000 Increase Inventory 70,400 –0– 70,400 Increase Prepaid expenses 9,600 6,400 3,200 Increase Land 88,000 112,000 24,000 Decrease Buildings 320,000 320,000 –0– Accumulated depreciation—buildings (33,600 ) (22,400 ) 11,200 Increase Equipment 292,800 108,800 184,000 Increase Accumulated depreciation—equipment (44,800 ) (16,000 ) 28,800 Increase      Totals $896,000 $601,600 Liabilities and Stockholders’ Equity Accounts payable $68,800 $64,000 $4,800 Increase Accrued expenses payable...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2021 and 2020 ($ in millions) 2021 2020 Assets...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2021 and 2020 ($ in millions) 2021 2020 Assets Cash $ 109 $ 81 Accounts receivable 190 194 Investment revenue receivable 6 4 Inventory 205 200 Prepaid insurance 4 8 Long-term investment 156 125 Land 196 150 Buildings and equipment 412 400 Less: Accumulated depreciation (97 ) (120 ) Patent 30 32 $ 1,211 $ 1,074 Liabilities Accounts payable $ 50 $ 65 Salaries payable 6 11 Interest payable (bonds) 8 4 Income...
The current sections of Ivanhoe Company’s balance sheets at December 31, 2021 and 2022, are presented...
The current sections of Ivanhoe Company’s balance sheets at December 31, 2021 and 2022, are presented here. Ivanhoe Company’s net income for 2022 was $165,100. Depreciation expense was $27,300. 2022 2021 Current assets   Cash  $40,300 $ 57,850 Accounts receivable 55,250 44,850    Inventory 50,700 40,300 Prepaid expenses 11,050 12,350 Total current assets $157,300 $155,350 Current liabilities    Accrued expenses payable $ 3,900 $ 10,400    Accounts payable 57,200 46,800 Total current liabilities $61,100 $ 57,200 Prepare the net cash provided by operating activities section...
Balance sheet data for Kilroy Company for 2022 appears below: January 1, 2022 December 31, 2022...
Balance sheet data for Kilroy Company for 2022 appears below: January 1, 2022 December 31, 2022 ASSETS: Cash 27,000 43,000 Accounts receivable 39,000 26,000 Inventory 42,000 88,000 Prepaid insurance 21,000 29,000 Land 37,000 72,000 Equipment 61,000 94,000 Accumulated depreciation <14,000> <25,000> LIABILITIES + EQUITY: Accounts payable 33,000 41,000 Income taxes payable 21,000 15,000 Unearned revenue 25,000 39,000 Notes payable 51,000 75,000 Common stock 34,000 93,000 Retained earnings 49,000 64,000 Kilroy Company's 2022 income statement is given below: Sales revenue 329,000...
Balance sheet data for Kilroy Company for 2022 appears below: January 1, 2022 December 31, 2022...
Balance sheet data for Kilroy Company for 2022 appears below: January 1, 2022 December 31, 2022 ASSETS: Cash 27,000 43,000 Accounts receivable 39,000 26,000 Inventory 42,000 88,000 Prepaid insurance 21,000 29,000 Land 37,000 72,000 Equipment 61,000 94,000 Accumulated depreciation <14,000> <25,000> LIABILITIES + EQUITY: Accounts payable 33,000 41,000 Income taxes payable 21,000 15,000 Unearned revenue 25,000 39,000 Notes payable 51,000 75,000 Common stock 34,000 93,000 Retained earnings 49,000 64,000 Kilroy Company's 2022 income statement is given below: Sales revenue 329,000...
Shown below are comparative balance sheets for Schmitt Company. SCHMITT COMPANY Comparative Balance Sheets December 31...
Shown below are comparative balance sheets for Schmitt Company. SCHMITT COMPANY Comparative Balance Sheets December 31 Assets 2014 2013 Cash $ 72,080 $ 23,320 Accounts receivable 93,280 80,560 Inventory 177,020 200,340 Land 84,800 106,000 Equipment 275,600 212,000 Accumulated depreciation—equipment (69,960 ) (33,920 ) Total $632,820 $588,300 Liabilities and Stockholders’ Equity Accounts payable $ 41,340 $ 45,580 Bonds payable 159,000 212,000 Common stock ($1 par) 228,960 184,440 Retained earnings 203,520 146,280 Total $632,820 $588,300 Additional information: 1. Net income for 2014...
Here are comparative balance sheets for Velo Company. Velo Company Comparative Balance Sheets December 31 Assets...
Here are comparative balance sheets for Velo Company. Velo Company Comparative Balance Sheets December 31 Assets 2020 2019 Cash $73,400 $33,100 Accounts receivable 85,800 71,200 Inventory 170,200 187,000 Land 72,800 101,000 Equipment 260,600 200,800 Accumulated depreciation—equipment (66,100 ) (33,900 )    Total $596,700 $559,200 Liabilities and Stockholders’ Equity Accounts payable $35,000 $47,500 Bonds payable 151,400 203,400 Common stock ($1 par) 217,600 174,100 Retained earnings 192,700 134,200    Total $596,700 $559,200 Additional information: 1. Net income for 2020 was $103,600. 2. Cash dividends...
Here are comparative balance sheets for Velo Company. VELO COMPANY Comparative Balance Sheets December 31 Assets...
Here are comparative balance sheets for Velo Company. VELO COMPANY Comparative Balance Sheets December 31 Assets 2017 2016 Cash $ 72,800 $ 33,300 Accounts receivable 86,400 71,300 Inventory 170,200 186,700 Land 72,800 101,600 Equipment 260,000 200,000 Accumulated depreciation—equipment (66,500 ) (33,800 )    Total $595,700 $559,100 Liabilities and Stockholders’ Equity Accounts payable $ 35,000 $ 47,200 Bonds payable 150,800 203,600 Common stock ($1 par) 215,200 173,000 Retained earnings 194,700 135,300    Total $595,700 $559,100 Additional information: 1. Net income for 2017 was...
PHAROAH COMPANY Balance Sheets December 31 (in thousands) 2022 2021 Current assets    Cash and cash equivalents...
PHAROAH COMPANY Balance Sheets December 31 (in thousands) 2022 2021 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 570 500    Inventory 640 570    Prepaid expenses 130 160      Total current assets 1,670 1,590 Property, plant, and equipment (net) 410 380 Investments 110 110 Intangibles and other assets 530 510      Total assets $2,720 $2,590 Current liabilities $920 $890 Long-term liabilities 660 560 Stockholders’ equity—common 1,140 1,140      Total liabilities and stockholders’ equity $2,720 $2,590 PHAROAH COMPANY Income Statements For the...
The current sections of Larkspur, Inc.’s balance sheets at December 31, 2021 and 2022, are presented...
The current sections of Larkspur, Inc.’s balance sheets at December 31, 2021 and 2022, are presented here. Larkspur, Inc.’s net income for 2022 was $221,850. Depreciation expense was $39,150. 2022 2021 Current assets    Cash $152,250 $ 143,550    Accounts receivable 116,000 129,050    Inventory 243,600 249,400    Prepaid expenses 39,150 31,900 Total current assets $551,000 $553,900 Current liabilities    Accrued expenses payable $ 21,750 $ 7,250    Accounts payable 123,250 133,400 Total current liabilities $145,000 $ 140,650 Prepare the net cash provided (used) by operating...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT