Question

What is the cash-to-cash cycle time for this data set? (Choose the best answer.) Sales over...

What is the cash-to-cash cycle time for this data set? (Choose the best answer.) Sales over the past 180 days Current accounts receivable balance Cost of sales (%) Current value of inventory (total) Current accounts payable balance $1,500,000 $250,000 45% $750,000 $400,000 80 days 100 days 120 days 140 days

Homework Answers

Answer #1

Answer: 120 Days

Cash to Cash Cycle = Days of receivables outstanding + Days of inventory outstanding -Days of Payables outstanding

Days of Receivables Outstanding = Average Accounts Receivables * (365/Revenue) = 250000*(180/1500000) = 30 days

Average Inventory Period = Average of Inventory *(365 days / COGS) = 750000*(180/675000) = 200

Days of Payables Period = Average Payables *(180/COGS ) = 400000*(180/675000) = 107 days

Cash to Cash Cycle = 30+200-107 = 123 = 120 days ( Nerest value)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Seiko Inc. has the following data. What is the company's cash conversion cycle? Sales per day...
Seiko Inc. has the following data. What is the company's cash conversion cycle? Sales per day $13,500 Annual cost of goods sold $1,300,000 Inventory $2,400,000 Accounts receivable $1,800,000 Accounts payable $2,800,000 (One year has 365 days)
8. Calvani, Inc., has a cash cycle of 44.5 days, an operating cycle of 65 days,...
8. Calvani, Inc., has a cash cycle of 44.5 days, an operating cycle of 65 days, and an inventory period of 28 days. The company reported cost of goods sold in the amount of $344,000, and credit sales were $567,000.    What is the company’s average balance in accounts payable and accounts receivable? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)    Average accounts payable $ Average accounts receivable $
Cash Conversion Cycle. Calculate the (a) accounts receivable period, (b) accounts payable period, (c) inventory period,...
Cash Conversion Cycle. Calculate the (a) accounts receivable period, (b) accounts payable period, (c) inventory period, and (d) cash conversion cycle for the following firm: Income Statement Data:             Sales                            5,000             Cost of goods sold      4,200             Balance sheet data: Beginning of Year End of Year Inventory 500 600 Accounts receivable 100 120 Accounts payable 250 290 Calculate the accounts receivable period: Response (show formula and numerical values): Calculate the accounts payable period Response (show formula and numerical values):...
Assignment title is: Liquidity The following financial data were taken from the annual financial statements of...
Assignment title is: Liquidity The following financial data were taken from the annual financial statements of Smith Corporation:                                   2017                      2018                   2019 Current assets     $   450,000             $   400,000           $    500,000 Current liabilities     390,000                  300,000                 340,000 Sales                     1,450,000               1,500,000             1,400,000 Cost of sales         1,180,000                1,020,000              1,120,000 Inventory                 280,000                   200,000                 250,000 Accounts receivable 120,000                  110,000                105,000 Required: Based on these data, calculate the following for 2018 and 2019 Working capital Current ratio Acid-test ratio Accounts receivable turnover Merchandise inventory turnover Inventory turnover...
(1) Use the information below to compute the number of days in the cash conversion cycle...
(1) Use the information below to compute the number of days in the cash conversion cycle for each company. (2) Which company is more effective at managing cash?    Spartan Co. Chen Co. Days' sales in accounts receivable 42 55 Days' sales inventory 25 29 Days' sales in accounts payable 32 37 Spartan Co. Chen Co. Cash to cash conversion cycle More Effective Cash Management    
Calculate the accounts receivable period, accounts payable period, inventory period, and cash conversion cycle for the...
Calculate the accounts receivable period, accounts payable period, inventory period, and cash conversion cycle for the following firm: Income statement data: Sales 5,000 Cost of goods sold 4,200 Balance sheet data: Inventory 550 Accounts receivable 110 Accounts payable 270
The finance department has been directed to reduce the cash-to-cash cycle time to 40.9 days. You...
The finance department has been directed to reduce the cash-to-cash cycle time to 40.9 days. You are the accounts payable manager and need to reduce the AP balance to achieve that goal. Given the following information, what must your AP balance be? Days in the period: 30 Sales: $1425000 Inventory: $3400000 AR: $5600000 Cost of Sales: 61.4 (Your answer should be in whole dollars) (Excel and calculator will probably be needed)
Exercise 22-18 Cash conversion cycle LO A4 Current Year Prior Year Accounts payable, end of year...
Exercise 22-18 Cash conversion cycle LO A4 Current Year Prior Year Accounts payable, end of year $ 5,123 $ 9,068 Accounts receivable, net, end of year 20,005 16,082 Inventory, end of year 7,424 6,615 Net sales 210,000 183,000 Cost of goods sold 123,000 127,000 (1) Use the information above to compute the number of days in the cash conversion cycle for each year. (2) Did the company manage cash more effectively in the current year? 1. Current Year Prior year...
A)The following items are reported on a company’s balance sheet: Cash $400,000 Marketable securities 50,000 Accounts...
A)The following items are reported on a company’s balance sheet: Cash $400,000 Marketable securities 50,000 Accounts receivable 150,000 Inventory 200,000 Accounts payable 250,000 Determine the (a) current ratio, and (b) quick ratio. Round your answers to one decimal place. a. Current ratio: b. Quick ratio : B) A company reports the following: Income before income tax: $341,880 Interest expense: 77,700 Determine the number of times interest charges are earned. Round your answer to one decimal place. C) A company reports...
Question 1: quater 1 quater 2 cash $3,000 $1,000 marketable securtiies 3,000 500 accounts recievable 6,000...
Question 1: quater 1 quater 2 cash $3,000 $1,000 marketable securtiies 3,000 500 accounts recievable 6,000 2,000    inventory (work in progress) 4,000 10,000 total curent assets $16,000 $ 13,500 total currrent liablilities $10,000 $15,000 quater 3 quater 4 cash $1,500 $1,000 marketable securtiies 500 5,000 accounts recievable 11,500 4,000 inventory (work in progress) 6,000 2,000 total curent assets $19,500 $13,000 total currrent liablilities $ 12,000 $ 6,000 a. (Rates of return) A financial analyst calculated the following ratios from...