Using Financial Statement Data to Compute Activity Ratios

Cisco Systems reported the following information in recent $10-$K filings.

INSTRUCTIONS:

$1.$ Use Excel to compute answers.

$2.$ Do not round your computations.

$3.$ Enter final answers rounded based on instructions provided.

a$.$ Compute accounts receivable turnover and DSO for the current and prior years.

Note: Round answers to the nearest dollar, if applicable.

Note: Round final answers to one decimal.

b$.$ Compute inventory turnover and DIO for the current and prior years.

Note: Round answers to the nearest dollar, if applicable.

Note: Round answers to one decimal. c$.$ Compute accounts payable turnover and DPO for the current and prior years.

Note: Round answers to the nearest dollar, if applicable.

Note: Round answers to one decimal.

d$.$ Compute cash conversion cycle for the current and prior years.

Note: Round answers to one decimal.

e$.$ Determine the cash flow impact arising from the change in DIO during the current year.

Note: Round answers to one decimal.

Note: Enter a cash inflow impact as positive and a cash outflow impact as negative.