Inventory Aging in Commercial Loan Underwriting: A Borrower’s Guide

01

Reconcile inventory to the books and physical records

Tie the inventory aging total to the general-ledger control account and the same-date balance sheet. Reconcile units and extended value to perpetual records, cycle counts, warehouse systems, third-party statements, and the latest physical inventory. Investigate negative quantities, duplicate item codes, unit-of-measure errors, unposted receipts, shipments not relieved, cutoff differences, and manual adjustments. Preserve the report parameters and count date so the lender can understand what was included and reproduce the total.

02

Define the aging date and method

State whether age begins at purchase receipt, production completion, transfer into finished goods, last movement, last sale, expiration date, or another controlled event. Apply the method consistently and explain items whose age resets after repackaging, rework, transfer, or component conversion. Show clear buckets appropriate to the business, such as current, 31–60, 61–90, 91–180, 181–365, and more than one year. A report can look current if old stock is repeatedly reassigned a new date.

• Requested amount and use of proceeds
• Historical and current financial statements
• Complete debt and ownership schedules
• Collateral and transaction documentation

03

Separate inventory by economic purpose

Present raw materials, components, work in process, finished goods, resale merchandise, spare parts, consigned goods, customer-owned materials, demonstration units, returns, damaged goods, obsolete stock, goods in transit, and supplies separately. Distinguish normal operating inventory from equipment, fixed assets, prepaid expenses, or capital-project materials. The categories have different accounting, saleability, conversion time, liquidation value, and borrowing-base treatment, so one blended total can hide material risk.

04

Verify cost and reserve methodology

Document whether inventory is carried using specific identification, FIFO, average cost, standard cost, or another accepted policy, and reconcile material variances between standard and actual cost. Identify freight, duties, labor, overhead, vendor rebates, purchase discounts, write-downs, and capitalization practices included in value. Review lower-of-cost-or-market or net-realizable-value analysis with qualified accounting professionals. Show gross value, valuation allowances, obsolescence reserves, and net carrying value rather than netting unsupported adjustments into one number.

05

Map location, possession, and ownership

List each warehouse, store, job site, customer location, contract manufacturer, public warehouse, bonded facility, freight terminal, and goods-in-transit category. Record who holds the goods, who owns them, what documents prove title, and whether access or inspection is available. Flag consignment, drop shipment, vendor-held stock, customer deposits, sale-or-return terms, bill-and-hold arrangements, and inventory subject to warehouse receipts. Physical possession does not always establish legal ownership or collateral access.

06

Identify slow-moving, excess, obsolete, and restricted stock

Measure recent sales, usage, orders, and last movement by item. Compare on-hand quantity with historical demand, committed orders, forecast consumption, shelf life, model changes, seasonality, warranty exposure, regulatory restrictions, and replacement products. Explain the disposition plan for aged stock, including discounted sale, return to vendor, rework, component recovery, scrap, donation, or write-off. Avoid assuming list price or original cost will be recovered when recent transactions show otherwise.

07

Connect inventory with sales, margins, and turnover

Calculate inventory days, turns, sell-through, gross margin, markdowns, shrinkage, returns, and stockouts by material category or product line. Reconcile changes in inventory with purchases, production, sales, backlog, and cash collections. Growth can require more stock, but a rising balance with flat sales, declining margins, or slower turns may signal forecast error or weak demand. Explain whether the requested facility funds a repeatable conversion cycle or accumulated goods without a credible exit.

08

Review liens, priority, and borrowing-base eligibility

Identify UCC filings, purchase-money interests, floor-plan financing, consignment rights, landlord claims, warehouse liens, customs or tax claims, supplier retention rights, and other interests that may affect inventory. If a revolving line uses a borrowing base, show eligibility rules, advance rates, aging exclusions, location limits, concentration caps, reserves, appraisals, and in-transit treatment. Do not remove ineligible inventory from the source report; present gross inventory, each contractual exclusion, lender reserves, and resulting availability so the calculation can be reproduced.

09

Build inventory into the cash forecast

Forecast purchases, deposits, freight, duties, production labor, storage, insurance, sales, collections, vendor payments, markdowns, and required minimum stock by week or month. Test slower demand, delayed shipments, shorter supplier terms, higher input costs, lower margins, customer cancellations, and reduced collateral eligibility. If new financing supports a seasonal or growth build, show the peak funding need and the documented path from inventory to receivable to collected cash and line repayment.

010

Create a lender-ready reporting control

Assign responsibility for item setup, receipt, transfer, production, shipment, count adjustments, costing, reserve review, and aging sign-off. Lock the reporting date, retain the detailed export and reconciliation, compare trends with prior periods, and investigate unusual movements before submission. Present the lender with the reconciled aging, category and location detail, reserve analysis, turnover trends, borrowing-base bridge, purchase and sales forecast, and downside case using the same entities and date as the financial statements. PFCS can help organize the package and financing discussion, while lenders and qualified advisers determine accounting, legal, valuation, collateral, underwriting, and final loan treatment.