ANYONE HAVE EXPERIENCE VALUING RETAIL INVENTORY?
I'm working on a deal to acquire a niche retail shop, and in the initial offer we put forth in the LOI we had determined a price range for the inventory (no more than $300,000 and no less than $250,000), dependent on how much the owner actually had on hand at the time of closing and doing a tiered discounting system for anything older than 90 days, 180 days and 365+. The owner has higher levels of inventory right now but believes he can get it down to $300,000 by the time of closing. However, he is not able to provide the data to determine how old each item of inventory is - so we're not able to actually use the proposed tiered pricing system. I proposed using a seller note to finance the inventory portion of the total purchase price, and the owner is resistant and said the broker warned him to never do that for inventory.
So now I need to figure out how to assess the value of current inventory, without date of purchase information. I wanted to share some of my initial ideas for input from the community.
1) Use date of most recent time the product was obtained. They aren't able to provide the date each individual item in their inventory was purchased, but they do have the most recent date the product type was updated in the system (i.e., the last time someone added a new item to their inventory. However, if they currently have 5 of the same product, you have no way to tell if they purchased all 5 recently or just 1 and the other 4 are old). If we assume they're only continuing to order products that sell well, we could filter and get to the products that have been ordered in the past 90 days, 180 days and 365+.
2) Use average turn rates based on historical sales data. Another approach could be manually calculating average turn rates by product type or category by analyzing historical sales and compare that to the current inventory and use some sort avg days to turn range to apply tiered discounting prices (only pay 100% for items with an average turn rate of <90 days, and so on... this would be a pretty manual and tedious task to do, but could be done. The tricky part is that certain types of their products get really hot for a while or are the newest edition/latest technology and could have been selling within 1-2 days last year, but may be out of trend this year. And sometimes older items become even more valuable later if the particular piece or product part is no longer made by the manufacturer and becomes harder to find or considered a collector's item. My gut says the frequency and total value increase from those occurrences doesn't make up for the risk of buying an unknown amount of old, possibly unsellable inventory.
3) Offer to pay only $250,000 (min of the range) if they won't consider using a seller note for the inventory. If they want the full $300,000, we'd have to revisit seller note option and make the last $50K difference the variable amount. But I'd would still need a way to assess the inventory we pay $250K for is mostly good, sellable product - which could be using the last date the product type was added to their inventory (from option 1 above).
Appreciate any thoughts or recommendations. Thanks!