Question

In: Finance

Suppose that LilyMac Photography has annual sales of $237,000, cost of goods sold of $172,000, average...

Suppose that LilyMac Photography has annual sales of $237,000, cost of goods sold of $172,000, average inventories of $5,200, average accounts receivable of $26,400, and an average accounts payable balance of $7,700.

Assuming that all of LilyMac’s sales are on credit, what will be the firm’s cash cycle? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places.)

Cash Cycle Days _________

Expert Solution

Cash Cycle days

35.35

Days

Working:

a.

Inventory Turnover ratio

=

Cost of goods sold/Average Inventory

=

$ 1,72,000

/

$ 5,200

=

33.08

b.

Days inventory outstanding

=

365

/

33.08

=

11.03

c.

Receivable Turnover ratio

=

Credit Sales / Average Accounts Receivable

=

$ 2,37,000

/

$ 26,400

=

8.98

d.

Days Sales outstanding

=

365

/

8.98

40.66

e.

Payable turnover ratio

=

Costs of goods sold/Average Accounts payable

=

$ 1,72,000

/

$ 7,700

=

22.34

f.

Days Payable outstanding

=

365

/

22.34

16.34

g.

Cash cycle

=

Days Inventory outstanding + Days sales outstanding - Days Payable outstanding

=

11.03

+

40.66

-

16.34

=

35.35

jeff jeffy answered 3 years ago

Suppose that LilyMac Photography has annual sales of $221,000, cost of goods sold of $156,000, average...

Suppose that LilyMac Photography has annual sales of $221,000, cost of goods sold of $156,000, average inventories of $6,400, average accounts receivable of $28,800, and an average accounts payable balance of $19,100. Assuming that all of LilyMac’s sales are on credit, what will be the firm’s cash cycle? (Use 365 days a year. Do not round intermediate calculations. Round your final answer to 2 decimal places.)

Suppose that LilyMac Photography has annual sales of $232,000, cost of goods sold of $167,000, average...

Suppose that LilyMac Photography has annual sales of $232,000, cost of goods sold of $167,000, average inventories of $4,700, and average accounts receivable of $25,200. Assume that all of LilyMac’s sales are on credit. What will be the firm’s operating cycle? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places.) Operating Cycle Days ____________

Suppose that Ken-Z Art Gallery has annual sales of $898,000, cost of goods sold of $588,000,...

Suppose that Ken-Z Art Gallery has annual sales of $898,000, cost of goods sold of $588,000, average inventories of $174,000, average accounts receivable of $107,000, and an average accounts payable balance of $53,000. Assuming that all of Ken-Z’s sales are on credit, what will be the firm’s cash cycle? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places.) Cash cycle days

XYZ Company has annual sales of $692,584. The cost of goods sold are $444,925. The firm...

XYZ Company has annual sales of $692,584. The cost of goods sold are $444,925. The firm has an accounts receivable balance of $5,685, an accounts payable balance of $18,445 and inventory of $9,946. How many days on average does it take the firm to collect its accounts receivable? That is, what is the average collection period? Assume 365 days.

XYZ Company has annual sales of $518,138. The cost of goods sold are $392,068. The firm...

XYZ Company has annual sales of $518,138. The cost of goods sold are $392,068. The firm has an accounts receivable balance of $16,047, an accounts payable balance of $15,631 and inventory of $18,963. How many days does it take on average for the firm to pay its suppliers? That is, what is the payable period? Assume 365 days

Dickson City Company has annual sales of $5 million, while the cost of goods sold is...

Dickson City Company has annual sales of $5 million, while the cost of goods sold is $3.2 million. All sales are made on a cash basis. The owner of Dickson has come up with the plan of giving credit to the customers. He believes that this will increase the sales by 25% without increasing any of the fixed costs. He thinks that 20% of the customers will pay within 30 days, 40% within 60 days, 37% within 90 days, and...

Alamo company has sales, cost of goods sold, and average ending inventory for the current year...

Alamo company has sales, cost of goods sold, and average ending inventory for the current year in the following amounts: $650,000, $500,000,and $128,000,respectively. calculate the amount of the company's inventory turnover for the year. what is the company's average number of days to sell inventory

Grippers expects cost of goods sold to average 65% of the current month’s sales and the...

Grippers expects cost of goods sold to average 65% of the current month’s sales and the company expects to sell 4,300 pairs of shoes in March for $240 each. Grippers’ target ending inventory is $10,000 plus 50% of the next month’s cost of goods sold. Use this information plus the sales budget from Question 1 to prepare Grippers’ inventory, purchases, and cost of goods sold budget for January and February. Sales budget from question 1: Particulars: Cash Sales in January =...

Current Expenses Average monthly sales over the last quarter was $20,000 Cost of goods sold is...

Current Expenses Average monthly sales over the last quarter was $20,000 Cost of goods sold is $10,000 Promotional costs are $1000 “Other” fixed costs are $1000 Taxes are 30% of your operating profit This leaves you with $5,600 a month, of which, you need $5000 to live on Expansion Costs You have found a commercial office and storage space for $1500 a month. You estimate it would cost you about $1500 a month to hire someone to work 20 hours...

Sales (all on account) $ 773,000 $ 607,000 Cost of goods sold 462,000 402,000 Average inventory...

Sales (all on account) $ 773,000 $ 607,000 Cost of goods sold 462,000 402,000 Average inventory during the year 130,000 120,000 Average receivables during the year 150,000 100,000 a-1. Compute the gross profit percentage for both years. (Round your percentage answers to the nearest whole number. i.e. 0.1234 as 12%.) a-2. Compute the inventory turnover for both years. (Round your answers to 1 decimal place.) a-3. Compute the accounts receivable turnover for both years. (Round your answers to 1 decimal...