Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

value: 5.00 points The financial information below presents selected information

ID: 2595862 • Letter: V

Question

value: 5.00 points The financial information below presents selected information from the financial statements of Pelican Company. Sales revenue during the current year was $13,380,300 and cost of goods sold was $8,913,195 All of Pelican's sales are made on account and are due within 30 days Prior Year 568,330 4,710,000 Current Year 631,780 3,816,000 Cash and cash equivalents Accounts receivable Inventory Total current assets Total assets Total current liabilities Total liabilities 936,360 271,440 8,300,030 8,240,100 11,116,020 10,996,000 6,436,000 8,465,900 8,272,700 7,760,300 Calculate the following a. Current ratios as of the end of the current and prior year. (Round your answers to 2 decimal places.) Current YearPrior Year Current Ratio 1.28 1.07 b. Calculate the receivables turnover ratio for the current year. (Round your answer to 2 decimal places.) Receivables Turnover 3.14

Explanation / Answer

SOLUTION

(A) Current Ratio = Current assets / Currenr Liabilities

Current year = $8,240,100 / $6,436,000 = 1.28

Prior yaer = $8,300,030 / $7,760,300 = 1.07

(B) Receivables turnover = Sales / (Average receivables)

= $13,380,300 / [(4,710,000+3,816,000)/2]

= $13,380,300 / $4,263,000 = 3.14

(C) Days to collect = 365 / 3.14 = 116 days

(D) Inventory turnover ratio = Cost of goods sold / Average inventory

= $8,913,195 / [(936,360 / 1,271,440 ) / 2]

= $8,913,195 / 1,103,900 = 8.07

(E) Days to sell = 365 / 8.07 = 45 days