Begin with a question the ratio can answer
Inventory turnover compares a flow of costs with the inventory supporting that activity. It can help organize a research question about how much inventory a business carries relative to its sales activity. It cannot, by itself, tell you whether customers are satisfied, a product is obsolete or a stock is attractive. The useful first step is to decide exactly which period and business you want to compare.
This tutorial builds a manual worksheet for fictional Harbor Equipment. All amounts and business situations below are invented. You can reproduce the calculations in your own spreadsheet or document while using available ThesisMemo research and timeline source links to locate original disclosures. The exercise does not describe an automatic inventory calculator or a note-storage feature inside the product.
Write one initial question: did inventory grow relative to the cost of goods sold over comparable periods? Keep possible explanations in a separate column. A larger stock of goods might accompany expansion, seasonal preparation or slower movement. Those are alternative hypotheses to investigate, not conclusions supplied by the ratio.
Collect the statement and its supporting notes
Open the original annual or quarterly filing and locate both the inventory balance and cost of sales. Investor.gov's filing guide identifies the financial statements, notes and management discussion as places to begin reading. Save the document URL and its publication date so another reader can find the same inputs. Then record the actual reporting dates printed above each column.
The SEC's introductory guide presents inventory turnover as cost of sales divided by average inventory for the period. Inventory is a balance at a date; cost of sales covers an interval. This difference determines the worksheet layout. Give the numerator a start and end date, and give every inventory observation its own balance-sheet date.
Also record currency, units and scope. If cost of sales is consolidated, do not casually divide it by inventory for one segment. Read the issuer's inventory policy and classification notes before deciding whether two periods are comparable. A label that looks familiar is not enough to establish that the same businesses or categories are included.
Calculate a transparent annual example
Assume Harbor reports annual cost of sales of 600 million dollars, opening inventory of 100 million and closing inventory of 140 million. For this exercise, estimate average inventory using the simple mean of the two balances: 100 plus 140, divided by two, equals 120 million. Write down that averaging choice rather than presenting it as an exact daily average.
Annual turnover is therefore 600 divided by 120, or 5.0 times for the year. Check the units: million dollars divided by million dollars leaves a ratio. If you accidentally enter cost of sales as 600,000 while leaving inventory as 120, the units are incompatible. Correct the input labels before interpreting an unusually large result.
As a second illustrative measure, using a 365-day convention gives 365 divided by 5, or 73 inventory days. This is a ratio-based approximation, not a measurement of how long each item actually stayed on a shelf. Preserve the chosen day count. A different reporting interval or calculation convention needs an explicit label.
Keep quarterly and annual comparisons separate
Now consider a separate Harbor quarter with cost of sales of 180 million dollars, opening inventory of 140 million and closing inventory of 160 million. The two-point average is 150 million, so turnover is 1.2 times during that quarter. Comparing 1.2 directly with the annual 5.0 would confuse periods of different lengths.
Assume this fictional quarter contains 90 days. Dividing 90 by 1.2 gives an illustrative 75 inventory days under the same averaging method. Multiplying quarterly turnover by four gives a simple annualized figure of 4.8 times, but that is an extrapolation. It is not an observed full-year outcome and does not remove seasonality.
For a cleaner first comparison, use the corresponding quarter a year earlier, checking both periods' lengths and scope. Keep annualized calculations in a separate column from reported-period ratios. If a fiscal calendar contains a different number of weeks, flag the mismatch instead of silently treating the periods as identical.
Test how much the average changes the answer
The opening-and-closing method is easy to reproduce, but it can miss substantial movements inside the period. Suppose another hypothetical quarter begins and ends with inventory of 100 million dollars, while two equally spaced intermediate observations are each 200 million. The two-point average is 100; the simple four-observation average is 150.
With cost of sales of 300 million dollars for that quarter, the first method produces turnover of 3.0 times and the second produces 2.0 times. Neither calculation establishes an exact time-weighted average. The difference shows why the sampling method belongs beside the result, especially when the available observations suggest a temporary build during the period.
Do not invent intermediate balances to make the worksheet look complete. If only opening and closing figures are disclosed, retain that approximation and explain its limitation. When comparing companies, investigate whether the ratios you found use the same averaging approach. A difference in construction can masquerade as a difference in operations.
Separate the calculation from its possible explanation
Assume Harbor's next comparable fictional year has cost of sales of 660 million dollars and estimated average inventory of 150 million. Cost of sales increased 10 percent from 600, while average inventory increased 25 percent from 120. Turnover falls from 5.0 to 4.4 times. Under a 365-day convention, inventory days rise to approximately 83.0.
These calculations support a narrow statement: inventory increased faster than cost of sales under the assumptions used. They do not identify the cause. Build an evidence checklist asking whether the issuer describes seasonal stocking, acquired operations, changes in product mix, supply arrangements or inventory valuation. Record an explanation only when a disclosure actually supports it.
Keep management's stated explanation distinct from your evaluation of it. If management says a build supports an upcoming launch, note what later evidence would help test that account. Possible checkpoints include subsequent inventory balances and the issuer's discussion of shipments or demand. Do not turn an unverified explanation into a fact merely because it sounds plausible.
Avoid shortcuts that change the question
Use the numerator specified by your chosen method. In the original annual example, assume revenue was 900 million dollars. Revenue divided by average inventory would be 7.5 times, compared with 5.0 using cost of sales. The arithmetic is valid, but it is a different ratio. Calling both inventory turnover without explaining the numerator makes a comparison misleading.
Using closing inventory alone also changes the result: 600 divided by 140 is approximately 4.29 times. That is not the same as the original 5.0 based on average inventory. Neither a high nor a low number should be selected simply because it makes the company look better. Choose the method first and apply it consistently.
Do not infer cash generation directly from a change in this ratio. The cash-flow statement and its explanations answer separate questions about cash movements. Similarly, a decline in the carrying value of inventory does not establish that every unit was sold. Read the relevant notes before treating an accounting balance change as a physical movement of goods.
Finish with a reproducible research note
Your final worksheet should preserve the source documents, period boundaries, original inputs, averaging method, division and limitations. Add a short conclusion stating only what you calculated. In Harbor's annual comparison, that is a decline from 5.0 to 4.4 times while the business explanation remains unresolved. Someone else should be able to reproduce the numbers without guessing your assumptions.
Before connecting the worksheet to ThesisMemo's company research, check the dates shown in both places. The methodology page distinguishes reporting periods, source publication dates and research review dates, and explains that coverage and updates can be incomplete. A newer filing in your own worksheet does not establish that every displayed assessment already reflects it.
Choose one useful follow-up rather than a sweeping verdict. You might locate a missing opening balance, reconcile an acquisition's scope or read a note explaining a seasonal build. Keep the next checkpoint tied to evidence you could actually obtain. That makes the ratio a starting point for a research process you can revisit when the next report arrives.
Product references
Questions & answers
What is the inventory turnover formula used here?
This guide uses cost of sales divided by average inventory for the same period. In the fictional annual example, 600 million dollars divided by a two-point average of 120 million gives 5.0 times. Preserve the reporting period, currency, units, scope and averaging method with the result.
Why not use the closing inventory balance?
It describes one date and can differ from the inventory carried during the period. Harbor's closing balance of 140 million produces approximately 4.29 times when used alone, while the opening-and-closing average produces 5.0. Neither calculation should be presented without disclosing which denominator was used.
Can quarterly turnover be compared directly with annual turnover?
The periods differ, so the raw ratios are not directly comparable. Harbor's illustrative quarter produces 1.2 times over 90 days. Multiplying by four produces an annualized approximation of 4.8, not an actual annual result. Compare matched quarters first and check seasonality and fiscal-period lengths.
Does a lower ratio prove inventory is obsolete?
No. It identifies a relationship between the chosen costs and inventory balances, not a specific cause. Investigate the issuer's inventory notes and operating discussion. Keep possible explanations, management statements and independently supported observations separate; missing evidence should remain an open research question.
Does ThesisMemo perform this worksheet automatically?
This is a manual research exercise using your own document or spreadsheet. Available company research and source links can help you locate evidence, but you must verify the original statements and calculations. Check visible dates and coverage rather than assuming every displayed item is current or independently audited.