Question

In: Accounting

Question 8: The following company has sales of $30 million and a cost of goods sold...

Question 8: The following company has sales of $30 million and a cost of goods sold of $18 million. The balance sheet for period ending 31 December 2019 for this company appears below:

Assets                                                      $000

Liabilities and Shareholder Equity      $000

Cash                                                         2500  

Accounts Payable                                    1600

Accounts Receivable                             4400

Other Payables                                           900

Inventory                                                1500

Accruals                                                      1100

Total Current Assets                            8400

Total Current Liabilities                          3600

Property Plant and Equipment         10500

Long Term Debt                                        2500

Total Assets                                         18900

Total Liabilities                                         6100

Issued Equity                                           12800

Total Liability & Shareholder Equity 18900

a. Calculate the company’s net working capital in 2019.                         

b. Calculate the company’s cash cycle for 2019.

c. The industry average for accounts receivable is 28 days. What would this company’s cash cycle have been in 2019 if it had matched this industry average for accounts receivable? Comment on this new cash cycle outcome against b. above.

Solutions

Expert Solution

a) Net working Capital

Net WC = CURRENT ASSETS - CURRENT LIABILITIES

OR

= INVENTORY + RECIEVABLES - A/C PAYABLES

Both methods gives Net Working Capital,

Second method represents only the “core” accounts that make up working capital in the day-to-day operations of the business.

First Method ;

Net WC = 8400 - 3600

= 4800

Second Method ;

Net WC = 1500 + 4400 - 1600

= 4300

b) Cash Operating Cycle

= Inventory Days + Recievable Days - Payable Days

Inventory Days = Inventory ÷ Cost of Sales × 365

= 1500 ÷ 18000 × 365

= 30.4 days

Receivable Days = Receivables ÷ Credit Sales × 365

= 4400 ÷ 30000 × 365

= 53.5 days

Payable Days = Payables ÷ Cost of Sales × 365

= 1600 ÷ 18000 × 365

= 32.4 days

Therefore,

Cash Operating Cycle = 30.4 days + 53.5 days - 32. 4 days

= 51.5 -> 52 days

c) If Receivable days have been 28 days (Industry Average),then

​​Cash operating cycle = 30.4 + 28 - 32.4

= 26 Days.

Old Cash Operating Cycle is Twice as that of New Cash Operating Cycle, this indicates that the company is taking more time to convert thier assets into cash.

They almost have 54 days of Recievable days compared to industry Average of 28 days, so they have some liquidity issues with the recievables.

Hope the answer is clear and if you need any further information please let me know in the comment below.

Thank you!


Related Solutions

Dickson City Company has annual sales of $5 million, while the cost of goods sold is...
Dickson City Company has annual sales of $5 million, while the cost of goods sold is $3.2 million. All sales are made on a cash basis. The owner of Dickson has come up with the plan of giving credit to the customers. He believes that this will increase the sales by 25% without increasing any of the fixed costs. He thinks that 20% of the customers will pay within 30 days, 40% within 60 days, 37% within 90 days, and...
A company reports sales revenue of $314 million, cost of goods sold of $187 million, selling...
A company reports sales revenue of $314 million, cost of goods sold of $187 million, selling and administrative expenses of $77 million, depreciation of $20 million, and interest expense of $5 million. What is the company's after-tax operating income (to one decimal place) if the corporate tax rate is 30%?
A company reports sales revenue of $313 million, cost of goods sold of $183 million, selling...
A company reports sales revenue of $313 million, cost of goods sold of $183 million, selling and administration expenses of $79 million, depreciation of $20 million and interest expense of $9 million. What is the company's after-tax operating income (to one decimal place) if the corporate tax rate is 30%?
A small business has sales of $2 million, cost of goods sold of $12 million, net...
A small business has sales of $2 million, cost of goods sold of $12 million, net profit of $34,500,net fixed assets of $200,000, and total asset turnover of 5.25. What is the value of current assets?
Sigma Limited has sales of $100 million, cost of goods sold of $60 million, assets of...
Sigma Limited has sales of $100 million, cost of goods sold of $60 million, assets of $120 million, accounts receivables of $20 million and inventory of $30 million. Calculate days' sales in receivables ratio.
Extotech has sales of $50 million, cost of goods sold for the same period of $15...
Extotech has sales of $50 million, cost of goods sold for the same period of $15 million, and average inventory of $250,000. What is Exotech’s inventory turnover?                 a.            200                 b.            20                 c.             60                 d.            150 An inventory turn ratio of 25 means a company’s average quantity of goods in inventory sold within how many days?                 a.            5.2                 b.            25                 c....
The Greek Connection had sales of $ 29.9 million and a cost of goods sold of...
The Greek Connection had sales of $ 29.9 million and a cost of goods sold of $ 12.0 million in 2013. A simplified balance sheet for the firm appears? below: a. Calculate The Greek? Connection's net working capital in 2013. b. Calculate the cash conversion cycle of The Greek Connection in 2013. c. The industry average accounts receivable days is 30 days. What would have been the cash conversion cycle for The Greek Connection in 2013 had it met the...
Consider a company with sales of $18,000.0 million, cost of goods sold of 42% of sales, other expenses including salaries
Consider a company with sales of $18,000.0 million, cost of goods sold of 42% of sales, other expenses including salaries ( we usually call this SG&A for selling, general and administrative) of 1750.0million, depreciation of 2250.0 million, and interest expense of 2300 million. tax rate =21%.a. generate an income statement and show net incomeb. what is the company's operating cash flow?c. if there are 775.2 million shares outstanding, what is the EPS?d. if the company has a payout ratio of...
Cost of Goods Sold, Cost of Goods Manufactured Gauntlet Company has the following information for January:...
Cost of Goods Sold, Cost of Goods Manufactured Gauntlet Company has the following information for January: Cost of direct materials used in production $ 37,000 Direct labor 46,000 Factory overhead 20,000 Work in process inventory, January 1 22,000 Work in process inventory, January 31 30,000 Finished goods inventory, January 1 24,000 Finished goods inventory, January 31 18,000 a. For January, determine the cost of goods manufactured. $ b. For January, determine the cost of goods sold. $
Cost of Goods Sold, Cost of Goods Manufactured Glenville Company has the following information for April:...
Cost of Goods Sold, Cost of Goods Manufactured Glenville Company has the following information for April: Cost of direct materials used in production $54,000 Direct labor 66,000 Factory overhead 20,000 Work in process inventory, April 1 45,000 Work in process inventory, April 30 50,000 Finished goods inventory, April 1 25,000 Finished goods inventory, April 30 17,000 a. For April, determine the cost of goods manufactured. Using the data given, prepare a statement of Cost of Goods Manufactured. Glenville Company Statement...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT