Question

In: Accounting

Accounts payable, end of year $ 9,803 $ 13,748 Accounts receivable, net, end of year 31,885...

Accounts payable, end of year $ 9,803 $ 13,748
Accounts receivable, net, end of year 31,885 19,286
Inventory, end of year 12,104 11,655
Net sales 157,000 104,000
Cost of goods sold 76,000 115,000


(1) Use the information above to compute the number of days in the cash conversion cycle for each year.
(2) Did the company manage cash more effectively in the current year?

Use the information above to compute the number of days in the cash conversion cycle for each year. (Use 365 days in a year. Round calculations to the nearest whole day.)
Current year Prior year
Cash conversion cycle days days

Solutions

Expert Solution

ASSUMPTION Assuming End Inventory balances , Account receivable balances and Account payable balances are AVERAGE balance for prior year
Cash conversion time=DIO+DSO−DPO
where:
DIO=Days of inventory outstanding
(also known as days sales of inventory)
DSO=Days sales outstanding
DPO=Days payables outstanding
​		 Current year Prior year
                     60 Days                                                                  61 Days Yes Company has managed the cash effectively during the current year.
Calculation
DIO= Average Inventory/COGS*365
DSO= Average Account receivable/Total credit sales*365
DPO= Average account payable/COGS*365
Current year Previous year Calculation Current year Previous year calculation
DIO                57.05                36.99 ((12104+11655)/2)/76000*365 11655/115000*365
DSO=                59.48                67.69 ((31885+19286)/2)/157000*365 19286/104000*365
DPO=                56.55                43.63 ((9803+13748)/2)/76000*365 13748/115000*365

If you've any further query please let me know in the comment section. Please note that opening inventory, account payable and opening account receivable data of the previous year was not given. hence Average of these were assumed to be closing balances of previous year.

Please give "Thumps up" If you are satisfied with my answers.  

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Current Year Prior Year Accounts payable, end of year $ 6,943 $ 10,888 Accounts receivable, net,...
Current Year Prior Year Accounts payable, end of year $ 6,943 $ 10,888 Accounts receivable, net, end of year 24,625 17,328 Inventory, end of year 9,244 8,575 Net sales 184,000 137,000 Cost of goods sold 94,000 120,000 (1) Use the information above to compute the number of days in the cash conversion cycle for each year. (2) Did the company manage cash more effectively in the current year?
ARCH began the year with the following balances Accounts Payable ................$ 27,000 Accounts Receivable, net .............26,000...
ARCH began the year with the following balances Accounts Payable ................$ 27,000 Accounts Receivable, net .............26,000 Cash .....................10,000 Inventory ...................25,000 Notes Payable .................270,000 Permanently Restricted Net Assets ........100,000 Pledges Receivable ...............350,000 Property, Plant, and Equipment, net .........350,000 Temporarily Restricted Net Assets .........30,000 Unrestricted Net Assets .............302,000 Wages Payable ................32,000 Transactions 1. January 12. Received a $300,000 payment from a pledge made last year. 2. February 4. Placed an order for new cubible partitions with five-year useful lives, for $15,000. ARCH...
accounts payable and accounts receivable
What is the difference between accounts payable and accounts receivable?
Natcher Corporation’s accounts receivable at the end of Year 2 was $148,000 and its accounts receivable...
Natcher Corporation’s accounts receivable at the end of Year 2 was $148,000 and its accounts receivable at the end of Year 1 was $156,000. The company’s inventory at the end of Year 2 was $151,000 and its inventory at the end of Year 1 was $143,000. Sales, all on account, amounted to $1,404,000 in Year 2. Cost of goods sold amounted to $822,000 in Year 2. The company’s operating cycle for Year 2 is closest to: (Round your intermediate calculations...
roviding for Doubtful Accounts At the end of the current year, the accounts receivable account has...
roviding for Doubtful Accounts At the end of the current year, the accounts receivable account has a debit balance of $703,000 and sales for the year total $7,970,000. The allowance account before adjustment has a credit balance of $9,500. Bad debt expense is estimated at 3/4 of 1% of sales. The allowance account before adjustment has a credit balance of $9,500. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $30,400. The allowance account before...
Providing for Doubtful Accounts At the end of the current year, the accounts receivable account has...
Providing for Doubtful Accounts At the end of the current year, the accounts receivable account has a debit balance of $821,000 and sales for the year total $9,310,000. The allowance account before adjustment has a debit balance of $11,100. Bad debt expense is estimated at 1/4 of 1% of sales. The allowance account before adjustment has a debit balance of $11,100. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $35,500. The allowance account before...
Providing for Doubtful Accounts At the end of the current year, the accounts receivable account has...
Providing for Doubtful Accounts At the end of the current year, the accounts receivable account has a debit balance of $1,147,000 and sales for the year total $13,000,000. The allowance account before adjustment has a credit balance of $15,500. Bad debt expense is estimated at 3/4 of 1% of sales. The allowance account before adjustment has a credit balance of $15,500. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $49,600. The allowance account before...
The projected balance of accounts payable at the end of the first year of operation is?
A family friend, Mr. Burn Out availed of the early retirement scheme offered by his employer. He said that he was already tired of the same routine of spending eight full hours in an office doing the same thing for the last twenty years. Mr. Burn Out plans to get into the field of entrepreneurship. He would invest part of his retirement pay in a business that would deal with the sale of medical supplies to local clinics and hospitals....
The following information is from Remmer Company for the year 2017. Accounts Payable $145,000 Accounts Receivable...
The following information is from Remmer Company for the year 2017. Accounts Payable $145,000 Accounts Receivable 15,000 Cash (balance on January 1, 2017) 75,000 Cash (balance on December 31, 2017) Common Stock 100,000 Dividends 10,000 Equipment 755,000 Notes Payable 30,000 Office Expenses 95,000 Prepaid Rent 50,000 Retained Earnings (Jan 1 2017) 410,000 Retained Earnings (December 31, 2017) Salaries and Wages Expense 955,000 Salaries and Wages Payable 170,000 Sales Revenue 1,660,000 Supplies 25,000 Utilities Expense 530,000 Cash from Operating Activities 171,000...
Category Prior Year Current Year Accounts payable ??? ??? Accounts receivable 320,715 397,400 Accruals 40,500 33,750...
Category Prior Year Current Year Accounts payable ??? ??? Accounts receivable 320,715 397,400 Accruals 40,500 33,750 Additional paid in capital 500,000 541,650 Cash 17,500 47,500 Common Stock 94,000 105,000 COGS 328,500 428,048.00 Current portion long-term debt 33,750 35,000 Depreciation expense 54,000 54,731.00 Interest expense 40,500 41,017.00 Inventories 279,000 288,000 Long-term debt 339,670.00 401,877.00 Net fixed assets 946,535 999,000 Notes payable 148,500 162,000 Operating expenses (excl. depr.) 126,000 161,905.00 Retained earnings 306,000 342,000 Sales 639,000 850,323.00 Taxes 24,750 48,686.00 What is...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT