Days inventory outstanding calculator

A seasonal seller with $5.2 million of cost of goods sold ends the year with $500,000 of stock, which is a DIO of 35.1 days. A two-point average gives 35.8. But inventory peaked at $1.5 million in October, and the average of all 13 month-end balances is $789,231, a DIO of 55.4 days. The same business, the same year, and a 20-day range depending on which inventory figure you use.

The formula is one line. The judgment is in the inputs. This calculator shows DIO on the ending balance, a two-point average and the average of every month-end balance, adds a forward-looking days of supply, and puts a dollar value on each day: $14,247 of cash for every day in this example.

Who reaches for this

You enter cost of goods sold for the period, the days in the period, and up to 13 month-end inventory balances: the balance at the start and one for each month. The calculator computes DIO three ways, plus DIO at the peak and the low. It then adds four things that competing calculators leave out: days of supply on a forecast, the cash tied up in each day, DIO without slow-moving stock, and the cash released if you reach a target.

The inventory turnover calculator covers the ratio, economic order quantity, reorder points, safety stock and ABC analysis. This page is about the days number itself: measuring it so it reflects reality, seeing what it costs, and deciding what a good one is for your business.

Days inventory outstanding is inventory divided by cost of goods sold, multiplied by the number of days in the period. For a year, that is inventory ÷ COGS × 365. The same measure appears as days sales of inventory, days in inventory, inventory days and the inventory period. Some sources use “average days inventory outstanding” for DIO averaged over several periods, which is useful for spotting seasonal patterns.

It is the inverse of turnover, expressed in days. Turnover is COGS divided by average inventory, so DIO is also 365 ÷ turnover. In the example, turnover is 6.59 times a year and 365 ÷ 6.59 is 55.4 days. The two say the same thing, and days are easier to set beside lead times, payment terms and the calendar.

Cost of goods sold, not sales

Inventory is recorded at cost, so it belongs beside the cost of what was sold. Using sales inflates the denominator by the markup and understates DIO. If cost of goods sold is 62% of sales, the example’s $8.39 million of sales gives 34.3 days instead of 55.4, a 21-day error. Sales also make DIO incomparable across businesses with different margins, since a high-margin business would look faster for the same physical turnover.

The number of days

Most sources use 365. Some finance teams use 360, which gives 54.6 days for the example, and a leap year has 366, giving 55.5. The differences are under a day, so consistency matters more than the choice. The rule that does matter is matching the period: use that period’s cost of goods sold, that period’s balances and that period’s days. A quarter uses 90 days and a month 30. Dividing quarterly inventory by annual COGS, or multiplying a monthly ratio by 365, gives a number that means nothing.

When prices are moving

DIO depends on how inventory is valued. When prices rise, first-in, first-out costing leaves older, cheaper costs in inventory and puts recent costs in cost of goods sold. Last-in, first-out does the opposite. The same physical stock and the same sales can therefore give different inventory values, different cost of goods sold and so a different DIO under each method. Inflation also makes DIO drift: if unit costs rise 5% in a year, inventory at cost rises with them even when the number of units is unchanged.

Two habits help. Compare DIO with a prior period only under the same cost method, and when comparing companies, check the method in the notes to the financial statements. In periods of changing prices, a units-based view, weeks of stock in units, gives a check that the dollar figures cannot.

Every DIO calculation has to pick an inventory figure. The three in common use give different answers when stock changes through the year, and for a seasonal business the difference can be weeks. Here is the example seller, with month-end balances of $520,000 at the start of the year, rising to $1,500,000 in October, and falling to $500,000 in December.

The ending balance and the two-point average both land near 35 days, because they use December and the start of the year, the two low points. They describe the business on the day the books close, not the stock it carries through the year. The average of all balances gives 55.4 days, and it is the figure that reflects the cash the business has tied up on an ordinary day. The peak of 105.3 days is a warning about the financing needed in the busy season: a credit line sized to the year-end balance would fall $1 million short in October.

Which to use

A business with steady stock will see the three measures agree, and then the choice does not matter. A business with a strong season will see them diverge, which is the signal that the simple version is hiding something.

A quarter or a month on its own

The same logic applies to a single period. Take the fourth quarter alone, which has 92 days. Month-end balances of $1,350,000 in September, $1,500,000 in October, $1,300,000 in November and $500,000 in December average $1,162,500. If fourth-quarter cost of goods sold is $2,000,000, quarterly DIO is $1,162,500 ÷ $2,000,000 × 92 = 53.5 days. It looks close to the year’s 55.4, but it comes from a different mix: a heavy quarter of sales against a stock that peaks and then drains. Compare it with the fourth quarter of the year before, not with the first quarter.

DIO looks back. It says how long inventory has lasted at the rate the company has sold. Days of supply looks forward: ending inventory divided by forecast daily cost of goods sold. It says how long today’s stock will last if sales follow the forecast.

The two diverge when sales are changing. The example seller expects cost of goods sold to grow from $5.2 million to $6.0 million. Its $500,000 of ending stock is 35.1 days of last year’s sales, and 30.4 days of next year’s forecast, since forecast daily COGS is $16,438 against $14,247 last year. A growing business looks better on a forward view because the same stock covers less time, and a shrinking one looks worse.

Days of supply is the number to use for buying decisions. If the supplier lead time is 21 days and safety stock is 7 days of demand, the business needs about 28 days on hand at the point of reordering. At 30.4 days of supply, that leaves little slack, and a purchase order that is late will produce a stockout. A backward-looking DIO of 35.1 would hide the tighter position. DIO is for judging how well stock has been managed. Days of supply is for deciding what to order.

