Inventories and Cost of Sales Cheat Sheet

Accurate inventory valuation is crucial for financial reporting, impacting cost of goods sold, gross profit, and net income. Understanding different costing methods (FIFO, LIFO, Weighted Average) and their effects is essential for financial analysis and tax compliance.

Core Principles

  • Merchandise inventory includes all goods a company owns and holds for sale, regardless of location.
  • Inventory costs include invoice cost, minus discounts, plus shipping, storage, insurance, and import duties.
  • Four primary methods assign costs: Specific Identification, FIFO, LIFO, and Weighted Average.
  • Inventory errors (understated or overstated ending inventory) directly impact Cost of Goods Sold and Net Income.
  • Inventory Turnover and Days' Sales in Inventory are key metrics for assessing inventory management efficiency.

Action Steps

  • Identify all goods owned and held for sale, including goods in transit, on consignment, and those damaged or obsolete.
  • Calculate inventory costs by summing invoice cost, adding costs like shipping and insurance, and subtracting discounts.
  • Apply chosen inventory costing methods (Specific Identification, FIFO, LIFO, Weighted Average) consistently for financial and tax reporting.
  • Analyze the impact of inventory errors on current and future financial statements by examining effects on ending inventory, cost of goods sold, and net income.
  • Calculate Inventory Turnover and Days' Sales in Inventory to evaluate inventory management effectiveness.

Formulas

  • Inventory Cost = Invoice Cost - Discounts + Other Costs
  • Net Realizable Value = Sales Price - Selling Costs
  • Inventory Turnover = Cost of Goods Sold / Average Inventory
  • Average Inventory = (Beginning Inventory + Ending Inventory) / 2
  • Days' Sales in Inventory = (Ending Inventory / Cost of Goods Sold) * 365
  • Weighted Average Cost per Unit = Cost of Goods Available for Sale / Number of Units Available for Sale

Key Terms

  • Merchandise Inventory: All goods that a company owns and holds for sale, regardless of their location when inventory is counted.
  • FOB Shipping Point: Ownership of goods transfers to the buyer at the shipping point, making them the buyer's inventory immediately.
  • FOB Destination: Ownership of goods transfers to the buyer upon arrival at the destination.
  • Consignor: The owner of goods who places them with another party for sale.
  • Consignee: The party who sells goods for the owner.
  • Net Realizable Value (NRV): The estimated selling price in the ordinary course of business, less estimated costs of completion, disposal, and transportation.
  • FIFO (First-In, First-Out): Assumes the first costs incurred are the first costs assigned to Cost of Goods Sold.
  • LIFO (Last-In, First-Out): Assumes the last costs incurred are the first costs assigned to Cost of Goods Sold.
  • Weighted Average: Assigns an average cost to all goods available for sale and to Cost of Goods Sold.
  • LIFO Conformity Rule: Requirement by the IRS that if LIFO is used for tax purposes, it must also be used for financial reporting.
  • Inventory Turnover: A measure of how many times a company's inventory is sold and replaced over a period.
  • Days' Sales in Inventory: A measure of the average number of days it takes to sell inventory.
  • Retail Inventory Method: A method to estimate ending inventory by applying a cost-to-retail ratio to the retail value of inventory.
  • Gross Profit Method: A method to estimate ending inventory by applying a gross profit ratio to net sales.

Pro Tips

  • For FOB shipping point, ownership transfers at the shipping point, making the goods part of the buyer's inventory immediately.
  • Consigned goods are always included in the consignor's inventory, never the consignee's.
  • Damaged or obsolete goods are excluded from inventory if unsellable; otherwise, they are valued at Net Realizable Value.
  • The LIFO conformity rule mandates that if LIFO is used for tax reporting, it must also be used for financial reporting.
  • When inventory value is lower than its cost, adjust the inventory balance downward to its market value (replacement cost).

Pitfalls to Avoid

  • Including goods not owned (e.g., goods on consignment) in inventory leads to overstatement.
  • Failing to account for all costs (shipping, storage, insurance) results in understated inventory costs.
  • Inconsistent application of inventory costing methods between financial and tax reporting violates the LIFO conformity rule.
  • Ignoring the 'lower of cost or market' rule can lead to overvalued inventory on the balance sheet.
  • Errors in ending inventory calculation directly cause misstatements in Cost of Goods Sold and Net Income for multiple periods.

Myth vs Reality

  • The physical flow of goods must match the inventory cost flow assumption (e.g., FIFO).: Physical flow does not need to follow cost flow; companies can use FIFO for costing even if they sell goods in a different order.
  • Inventory costs are only the purchase price.: Inventory costs include all expenditures necessary to bring an item to its salable condition and location, such as shipping, storage, and insurance.

Real World Examples

  • A motor sports retailer has inventory items with a total cost of $220,000 and a total market value of $190,000.: The inventory must be written down to $190,000, with a $30,000 adjustment to Cost of Goods Sold.
  • Trekking Company uses different inventory costing methods (Specific Identification, FIFO, LIFO, Weighted Average) for its mountain bikes.: This results in varying Cost of Goods Sold and Ending Inventory values on its financial statements, illustrating the impact of method choice.
  • Costco's inventory turnover is 12.3 times, while Walmart's is 8.8 times in the current year.: This indicates Costco sells and replaces its inventory more frequently than Walmart, suggesting potentially more efficient inventory management.

Statistics

  • Costco Inventory Turnover (Current Year): 12.3 times
  • Walmart Days' Sales in Inventory (Current Year): 40.9 days

Related cheat sheets

  • Cash, Fraud, and Internal Control Cheat Sheet
  • Accounting Principles Cheat Sheet
  • Accounting for Receivables Cheat Sheet
  • Accounting Principles and Practices Cheat Sheet
  • Capital Structure & Financial Leverage Cheat Sheet

More like this

  • More cheat sheets by @lmthegawdess
  • Finance cheat sheets
  • Explore all cheat sheets

ClipSheet — AI Cheat Sheet Generator

ClipSheet transforms YouTube videos, PDFs, and text into structured cheat sheets and study notes using AI. Built for students, professionals, and content creators who need to learn faster.

Features

  • AI-powered extraction of key concepts, formulas, and action steps
  • Automatic quiz and flashcard generation for active recall
  • PDF export and public sharing via unique URLs
  • Support for YouTube videos, PDFs, and raw text input

Browse by Category

  • All Cheat Sheets
  • Science & Academic
  • Technology
  • Health & Fitness
  • Coding
  • Business
  • Education
  • Productivity
  • Finance
  • Lifestyle

Legal

  • Privacy Policy
  • Terms of Service
  • Imprint