Practice questions
- 1. Select the margin basis
- 2. Estimate expense
- 3. Estimate ending inventory
- 4. Evaluate a changed product mix
- 5. Change the margin assumption
- 6. Convert markup to estimated expense
- 7. Estimate the goods destroyed
- 8. Calculate the retail ratio
- 9. Derive ending inventory at retail
- 10. Estimate ending cost
- 10a. Compare FIFO and LIFO retail estimates
- 10b. Compare retail markdown treatments
- 11. Evaluate missing goods
- 12. Select the receivable flow
- 13. Calculate receivable turnover
- 14. Calculate collection days
- 15. Retrieve inventory days
- 16. Derive credit purchases
- 17. Calculate payment days
- 18. Evaluate a proxy
- 19. Combine the cycle
- 20a. Compare the second year
- 20b. Attribute the change
- 20c. Choose the operating evidence
Confetti Party Supply is a fictional retailer of decorations, balloons, and other party supplies. It sells to households and event planners. These new cases are separate from Second Helping and Sound Decision. All amounts are US dollars. Use a 365-day year and beginning/ending averages. Enter days and turnover to two decimal places. Keep unrounded intermediate values.
1. Select the margin basis
A retailer describes selling prices as cost plus a percentage. Which denominator defines the quoted markup?
B is correct. Markup divides profit by cost. Margin on sales divides profit by sales.
2. Estimate expense
Confetti provides these amounts for March 2026:
| Input | Amount |
|---|---|
| Beginning inventory at cost | $44,200 |
| Net purchases at cost | $121,800 |
| Net sales | $175,000 |
| Supported gross margin on sales | 28.00% |
No other inventory movements apply.
Calculate estimated cost of goods sold.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Estimated COGS | Net sales × (1 − Gross profit rate) | $175,000 × (1 − 28.00%) | $126,000 |
The gross profit rate is a share of sales. Subtract it from 100% to find the share assigned to inventory cost.
3. Estimate ending inventory
Confetti provides these amounts for March 2026:
| Input | Amount |
|---|---|
| Beginning inventory at cost | $44,200 |
| Net purchases at cost | $121,800 |
| Net sales | $175,000 |
| Supported gross margin on sales | 28.00% |
No other inventory movements apply.
Calculate estimated ending inventory.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Goods available at cost | Beginning inventory + Net purchases | $44,200 + $121,800 | $166,000 |
| Estimated COGS | Net sales × (1 − Gross profit rate) | $175,000 × (1 − 28.00%) | $126,000 |
| Estimated ending inventory | Goods available at cost − Estimated COGS | $166,000 − $126,000 | $40,000 |
Subtract the estimated cost of goods sold from the cost of goods available. Gross profit itself is not the amount to subtract from inventory.
4. Evaluate a changed product mix
Confetti uses last year's gross profit rate to estimate inventory. This month's sales shift toward lower-margin products. Selling prices and purchase costs within each product group are unchanged.
Compared with using the current lower rate, how does retaining last year's rate affect estimated cost of goods sold and ending inventory?
D is correct. The higher assumed gross profit rate reduces estimated cost of goods sold. Subtracting that smaller cost from unchanged goods available leaves an overstated inventory estimate.
5. Change the margin assumption
Confetti provides these amounts for March 2026:
| Input | Amount |
|---|---|
| Beginning inventory at cost | $44,200 |
| Net purchases at cost | $121,800 |
| Net sales | $175,000 |
| Supported gross margin on sales | 28.00% |
No other inventory movements apply.
Replace the base margin with 24.00% of sales. Calculate the revised inventory estimate.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Goods available at cost | Beginning inventory + Net purchases | $44,200 + $121,800 | $166,000 |
| Estimated COGS | Net sales × (1 − Gross profit rate) | $175,000 × (1 − 24.00%) | $133,000 |
| Estimated ending inventory | Goods available at cost − Estimated COGS | $166,000 − $133,000 | $33,000 |
The lower assumed margin assigns more of each sales dollar to COGS, leaving less cost in ending inventory.
6. Convert markup to estimated expense
Confetti provides these amounts for March 2026:
| Input | Amount |
|---|---|
| Beginning inventory at cost | $44,200 |
| Net purchases at cost | $121,800 |
| Net sales | $175,000 |
| Supported gross margin on sales | 28.00% |
No other inventory movements apply.
For a separate scenario, replace the margin assumption with a markup of 25.00% on cost. Calculate estimated expense.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Markup factor | 1 + Markup on cost | 1 + 0.25 | 1.25 |
| Estimated COGS | Net sales1 + Markup on cost | $175,0001.25 | $140,000 |
The selling price includes both cost and markup. Divide sales by the cost-plus-markup factor; a markup on cost is not a gross margin on sales.
7. Estimate the goods destroyed
Confetti provides these amounts for March 2026:
| Input | Amount |
|---|---|
| Beginning inventory at cost | $44,200 |
| Net purchases at cost | $121,800 |
| Net sales | $175,000 |
| Supported gross margin on sales | 28.00% |
No other inventory movements apply.
A fire then leaves recovered goods costing $6,800. Assume the pre-fire estimate is suitable and no earlier shortage exists. Calculate estimated inventory destroyed.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Goods available at cost | Beginning inventory + Net purchases | $44,200 + $121,800 | $166,000 |
| Estimated COGS | Net sales × (1 − Gross profit rate) | $175,000 × (1 − 28.00%) | $126,000 |
| Estimated ending inventory | Goods available at cost − Estimated COGS | $166,000 − $126,000 | $40,000 |
| Estimated cost destroyed | Estimated pre-fire inventory − Surviving inventory at cost | $40,000 − $6,800 | $33,200 |
The final subtraction uses the cost of surviving goods. This estimates inventory lost under the stated assumptions; it does not determine insurance reimbursement.
8. Calculate the retail ratio
Confetti uses the average-cost retail method for this April 2026 inventory pool:
| Inventory source | Cost | Retail |
|---|---|---|
| Beginning inventory | $26,400 | $44,000 |
| Purchases | $81,600 | $136,000 |
Net sales are $127,000. There are no price changes, returns, transfers, or inventory shortages.
Calculate the cost-to-retail ratio as a percentage.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Goods available at cost | Beginning cost + Purchase cost | $26,400 + $81,600 | $108,000 |
| Goods available at retail | Beginning retail + Purchase retail | $44,000 + $136,000 | $180,000 |
| Cost-to-retail ratio | Goods available at costGoods available at retail × 100% | $108,000$180,000 × 100% | 60.00% |
Both totals describe the same merchandise. Divide cost by retail value, not retail value by cost.
9. Derive ending inventory at retail
Confetti uses the average-cost retail method for this April 2026 inventory pool:
| Inventory source | Cost | Retail |
|---|---|---|
| Beginning inventory | $26,400 | $44,000 |
| Purchases | $81,600 | $136,000 |
Net sales are $127,000. There are no price changes, returns, transfers, or inventory shortages.
Calculate ending inventory at retail.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Goods available at retail | Beginning retail + Purchase retail | $44,000 + $136,000 | $180,000 |
| Ending inventory at retail | Goods available at retail − Net sales | $180,000 − $127,000 | $53,000 |
This result is still at retail selling prices. Do not apply the cost-to-retail ratio until estimating inventory cost.
10. Estimate ending cost
Confetti uses the average-cost retail method for this April 2026 inventory pool:
| Inventory source | Cost | Retail |
|---|---|---|
| Beginning inventory | $26,400 | $44,000 |
| Purchases | $81,600 | $136,000 |
Net sales are $127,000. There are no price changes, returns, transfers, or inventory shortages.
Calculate estimated ending inventory at cost.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Goods available at cost | Beginning cost + Purchase cost | $26,400 + $81,600 | $108,000 |
| Goods available at retail | Beginning retail + Purchase retail | $44,000 + $136,000 | $180,000 |
| Cost-to-retail ratio | Goods available at costGoods available at retail × 100% | $108,000$180,000 × 100% | 60.00% |
| Ending inventory at retail | Goods available at retail − Net sales | $180,000 − $127,000 | $53,000 |
| Ending inventory at cost | Ending retail value × Cost-to-retail ratio | $53,000 × 60.00% | $31,800 |
Apply the ratio to the unsold retail value, not to sales or total goods available.
10a. Compare FIFO and LIFO retail estimates
Instead, assume Confetti has these April 2026 records:
| Inventory source | Cost | Retail |
|---|---|---|
| Beginning inventory | $18,000 | $30,000 |
| April purchases | $84,000 | $120,000 |
Net sales are $100,000. Beginning inventory is one opening layer, and all April purchases have the same cost-to-retail ratio. Selling prices are unchanged. There are no markdowns, losses, returns, or other inventory movements. Use periodic calculations.
Calculate ending inventory at cost under FIFO retail and LIFO retail, before any required write-down.
| Calculation | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Beginning ratio | Beginning costBeginning retail × 100% | $18,000$30,000 × 100% | 60% |
| Purchases ratio | Purchase costPurchase retail × 100% | $84,000$120,000 × 100% | 70% |
| Goods available at retail | Beginning retail + Purchase retail | $30,000 + $120,000 | $150,000 |
| Ending inventory at retail | Goods available at retail − Net sales | $150,000 − $100,000 | $50,000 |
| FIFO ending inventory at cost | Ending retail × Purchases ratio | $50,000 × 70% | $35,000 |
FIFO assigns beginning inventory to sales first. April purchases cover the entire ending balance, so all remaining retail value uses April's ratio.
Under LIFO, the opening layer remains. Calculate the increase above that layer separately:
| Calculation | Formula | Substitute the amounts | Result |
|---|---|---|---|
| New layer at retail | Ending retail − Beginning retail | $50,000 − $30,000 | $20,000 |
| New layer at cost | New retail layer × Purchases ratio | $20,000 × 70% | $14,000 |
| LIFO ending inventory at cost | Beginning cost + New layer cost | $18,000 + $14,000 | $32,000 |
The opening layer retains its $18,000 recorded cost, corresponding to its original 60% ratio. Only the new layer uses April's 70% ratio.
10b. Compare retail markdown treatments
Instead, assume Confetti reports these amounts for an April 2026 merchandise pool:
| Input | Amount |
|---|---|
| Goods available at cost | $72,000 |
| Goods available at original retail prices | $120,000 |
| Permanent markdowns | $24,000 |
| Net sales | $60,000 |
There are no other price changes or inventory movements. Calculate the cost-to-retail ratio and ending inventory under each alternative: average-cost retail and conventional retail.
Both methods subtract markdowns and sales to determine ending inventory at retail:
| Calculation | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Ending inventory at retail | Original retail − Markdowns − Net sales | $120,000 − $24,000 − $60,000 | $36,000 |
The ratio denominators differ:
| Method | Cost-to-retail ratio formula | Substitute the amounts | Ratio |
|---|---|---|---|
| Average-cost retail | Goods available at costOriginal retail − Markdowns × 100% | $72,000$120,000 − $24,000 × 100% | 75% |
| Conventional retail | Goods available at costOriginal retail × 100% | $72,000$120,000 × 100% | 60% |
| Method | Formula | Substitute the amounts | Ending inventory |
|---|---|---|---|
| Average-cost retail | Ending retail × Selected ratio | $36,000 × 75% | $27,000 |
| Conventional retail | Ending retail × Selected ratio | $36,000 × 60% | $21,600 |
Average-cost retail estimates cost before any required write-down. Conventional retail approximates lower of cost or market by excluding markdowns from the ratio denominator. Both methods remain subject to that measurement requirement. The difference between these results does not establish the required write-down without further information about market.
11. Evaluate missing goods
Confetti has calculated ending inventory at retail by subtracting sales from goods available at retail. It then discovers a theft omitted from that calculation.
The theft has not affected the pool's cost-to-retail ratio. How should Confetti use that ratio to estimate the cost of goods still on hand?
A is correct. First remove the stolen goods at their retail value. Then apply the cost-to-retail ratio to estimate the cost of goods still present. Both amounts in the subtraction must be measured at retail.
12. Select the receivable flow
Confetti reports net credit sales, cash sales, and customer collections separately. Its trade receivables arise only from credit sales. Which numerator should it use for accounts receivable turnover?
C is correct. Divide net credit sales by average related trade receivables. Customer collections differ from current credit sales because some payments settle earlier sales and some current sales remain unpaid.
13. Calculate receivable turnover
Confetti reports the following annual amounts.
| Annual amount | 2026 |
|---|---|
| Net credit sales | $584,000 |
| Cash sales | $116,800 |
| Cost of goods sold | $383,250 |
| Beginning inventory | $42,000 |
| Ending inventory | $51,100 |
| Beginning trade receivables | $47,000 |
| Ending trade receivables | $65,000 |
| Beginning trade payables | $31,000 |
| Ending trade payables | $39,000 |
All inventory purchases are on credit, and trade payables relate only to those purchases. Assume no receivable allowance or other receivable adjustments, and no inventory losses, write-downs, acquisitions, or other inventory movements.
Calculate receivable turnover.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average receivables | Beginning receivables + Ending receivables2 | $47,000 + $65,0002 | $56,000 |
| Receivable turnover | Net credit salesAverage receivables | $584,000$56,000 | 10.43 times |
Use the average of the beginning and ending receivables. Cash sales do not create these receivables and are excluded from the numerator.
14. Calculate collection days
Confetti reports the following annual amounts.
| Annual amount | 2026 |
|---|---|
| Net credit sales | $584,000 |
| Cash sales | $116,800 |
| Cost of goods sold | $383,250 |
| Beginning inventory | $42,000 |
| Ending inventory | $51,100 |
| Beginning trade receivables | $47,000 |
| Ending trade receivables | $65,000 |
| Beginning trade payables | $31,000 |
| Ending trade payables | $39,000 |
All inventory purchases are on credit, and trade payables relate only to those purchases. Assume no receivable allowance or other receivable adjustments, and no inventory losses, write-downs, acquisitions, or other inventory movements.
Calculate days sales outstanding.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average receivables | Beginning receivables + Ending receivables2 | $47,000 + $65,0002 | $56,000 |
| Daily credit sales | credit salesDays in the year | $584,000365 | $1,600 per day |
| Collection days | Average receivablesDaily credit sales | $56,000$1,600 | 35.00 days |
The average unpaid balance represents 35.00 days of credit sales. Including cash sales would increase daily sales and make the collection period appear shorter.
15. Retrieve inventory days
Confetti reports the following annual amounts.
| Annual amount | 2026 |
|---|---|
| Net credit sales | $584,000 |
| Cash sales | $116,800 |
| Cost of goods sold | $383,250 |
| Beginning inventory | $42,000 |
| Ending inventory | $51,100 |
| Beginning trade receivables | $47,000 |
| Ending trade receivables | $65,000 |
| Beginning trade payables | $31,000 |
| Ending trade payables | $39,000 |
All inventory purchases are on credit, and trade payables relate only to those purchases. Assume no receivable allowance or other receivable adjustments, and no inventory losses, write-downs, acquisitions, or other inventory movements.
Calculate days inventory outstanding.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average inventory | Beginning inventory + Ending inventory2 | $42,000 + $51,1002 | $46,550 |
| Inventory turnover | COGSAverage inventory | $383,250$46,550 | 8.23 times |
| Days in inventory | Days in the yearInventory turnover | 365$383,250$46,550 | 44.33 days |
Keep unrounded intermediate values in your calculator. The displayed ratios and days are rounded to two decimal places.
16. Derive credit purchases
Confetti reports the following annual amounts.
| Annual amount | 2026 |
|---|---|
| Net credit sales | $584,000 |
| Cash sales | $116,800 |
| Cost of goods sold | $383,250 |
| Beginning inventory | $42,000 |
| Ending inventory | $51,100 |
| Beginning trade receivables | $47,000 |
| Ending trade receivables | $65,000 |
| Beginning trade payables | $31,000 |
| Ending trade payables | $39,000 |
All inventory purchases are on credit, and trade payables relate only to those purchases. Assume no receivable allowance or other receivable adjustments, and no inventory losses, write-downs, acquisitions, or other inventory movements.
Calculate credit inventory purchases.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Credit purchases | COGS + Ending inventory − Beginning inventory | $383,250 + $51,100 − $42,000 | $392,350 |
Ending inventory exceeds beginning inventory, so purchases exceed COGS. All purchases are on credit in this case; no cash-purchase adjustment is needed.
17. Calculate payment days
Confetti reports the following annual amounts.
| Annual amount | 2026 |
|---|---|
| Net credit sales | $584,000 |
| Cash sales | $116,800 |
| Cost of goods sold | $383,250 |
| Beginning inventory | $42,000 |
| Ending inventory | $51,100 |
| Beginning trade receivables | $47,000 |
| Ending trade receivables | $65,000 |
| Beginning trade payables | $31,000 |
| Ending trade payables | $39,000 |
All inventory purchases are on credit, and trade payables relate only to those purchases. Assume no receivable allowance or other receivable adjustments, and no inventory losses, write-downs, acquisitions, or other inventory movements.
Calculate days payables outstanding using purchases.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Credit purchases | COGS + Ending inventory − Beginning inventory | $383,250 + $51,100 − $42,000 | $392,350 |
| Average payables | Beginning payables + Ending payables2 | $31,000 + $39,0002 | $35,000 |
| Daily credit purchases | credit purchasesDays in the year | $392,350365 | Approximately $1,074.93 per day |
| Payment days | Average payablesDaily credit purchases | $35,000$392,350365 | 32.56 days |
The average payable balance is divided by daily credit purchases, not daily COGS. Keep unrounded intermediate values in your calculator. The displayed ratios and days are rounded to two decimal places.
18. Evaluate a proxy
Inventory increases, and all inventory purchases are on credit. There are no losses, write-downs, acquisitions, or other inventory changes.
An analyst substitutes cost of goods sold for credit purchases when calculating payment days. Holding payables and the other cycle components constant, how does this affect payment days and the cash conversion cycle?
B is correct. Purchases equal cost of goods sold plus the inventory increase. Substituting the smaller cost of goods sold overstates payment days. Because the cash conversion cycle subtracts payment days, the cycle is understated.
19. Combine the cycle
Confetti reports the following annual amounts.
| Annual amount | 2026 |
|---|---|
| Net credit sales | $584,000 |
| Cash sales | $116,800 |
| Cost of goods sold | $383,250 |
| Beginning inventory | $42,000 |
| Ending inventory | $51,100 |
| Beginning trade receivables | $47,000 |
| Ending trade receivables | $65,000 |
| Beginning trade payables | $31,000 |
| Ending trade payables | $39,000 |
All inventory purchases are on credit, and trade payables relate only to those purchases. Assume no receivable allowance or other receivable adjustments, and no inventory losses, write-downs, acquisitions, or other inventory movements.
Calculate the cash conversion cycle. Explain what the result does and does not establish.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average receivables | Beginning receivables + Ending receivables2 | $47,000 + $65,0002 | $56,000 |
| Daily credit sales | credit salesDays in the year | $584,000365 | $1,600 per day |
| Collection days | Average receivablesDaily credit sales | $56,000$1,600 | 35.00 days |
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average inventory | Beginning inventory + Ending inventory2 | $42,000 + $51,1002 | $46,550 |
| Inventory turnover | COGSAverage inventory | $383,250$46,550 | 8.23 times |
| Days in inventory | Days in the yearInventory turnover | 365$383,250$46,550 | 44.33 days |
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Credit purchases | COGS + Ending inventory − Beginning inventory | $383,250 + $51,100 − $42,000 | $392,350 |
| Average payables | Beginning payables + Ending payables2 | $31,000 + $39,0002 | $35,000 |
| Daily credit purchases | credit purchasesDays in the year | $392,350365 | Approximately $1,074.93 per day |
| Payment days | Average payablesDaily credit purchases | $35,000$392,350365 | 32.56 days |
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Cash conversion cycle | Days in inventory + Collection days − Payment days | 44.33 + 35.00 − 32.56 | 46.77 days |
Keep unrounded intermediate values in your calculator. The displayed ratios and days are rounded to two decimal places. The result estimates the interval between supplier payment and customer collection. It is not cash on hand or a forecast of every cash payment.
20a. Compare the second year
Confetti reports the following annual amounts.
| Annual amount | 2026 | 2027 |
|---|---|---|
| Net credit sales | $584,000 | $700,800 |
| Cash sales | $116,800 | $140,160 |
| Cost of goods sold | $383,250 | $452,600 |
| Beginning inventory | $42,000 | $51,100 |
| Ending inventory | $51,100 | $62,000 |
| Beginning trade receivables | $47,000 | $65,000 |
| Ending trade receivables | $65,000 | $53,000 |
| Beginning trade payables | $31,000 | $39,000 |
| Ending trade payables | $39,000 | $53,000 |
All inventory purchases are on credit, and trade payables relate only to those purchases. Assume no receivable allowance or other receivable adjustments, and no inventory losses, write-downs, acquisitions, or other inventory movements.
Calculate the 2027 cash conversion cycle.
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average receivables | Beginning receivables + Ending receivables2 | $65,000 + $53,0002 | $59,000 |
| Daily credit sales | credit salesDays in the year | $700,800365 | $1,920 per day |
| Collection days | Average receivablesDaily credit sales | $59,000$1,920 | 30.73 days |
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average inventory | Beginning inventory + Ending inventory2 | $51,100 + $62,0002 | $56,550 |
| Inventory turnover | COGSAverage inventory | $452,600$56,550 | 8.00 times |
| Days in inventory | Days in the yearInventory turnover | 365$452,600$56,550 | 45.60 days |
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Credit purchases | COGS + Ending inventory − Beginning inventory | $452,600 + $62,000 − $51,100 | $463,500 |
| Average payables | Beginning payables + Ending payables2 | $39,000 + $53,0002 | $46,000 |
| Daily credit purchases | credit purchasesDays in the year | $463,500365 | Approximately $1,269.86 per day |
| Payment days | Average payablesDaily credit purchases | $46,000$463,500365 | 36.22 days |
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Cash conversion cycle | Days in inventory + Collection days − Payment days | 45.60 + 30.73 − 36.22 | 40.11 days |
Keep unrounded intermediate values in your calculator. The displayed ratios and days are rounded to two decimal places.
20b. Attribute the change
Confetti reports the following annual amounts.
| Annual amount | 2026 | 2027 |
|---|---|---|
| Net credit sales | $584,000 | $700,800 |
| Cash sales | $116,800 | $140,160 |
| Cost of goods sold | $383,250 | $452,600 |
| Beginning inventory | $42,000 | $51,100 |
| Ending inventory | $51,100 | $62,000 |
| Beginning trade receivables | $47,000 | $65,000 |
| Ending trade receivables | $65,000 | $53,000 |
| Beginning trade payables | $31,000 | $39,000 |
| Ending trade payables | $39,000 | $53,000 |
All inventory purchases are on credit, and trade payables relate only to those purchases. Assume no receivable allowance or other receivable adjustments, and no inventory losses, write-downs, acquisitions, or other inventory movements.
Calculate the change in the cash conversion cycle, using unrounded values. Explain the component contributions.
Reconstruct the 2026 components:
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average receivables | Beginning receivables + Ending receivables2 | $47,000 + $65,0002 | $56,000 |
| Daily credit sales | credit salesDays in the year | $584,000365 | $1,600 per day |
| Collection days | Average receivablesDaily credit sales | $56,000$1,600 | 35.00 days |
| Average inventory | Beginning inventory + Ending inventory2 | $42,000 + $51,1002 | $46,550 |
| Inventory turnover | COGSAverage inventory | $383,250$46,550 | 8.23 times |
| Days in inventory | Days in the yearInventory turnover | 365$383,250$46,550 | 44.33 days |
| Credit purchases | COGS + Ending inventory − Beginning inventory | $383,250 + $51,100 − $42,000 | $392,350 |
| Average payables | Beginning payables + Ending payables2 | $31,000 + $39,0002 | $35,000 |
| Daily credit purchases | credit purchasesDays in the year | $392,350365 | Approximately $1,074.93 per day |
| Payment days | Average payablesDaily credit purchases | $35,000$392,350365 | 32.56 days |
Reconstruct the 2027 components:
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Average receivables | Beginning receivables + Ending receivables2 | $65,000 + $53,0002 | $59,000 |
| Daily credit sales | credit salesDays in the year | $700,800365 | $1,920 per day |
| Collection days | Average receivablesDaily credit sales | $59,000$1,920 | 30.73 days |
| Average inventory | Beginning inventory + Ending inventory2 | $51,100 + $62,0002 | $56,550 |
| Inventory turnover | COGSAverage inventory | $452,600$56,550 | 8.00 times |
| Days in inventory | Days in the yearInventory turnover | 365$452,600$56,550 | 45.60 days |
| Credit purchases | COGS + Ending inventory − Beginning inventory | $452,600 + $62,000 − $51,100 | $463,500 |
| Average payables | Beginning payables + Ending payables2 | $39,000 + $53,0002 | $46,000 |
| Daily credit purchases | credit purchasesDays in the year | $463,500365 | Approximately $1,269.86 per day |
| Payment days | Average payablesDaily credit purchases | $46,000$463,500365 | 36.22 days |
Attribute the change:
| Step | Formula | Substitute the amounts | Result |
|---|---|---|---|
| Collection days | 2027 days − 2026 days | 30.73 − 35.00 | -4.27 days |
| Days in inventory | 2027 days − 2026 days | 45.60 − 44.33 | 1.27 days |
| Payment days | 2027 days − 2026 days | 36.22 − 32.56 | 3.66 days |
| Change in cash conversion cycle | Change in inventory days + Change in collection days − Change in payment days | 1.27 + (-4.27) − 3.66 | -6.66 days |
Faster collection shortens the cycle. Longer inventory holding partly offsets that improvement. Longer supplier payment time further shortens the cycle because payment days are subtracted. A negative net change means the cycle decreased. Keep unrounded intermediate values in your calculator. The displayed ratios and days are rounded to two decimal places.
20c. Choose the operating evidence
Confetti's cash conversion cycle decreases while days in inventory increase. Management reviews these additional records:
| Record | Finding |
|---|---|
| Customer accounts | Payment terms are unchanged; fewer invoices remain overdue. |
| Inventory plans | The inventory increase consists of goods ordered for confirmed upcoming events. |
| Supplier accounts | Suppliers agreed to longer payment terms; Confetti pays by the new due dates. |
Which explanation best fits these records?
D is correct. The customer records support improved collection under unchanged terms. Confirmed events explain the additional inventory, and supplier agreements explain later payment. These records support the reasons for the timing changes; they do not establish whether total profitability improved.