Question

Splish Brothers Merchants reported the following on its income statement for the fiscal year ended December...

Splish Brothers Merchants reported the following on its income statement for the fiscal year ended December 31, 2021 and 2020.

2021 2020
Sales $496,060 $475,390
Cost of goods sold
    Beginning inventory 146,480 154,124
    Net purchases 345,990 322,960
    Ending inventory (138,774) (146,480)
Cost of goods sold 353,696 330,604
Gross profit 142,364 144,786
Operating expenses 87,568 89,168
Profit $54,796 $55,618

Calculate the inventory turnover ratio for Splish Brothers for 2021 and 2020. (Round answers to 2 decimal places, e.g. 52.75.)

2021 2020
Inventory turnover times times

Calculate the days sales in inventory for Splish Brothers for 2021 and 2020. (Round answers to 0 decimal places, e.g. 5,275 and use 365 days for calculation.)

2021 2020
Days sales in inventory days days

Calculate the gross profit margin for Splish Brothers for 2021 and 2020. (Round answers to 1 decimal place, e.g. 52.7%.)

2021 2020
Gross profit margin % %

Calculate the profit margin for Splish Brothers for 2021 and 2020. (Round answers to 1 decimal place, e.g. 52.7%.)

2021 2020
Profit margin % %

For each ratio calculated in (a), (b), (c) and (d) above, identify if the ratio has improved or deteriorated from 2020 to 2021.

Inventory turnover                                                                       DeterioratedImproved
Days sales in inventory                                                                       DeterioratedImproved
Gross profit margin                                                                       ImprovedDeteriorated
Profit margin                                                                       ImprovedDeteriorated

Homework Answers

