Q12
DIO | 365*Average Inventory/Cost of goods sold | Average Cost of Goods sold | 360000 | ||||||||
76.04167 | Average inventory | 75000 | |||||||||
Annual Sales | 600000 | ||||||||||
Average Accounts receivables | 160000 | ||||||||||
DSO | 365*average accounts receivables/credit sales | Average accounts payables | 25000 | ||||||||
97.33333 | |||||||||||
DPO | 365*average payables/cost of goods sold | ||||||||||
25.34722 | |||||||||||
Cash conversion Cycle=DIO+DSO-DPO | |||||||||||
148.0278 | |||||||||||
Answer is E |
Q13
BEFORE | AFTER | |||||||||||
Average Cost of Goods sold | 43124750 | Average Cost of Goods sold | 43124750 | |||||||||
Average inventory | 15012000 | Average inventory | 13066000 | |||||||||
Annual Sales | 50735000 | Annual Sales | 50735000 | |||||||||
Average Accounts receivables | 10008000 | Average Accounts receivables | 8062000 | |||||||||
Average accounts payables | Average accounts payables | |||||||||||
DIO | 365*Average Inventory/Cost of goods sold | |||||||||||
127.0588 | 110.5882 | |||||||||||
DSO | 365*average accounts receivables/credit sales | |||||||||||
72 | 58 | |||||||||||
DPO | 365*average payables/cost of goods sold | |||||||||||
30 | 40 | |||||||||||
Cash conversion Cycle=DIO+DSO-DPO | ||||||||||||
169.0588 | 128.5882 | 40.47059 | Answer is E |
Q14
Answer is b.False |
If the firm changes the credit terms from 2/10 net 30 to 3/10 net 30. The number of credit days remains at 30 days. Discount percent is increased to 3% from 2% to match the competitors. |
There are 2 methods for accounting the discounts. One is Gross and another is net methods. |
In Net method, receivables are recorded at sale price - discount even if customer makes use of the discount or does not. If customer does not make use of the discount, a interest revenue is recognized (difference between face value and discounted value) |
In gross method, receivables are recorded at face value |
In both the methods, receivables will remain constant and not change. |
Q15
Answer is b. False | ||
Year 1 (in Million) | Year 2 (in Million) | |
Sales | 5 | 5.5 |
Account receivables (90% credit) | 4.5 | 4.95 |
This clearly shows account receivables will also grow with increase in sales. | ||
12. Marshall Inc. recently hired your conting firm to improve the company's performance. It has been highly profita...
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? Average inventory = $75,000 Annual sales = $600,000 Annual cost of goods sold = $360,000 Average accounts receivable = $180,000...
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? Average inventory = $75,000 Annual sales = $600,000 Annual cost of goods sold = $360,000 Average accounts receivable = $180,000...
Marshall Inc. recently hired your consulting firm to improve the company's performance. It has been highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365 day year, what is the firm's present cash conversion cycle? Enter your answer rounded to two decimal places. For example, if your answer is 123.45% or 1.2345 then enter...
Your consulting firm was recently hired to improve the performance of Shin-Soenen Inc, which is highly profitable but has been experiencing cash shortages due to its high growth rate. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? Average inventory = $75,000 Annual sales = $775,000 Annual cost of goods sold = $465,000 Average accounts receivable = $160,000...
Please show in Excel! Your consulting firm was recently hired to improve the performance of Rumpke, which has been experiencing cash shortages due to its high growth rate. You want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? Average inventory $75,000 Annual sales $500,000 Annual cost of goods sold $360,000 Average accounts receivable $160,000 Average accounts payable $25,000 ACP/DSO ICP PDP CCC 167.4944
vi А B С D E F G H Your consulting firm was recently hired to improve the performance of Rumpke, which has been experiencing cash shortages due to its high growth rate. You want to determine the firm's cash conversion cycle. Using the following information and a 365-day year, what is the firm's present cash conversion cycle? 1 4 Average inventory Annual sales Annual cost of goods sold Average accounts receivable Average accounts payable $75,000 $500,000 $360,000 $160,000 $25,000...
Jordan Air Inc. has average inventory of $1,000,000. Its estimated annual sales are 15 million and the firm estimates its receivables collection period to be twice as long as its inventory conversion period. The firm pays its trade credit on time; its terms are net 30. The firm wants to decrease its cash conversion cycle by 10 days. It believes that it can reduce its average inventory to $900,000. Assume a 360-day year and that sales will not change. Cost...
GBC Corp. has annual sales of RM100,000,000 with cost of goods sold of RM50,735,000 and maintains an average inventory level of RM15,012,000. The average accounts receivable balance outstanding is RM10,000,000. The company makes all purchases on credit and has always paid on the 30th day. The company is now going to take full advantage of trade credit and pay its suppliers on the 40th day. If sales can be maintained at existing levels but inventory can be lowered by RM1,946,000...
Monar Inc.'s CFO would like to decrease its cash conversion cycle by 10 days. The company carries average inventory of $750,000. Its annual sales are $10 million, its cost of goods sold is 75% of annual sales, and its average collection period is twice as long as its inventory conversion period. It uses a 365-day year. The firm buys on terms of net 30 days, and it pays on time. The CFO believes he can reduce the average inventory to...
Margetis Inc. carries an average inventory of $750,000. Its annual sales are $10 million, its cost of goods sold is 75% of annual sales, and its average collectionperiod is twice as long as its inventory conversion period. The firm buys on terms of net 30 days, and it pays on time. Its new CFO wants to decrease the cashconversion cycle by 10 days, based on a 365-day year. He believes he can reduce the average inventory to $647,260 with no...