Answer 1:
a. DIH = 0 days
b. DIH = 30 days
c. DIH = 50 days
Workings:
DIH = Operating cycle - DSO
a. DIH = 30 - 30 = 0 days
b. DIH = 60 - 30 = 30
C. DIH =80- 30 = 50
Answer 2:
a. DSO = 70 days
b. DSO = 40 days
c. DSO = 0 days
Workings:
DSO = CCC - DIH + DPO
a. DSO = 90 - 50 + 30 = 70
b. DSO = 60- 50 + 30 = 40
c. DSO = 20- 50 + 30 = 0
Answer 3:
a. DPO = 20 days
b. DPO = 60 days
c. DPO = 40 days
Workings:
DPO = Operating cycle - CCC
a. DPO = 60 - 40 = 20 days
b. DPO = 60 - 0 = 60
C. DPO = 60- 20 = 40
Answer 4:
DSO = Receivable / (sales / 365) = 1100000 / (4200000 / 365) = 96 days
DIH = Inventory/ (COGS /365) = 800000 /(45% * 4200000 / 365) = 154 days
DPO = 700000 / (45% * 4200000 / 365) = 135 days
a. Operating cycle = DSO +DIH = 96 + 154 = 250 days
b. CCC = Operating cycle - DPO = 250 - 135 = 115 days
c. CCC will be 0 days if DPO = Operating cycle = 250 days
Payables = 250 * (45% * 4200000 / 365) =$1,294,521
d. CCC will be 0 when:
DIH = CCC - DSO + DPO = 0 - 96 + 135 =39 days
Inventory =39 * (45% * 4200000 / 365) = $201,945
e. CCC will be 0 when:
DSO = CCC - DIH + DPO = 0 - 154 + 135 = -19 days
DSO has to be negative to have CCC = 0 (all else remaining same). This is not feasible.
uiek ratio to exceed the current ratio? iy moou the current ratio? 15. Interpret a working...
3. Calculate the Cash Conversion Cycle (use end-of-period amounts rather than average of receivables, inventory, and payables): • Days Sales Outstanding (DSO) = Receivables / (Sales/365) • Days Inventory Held (DIH) = Inventory / (CGS/365) • Days Payable Outstanding (DPO) = Payables/(CGS/365) • Operating Cycle = DSO + DIH • Cash Conversion Cycle (CCC) = Operating Cycle - DPO 2017 2016 2015 2014 2013 DIH 152.08 106.46 101.39 DSO 121.67 73.00 64.89 DPO 121.67 76.04 70.97 Operating Cycle 273.75 179.46...
Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...
Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...
What is Chutes' interest coverage ratio? The interest coverage ratio istimes. (Round to one decimal place.) Suppose your firm receives a $4.62 million order on the last day of the year. You fill the order with $1.95 million worth of inventory. The customer picks up the entire order the same day and pays $1.22 million up front in cash; you also issue a bill for the customer to pay the remaining balance of $3.40 million within 40 days. Suppose your...
Quantitative Problem: Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales outstanding on its cash conversion cycle. Winston's 2017 sales (all on credit) were $117,000 and its cost of goods sold was 75% of sales. It turned over its inventory 8.77 times during the year. Its receivables balance at the end of the year was $13,148.72 and its payables balance at the end of the year was $7,407.63. Using this information calculate the...
Question 3. The Timber Ridge Company has the following relationships: Sales/Total assets = 3.80; ROA = 0.0980 What is Timber Ridge’s net profit margin? Round to 3 decimal places. Question 5 Archware Systems has total assets of $35.594 billion, total debt of $9.678 billion, and net sales of $23.720 billion. Their net profit margin for the year was 0.22, while the operating profit margin was 30 percent. What is Archware’s net income? (Answer needs to be stated in billions. For...
CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $183,000; its cost of goods sold is 80% of sales, and it earned a net profit of 4%, or $7,320. It turned over its inventory 4 times during the year, and its DSO was 39 days. The firm had fixed assets totaling $34,000. Chastain's payables deferral period...
CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $183,000; its cost of goods sold is 80% of sales, and it earned a net profit of 4%, or $7,320. It turned over its inventory 4 times during the year, and its DSO was 39 days. The firm had fixed assets totaling $34,000. Chastain's payables deferral period...
CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $272,000; its cost of goods sold is 80% of sales; and it earned a net profit of 3%, or $8,160. It turned over its inventory 4 times during the year, and its DSO was 35 days. The firm had fixed assets totaling $32,000. Chastain's payables deferral period...
CASH CONVERSION CYCLE Chastain Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastain's 2016 sales (all on credit) were $240,000; its cost of goods sold is 80% of sales; and it earned a net profit of 2%, or $4,800. It turned over its inventory 5 times during the year, and its DSO was 31.5 days. The firm had fixed assets totaling $40,000. Chastain's payables deferral period...