230k views
4 votes
Following are financial data from year-end financial statements of Portland Company for 2017, 2016 and 2015.

2017 2016 2015
Accounts receivable $136,125 $144,576 $132,000
Cost of goods sold 1,023,750 864,000 960,000
Current assets 450,000 360,000 405,000
Current liabilities 300,000 250,000 310,000
Inventory 225,000 165,000 195,000
Sales 1,642,500 1,752,000 1,200,000

Required:
Compute the following financial ratios for 2016 and 2017.

User Alirobe
by
6.5k points

1 Answer

6 votes

Answer:

Answers are calculated below

Step-by-step explanation:

Financial ratios can be calculated according to their formulas. Both formulas and calculation are as follows

CURRENT RATIO

Current ratio = Current assets/current liabilities

Current ratio (2016) = $360,000/$250,000

Current ratio (2016) = 1.44

Current ratio (2017) = $450,000 / $300,000

Current ratio (2017) = 1.50

ACID RATIO

Acid ratio = (Current asset - inventory)/current liabilities

Acid ratio (2016) = (360,000 - 165,000)/250,000

Acid ratio (2016) = 0.78

Acid ratio (2017) = (450,000-225,000)/300,000

Acid ratio (2017) = 225,000/300,000

Acid ratio (2017) = 0.75

INVENTORY TURNOVER RATIO

Inventory turnover ratio = cost of good Sold / Average inventory

Inventory turnover ratio (2016) = 864,000/(360,000 ÷2)

Inventory turnover ratio (2016) = 864,000/180,000

Inventory turnover ratio (2016) = 4.80

Inventory turnover ratio (2017) = 1,023,750 / ( 390,000 ÷ 2)

Inventory turnover ratio (2017) = 1,023,750 / 195,000

Inventory turnover ratio (2017) = 5.25

DAYS SALE IN RECEIVABLE

Days sale in receivable = 365/Average receivable turnover ratio

Days sale in receivable (2016) = 365/ 12.67(w1)

Days sale in receivable (2016) = 28.81 days

Days sale in receivable (2017) =365/11.7(w1)

Days sale in receivable (2017) = 31.20 days

Working 1

Account receivable turnover ratio = Sales/ Average receivable

Account receivable turnover ratio (2016) = 1,752,000/138,288(w2)

Account receivable turnover ratio = 12.67 times

Account receivable turnover ratio (2017) = 1,642,500/140,351(w2)

Account receivable turnover ratio (2017) = 11.7 times

Working 2

Average receivable = (Opening + Closing) /2

Average receivable (2016) = (132,000 + 144,576) /2

Average receivable (2016) = 138,288

Average receivable (2017) = (144,576 +136,125 ) /2

Average receivable (2017) = 140,351

User Rockeem
by
5.6k points