Question

In: Finance

inventory: beginning $21,430 Ending $23,865 Accounts receivable: beginning $15,362 Ending $17,210 accounts payable: beginning $20,416 Ending...

inventory: beginning $21,430 Ending $23,865
Accounts receivable: beginning $15,362 Ending $17,210
accounts payable: beginning $20,416 Ending $21,803
net sales for the year: $243,612
cost of goods sold for the year: $108,915

what is the cash cycle?

Solutions

Expert Solution

Ans. Cash cycle =   Days sales in inventory + Days sales in receivables - Payable period
75.90 + 24.60 - 69.20
31.30 days
*Calculations:
Days sales in inventory = Average inventory / Cost of goods sold * No. of days in year
22647.5 / 108915 * 365
75.90 days
*Average inventory = (Beginning inventory + Ending inventory) / 2
(21430 + 23865) / 2
22647.5
Days sales in receivables = Average receivables / Sales * No. of days in year
16421 / 243612 * 365
24.60 days
*Average receivables = (Beginning receivables + Ending receivables) / 2
(15632 + 17210) / 2
16421
*Payable period = Average payable / Purchase * No. of days in year
21109.5 / 111350 * 365
69.20 days
*Average payable = (Beginning payable + Ending payable) / 2
(20416 + 21803) / 2
21109.5
*Purchase   =   Cost of goods sold + Ending inventory - Beginning inventory
108915 + 23865 - 21430
111350

*Payable period can also be determined by using the following formula:

Average payable / Cost of goods sold * No. of days in year


Related Solutions

Account Beginning Balance Ending Balance Inventory $2,600 $2,890 Accounts receivable $3,222 $2,800 Accounts payable $2,500 $2,670...
Account Beginning Balance Ending Balance Inventory $2,600 $2,890 Accounts receivable $3,222 $2,800 Accounts payable $2,500 $2,670 Net sales $24,589 Cost of goods sold $19,630 What is the operating cycle? a. 51.04 days b. 95.74 days c. 48.07 days d. 99.11 days Following Question 1, what is the cash cycle? a. 44.70 days b. 48.07 days c. 47.67 days d. 51.04 days
What is the value of Accounts Receivable, Gross at the beginning and the ending of the...
What is the value of Accounts Receivable, Gross at the beginning and the ending of the current fiscal year? Any examples?
If ending accounts receivable exceeds the beginning accounts receivable: A. cash collections during-the period exceed the...
If ending accounts receivable exceeds the beginning accounts receivable: A. cash collections during-the period exceed the amount of revenue earned. B. net Income for the period is less than the amount of cash basis income. C. no cash was collected during the period. D. cash collections during the year are less than the amount of revenue earned.
Shown below in T-account format are the beginning and ending balances ($ in millions) of both inventory and accounts payable.
Shown below in T-account format are the beginning and ending balances ($ in millions) of both inventory and accounts payable.  Required: 1. Use a T-account analysis to determine the amount of cash paid to suppliers of merchandise during the reporting period if cost of goods sold was $300 million. 2. Prepare a summary entry that represents the net effect of merchandise purchases during the reporting period.
accounts payable and accounts receivable
What is the difference between accounts payable and accounts receivable?
6.          Calculate the Operating and Cash Cycles. Item Beginning Ending Inventory $10,000 $11,000 Accounts Receivable $5,000...
6.          Calculate the Operating and Cash Cycles. Item Beginning Ending Inventory $10,000 $11,000 Accounts Receivable $5,000 $6,000 Accounts Payable $6,000 $65,000 Net Sales $140,000 Cost of Goods Sold $85,000 Operating Cycle Days Cash Cycle Days Please put the excel formulas en step by step solution so i can understand . thank you What does Operating and Cash Cycles tell you? Why are they important?
Explain how the accounts receivable, inventory, power and equipment, accounts payable, wages payable and long-term debt...
Explain how the accounts receivable, inventory, power and equipment, accounts payable, wages payable and long-term debt impacted cash flow from one year to the next. 200-word minimum.
A company has inventory balance of $24,318, accounts receivable of $9,637, and accounts payable of $14,365....
A company has inventory balance of $24,318, accounts receivable of $9,637, and accounts payable of $14,365. If the credit sales are $183,030 and cost of goods sold are $128,952, what is the company's cash (conversion) cycle in number of days? (Use ending balances and assume 365 days in a year.) A) 36.59 B) 37.61 C) 38.63 D) 39.64 E) 40.66
A company has inventory balance of $24,935, accounts receivable of $9,902, and accounts payable of $14,652....
A company has inventory balance of $24,935, accounts receivable of $9,902, and accounts payable of $14,652. If the credit sales are $186,978 and cost of goods sold are $132,477, what is the company's cash (conversion) cycle in number of days? (Use ending balances and assume 365 days in a year.)
BeachTime Company uses a perpetual inventory system and both an accounts receivable and an accounts payable...
BeachTime Company uses a perpetual inventory system and both an accounts receivable and an accounts payable subsidiary ledger. Balances related to both the general ledger and the subsidiary ledger for the company are indicated in the working papers. Below are a series of transactions for BeachTime Co. for the month of January. Credit sales terms are 2/10, n/30. The cost of all merchandise sold was 57% of the sales price. Jan.3  Sell merchandise on account to M. Knast $2,900, invoice...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT