Click to Print

How to Value Your Inventory

It's a great way to gain insight into the financial health of your business.
September 23, 2002
URL: http://www.entrepreneur.com/article/55578

Q: How do I value my inventory?

A: For many business owners, inventory valuation is a major issue that impacts their P&L, balance sheet and taxes. The general rule of thumb is that inventory should be valued at what you paid for it and the market value (what it's worth). Unless the inventory is obsolete, your inventory is generally valued at cost. But what is cost? Is it the last price you paid, the first price or the average price? In addition, what does cost include? Does cost include labor and overhead and freight or only the cost of the purchases? Consider the following:

To demonstrate how these three valuation methods result in different inventory values, consider the following ending inventory scenario:

Company XYZ purchased 3,000 widgets during the year and sold 1,600, so it has 1,400 widgets in stock at the end of the year. (There was no beginning inventory.) The following is a schedule of purchases it made:

Date Qty Cost per Total cost
Jan 25, 2001 1,000 $1.00 $1,000
July 3, 2001 1,000 $1.25 $1,250
Nov 9, 2001 1,000 $1.10 $1,100
Total purchases = $3,350

The following is a schedule of sales of widgets:

Date Qty Price Total price
Feb 4, 2001 800 $2.00 $1,600
July 14, 2001 800 $1.80 $1,440
Total sales = $3,040

Under FIFO, inventory would be valued at $1,600 (400 at $1.25 + 1,000 at $1.10). Cost of sales would be $1,750 ($0 + $3,350 - $1,600), and gross profit would be $1,290 ($3,040 - $1,750).

Under LIFO, inventory would be valued at $1,500 (1,000 at $1.00 + 400 at $1.25). Cost of sales would be $1,850 ($0 + $3,350 - $1,500), and gross profit would be $1,190 ($3,040 - $1,850).

Under WAC, you first determine the cost of sales then back into inventory. Cost of sales would be $1,768 (800 at $1.00 + 800 at $1.21), inventory would be $1,582 ($0 - $3,350 - $1,768), and gross profit would be $1,582. The $1.21 was determined as follows: $200 left from the first 1,000 units plus $1,250 from the second 1,000 units, divided by 1,200 units.

In the real world, you wouldn't have to do any of these calculations yourself because the computer would do them for you. However, it's important to know the differences. When costs are rising, FIFO would have the highest inventory valuation and gross profit. When costs are falling, LIFO would have the highest inventory valuation and gross profit. WAC estimates FIFO.

You should also note that once you pick an inventory valuation method, you generally have to stick with it. You cannot change every year without raising eyebrows from your bankers and other readers of your financial statements.

You should note that from a management point of view, it is essential that you also include those costs in your inventory costs--otherwise, you run the risk of undercharging for your products.

Ian Benoliel is the CEO of NumberCruncher.com Inc., a developer of budgeting, manufacturing and management software for entrepreneurial businesses. NumberCruncher combines its accounting and finance expertise with technological know-how to deliver software that is affordable and easy to use, yet sophisticated and powerful. More information on the NumberCruncher's products and services is available at www.numbercruncher.com. Ian has nearly two decades of business, accounting and financial consulting experience. He has advised corporations on business plans, financial projections and accounting computer systems.


The opinions expressed in this column are those of the author, not of Entrepreneur.com. All answers are intended to be general in nature, without regard to specific geographical areas or circumstances, and should only be relied upon after consulting an appropriate expert, such as an attorney or accountant.