Balance Sheet:
The balance sheet concludes the assets invested in by the company as well as reports the liabilities and equity taken up thus showing the economic or financial status of the company.
Inventory:
Inventory refers to the stock or goods which will be sold in the near future and thus is an asset for the company. It comprises of the raw materials which are yet to be processed, the stock which is still going through the process of production and it also includes completed products that are ready for sale. Thus inventory is the biggest and the important source of income and profit for the business.
End inventory:
Period end inventory refers to the units remaining at the end of the fiscal year which are yet to be sold.
Current Assets:
It comprises of all the assets which gets converted into cash in less than a year. Example: inventory, other current assets, etcetera.
Inventory Turnover Ratio:
It depicts the fraction of inventory sold or used by the company within a fiscal year. It states a ratio which shows the number of times goods were sold during an accounting period which thereby states the productivity or the efficiency level of the company regarding the inventory which apparently is the biggest asset for the company.
Days’ sales in inventory:
It indicates the days taken up by the company to convert the stock items into actual sales.
1.
Amount of inventories as a part of current assets on September 26, 2015 and on September 27, 2014.
Explanation of Solution
- The ending inventory as a part of the current assets as on September 26, 2015 accounts for $2,349.
- And the ending inventory as a part of the current assets as on September 27, 2014 accounts for $2,111.
2.
To compute: Inventories as a percentage of total assets on September 26, 2015 and.
September 27, 2014.
2.
Explanation of Solution
Given info,
2015
The ending inventory is $2,349.
Total assets account for $290,479.
2014
The ending inventory is $2,111.
Total assets accounts for $231,839.
Inventory as a percentage of total assets as on September 26, 2015:
Formula to calculate inventory as a percentage of total assets is,
Substitute $2,349 for inventory and $290,479 for total assets.
Therefore, the inventory as a percentage of total assets as on September 26, 2015 is 0.81%.
Inventory as a percentage of total assets as on September 27, 2014:
Formula to calculate inventory as a percentage of total assets is,
Substitute $2,111 for inventory and $231,839 for total assets.
Therefore, the inventory as a percentage of total assets as on September 27, 2014 is 0.91%.
3.
To explain: Relative size of inventories compared to its other types of assets.
3.
Explanation of Solution
- The inventory in both the years accounts for very low amount as compared to other assets of the company.
- Long-term marketable securities comparatively is very high than the inventory.
- Whereas,
goodwill and other assets are somewhere amounts near to inventories yet have a higher value in the balance sheet.
4.
The accounting method used to compute inventory amounts.
4.
Explanation of Solution
The company accounts inventory as per the lower of cost or market (LCM) approach. The notes to statement also mention that the method of
5.
To compute: Inventory turnover and days’ sales in inventory for the year ended September 26, 2015.
5.
Explanation of Solution
Given info,
Cost of sales is $140,089.
The ending inventory is $2,349.
A’s inventory turnover:
Computation of the inventory turnover for 2015:
Formula to calculate the inventory turnover is,
Substitute $140,089 for cost of sales (given) and $2,230 for average inventory (working notes) in the above formula.
Thus, the inventory turnover results to 62.8 times.
Working Notes:
Calculation of the average inventory,
A’s days’ sales in inventory:
Formula to calculate the days’ sales in inventory is,
Substitute $2,349 for ending inventory (given) and $140,089 for cost of sales (given) in the above formula.
Thus, the days’ sales in inventory accounts for 6.12 days.
6.
Information for the year ended September 26, 2015.
6.
Explanation of Solution
Given info,
2016
The ending inventory is $2,132.
The total assets are $321,686.
The cost of sales is $131,376.
2017
The ending inventory is $4,855.
The total assets are $375,319
The cost of sales is $141,048.
Year 2016
1.
Ending inventory
Ending inventory as on September 24, 2016 amounts to $2,132.
2.
Inventory as a percentage of total assets as on September 24, 2016:
Formula to calculate inventory as a percentage of total assets is,
Substitute $2,132 for inventory and $321,686 for total assets.
Therefore, the inventory as a percentage of total assets as on September 24, 2016 is 0.66%.
3.
Inventory relative size compared to other assets
- The inventory in both the years accounts for very low amount as compared to other assets of the company.
- Long-term marketable securities comparatively is very high than the inventory.
- Whereas goodwill and other assets are somewhere amounts near to inventories yet have a higher value in the balance sheet.
4.
Method of inventory valuation:
- The company accounts inventory as per the lower of cost or market (LCM) approach.
- The notes to statement also mention that the method of inventory valuation used is first in, first out method. The inventory mainly consists of the finished goods.
5.
A’s inventory turnover:
Computation of the inventory turnover for 2016:
Formula to calculate the inventory turnover is,
Substitute $131,376 for cost of sales (given) and $2,240.5 for average inventory (working notes) in the above formula.
Thus, the inventory turnover results to 58.64 times.
Working notes:
Calculation of the average inventory,
A’s days’ sales in inventory:
Formula to calculate the days’ sales in inventory is,
Substitute $2,132 for ending inventory (given) and $131,376 for cost of sales (given) in the above formula.
Thus, the days’ sales in inventory accounts for 5.92 days.
Year 2017
1.
Ending inventory
Ending inventory as on September 30, 2017 amounts to $4,855.
2.
Inventory as a percentage of total assets as on September 30, 2017:
Formula to calculate inventory as a percentage of total assets is,
Substitute $4,885 for inventory and $375,319 for total assets.
Therefore, the inventory as a percentage of total assets as on September 30, 2017 is 1.3%.
3.
Inventory relative size compared to other assets
The inventory in both the years accounts for low amount as compared to other assets of the company but has increased comparatively and is more than the intangible assets. Whereas goodwill and other assets are somewhere amounts near to inventories yet have a higher value in the balance sheet.
4.
Method of inventory valuation:
The company accounts inventory as per the lower of cost or market (LCM) approach. The notes to statement also mention that the method of inventory valuation used is first in, first out method. The inventory mainly consists of the finished goods.
5.
A’s inventory turnover:
Computation of the inventory turnover for 2017:
Formula to calculate the inventory turnover is,
Substitute $141,048 for cost of sales (given) and $3,493.5 for average inventory (working notes) in the above formula.
Thus, the inventory turnover results to 40.3 times.
Working Notes:
1. Calculation of the average inventory:
A’s days’ sales in inventory:
Computation of the days’ sales in inventory for 2017:
Formula to calculate the days’ sales in inventory is,
Substitute $4,855 for ending inventory (given) and $141,048 for cost of sales (given) in the above formula.
Thus, the days’ sales in inventory accounts for 12.56 days.
Observation:
- Inventory as a percentage of total assets has fallen over the years though in the year 2017 it has shown a rise trend.
- In the year 2017 the company has been most efficient as per the inventory turnover when compared to the previous years.
- Whereas in case of days’ sales in inventory the results suggests that the company in the year 2017 held inventory in store for a bit longer time whereas it is least in the year 2016.
Want to see more full solutions like this?
Chapter 5 Solutions
FINANCIAL ACCOUNTING FUNDAMENTALS W/ CO
- Use the following information relating to Medinas Company to calculate the inventory turnover ratio, gross margin, and the number of days sales in inventory ratio, for years 2022 and 2023.arrow_forwardUse a spreadsheet and the following excerpts from Hileah Companys financial information to build a template that automatically calculates (A) inventory turnover and (B) number of days sales in inventory, for the year 2018.arrow_forwardIf merchandise inventory is understated at the end of 2015, and the error is not discovered, how will net income be affected in 2016?arrow_forward
- What is the relationship of inventory at the beginning of year 2022 to net income for the year 2022? a. Direct b. Indirect c. Inverse d. Cannot be determined due to incomplete informationarrow_forwardABC Co. a manufacturer provided the ff information for the year ended December 31, 2017. What is the correct amount of inventory?arrow_forwardWhat is the correct balance of inventory as of December 31, 2018? What is the correct 2018 gross profit?arrow_forward
- This information is available for Kingbird, Inc. for 2017, 2018, and 2019. 2017 2018 2019 Beginning inventory $ 106,000 $ 318,500 $ 410,000 Ending inventory 318,500 410,000 470,000 Cost of goods sold 894,000 1,127,500 1,292,500 Net sales 1,206,500 1,608,500 1,907,500 (a1) (a2) Your answer is partially correct. Try again. Calculate days in inventory for Kingbird, Inc. for 2017, 2018, and 2019. (Round answers to 1 de 2017 2018 2019 Days in inventory 86.9 days 117.7 days 125.8 daysarrow_forwardDetermine ending inventory using dollar-value LIFO. Assume that the December 2, 2017, purchase cost is the current cost of inventory. (Hint: The beginning inventory is the base layer priced at $24 per unit.)arrow_forwardThe following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to determine the firms cost of goods sold for 2012. Remember to change the year in row 24 and to enter new beginning inventory balances. Save the 2012 file as MFG3. Print the worksheet when done. If sales and other expenses were identical in 2011 and 2012, during which year did Twisp earn more income? Why?arrow_forward
- Presented below is information related to Sunland Company. Compute the ending inventory for Sunland Company for 2022 through 2027 using the dollar-value LIFO method.arrow_forwardAdjusting Balance Sheet and Income Statement for LIFO to FIFO In its December 2019 10-K, Phillips 66 reported the following information ($ millions). 2019 Assets 2019 Inventories 2019 LIFO Reserve 2018 LIFO Reserve Tax Rate $52,848 $3,398 $3,870 $2,610 22% a. Determine the necessary adjustments to the following balance sheet line items for 2019. Note: Round your answers to the nearest whole dollar. Adjustment (S in millions) Inventories $4 6,008 x Total assets %24 Deferred tax liabilkies $ 54,108 x 277 x Equity 0 x b. Determine the necessary adjustments to the following income statement line items for 2019. Note: Round your answers to the nearest whole dollar. Adjustment ($ in millions) Cost of goods sold %24 0 x Pretax income %24 0 x Income tax expense $ 0 x Net income %24arrow_forwardWhat inventory costs would be carried in the balance sheet on December 31, 2016 and 2017 under each method?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT