Real World Case 8-9
EDGAR, the Electronic Data Gathering, Analysis, and Retrieval system, performs automated collection, validation, indexing, and forwarding of submission by companies and others who are required by law to file forms with the U.S Securities and Exchange Commission (SEC). All publicly traded domestic companies use EDGAR to make the majority of their filings. (Some foreign companies file voluntarily.) Form 10-K or 10-KSB, which includes the annual report, is required to be filed on EDGAR. The SEC makes this information available on the internet.
Required: 1- Access EDGAR on the Internet. The web address is www.sec.gov. 2- Search for Whole Foods Market, Inc. Access the 10-K filing for the most recent fiscal year. Search or scroll to find the financial statements and related notes. 3- Answer the following questions related to the company’s inventories. a. What method(s) does the company use to value its inventories? b. Calculate what cost of sales would have been for the year if the company had used FIFO to value its inventories c. Calculate inventory turnover for the year using the reported numbers.
a. Whole Foods Market values their inventories at the lower of cost or market. They use the last-in, first-out (“LIFO”) method to determine the cost. It was used for approximately 93.6% and 94.0% of inventories in fiscal years 2009 and 2008, respectively.
b. Cost of sales for the year under FIFO would have been: * COGS (FIFO) = COGS (LIFO) – change in LIFO reserve
5,277,310 – (27,100,000 – 32,700,000)
5,277,310 + 5,600,000
COGS (FIFO) = 10,877,310
c. Inventory Turnover = Cost of goods sold / Average Inventory * Average inventory:
Ending Balance = 310,602
Beginning Balance = 327,452
Average = (310,602 + 327,452) / 2 = 319,027 * Cost of Goods sold = 5,277,310 * Inventory Turnover = 5,277,310 / 319,027 = 16.5