**Excel's Companies Financial Overview****Income Statement***For the Years Ended May 31, 2018, and 2017*- **Net Sales Revenue** - 2018: $51,200 - 2017: $39,800- **Cost of Goods Sold** - 2018: $22,500 - 2017: $23,700- **Interest Expense** - 2018: $500 - 2017: $280- **All Other Expenses** - 2018: $6,200 - 2017: $7,100- **Net Income** - 2018: $22,000 - 2017: $8,720**Balance Sheet***As of May 31, 2018, and 2017***Assets**- Cash - 2018: $2,000 - 2017: $1,800- Short-term Investments - 2018: $26,000 - 2017: $10,000- Accounts Receivable - 2018: $7,300 - 2017: $5,500- Merchandise Inventory - 2018: $6,800 - 2017: $7,500- Other Current Assets - 2018: $11,000 - 2017: $2,400- **Total Current Assets** - 2018: $53,100 - 2017: $27,200- All Other Assets - 2018: $33,000 - 2017: $23,000- **Total Assets** - 2018: $86,100 - 2017: $50,200**Liabilities**- Total Current Liabilities - 2018: $25,000 - 2017: $13,300- Long-term Liabilities - 2018: $14,100 - 2017: $10,200- **Total Liabilities** - 2018: $39,100 - 2017: $23,500**Stockholders' Equity**- Common Stock

Name: **Excel's Companies Financial Overview****Income Statement***For the
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: **Excel's Companies Financial Overview****Income Statement***For the Years Ended May 31, 2018, and 2017*- **Net Sales Revenue** - 2018: $51,200 - 2017: $39,800- **Cost of Goods Sold** - 2018: $22,500 - 2017: $23,700- **Interest Expense** - 2018

Inventory turnover ratio: This is a financial measure that is used to evaluate as to how many times a company sells or uses its inventory during an accounting period. Calculate inventory turnover ratio for the year 2018: Inventory turnover = Cost of goods sold / Average inventory Inventoy turnover = $22,500 / (($6,800 + $7,500) / 2) Inventory turnover = $22,500 / $7,150 Inventory turnover = 3.15 times Calculate days sales inventory: days sales inventory = 365 days in the year / Inventory turnover days sales inventory = 365 / 3.15 times days sales inventory = 115.87 days Note: days sales inventory answer might vary due to round off inventory turnover ratio. Calculate gross profit percentage for 2018: Gross profit percentage = (Gross profit / sales)* 100 Gross profit percentage = (($61,200 - $22,500) / $61,200) * 100 Gross profit percentage = ($38,700 / $61,200) * 100 Gross profit percentage = 63.24%

Business

Accounting

Requirement 1. Compute the inventory turnover, days' sales in inventory, and gross profit percentage for Excels Companies for 2018. Compute the inventory turnover. (Round your answer to two decimal places, XXX) The inventory tumover %3D times

Requirement 1. Compute the inventory turnover, days' sales in inventory, and gross profit percentage for Excels Companies for 2018. Compute the inventory turnover. (Round your answer to two decimal places, XXX) The inventory tumover %3D times

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Current Attempt in Progress The following financial statement items are shown for Cullumber Manufacturing. Inventory Total assets Salaries payable Total liabilities $27060 455% 22.0% 15.2% O 10.0% 123000 15000 55000 Calculate the common-size percentage for inventory.
The following data were taken from the financial records of Pharoah Company. Net sales Beginning inventory Purchases Ending inventory (a1) 2022 $6,310,000 905,000 Inventory turnover 5,137,500 1,080,000 Your answer is correct. 2021 $6,180,000 Compute for each year the inventory turnover. (Round answers to 1 decimal place, e.g. 1.6.) 2022 820,000 4,742,500 905,000 5.0 times 2021 5.4 times
P palace provided the following Information:Ending inventory, previous period$95,500Ending inventory, current period$105,500Sales, previous period$450,550Sales, current period$540,450Determine the Inventory turnover for current period, assuming that gross profit for $195,405.3.43 times2.99 times3.27 times3.61 times
Attached is the spreadsheet to use to enter the figures. Please help
(3) The company "ALPHA" started operations on 01/06/202X. The transactions of buying and selling inventories are shown in the table below: You are asked (a) to display your inventory account statement based on the methods of: FIFO, Weighted average price, with continuous inventory (b) analyze the impact of each method on the balance sheet (statement of financial position) and profit and loss statement figures. 01/06/202X Initial inventory 400 units 0,80€ 09/07/202X Market 1600 0,83€ 10/08/202X Sale- export 1800 21/09/202X Market 1500 0,84€ 25/10/202X Sale – export 1500 29/11/202X Market 1300 0,85€ 20/12/202X Sale-export 1100
You have the following information for Bramble Inc. for the month ended June 30, 2022. Bramble uses a periodic inventory system. Date Description Quantity Unit Cost orSelling Price June 1 Beginning inventory 40 $31 June 4 Purchase 135 34 June 10 Sale 110 61 June 11 Sale return 15 61 June 18 Purchase 55 37 June 18 Purchase return 10 37 June 25 Sale 65 67 June 28 Purchase 35 41
Subject: accounting
Please answer attached
pg up F G enter pg dn Compute Altoona Company's (a) inventory turnover ratio and (b) number of days' sales in inventory ratio, using the following information. Use 365 days year. Round your intermediate calculations to 2 decimal places and final answers to 1 decimal place. Cost of Goods Sold $730,000 Beginning Inventory 53,000 Ending Inventory 68,000 (a) Inventory Turnover Ratio 60,500 (b) Number of Days' Sales in Inventory Ratio 200 Feedback Check My Work a. Refer to the textbook for the inventory turnover ratio formula. Consider the average inventory portion of the formula carefully. b. Average inventory utilizes the total number of days in a year to determine the number of days' sales in inventory ratio. (Refer to the textbook for the formula). 4 more Check My Work uses remaining.
The following data were taken from the financial records of Sunland Company. Net Sales Beginning inventory Purchases Ending inventory (a1) 2022 $6,480,000 Inventory turnover 1,000,000 4,363,000 1,020,000 Your answer is incorrect. 2021 2022 $6,250,000 850,000 4,590,000 Compute for each year the inventory turnover. (Round answers to 1 decimal place, e.g. 1.6.) 1,000,000 times 2021 times
(b) Your answer is correct. Calculate the days in inventory for 2020, 2021, and 2022. (Round answers to 1 decimal places, e.g. 15.2.) (c) 2020 86.9 days eTextbook and Media 2021 121.7 days 2022 125.9 days Attempts: unlimited Calculate the gross profit rate for 2020, 2021, and 2022. (Round answers to 1 decimal places, e.g. 15.2%.) Gross profit rate eTextbook and Media Save for Later 2020 % 2021 % 2022 Attempts: unlimited Submit Answer
Nn.194. Subject :- Account