Answer #1
2021 2020
Average inventory [ ( Beginning inventory + Ending inventory ) / 2 ] 142627 150302
2021 2020
Inventory turnover [ Cost of goods sold / Average inventory ] 2.48 2.20
Days sales in inventory [ 365 / Inventory turnover ] 147 166
Gross profit margin [ Gross profit / Sales ] 28.7% 30.5%
Profit margin [ Profit / Sales ] 11.0% 11.7%
Inventory turnover Improved
Days sales in inventory Improved
Gross profit margin Deteriorated
Profit margin Deteriorated
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Arlington Merchants reported the following on its income statement for the fiscal years ended December 31,...
Arlington Merchants reported the following on its income statement for the fiscal years ended December 31, 2020 and 2019. 2020 2019 Sales $4,853,000 $4,753,000 Cost of goods sold 3,266,069 3,203,522 Gross profit 1,586,931 1,549,478 Operating expenses 878,393 893,564 Profit $708,538 $655,914 Calculate the gross profit margin for Arlington for 2019 and 2020. (Round answers to 1 decimal place, e.g. 52.7%.) Gross profit margin 2020 % 2019 % eTextbook and Media       Calculate the profit margin for Arlington for 2019...
The following information is available for Splish Brothers Inc. for three recent fiscal years. 2022 2021...
The following information is available for Splish Brothers Inc. for three recent fiscal years. 2022 2021 2020 Inventory $580,000 $590,000 $320,000 Net sales 1,950,000 1,750,000 1,350,000 Cost of goods sold 1,462,500 1,228,500 938,000 (a) Calculate the inventory turnover, days in inventory, and gross profit rate for 2022 and 2021. (Round inventory turnover to 1 decimal place, e.g. 5.2, days in inventory to 0 decimal places, e.g. 125 and gross profit rate to 1 decimal place, e.g. 5.2%.) 2022 2021 Inventory...
At December 31, 2021, Splish Brothers Inc. reported this information on its balance sheet. Accounts receivable...
At December 31, 2021, Splish Brothers Inc. reported this information on its balance sheet. Accounts receivable $581,000 Less: Allowance for doubtful accounts 37,000 During 2022, the company had the following transactions related to receivables. 1. Sales on account $2,355,000 2. Sales returns and allowances 49,000 3. Collections of accounts receivable 2,050,000 4. Write-offs of accounts receivable deemed uncollectible 38,000 5. Recovery of bad debts previously written off as uncollectible 16,000 Compute the accounts receivable turnover and average collection period, assuming...
The following information is available for Bramble Corp. for three recent fiscal years. 2022 2021 2020...
The following information is available for Bramble Corp. for three recent fiscal years. 2022 2021 2020 Inventory $530,000 $562,000 $330,000 Net sales 1,885,000 1,784,000 1,315,000 Cost of goods sold 1,583,400 1,338,000 955,000 (a) Calculate the inventory turnover, days in inventory, and gross profit rate for 2022 and 2021. (Round inventory turnover to 1 decimal place, e.g. 5.2, days in inventory to 0 decimal places, e.g. 125 and gross profit rate to 1 decimal place, e.g. 5.2%.) 2022 2021 Inventory Turnover...
The following information is available for Tamarisk, Inc. for three recent fiscal years. 2022 2021 2020...
The following information is available for Tamarisk, Inc. for three recent fiscal years. 2022 2021 2020 Inventory $568,000 $578,000 $345,000 Net sales 1,910,000 1,775,000 1,370,000 Cost of goods sold 1,661,700 1,384,500 954,000 (a) Calculate the inventory turnover, days in inventory, and gross profit rate for 2022 and 2021. (Round inventory turnover to 1 decimal place, e.g. 5.2, days in inventory to 0 decimal places, e.g. 125 and gross profit rate to 1 decimal place, e.g. 5.2%.) 2022 2021 Inventory Turnover...
Exercise 6-11 a-c Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022....
Exercise 6-11 a-c Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) 2020 2021 2022 Beginning inventory $2,100 $2,600 $2,900 Ending inventory 2,600 2,900 3,000 Cost of goods sold 22,795 26,400 26,255 Sales revenue 41,000 44,000 43,980 Calculate the inventory turnover for 2020, 2021, and 2022. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 2020 2021 2022 Inventory turnover enter an inventory turnover times enter an inventory turnover times enter an inventory turnover...
Metlock Inc., a fertilizer company based in Alberta, had the following information on its financial statements...
Metlock Inc., a fertilizer company based in Alberta, had the following information on its financial statements for the fiscal years ended December 31. All figures are in millions of dollars. 2022 2021 2020 2019 Net sales $16,210 $15,759 $16,882 $15,380 Profit 715 1,303 1,498 1,335 Total assets 17,252 15,955 14,378 13,280 a) Calculate Metlock's (1) asset turnover ratio, and (2) return on assets ratio for 2020 through 2022. (Round answers to 2 decimal places, e.g. 52.75.) 2022 2021 2020 Asset...
In its 2020 annual report, Headlands Limited reports beginning-of-the-year total assets of $2,308 million, end-of-the-year total...
In its 2020 annual report, Headlands Limited reports beginning-of-the-year total assets of $2,308 million, end-of-the-year total assets of $2,182 million, total revenue of $2,355 million, and net income of $150 million. Calculate Headlands's asset turnover ratio. (Round answer to 2 decimal places, e.g. 52.75.) Asset turnover ratio enter Asset turnover ratio in times times Link to Text Calculate Headlands's profit margin. (Round answer to 2 decimal places, e.g. 52.75%.) Profit margin enter Profit margin in percentages % Link to Text...
Zipper Corporation reported the following condensed income statement for 2015: Sales $5,900,000 Cost of goods sold...
Zipper Corporation reported the following condensed income statement for 2015: Sales $5,900,000 Cost of goods sold 4,130,000 Gross profit $1,770,000 Less expenses -1,520,000 Net income before taxes $250,000 Less income taxes 100,000 Net income after taxes $150,000 Assume the following: Average inventory $690,000 Average accounts receivable $1,220,000 Average accounts payable $390,000 (Use 365 days a year) Compute the following: (Round answers to 2 decimal places, e.g. 52.75.) Inventory turnover times Accounts receivable turnover times Average number of days to sell...
Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) 2020...
Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) 2020 2021 2022 Beginning inventory $2,000 $2,400 $2,700 Ending inventory 2,400 2,700 2,800 Cost of goods sold 20,680 23,715 23,650 Sales revenue 38,800 42,500 42,460 Calculate the inventory turnover for 2020, 2021, and 2022. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 2020 2021 2022 Inventory turnover enter an inventory turnover times enter an inventory turnover times enter an inventory turnover times eTextbook and...