Question

In: Finance

Pepsi Last year Days Sales Outstanding (A/R period) 41.59 Days Inventory (Inventory Period) 41.93 Payables Period...

Pepsi

Last year

Days Sales Outstanding (A/R period)

41.59

Days Inventory (Inventory Period)

41.93

Payables Period (A/P period)

154.33

  1. Using this information, compute the Cash Cycle for this company.

Cash Cycle = Days Sales Outstanding + Days Inventory – Payables Period

Questions

  • What is the length of this company’s cash cycle? (Show us your work!)
  • What information does this give you about the company’s need for cash?
  • Do you feel that this company must seek out short-term financing? Please explain your response.
  • Discuss whether Martin and Samantha should be concerned about their company’s cash cycle of 73 days.

Solutions

Expert Solution

Cash conversion cycle= Days Sales Outstanding + Days Inventory – Payables Period

=41.59-41.93-154.33

=-70.81

This company has negative working capital which is a good thing. Basically, company able to maintain the suppliers by paying lately which led to better workig capital cycle. Once it have sufficient cash, then only company makes the payments to the suppliers. In this case, I think there is no need to take short term borrowings. Generally, short term loans will be taken to fund the positive/high working capital cycle of the companies.

2. If a company has a working capital cycle of 73 days means, it takes 73 days to convert the raw material to cash in to business. So, to run the business properly with out any liquidity issues, company has to take short term loans to pay for the working capital needs. However, we cant say that the working capital cycle is high/low with out industry averge. Working capital cycle changes from industry to industry.


Related Solutions

Company Inventory Conversion Period, days Average Collection Period, days Payables Deferral Period, days Cash Conversion Cycle,...
Company Inventory Conversion Period, days Average Collection Period, days Payables Deferral Period, days Cash Conversion Cycle, days Adidas 112 27 57 82 Puma 107 18 49 Nike 128 20 43 105 Under Armor 89 24 21 1)calculate CCC for Puma and UA. 2)pick any 1 company of the 4: how its operational liquidity stands versus competitors (other 3 firms)? how can this company improve its liquidity? What are possible risks/limitations to your proposed changes?
A firm has days' sales in an inventory of 105 days, an average collection period of...
A firm has days' sales in an inventory of 105 days, an average collection period of 35 days, and takes 42 days, on average, to pay its accounts payable. Taken together, what do these three figures imply about the firm's operations and its cash flows?
Famous Farm's payables deferral period (PDP) is 40 days (on a 365-day basis), accounts payable are...
Famous Farm's payables deferral period (PDP) is 40 days (on a 365-day basis), accounts payable are $120 million, and its balance sheet shows inventory of $208 million. What is the inventory turnover ratio?
The below table reports the $ amounts of inventory, receivables, payables, net sales and cost of...
The below table reports the $ amounts of inventory, receivables, payables, net sales and cost of good sols the XYZ Company in 200N. Accounts Beginning Ending Inventory $10,000 $12,000 Receivables 8,000 10,000 Accounts payable 6,000 7,000 Net sales 30,000 Cost of Goods sold 14,000 Calculate the inventory turnover and inventory period. Interpret. Calculate the receivable turnover and receivable period. Interpret. Calculate the operating cycle (OC). Interpret. Calculate and interpret the cash cycle (CC).
A firm’s Days Sales Outstanding is 36.5 days. Its sales is $1,000,000. What is this firm’s...
A firm’s Days Sales Outstanding is 36.5 days. Its sales is $1,000,000. What is this firm’s Accounts Receivable balance (assume a 365 day year)?
What is Amazon's days sales outstanding for the year 2018 & 2019? With no given data.
What is Amazon's days sales outstanding for the year 2018 & 2019? With no given data.
Geoffrey’s Toy Box currently has sales of $1,000,000, and its days sales outstanding is 30 days....
Geoffrey’s Toy Box currently has sales of $1,000,000, and its days sales outstanding is 30 days. The new CFO estimates that offering longer credit terms would (1) increase the days sales outstanding to 50 days and (2) increase sales to $1,200,000. However, bad debt losses, which were 2 percent on the old sales, would increase to 5 percent on the incremental sales while bad debts on the old sales would stay at 2 percent. Variable costs are 80 percent of...
Geoffrey’s Toy Box currently has sales of $1,000,000, and its days sales outstanding is 30 days....
Geoffrey’s Toy Box currently has sales of $1,000,000, and its days sales outstanding is 30 days. The new CFO estimates that offering longer credit terms would (1) increase the days sales outstanding to 50 days and (2) increase sales to $1,200,000. However, bad debt losses, which were 2 percent on the old sales, would increase to 5 percent on the incremental sales while bad debts on the old sales would stay at 2 percent. Variable costs are 80 percent of...
A company has increasing accounts receivable, increasing inventory and decreasing accounts payables year over year on...
A company has increasing accounts receivable, increasing inventory and decreasing accounts payables year over year on the balance sheet.  Which of the following is correct about the impact operating cash flow? a. None of these b. Increase in inventory is a source of cash c. Increase in accounts receivable is a source of cash d. Decreasing accounts payable is a source of cash
Zane Corporation has an inventory conversion period of 89 days, an average collection period of 39...
Zane Corporation has an inventory conversion period of 89 days, an average collection period of 39 days, and a payables deferral period of 31 days. Assume 365 days in year for your calculations. What is the length of the cash conversion cycle? Round your answer to two decimal places.   days If Zane's annual sales are $3,706,915 and all sales are on credit, what is the investment in accounts receivable? Do not round intermediate calculations. Round your answer to the nearest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT