Question

The financial information below presents selected information from the financial statements of Pelican Company. Sales revenue during the current year was $13,560,300 and cost of goods sold was $8,908,695. All of Pelican's sales are made on account and are due within 30 days.
Prior Year Current Year
Cash and cash equivalents $556,330 $607,780
Accounts receivable 4,590,000 3,804,000
Inventory 924,360 1,235,440
Total current assets 8,600,030 8,420,100
Total assets 11,104,020 10,984,000
Total current liabilities 7,340,300 7,216,000
Total liabilities 8,453,900 8,248,700
A. Current ratios as of the end of the current and prior year.
B. Calculate the receivables turnover ratio for the current year.
C. Calculate the days to collect for the current year.
D. Calculate the inventory turnover ratio for the current year.
E. Calculate the days to sell for the current year.

Answer 1

Answer:

a. Current ration = Total current assets / Total current liabilities

Current year = 8,600,030 / 7,340,300 = 1.17

Prior year = 8,420,100 / 7,216,000 = 1.167

b. Receivables turnover = Sales / Average Account receivables

=$13,560,300 / (4,590,000 + 3,804,000 / 2)

= $13,560,300 / $4,197,000

= 3.23 times

c. Days to collect = 365 / Receivables times

= 365 / 3.23

= 113 days

d. Inventory turnover ration = Cost of goods sold / Average Inventory

= $8,908,695 / ($924,360 + $1,235,440 / 2)

= $8,908,695 / $1.079,990

= 8.25 times

e. Days to sell = 365 / Inventory turnover

= 365 / 8.25

= 44.24 days