A day of DIO is worth one day of cost of goods sold. The example’s $5.2 million of COGS is $14,247 a day, so each day removed frees $14,247 of cash. Moving from 55.4 days to a 45-day target frees 10.4 days, or $148,135, once. It is a cash release, not a profit, and it happens one time.

The recurring benefit is the cost of carrying that stock. Carrying cost includes the return on the capital tied up or the interest paid to finance it, warehouse space, handling, insurance, shrinkage and the risk of obsolescence. Businesses estimate it at very different percentages, and the calculator uses 20% as an illustration, so replace it with your own figure. At 20%, $148,135 less inventory saves $29,627 a year. Even counting only the interest at a 9% cost of capital, the saving is $13,332 a year. To build the rate from your own capital, storage, service and risk costs, and to see how much of it is avoidable, use the inventory carrying cost calculator.

These numbers explain why inventory decisions get attention from finance. A ten-day improvement in DIO for a business this size funds a hiring plan or repays a loan. It also cuts a risk that is easy to forget: stock that sits gets old, damaged or superseded, and the longer it sits, the larger the write-down when it finally moves.

What lenders and buyers read into DIO

Lenders look at DIO for two reasons. A rising DIO with flat sales suggests stock that is not moving, which weakens the collateral behind an inventory-backed loan. And a seasonal peak tells them how much borrowing the business will need, and when. Many inventory loans advance only a percentage of eligible stock, and aged or slow-moving goods are often excluded, so the aging view on this page is close to what a lender will compute. Buyers of a business do the same arithmetic: a large slice of old stock is a price adjustment waiting to happen.

How often to measure

Monthly is the useful rhythm for most businesses. It is frequent enough to catch a build-up before it becomes a write-down, and the month-end balances feed the 13-point average directly. Weekly tracking makes sense for fast-turning goods, where a few days matter. Quarterly is the minimum for a business with steady stock. Whatever the frequency, record the method each time, so that a change in the number reflects the stock and not a change in the calculation.

A single DIO averages fast-moving goods with slow ones, and the average can look healthy while a slice of the stock is going stale. Splitting inventory by category shows it. The example’s $789,231 of average inventory divides into three groups.

The slow group is 27.8% of inventory and 9.6% of sales at cost, and it turns in about 160 days. The blended figure of 55.4 days does not show that. Age is the second lens. If $120,000 of the average is more than 180 days old, DIO without it is 47.0 days, and that stock is 15.2% of the total. An aging report divides inventory into buckets and puts a write-down assumption on each.

The write-down percentages are assumptions for illustration, not accounting rules. On those assumptions, $47,539 of inventory is at risk. The exercise matters more than the percentages: an aging view turns “DIO is a bit high” into a list of what to clear, and by when.

For a manufacturer: three stages

A manufacturer holds inventory in three forms: raw materials, work in process and finished goods. Total DIO hides where the days are. Suppose the $789,231 average splits into $240,000 of raw materials, $120,000 of work in process and $429,231 of finished goods. Each stage divided by the same $5.2 million of COGS gives 16.9, 8.4 and 30.1 days, which add to the 55.4 total.

The split tells you where to act. Long raw material days point to purchasing, supplier lead times and minimum order quantities. Long work in process days point to production scheduling, batch sizes and bottlenecks. Long finished goods days point to forecasting, sales and the range. The stages have different owners, so a single DIO target rarely works. Set one for each.

Benchmarks tell you how you compare. A target built from how you buy tells you what you should be able to reach. Four components make up the stock a business needs on an ordinary day.

Take a business that orders every 28 days, so cycle stock averages 14 days. It holds 7 days of safety stock, owns goods for 14 days in transit and plans an average of 7 days of seasonal build. The planning floor is 14 + 7 + 14 + 7 = 42 days. The example’s 55.4 days is 13.4 days above it, which is about $191,000 of stock beyond what the way it buys explains. That gap is where to look first: slow stock, over-ordering, a bad forecast or a purchase pattern that no longer fits.

The floor is a planning tool, not a law. A higher service level needs more safety stock, and a supplier who ships weekly lowers cycle stock. The inventory turnover calculator covers economic order quantity and safety stock in detail, and the workbook has a sheet that builds the floor from your own numbers.

DIO is the first of three pieces in the cash conversion cycle. The full cycle is DIO plus days sales outstanding minus days payable outstanding. It says how many days cash is tied up between paying for inputs and collecting from customers. With a DIO of 55.4, a DSO of 38 and a DPO of 42, the cycle is 51.4 days.

Each piece is a lever. A day off DIO frees $14,247 of cash in this example, by way of a smaller inventory. A day off DSO frees a day of sales, and a day added to DPO holds a day of purchases. The days are on different bases: DIO and DPO on cost of goods sold, and DSO on sales, so the dollar value of a day differs by component. The cash conversion cycle calculator, the DSO calculator and the DPO calculator work through the other two.

The trap in reducing DIO is cutting stock the business needs. The levers worth pulling shrink the stock that does no work, and leave service alone. Here is what each is worth in the example, where a day is $14,247.

Clearing the slow stock is the fastest and the most certain, since it requires no change to how the business buys. It may mean a markdown, a bundle or a return to the supplier, and the loss on those is real, but it is smaller than the loss from letting the stock age. Ordering more often trades a lower cycle stock for more purchase orders and, for some suppliers, higher freight. Cutting safety stock needs a better forecast first. Changing when you take ownership of in-transit goods moves days between you and the supplier, so it needs their agreement.

Watch service while you do this. A DIO that falls while the fill rate falls is a sign that the wrong stock was cut. The number to hold steady is the availability of the products customers buy most. The cost side of the decision, the price per unit that goes into inventory, comes from the cost per unit calculator and the landed cost calculator.

Continue with the inventory turnover calculator or the cash conversion cycle calculator.