E6-4-1.pdf

Comments

This is an opportunity to work with Accounts Receivable, Inventory, and Accounts Payable. These

notions are from about pages 194 to 197. With any problem statement we operate with whatever data

is given. While the ideal would be that sales is subdivided between credit sales and cash sales, like in

this problem, if we only have total sales, then we use total sales in the accounts receivable turnover.

Also, feel free to use years of 360 rather than 365. That should never make a difference in the right-ness

or wrong-ness of your response.

Accounts Receivable Turnover = Net credit sales / Average accounts receivable

Days Accounts Receivable outstanding = 365 / Accounts Receivable Turnover

Inventory Turnover = Cost of goods sold / Average inventory

Days Inventory held = 365 / Inventory Turnover

Accounts Payable Turnover = Inventory Purchases / Average accounts payable

Days Accounts Payable outstanding = 365 / Accounts payable turnover

Operating cycle = Days in receivables + Days in inventory

You can see that the operating cycle is the time from purchase of inventory from the vendor to

collection of cash from the customer.

Cash conversion cycle = operating cycle – days accounts payable outstanding

Problem Statement

Selected data of Islander Company follow:

As of December 31, 2022 2021 Accounts receivable $500,000 $470,000 Allowance for doubtful accounts <25,000 > <20,000 > Net accounts receivable $475,000 $450,000 Inventories – lower of cost or market $600,000 $550,000 Accounts payable $400,000 $360,000 Year Ended December 31, 2022 2021 Net credit sales $2,500,000 $2,200,000 Net cash sales 500,000 400,000 Net sales $3,000,000 $2,600,000 Cost of goods sold $2,200,000 $1,800,000 Selling, general, and administrative expenses 300,000 270,000 Other 50,000 30,000 Total operating expenses $2,350,000 $2,100,000

Required:

1. What is the Accounts Receivable Turnover?

2. What is the Days Accounts Receivable Outstanding?

3. What is the Inventory Turnover?

4. What is the Days Inventory held?

5. What is the Accounts Payable Turnover?

6. What is the Days Accounts Payable Outstanding?

7. What is the Operating Cycle?

8. What is the Cash Conversion Cycle?