Selected financial data for Quick Sell, Inc., a retail store, appear as follows. Year 2 Year 1
Sales (all on account) $ 750,000 $ 610,000
Cost of goods sold 495,000 408,000
Average inventory during the year 110,000 102,000
Average receivables during the year 150,000 100,000
a-1. Compute the gross profit percentage for both years. (Round your percentage answers to the nearest whole number. i. e. 0.1234 as 12%.)
a-2. Compute the inventory turnover for both years. (Round your answers to 1 decimal place.)
a-3. Compute the accounts receivable turnover for both years. (Round your answers to 1 decimal place.)
b. Which of the following show a positive or negative trend?
Year 1 Year 2
Gross profit percentage % %
Inventory turnover times times
Accounts receivable turnover times times
Trend
Gross profit rate
Inventory turnover
Accounts receivable turnover
Growth in net sales

a-1

Year 2 34%

Year 1 33%

a-2

Year 2 4.5

Year 1 4.0

a-3

Year 2 5.0

Year 1 6.1

b. Year 2

Explanation:

a-1. Computation for the gross profit percentage for both years using this formula

Gross profit percentage = Gross profit / Sales

Let plug in the formula

Year 2 =( $ 750,000-495,000)/$ 750,000 = 34%

Year 1 = ($ 610,000-$408,000)/$ 610,000 = 33%

a-2. Computation for the inventory turnover for both years using this formula

Inventory turnover = Cost of goods sold / Average inventory during the year

Let plug in the formula

Year 2 = 495,000 /110,000 = 4.5

Year 1 = 408,000/102,000= 4.0

a-3. Computation for the accounts receivable turnover for both years using this formula

Accounts receivable turnover = Sales (on account) / Average receivables during the year

Let plug in the formula

Year 2 = $ 750,000 /150,000 = 5.0

Year 1 = $ 610,000 /100,000 = 6.1

b. Based on the above calculation Year 2 show a positive trend.