Question

A company has inventory balance of $22,467, accounts receivable of $8,842, and accounts payable of $13,504....

A company has inventory balance of $22,467, accounts receivable of $8,842, and accounts payable of $13,504. If the credit sales are $171,186 and cost of goods sold are $118,377, what is the company's cash (conversion) cycle in number of days? (Use ending balances and assume 365 days in a year.)

a) 41.64

b)40.60

c) 44.76

d) 42.68

e)43.72

Homework Answers

Answer #1

inventory balance = $22,467

accounts receivable (AR)= $8,842

accounts payable(AP) = $13,504.

credit sales = $171,186

cost of goods sold = $118,377,

Cash Conversion Cycle

Cash Conversion Cycle = Days of Sales Outstanding + Days of Inventory Outstanding - Days of Payables Outstanding

Days of Sales Outstanding = [(Beginning AR + ending AR) / 2] / (Revenue / 365)

Days of Sales Outstanding = 8842 / (171186/365) = 18.8528 days

.

Days of Inventory Outstanding = [(Beginning inventory + ending inventory) / 2] / (COGS / 365)

Days of Inventory Outstanding = 22467 / (118377 / 365) = 69.2741 days

.

Days of Payables Outstanding = [(Beginning AP + ending AP) / 2] / (COGS / 365)

Days of Payables Outstanding = 13504 / (118377 / 365) = 41.6378 days

.

Cash Conversion Cycle = 18.8528 days + 69.2741 days - 41.6378 days = 46.4891 Days

.

Cash Conversion Cycle = 46.4891 days

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
A company has inventory balance of $26,169, accounts receivable of $10,432, and accounts payable of $15,226....
A company has inventory balance of $26,169, accounts receivable of $10,432, and accounts payable of $15,226. If the credit sales are $194,874 and cost of goods sold are $139,527, what is the company's cash (conversion) cycle in number of days? (Use ending balances and assume 365 days in a year.) Options: 36.84 37.84 38.84 39.83 40.83
Sempurna Manufacturing Company (SMC) has an average accounts receivable balance of RM1,250,000, an average inventory balance...
Sempurna Manufacturing Company (SMC) has an average accounts receivable balance of RM1,250,000, an average inventory balance of RM1,750,000, and an average accounts payable balance of RM800,000. Its annual sales are RM12,000,000 and its cost of goods sold represents 80 percent of annual sales. Assume there are 365 days in a year. What is SMC’s cash conversion cycle? "hopefully the answer without using excel"
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
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):...
Using the following information, and a 360-year. Calculate the accounts receivable period, accounts payable period, inventory...
Using the following information, and a 360-year. 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: Beginning of Year End of Year Inventory 500 600 Accounts receivable 100 120 Accounts payable 250 290
Case X: Compute cash received from customers: Sales $ 700,000 Accounts receivable, Beginning balance 48,000 Accounts...
Case X: Compute cash received from customers: Sales $ 700,000 Accounts receivable, Beginning balance 48,000 Accounts receivable, Ending balance 66,240 Case Y: Compute cash paid for rent Rent expense $ 106,300 Rent payable, Beginning balance 12,900 Rent payable, Ending balance 10,836 Case Z: Compute cash paid for inventory Cost of goods sold $ 465,000 Inventory, Beginning balance 144,150 Accounts payable, Beginning balance 60,543 Inventory, Ending balance 118,203 Accounts payable, Ending balance 75,073 For each of the above three separate cases,...
Sales (all credit): $6,000,000; Cost of Goods Sold: 80% of Sales; Accounts receivable: $350,000; Inventory: $600,000;...
Sales (all credit): $6,000,000; Cost of Goods Sold: 80% of Sales; Accounts receivable: $350,000; Inventory: $600,000; Accounts payable: $150,000 What is the expected working capital financing requirement based on the working capital cycle? Use 1 year = 365 days $736,438 $756,164 $604,932 $920,548
Question 4: During 2016, XYZ Ltd. had the inventory period of 25 days, the accounts receivable...
Question 4: During 2016, XYZ Ltd. had the inventory period of 25 days, the accounts receivable period of 30 days and the accounts payable period of 20 days. Assume that XYZ Ltd. has the credit sales of $365 million in 2016 and the cost of goods sold of $255.5million. It had beginning of the year inventories, receivables and payables of $15 million, $28 million and $12 million respectively: i) Calculate the operating cycle and the cash conversion cycle of XYZ...
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)
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...