TL;DR: Inventory affects reported profit through cost allocation, production absorption, and write-downs, while cash depends on what the business buys, sells, and collects. An equity analyst should reconcile units, cost layers, aging, margins, and working capital before treating a stronger gross margin as evidence of stronger demand. Accounting profit can rise while more cash becomes trapped in a warehouse.
This workbook follows a fictional manufacturer and distributor called Marlow. Every amount is invented, with currency units treated as dollars for readability. The examples illustrate financial-statement analysis rather than recommend a security. They use an IFRS-oriented accounting baseline, so readers comparing a company under another framework must check its own policies instead of assuming identical treatment.
The controlling starting point is the IFRS Foundation's IAS 2 overview, supported by the issued standard's production-overhead rules. The cash bridge follows the distinction between profit and operating cash flows described in IAS 7. The analysis below keeps accounting measurement separate from the commercial evidence needed to judge inventory quality.
Shelf one: Count the units before reading the margin
Marlow begins the period with 100 interchangeable units costing ten dollars each. It buys another 100 at fourteen dollars and sells 120 at twenty dollars. There are 80 units left. That physical reconciliation is the first anchor: 100 opening units plus 100 purchased units minus 120 sold equals 80 closing units.
The revenue is 2,400 dollars. The remaining questions concern which costs are assigned to the sold units, which remain in inventory, and whether the unsold units can still recover their carrying value. A margin percentage alone cannot answer those questions because different permitted cost formulas can allocate the same total costs differently across periods.
The analyst also asks whether the units are genuinely interchangeable. A warehouse containing different product generations, custom orders, or damaged items may require more granular analysis than one average unit count. A simplified workbook is useful only when its assumptions are stated clearly enough to identify where the real company differs.
Marlow's evidence sheet therefore includes opening units, purchases, sales, returns, write-offs, and closing units by relevant product family. If the company does not disclose that detail publicly, the analyst records the limitation. Missing physical evidence should reduce confidence in a conclusion rather than invite invented sell-through estimates.
Shelf two: FIFO moves older costs into the income statement
Under the example's first-in, first-out allocation, the 120 units sold carry 1,000 dollars from the opening layer and 280 dollars from twenty newly purchased units. Cost of goods sold is 1,280 dollars. The remaining 80 units carry fourteen dollars each, or 1,120 dollars in total.
Gross profit before other expenses is therefore 2,400 minus 1,280, or 1,120 dollars. The gross margin is about 46.7 percent. These figures describe the cost allocation under the stated assumptions; they do not show that the selling price improved or that customers became more enthusiastic.
IAS 2 permits FIFO and weighted-average formulas for ordinarily interchangeable inventories, while specific identification applies to items that are not ordinarily interchangeable. The analyst reads the company's actual policy rather than assuming a method from its industry label. Comparability begins with knowing which costs the reported margin contains.
When purchase costs rise, a FIFO margin can temporarily reflect older, cheaper units flowing through cost of sales. That is a timing feature of the cost layers. To assess future margins, the analyst asks what replacement inventory costs and whether selling prices can adjust, rather than projecting the current percentage without examining its composition.
Shelf three: Weighted average tells a different period story
The same 200 available units have a total cost of 2,400 dollars, giving a weighted-average cost of twelve dollars per unit in this simplified periodic example. Selling 120 units assigns 1,440 dollars to cost of goods sold and leaves 960 dollars in inventory. Gross profit is 960 dollars, or forty percent of revenue.
Nothing about the physical sales changed. Both methods began with the same units, purchases, and customer receipts. FIFO reports 160 dollars more gross profit in the period and 160 dollars more closing inventory. The difference is an allocation across the income statement and balance sheet, not additional cash created by the warehouse.
This comparison is deliberately narrow. A perpetual moving-average system with purchases and sales interspersed through the period can produce results that depend on transaction order. A real analysis must match the company's method and timing rather than applying a periodic example mechanically to every inventory ledger.
The analyst uses the workbook to ask a practical question: how much of a reported margin change comes from economic pricing and how much comes from the timing of cost recognition? The answer may be favorable, unfavorable, or unavailable. The value lies in separating the explanations before attaching an investment narrative to the percentage.
| Allocation for the same physical sales | Cost of goods sold | Closing inventory | Gross profit |
|---|---|---|---|
| FIFO | 1,280 | 1,120 | 1,120 |
| Periodic weighted average | 1,440 | 960 | 960 |
| FIFO minus weighted average | -160 | 160 | 160 |
Cash bridge: Two profits, one operating receipt pattern
Assume Marlow collects all 2,400 dollars of sales and pays 1,400 dollars for the new purchases during the period. Ignore other expenses, taxes, payables, and receivables. Operating cash generated by these transactions is 1,000 dollars regardless of whether the period uses FIFO or the simplified weighted-average allocation.
Under FIFO, start with 1,120 dollars of profit and subtract the 120-dollar increase in inventory from 1,000 to 1,120. The result is 1,000 dollars. Under weighted average, start with 960 dollars of profit and add the forty-dollar decrease in inventory from 1,000 to 960. The result is again 1,000 dollars.
The arithmetic demonstrates why an analyst should reconcile profit with working capital. A cost formula can change reported profit and inventory while leaving the underlying cash transactions unchanged. The cash-flow statement provides another view of the same business, but it also needs interpretation because payment timing can change independently of sales quality.
If Marlow delays paying suppliers, operating cash may look stronger without any improvement in customer demand. If it collects customers slowly, strong reported sales may not become cash promptly. The inventory analysis belongs within the full working-capital system rather than being treated as a standalone ratio exercise.
Markdown card: Recoverable value can fall below recorded cost
The remaining FIFO inventory carries fourteen dollars per unit. Suppose its expected selling price falls to thirteen dollars and the estimated necessary selling costs are two dollars per unit. In this simplified example, net realizable value is eleven dollars. The carrying value would need a three-dollar reduction per unit, or 240 dollars across the 80 units.
IAS 2 measures inventories at the lower of cost and net realizable value and defines net realizable value using estimated selling price less completion and necessary selling costs. The analyst should therefore examine both the expected price and the costs required to achieve that sale. A headline list price may be irrelevant if clearance requires discounts, refurbishment, or costly distribution.
After the illustrative write-down, inventory is 880 dollars. If the charge is included in the example's cost of sales, gross profit falls from 1,120 to 880 dollars. The presentation in a real company's statements and notes should be checked rather than assumed. The economic issue is that the previously recorded asset no longer supports its old carrying amount.
The write-down itself does not produce a cash payment at that moment. It recognizes an economic loss or reduced recovery expectation in accounting. Future cash depends on whether the goods sell, at what price, and at what additional cost. Calling the charge non-cash does not make the underlying deterioration irrelevant to equity value.
The aging report gives the balance sheet a memory
An inventory balance combines items purchased yesterday with items that have been sitting for months. Two companies can report the same total inventory and have very different recovery prospects. Aging by product family helps distinguish a deliberate seasonal build from a growing stock of obsolete goods.
Marlow's analyst asks how the aging clock is defined. Is it time since purchase, production completion, last movement, or last sale of that product? A warehouse transfer can reset some operational dates without making the goods economically newer. The definition matters before changes in an aging chart are interpreted as improvement.
The analyst also separates quantity from unit cost. Inflation can increase the inventory balance even when physical units are flat. A shift toward expensive products can do the same. Conversely, a write-down can reduce the balance while the physical backlog remains unchanged. A lower dollar balance is not always evidence that the warehouse cleared.
Where public disclosure is limited, the analyst can compare management commentary, product cycles, discounting, and working-capital movements, but should label the resulting inference. The absence of a disclosed aging table does not justify claiming that goods are stale. It just limits how confidently the reported asset can be assessed.
Production card: Fixed overhead can remain in unsold goods
Marlow's manufacturing unit has normal capacity of 10,000 units and fixed production overhead of 120,000 dollars. Variable production cost is eight dollars per unit. Under the example's normal-capacity allocation, fixed overhead is twelve dollars per unit, making the inventory cost twenty dollars per unit.
If it produces 10,000 units and sells 8,000 at thirty dollars, revenue is 240,000 dollars. Cost assigned to the sold units is 160,000 dollars, leaving 40,000 dollars in inventory and 80,000 dollars of profit before other expenses. The closing inventory includes 24,000 dollars of fixed overhead and 16,000 dollars of variable production cost.
The analyst should understand this absorption mechanism before interpreting profit growth during an inventory build. Some production costs remain on the balance sheet until the goods are sold or written down. That can be appropriate accounting while still raising a commercial question about whether the extra output has a credible customer destination.
The question is not automatically an allegation of manipulation. A planned product launch or seasonal demand can justify production ahead of sales. The analyst needs evidence about orders, sell-through, capacity planning, and future markdown risk. The mechanism explains what to investigate; it does not determine the motive.
The idle-capacity comparison
Now suppose Marlow produces only 8,000 units and sells all of them at thirty dollars. Keep normal capacity at 10,000 and fixed overhead at 120,000 dollars. The example allocates 96,000 dollars of fixed overhead to the units and recognizes 24,000 dollars of unallocated overhead as a period expense, consistent with the normal-capacity principle described in IAS 2.
The sold units carry 160,000 dollars of total production cost, and the additional unallocated overhead is 24,000. Profit before other expenses is therefore 56,000 dollars. Producing the extra 2,000 units in the previous scenario raised reported profit by 24,000 dollars because that amount of fixed overhead remained in closing inventory.
The extra production also consumed 16,000 dollars of variable-cost cash under the simplified assumption that all production costs were paid. Sales and fixed cash costs were unchanged. Thus the higher-production scenario reports more profit while using more cash and leaving more goods unsold. The numerical bridge shows the tension clearly.
IAS 2 does not permit simply inflating unit overhead because production is low, and it addresses abnormal high production as well. A real analysis must respect those constraints. The workbook illustrates a permitted timing mechanism under stated normal-capacity assumptions, not a suggestion that management can arbitrarily choose any profit it wants.
The order book does not automatically clear the shelves
Management says the inventory build supports a strong order book. The analyst asks whether the orders are firm, cancellable, conditional, or concentrated in a few customers. A booked order may support planning, but it is not the same as a completed sale or collected cash.
The product mix also matters. Orders for a new model do not necessarily support the carrying value of an older model in inventory. Aggregating both under one product family can make the balance appear better covered than it is. The analyst seeks a match between the goods held and the demand cited to justify them.
Delivery timing can create a legitimate temporary build. If components arrived early while a customer's installation date moved later, the inventory may still have a clear use. The financial consequence is then a longer cash commitment and possibly storage costs, rather than immediate obsolescence. Those distinctions should appear in the scenario analysis.
The evidence standard is practical: identify which demand supports which inventory and what could prevent conversion into cash. A confident statement that the backlog is “covered” should be tied to terms and timing. If the disclosure does not provide that detail, the analyst can frame alternative scenarios rather than inventing certainty.
Inventory days can improve for the wrong reason
A common ratio compares inventory with cost of goods sold to estimate days of inventory. The calculation is useful only when the numerator, denominator, averaging convention, and period length are consistent. Seasonal businesses can look very different at quarter-end depending on when goods arrive and when sales peak.
A write-down reduces inventory and can improve the ratio without moving any physical units. Rising input costs can raise cost of goods sold and alter the ratio even if operating processes are unchanged. A change in product mix can shift both sides. The analyst should reconcile these effects before calling a lower number more efficient.
For a fictional annualized illustration, average inventory of 100 million dollars and annual cost of goods sold of 500 million imply 73 days using 365 times inventory divided by cost of sales. If a write-down reduces the relevant average inventory measure to 90 million while cost of sales remains 500 million for the comparison, the ratio becomes about 65.7 days. The apparent improvement is not necessarily faster sell-through.
The example simplifies the timing of the average and charge. Its purpose is to show the direction of a measurement effect. A real model should use the actual period balances and consistent cost figures, with adjustments documented rather than hidden inside a spreadsheet formula.
The supplier can finance the warehouse for a while
An inventory build does not always consume cash immediately because suppliers may extend payment terms. Marlow can increase inventory and accounts payable together, leaving near-term operating cash less affected. That does not eliminate the obligation to pay or prove that the inventory is commercially sound.
The analyst compares inventory days with payable days and the terms described in the notes. A longer payment period may reflect negotiated efficiency, a deliberate financing arrangement, or pressure on suppliers. The financial statements alone may not identify the motive, so the interpretation should remain bounded by available evidence.
The important scenario is what happens when the payable comes due before the inventory converts to cash. A business can show acceptable current cash flow while accumulating a future working-capital need. This article's focus is the warehouse-to-cash conversion; a separate financing analysis would examine the company's broader liquidity resources.
The model therefore includes a timing bridge: when goods are paid for, when they are expected to sell, and when customers are expected to pay. That bridge makes the inventory thesis testable. A rising balance is neither automatically bad nor automatically harmless; its effect depends on recoverability and the timing of the associated cash flows.
Returns send yesterday's sale back into today's warehouse
Customer returns complicate the simple unit bridge. A returned product may be resalable as new, require refurbishment, or have little recovery value. Treating every return as an ordinary addition to inventory at its original cost can conceal deterioration in product quality or demand.
Marlow's analyst separates gross shipments from net sales and asks how returns affect inventory and expected recovery. A product launch with strong shipments but high returns may look different once the goods re-enter the warehouse. The timing can move the commercial evidence across reporting periods.
Warranty replacements create another flow. Goods may leave the warehouse without generating a new sale, while the associated cost follows the relevant warranty accounting. An inventory analysis that assumes every unit shipped produces revenue will overstate conversion. The physical reconciliation needs categories that reflect the business's actual uses of stock.
The analyst does not need to reproduce the entire accounting system. A small bridge that explains purchases, production, sales, returns, write-offs, and other uses can reveal whether the reported change is consistent with the commercial story. Unexplained residuals become questions for further disclosure rather than numbers to force into a favorable narrative.
A margin forecast needs a replacement-cost case
The FIFO example produced a strong current margin partly because older ten-dollar units flowed into cost of sales while new units cost fourteen dollars. If future sales must rely on the fourteen-dollar stock and the selling price remains twenty dollars, the unit gross profit before other costs becomes six dollars rather than ten on the old layer.
The analyst builds a replacement-cost scenario to understand that pressure. It is not a substitute for the company's reported accounting results. It is a forward-looking economic question: what margin would the business earn when it replaces the inventory needed for the next sales cycle at the assumed new cost?
The scenario should include pricing response, product mix, freight, and other relevant costs only when there is a defensible basis. A model that assumes immediate full price pass-through may be optimistic; one that assumes none may be pessimistic. The analyst states the range and identifies the evidence that would shift the judgment.
This makes the forecast less dependent on one period's cost layers. It also helps distinguish temporary inventory benefits from durable pricing power. A company can report an excellent quarter and still face a weaker next cycle if the warehouse contains the last of its inexpensive inputs.
The write-down history deserves context
Repeated inventory charges can indicate a business with difficult forecasting, rapid product cycles, or recurring operational problems. They can also reflect a transparent recognition policy. The analyst should examine the pattern rather than assuming that every charge is either conservative housekeeping or evidence of misconduct.
The useful questions concern recurrence, scale, affected products, and what changed afterward. Did production planning improve? Did the company reduce slow-moving stock? Did similar charges return under a new label? A one-time adjustment in a model should have a reason tied to the future economics, not merely to management's description.
A prior write-down can also affect later reported margins when the goods are eventually sold at their reduced carrying value. The later margin may look strong because some cost was recognized earlier. The analyst tracks that relationship where disclosure permits, rather than treating the sale period as an isolated performance improvement.
The goal is to understand the full life of the inventory cost. Moving an expense from one period to another changes the time pattern of profit. The economic assessment should connect purchase, storage, markdown, sale, and cash recovery across that life instead of rewarding whichever quarter happens to look cleanest.
The evidence packet for the investment committee
Marlow's final worksheet contains a physical unit bridge, a cost-layer bridge, an aging view, a production-absorption example, and a working-capital timeline. It separates disclosed facts from analyst assumptions and marks where public information is insufficient. The committee can see which part of the margin thesis depends on each assumption.
The analyst presents three commercial cases: inventory clears at expected prices, clearance requires a discount, or part of the stock remains unsold beyond the planned window. Each case changes cash recovery and future purchasing needs. The model avoids assigning probabilities that the evidence cannot support merely to produce a single precise target value.
The committee also receives a short list of observations that would change the thesis: improving sell-through, increasing discounts, another product transition, a change in supplier terms, or a new write-down. These are concrete signals tied to the warehouse's economics, not a generic promise to monitor the next earnings release.
The strongest conclusion may be that reported profit is understandable but not yet sufficient evidence of demand quality. That is a useful analytical result. It directs attention to the missing conversion evidence rather than treating accounting compliance and commercial strength as the same question.
What remains after the shelves are counted
Inventory is an asset whose value depends on a future transaction. Cost formulas determine how expenditures move through reported profit, but customers determine whether the goods ultimately produce cash. Production planning and payment terms determine how long capital remains committed along the way.
Marlow's examples show why those views must be reconciled. FIFO and weighted average produce different period profits with the same cash transactions. Extra production can defer fixed overhead into inventory while consuming additional cash. A write-down can improve a days ratio without selling a single unit.
An analyst who follows only the margin can miss those mechanisms. An analyst who treats every inventory increase as a warning can miss legitimate growth and seasonal preparation. The disciplined approach is to trace the goods, the costs, and the cash together, with the assumptions visible.
That produces a more durable equity thesis: one based on what the warehouse is likely to recover and what the next cycle will require, rather than on a single accounting percentage detached from the stock behind it.