Question

In: Finance

Calculate the operating and cash cycles. How do you interpret your answer?

  1. Consider the following financial statement information for the Bulldog Icers Corporation:

Item

Beginning

Ending

Inventory

$   7,281

$   9,318

Accounts Receivable

$   4,814

$   5,108

Accounts payable

$   6,623

$   7,415

Net Sales

$ 65,180


Cost of goods sold

$ 51,912


Calculate the operating and cash cycles. How do you interpret your answer?

Solutions

Expert Solution

Inventory turnover = Cost of goods sold / Average inventory = $51,912 / [($7,281 + $ 9,318)/2] = $51,912 / $8,299.5 = 6.25 times

Days inventory outstanding = 365 days / 6.25 = 58.4 days

Accounts receivable turnover = Credit sales / average accounts receivables = $65,180 / [($4,814 + $5,108)/2] = 13.14 times

Days sales outstanding = 365 days / 13.14 = 27.78

Accounts payable turnover = Cost of goods sold / average accounts payable = $51,912 / [($6,623 + $7,415)/2] = 7.40

Days payable outstanding = 365/7.40 = 49.32 days

Cash cycle = Operating cycle - Days payable outstanding

Operating cycle = Days inventory outstanding + Days sales outstanding = 58.4 days + 27.78 days = 86.18 days

Cash cycle = 86.18 days - 49.32 days = 36.86 days

​​​​​​​


Related Solutions

how do you calculate net change in non-cash working capital, cash provided in operating activities, cash...
how do you calculate net change in non-cash working capital, cash provided in operating activities, cash used in investing activities and cash used in financing activities?
What does Operating and Cash Cycles tell you? Why are they important?
What does Operating and Cash Cycles tell you? Why are they important?
6.          Calculate the Operating and Cash Cycles. Item Beginning Ending Inventory $10,000 $11,000 Accounts Receivable $5,000...
6.          Calculate the Operating and Cash Cycles. Item Beginning Ending Inventory $10,000 $11,000 Accounts Receivable $5,000 $6,000 Accounts Payable $6,000 $65,000 Net Sales $140,000 Cost of Goods Sold $85,000 Operating Cycle Days Cash Cycle Days Please put the excel formulas en step by step solution so i can understand . thank you What does Operating and Cash Cycles tell you? Why are they important?
Calculate cash flow from operating activities using the following information. Please place your answer in the...
Calculate cash flow from operating activities using the following information. Please place your answer in the blank below (please do not use commas or dollar signs, i.e., simply type 1000). Net income 60,000 Purchase of new machine 35,000 Depreciation expense 10,000 Increase in Accts. Receivable 15,000 Loss on sale of machine 9,000 Decrease in Prepaid Expenses 7,000 Increase in Accts. Payable 14,000 Decrease in Accrued Liabilities 4,000
How do you calculate ''Net increase in cash" & "Cash End of the year" for cash...
How do you calculate ''Net increase in cash" & "Cash End of the year" for cash flow statement from balance sheet and income statement?
What is the cash ratio? How do you calculate it and why is the cash ratio...
What is the cash ratio? How do you calculate it and why is the cash ratio useful?
Discuss the operating and cash cycles and why they are important for a financial manager to...
Discuss the operating and cash cycles and why they are important for a financial manager to have a good understanding of how cash and operating cycles impact business operations.
What is Mean Arterial Pressure? How do you calculate it? Explain every aspect of your answer,...
What is Mean Arterial Pressure? How do you calculate it? Explain every aspect of your answer, including the variables in the equation.
what are milankovitch cycles and how do they influence cycles of glaciation?
what are milankovitch cycles and how do they influence cycles of glaciation?
Operating Activities How do you determine cash flow provided by (used in) operating activities using the...
Operating Activities How do you determine cash flow provided by (used in) operating activities using the indirect method? How is cash flow provided by (used in) operating activities determined using the direct method? How is this different from the indirect method? Investing Activities How do you determine cash flow provided by (used in) investing activities? Financing Activities How do you determine cash flow provided by (used in) financing activities? What is the formula to calculate change in cash flow? What...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT