ABC Inc. is evaluating its financing needs. To do this, the company must determi
ID: 2807209 • Letter: A
Question
ABC Inc. is evaluating its financing needs. To do this, the company must determine the amount of time it will need to finance its inventory. ABC Inc. had the following information.
Beginning Inventory = 225,000; Ending Inventory = 270,000
Beginning Accounts Receivable = 180,000; Ending Accounts Receivable = 200,000
Beginning Accounts Payable= 75,000; Ending Accounts Payable= 100,000
Net sales = 1,100,000; Cost of Goods sold = 850,000
A. What is ABC Inc.’s Inventory period? (Hint: 365 / Inventory Turnover)
B. What is ABC Inc.’s Receivables period? (Hint: 365 / Receivables Turnover)
C. What is ABC Inc.’s Operating cycle? (Hint: Inventory Period + Accounts Receivable Period)
D. What is ABC Inc.’s Payables period? (Hint: 365 / Payables Turnover)
E. What is ABC Inc.’s Cash cycle? (Hint: Operating cycle – Accounts payable period)
Explanation / Answer
Inventory turnover = Cost of goods sold x 2 / (Beginning Inventory + Ending Inventory)
= $850,000 x 2 / ($225,000 + $270,000)
= 3.4343 times
Receivables Turnover = Net Sales x 2 / (Beginning AR + Ending AR)
= $1,100,000 x2 / ($180,000 + $200,000)
= 5.7895
Payable Turnover = Cost of goods sold x 2 / (Beginning AP + Ending AP)
= $850,000 x 2 / ($75,000 + $100,000)
= 9.71 times
Part A
Inventory period = 365 / Inventory Turnover
= 365 / 3.4343
= 106.28 days
Part B
Receivables period = 365 / Receivable Turnover
= 365 / 5.7895
= 63.05 days
Part C
Operating cycle = Receivables period+ Inventory period
= 63.05 + 106.28 days
= 169.33 days
Part D
Payable period = 365 / payable Turnover
= 365 / 9.71
= 37.59 days
Part E
Cash Conversion cycle = Operating cycle – payable period
= 169.33 days – 37.59 days
= 131.74 days