A) Did the company manage its noncash working capital effectively? Explain
B)The company’s banker is worried. Why?
The comparative, unclassifi ed statement of financial position for Alton Ltd. shows the following balances at December 31:
Alton
Ltd. Statement of Financial Position December 31 |
||||||
2018 | 2017 | |||||
Assets | ||||||
Cash | $ 5,000 | $ 36,000 | ||||
Term deposits (maturing in 60 days) | 0 | 42,000 | ||||
Accounts receivable | 75,000 | 40,000 | ||||
Inventory | 101,000 | 70,000 | ||||
Land | 180,000 | 230,000 | ||||
Buildings | 923,000 | 524,000 | ||||
Accumulated depreciation—buildings | (136,000 | ) | (190,000 | ) | ||
Equipment | 100,000 | 70,000 | ||||
Accumulated depreciation—equipment | (41,000 | ) | (20,000 | ) | ||
Total assets | $1,207,000 | $802,000 | ||||
Liabilities and Shareholders’ Equity | ||||||
Accounts payable | $ 29,000 | $ 72,000 | ||||
Income tax payable | 3,000 | 5,000 | ||||
Interest payable | 18,000 | 13,000 | ||||
Bank loan payable—current portion | 56,000 | 40,000 | ||||
Bank loan payable—non-current portion | 891,000 | 420,000 | ||||
Common shares | 160,000 | 180,000 | ||||
Retained earnings | 50,000 | 72,000 | ||||
Total liabilities and shareholders’ equity | $1,207,000 | $802,000 |
Additional information regarding 2018:
1. | Net income was $10,000. | |
2. | A loss of $21,000 was recorded on the disposal of a small parcel of land. No land was purchased during the year. | |
3. | A gain on disposal of $15,000 was recorded when an old building was sold for $40,000 cash. A new building was purchased for $520,000 and depreciation expense on buildings for the year was $42,000. | |
4. | Equipment costing $72,000 was purchased while a loss of $11,000 was recorded on equipment that originally cost $42,000 and was sold for $21,000. | |
5. | The company received $512,000 from new bank loans during the year. | |
6. | Dividends were declared and paid during the year. | |
7. |
No common shares were issued during the year but some were bought back and retired at the amount they were originally issued at. |
Where CA = Cash + Term deposits + Accounts receivable + Inventory and
Current Liabilities = Accounts payable + Income Tax payable + Interest payable + Bank loan payable (current portion only)
For 2017:
CA = $36,000 + $42,000 + $40,000 + $70,000 = $188,000.
CL = $72,000 + $5,000 + $13,000 + $40,000 = $130,000.
WC = $188,000 - $130,000 = $58,000.
For 2018:
CA = $5,000 + $0 + $75,000 + $101,000 = $181,000.
CL = $29,000 + $3,000 + $18,000 + $56,000 = $106,000.
WC = $181,000 - $106,000 = $75,000.
The company has not managed its working capital effectively. The cash and term deposits balance has reduced substantially whereas the accounts receivable balance has increased implying that the accounts receivable and inventory take a longer time to convert to cash. Similarly accounts payable and income tax payable have reduced implying that the credit that the company gets is reduced. This has all led to an increase in interest payable and bank loan payable. Further the non-current portion of the bank loan has increased significantly. This has given a net impact of $17,000 increase in working capital. For these reasons, the company has not managed its working capital effectively.
A) Did the company manage its noncash working capital effectively? Explain B)The company’s banker is worried....
a)Did the company manage its noncash working capital effectively? b)The company’s banker is worried. Why? SaLEMENIL UITMancial TOSICIOTT December 31 2018 2017 Assets Cash $5,000 $36,000 Term deposits (maturing in 60 days) 42,000 Accounts receivable 75,000 40,000 Inventory 101,000 70,000 Land 180,000 230,000 Buildings 923,000 524,000 Accumulated depreciation-buildings (136,000) (190,000) Equipment 100,000 70,000 Accumulated depreciation-equipment (41,000) (20,000) Total assets $1,207,000 $802,000 Liabilities and Shareholders' Equity Accounts payable $ 29,000 $72,000 Income tax payable 3,000 5,000 Interest payable 18,000 13,000 Bank...
The comparative, unclassified statement of financial position for Alton Ltd. shows the following balances at December 31: 2017 Alton Ltd. Statement of Financial Position December 31 2018 Assets Cash $5,000 Term deposits (maturing in 60 days) Accounts receivable 75,000 Inventory 101,000 Land 180,000 Buildings 923,000 Accumulated depreciation-buildings (136,000) Equipment 100,000 Accumulated depreciation-equipment (41,000) Total assets $1,207,000 Liabilities and Shareholders' Equity Accounts payable $ 29,000 Income tax payable 3,000 Interest payable 18,000 Bank loan payable-current portion 56,000 Bank loan payable-non-current portion...
The comparative, unclassified statement of financial position for Ivanhoe Ltd. shows the following balances at December 31: Ivanhoe Ltd. Statement of Financial Position December 31 Assets 2018 2017 Cash $ 16,000 $ 38,000 Term deposits (maturing in 60 days) 0 46,000 Accounts receivable 77,000 40,000 Inventory 104,000 68,000 Land 187,000 234,000 Buildings 908,000 529,000 Accumulated depreciation—buildings (134,000 ) (188,000 ) Equipment 96,000 67,000 Accumulated depreciation—equipment (39,000 ) (21,000 ) Total assets $1,215,000 $813,000 Liabilities and Shareholders’ Equity Accounts payable $...
he comparative, unclassified statement of financial position for Ivanhoe Ltd. shows the following balances at December 31: Ivanhoe Ltd. Statement of Financial Position December 31 Assets 2018 2017 Cash $ 16,000 $ 38,000 Term deposits (maturing in 60 days) 0 46,000 Accounts receivable 77,000 40,000 Inventory 104,000 68,000 Land 187,000 234,000 Buildings 908,000 529,000 Accumulated depreciation—buildings (134,000 ) (188,000 ) Equipment 96,000 67,000 Accumulated depreciation—equipment (39,000 ) (21,000 ) Total assets $1,215,000 $813,000 Liabilities and Shareholders’ Equity Accounts payable $...
can you expain with steps? The comparative, unclassified statement of financial position for Sunland Ltd. shows the following balances at December 31: Cash $0 Sunland Ltd. Statement of Financial Position December 31 Assets 2018 2017 $ 43,000 Accounts receivable 22,000 37,000 Inventory 35,000 57,000 Land 96,000 105,000 Buildings 523,000 259,000 Accumulated depreciation-buildings (72,000) (104,000) Equipment 75,000 38,000 Accumulated depreciation-equipment (12,000) (6,000) Total assets $710,000 $386,000 Liabilities and Shareholders' Equity Bank overdraft $0 $11,000 Accounts payable $ 42,000 $ 21,000 Income...
The comparative, unclassified statement of financial position for Ivanhoe Ltd. shows the following balances at December 31: Ivanhoe Ltd. Statement of Financial Position December 31 Assets 2018 2017 Cash $ 18,000 $ 39,000 Term deposits (maturing in 60 days) 0 41,000 Accounts receivable 78,000 41,000 Inventory 104,000 73,000 Land 185,000 230,000 Buildings 902,000 525,000 Accumulated depreciation—buildings (137,000 ) (191,000 ) Equipment 104,000 74,000 Accumulated depreciation—equipment (38,000 ) (19,000 ) Total assets $1,216,000 $813,000 Liabilities and Shareholders’ Equity Accounts payable $...
The comparative, unclassified statement of financial position for Ivanhoe Ltd. shows the following balances at December 31: Ivanhoe Ltd. Statement of Financial Position December 31 Assets 2018 2017 Cash $ 16,000 $ 38,000 Term deposits (maturing in 60 days) 0 46,000 Accounts receivable 77,000 40,000 Inventory 104,000 68,000 Land 187,000 234,000 Buildings 908,000 529,000 Accumulated depreciation—buildings (134,000 ) (188,000 ) Equipment 96,000 67,000 Accumulated depreciation—equipment (39,000 ) (21,000 ) Total assets $1,215,000 $813,000 Liabilities and Shareholders’ Equity Accounts payable $...
1. Based on the following data, what is the amount of working capital? Accounts payable....................$32,000 Accounts receivable....................64,000 Accrued liabilities....................7,000 Cash.........................................20,000 Intangible assets............................40,000 Inventory...............................................72,000 Long-term investments...............................100,000 Long-term liabilities.....................................75,000 Marketable securities.................................35,000 Notes payable (short-term)........................20,000 Property, plant, and equipment.................625,000 Prepaid expenses.........................................2,000 WHAT IS WORKING CAPITAL? a. $162,000 b. $134,000 c. $193,000 d. $62,000 2. Use the following data to determine the total dollar amount of assets to be classified as current assets. Cash..............................................$60,000 Prepaid insurance..........................40,000 Accounts receivable......................50,000 Inventory.........................................70,000 Land held for investment................80,000 Land................................................95,000...
The balance sheet data of Ke Company at the end of 2020 and 2019 follow: 2020 2019 Cash $100,000 $140,000 Accounts Receivable (net) 240,000 180,000 Inventory 280,000 180,000 Prepaid expenses 40,000 100,000 Buildings and equipment 360,000 300,000 Accumulated depreciation - buildings and equipment (72,000) (32,000) Land 360,000 160,000 Total Assets $1,308,000 $1,028,000 Accounts payable $272,000 $220,000 Accrued expenses 48,000 72,000 Mortgage payable 120,000 160,000 Common stock, $10 par 836,000 636,000 Retained earnings 32,000 (60,000) Total liabilities and equity $1,308,000 $1,028,000...
The comparative balance sheets for Spicer Company as of December 31 are presented below Spicer Company Comparative Balance Sheets December 31 Assets Cash Accounts receivable Inventory Prepaid expenses Land Buildings Accumulated depreciation-buildings Equipment Accumulated depreciation-equipment Total 2017 2016 $ 45,000 58,000 142,000 21,000 130,000 200,000 (40,000 ) 155,000 68,000 50,000 151,450 15,280 145,000 200,000 (60,000) 225,000 (45,000) (35,000) $749,730 $676,000 Liabilities and Stockholders Equity Accounts payable Bonds payable Common stock, $1 par Retained earnings Total $ 36,000 300,000 160,000 180,000...