How to value inventory

Day 09 of 12Intro to AccountingTen minutes

Inventory is the stock a company holds to sell. It's a current asset because it's meant to become cash within the year.

Teach 1

The definition

Inventory is the stock a company holds to sell. It's a current asset because it's meant to become cash within the year.

Inventory days is how long stock sits before it's sold. Inventory divided by cost of goods sold times 365. It's the number that tells you whether a company is efficient or drowning in stuff.

FIFO and LIFO are the two ways to decide which cost to count when a unit is sold. First in first out counts the oldest cost. Last in first out counts the newest. When prices are rising LIFO shows a higher cost and a lower profit. It's a choice and the company states it in the notes.

Teach 2

The worked example

Costco and Apple. In millions.

CompanyInventory at year end ($M)Cost of goods sold ($M)Inventory days
Costco16,651212,58628.6
Apple6,331214,13710.8

Derived. Costco. $16,651 million divided by $212,586 million is 0.0783. Times 365 is 28.6 days. Apple. $6,331 million divided by $214,137 million is 0.0296. Times 365 is 10.8 days.

Costco turns its warehouse over about every four weeks. That's fast for a retailer. Apple holds under two weeks of product. It builds what's ordered and ships it.

Costco's 10-K states that its US inventories are valued using LIFO. In a year of rising prices that lowers reported profit and lowers tax. It's one reason two retailers with the same shelves can report different margins.

Teach 3

The trap

The trap is reading inventory growth as sales growth.

Stock rising faster than sales means stock is piling up. It's the earliest warning that products aren't moving. Costco's inventory fell from $17,907 million to $16,651 million in a year when sales rose. That's the good direction.

The other trap is the write-down. When stock can't be sold at cost the company cuts its value and the cut hits the P&L as a cost. A company with old inventory and no write-downs is a company with a profit that's too high.

Put it on a real company

You're a category manager at a retailer. Your CFO says inventory rose 20% last year and asks whether that's a problem.

  1. Step 1

    Sales rose 5%. Inventory rose 20%. What happened to inventory days?

    They went up. Stock grew four times faster than sales.

  2. Step 2

    Costco's inventory fell from $17,907 million to $16,651 million while revenue rose from $226,954 million to $242,290 million. Which direction did Costco's inventory days move?

    Down. Less stock on more sales.

  3. Step 3

    Name the risk your CFO is asking about.

    A write-down. Stock that can't be sold at cost.

  4. Step 4

    Reply in one sentence.

    Stock is growing four times faster than sales. We need to know which categories are sitting before it becomes a write-down.

Check yourself

  1. Inventory days is which of these?
  2. Apple holds $6,331 million of inventory against $214,137 million of cost of goods sold. Roughly how many days is that?
  3. Prices are rising. Which method reports the lower profit?
Answer these in the app

Where these figures come from

Every figure on the site, with its document

What this class introduces

The class beforeHow deferred revenue works
The class afterHow to read accounts receivable

Stock growing faster than sales is the earliest warning you'll get.

Ten minutes. Free. Nothing to install.

Take this class