Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute the cash cycle based on the following information: Average Collection Period = 34 Accounts Payable Period = 44 Average Age of Inventory = 42

Compute the cash cycle based on the following information:

Average Collection Period = 34

Accounts Payable Period = 44

Average Age of Inventory = 42

Compute the Accounts Payable (A/P) period based on the following information:

Average A/P balance = $33142

Annual Cost of Goods Sold = $142459

Assume 365 days

ABC Company has annual sales of $400,000 and cost of goods sold of $225308. The accounts payable period is 38.7 days. What is the average accounts payable balance?

ABC Corporation currently has an inventory turnover of 9.54, a payables turnover of 10.26, and a receivables turnover of 12.65. How many days are in the cash cycle?

Enter your answer rounded off to two decimal points. For example, if your answer is 12.345 then enter as 12.35 in the answer box.

Month

Sales $

Month

Sales $

Jan

42175

July

14603

Feb

19251

Aug

34663

Mar

34663

Sep

42175

Apr

14603

Oct

34663

May

42175

Nov

19251

June

19251

Dec

14603

Sales are collected as follows:

In the month of Sales: 25%

In the next month: 34%

After 2 months: 11%

After 3 months: remainder is collected

Calculate the cash collection for December.

Month

Sales $

Month

Sales $

Jan

35454

July

19468

Feb

45233

Aug

40856

Mar

40856

Sep

35454

Apr

19468

Oct

40856

May

35454

Nov

45233

June

45233

Dec

19468

The company has estimated expenses as follows:

General and administrative expenses: $5424

Material purchases are 64 percent of sales. Material purchases are paid in the month following the purchase.

Interest payment per month: $4731

Rent expenses per quarter starting March: $8737

Calculate the cash outflows for June.

Enter your answer rounded off to two decimal points. Do not enter $ or comma in the answer box. For example, if your answer is $12.345 then enter as 12.35 in the answer box.

Month

Sales $

Month

Sales $

Jan

47902

July

32650

Feb

23277

Aug

26665

Mar

26665

Sep

47902

Apr

32650

Oct

26665

May

47902

Nov

23277

June

23277

Dec

32650

Sales are collected as follows:

In the month of Sales: 41%

In the next month: 25%

After 2 months: 5%

Remainder is considered as bad debt and is not collected.

Calculate the cash collection for June.

ABC Corporation currently has an inventory turnover of 31.72, a payables turnover of 7.84, and a receivables turnover of 8.35. How many days are in the operating cycle?

ABC Company has annual sales of $424011 and cost of goods sold of $198,600. The average accounts receivable balance is $62060. How many days on average does it take the firm to collect its accounts receivable? Assume 365 days.

Month

Sales $

Month

Sales $

Jan

43856

July

27570

Feb

11664

Aug

22907

Mar

22907

Sep

43856

Apr

27570

Oct

22907

May

43856

Nov

11664

June

11664

Dec

27570

Sales are collected as follows:

In the month of Sales: 39%

In the next month: 26%

After 2 months: 7%

After 3 months: remainder is collected

Calculate the cash collection for November.

OnJuly 15th, you purchased $10,000 worth of goods. The terms of the sale were 2/9, net 57. What is the effective annual rate of interest for the credit period for this sale?

ABC Company has an average collection period of 32 days and factors all of its receivables immediately at a 2.8 percent discount. Assume all accounts are collected in full. What is the firm's effective cost of borrowing?

ABC Company has a cash cycle of 13.84 days, an operating cycle of 19.33 days, and an average collection period of 4 days. The company reported cost of goods sold of $291337. What is the company's average balance in Accounts Payable?

The terms of the sale were 1/9, net 45. What is the effective annual rate of interest?

ABC Company writes 317 checks a day for an average amount of $438 each. These checks generally clear the bank in 5 days. In addition, the firm generally receives an average of $150094 a day in checks that are deposited immediately. Deposited funds are available in 1 days. What is the firm's net float?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes, Arshad Ahmad, Jordan Fortino

6th Canadian edition

1259453146, 978-1259453144

More Books

Students also viewed these Finance questions

Question

justify why cost-plus pricing is widely used; LO1

Answered: 1 week ago

Question

explain the limitations of cost-plus pricing; LO1

Answered: 1 week ago