2014-09-26 01:21:12 Online Store and Retail English The retail method is a straightforward way to determine the value of your inventory. Learn how the retail method works and how to calculate... https://quickbooks.intuit.com/r/us_qrc/uploads/2014/09/iStock_000024171106Small.jpg https://quickbooks.intuit.com/r/online-store-and-retail/new-method-determine-inventory-value-balance-sheet/ The Easy Way to Calculate Business Inventory | QuickBooks

How to Calculate Your Business Inventory the Easy Way

3 min read

If you sell physical goods, you have dealt with the need to quickly tally up your inventory. If you only sell a few products, this may not be difficult. But what if you have a large number of items to sell, and you don’t have the time to take a manual inventory every time you need to come up with a number for your financial statements? What’s more, you may know the selling price of your items, but do not have the actual costs of the individual items that you sold since you bought the items at different times for different prices.  You need a better way to calculate the cost of your inventory.

The Retail Method

There’s a straightforward way to determine the value of your inventory:  It’s called the retail method and it involves converting the retail value of your inventory to a cost value.   Under this method, a ratio is multiplied by the retail selling prices of the goods on hand.  This ratio, called the cost component, is calculated as follows:

Beginning inventory plus cost of purchases

divided by

Retail selling price of beginning inventory plus purchases plus any markups or markdowns

The advantages of this method is that you do not have to take physical inventory to get a value of your ending inventory. You only have to record the retail prices of your items in inventory. Additionally, you can easily keep an inventory valuation report to use for budgeting or preparing your financial statements.

How the Method Works

Here’s an example of how this works.  Let’s say your beginning inventory at cost was $90,000 and the cost of your new purchases was $330,000.  Additionally, the retail value of your beginning inventory and purchases was $130,000 and $460,000, respectively, and you had $10,000 in markups and $40,000 in markdowns.  You had sales of $480,000.  The calculation of the ratio, using the formula above, would be as follows:

$90,000 plus $330,000

divided by

$130,000 plus $460,000 plus $10,000 minus $40,000


The equation is $420,000 divided by $560,000, which gives you a ratio of 75 percent.

Now that you know this ratio, you can convert the retail value of your inventory to an estimated cost of the inventory.  The ending retail value of your inventory is:

Now multiply the cost of your ending ending inventory ($80,000) by your ratio (0.75), to cone up with $60,000. This method allows you to come up with an inventory number without having to calculate the cost value of your inventory.

New IRS Rules

The IRS recently came out with some rules related to how to calculate this cost.  The big change is that the denominator in the ratio calculation should not be adjusted for any temporary markups or markdowns — only those that are permanent. Additionally, the numerator also should not be reduced by vendor allowances that you may receive that only reduce your cost of goods sold.  However, you can reduce the numerator of the ratio by any margin for protection payments you receive that are meant to compensate you for a reduction in your selling price of inventory.

Determining the correct value of your inventory can be tricky, no matter how you go about looking at it.  Luckily, there is inventory management software that can take care of the hard parts for you, so you can focus on running your business.

Rate This Article

This article currently has 9 ratings with an average of 2.7 stars

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Help Your Business Thrive

Get our newsletter

Thanks for signing up!

Check your inbox for a confirmation email.*

*Check your spam folder if you don’t see a confirmation email.

Related Articles

Complete guide to filing self-employment taxes

In the past decade, the self-employment industry has grown more rapidly than…

Read more

Break even analysis: how to calculate your break even point

Every company owner wants to grow sales and profits, but the first…

Read more

Why Sales Tax Calculations Based on Zip Codes Are Not Enough

Unless you live in a single rate state like Massachusetts, where you…

Read more