Details of this Paper

We started the course looking at the accounting




Question;We started the course looking at the accounting for basic things like bad debts and operating expenses, and that is how we?ll end it. The subject for our last case is inventory valuation.As you read the case, it will become apparent that there is an added dimension here. We are dealing with a specific and somewhat unique product---classic French red wines?that actually improves with age. Also, there is some real history connected with this case in that the scenario is drawn, for the most part, from something that actually happened.You are to write a letter to Romano Wine Company that outlines the scenario, identifies the accounting issue, and proposes a solution. Specifically, you must address how the Bordeaux red wines will be valued on the May 31, 2004 balance sheet and how that this will impact both the 2004 and 2005 income statements.Note: You read the balance sheet date correctly--it is May of 2004. The dates and periods of time are very important in this case. Therefore, assume that you are looking into this issue on or about June 15, 2004.Case #5Inventory ValuationThe Scenario:The setting for our last case is the wine industry, and the issue is inventory valuation. Before we go into specifics, I am going to ask you to assume that wholesale and retail prices for expensive French red wines (for example, those from Bordeaux) have declined significantly over the past four months. This is purely an assumption for purposes of this case. In reality, I doubt that there has been any such decline.The Case:The Romano Wine Company is a relatively small, family owned San Francisco company that distributes wine to restaurants, general purpose liquor stores, and retail wine shops including many small boutique shops. Even though Romano is a Sicilian name, the company is known for its expertise with French wines, particularly the more expensive reds. Romano has been around since the early sixties and has survived as an independent distributor mainly because of personal relationships established and nurtured over forty years.One of these close, long-lasting relationships is with Wells Fargo Bank ("Wells"), who provides short-term financing for the company?s inventory and long-term financing for the company?s warehouse and offices. Wells has always wanted to see unaudited quarterly financial statements and audited annual financial statements all prepared according to US GAAP. Romano?s most recent year-end is May 31, 2004 and the following scenario played-out in early June as part of the annual audit.Romano began to see soft prices for French reds late in 2003, which continued into the current year. In fact, wholesale prices (and soon after, the retail prices) really started to drop in early spring of this year. As of June 1, prices are down 30-40% from what they were in the fall of 2003 and the auditors have raised an issue about the valuation.Romano values its inventory using a weighted average cost basis and utilized the periodic inventory system. About a third of Romano?s inventory at May 31, 2004 consisted of red wines from Bordeaux, these 2,100 cases of red wine were purchased at an average cost of $120 per case, and in normal times would sell for roughly $220 a case. The replacement cost of this inventory at May 31st, was $80 a case, and the current selling price is $146 per case.How should the Bordeaux reds be valued on the May 31st balance sheet and what is the impact, if any, on the 2004 income statement? What will be the impact on the 2005 income statement?A proper response should be done within 2 pages or less.Additional Information:1) This is not the first time that wine prices have fallen (or risen) dramatically. (After all, grapes are a commodity even in the Bordeaux area of France!). Romano?s general manager is kind of a wine historian and he says volatility like this happens at least twice each decade, and prices always bounce back.According to your research the main reason for the price drop is excess produce, especially the 1999-2001 vintages. As soon as the distribution channel is cleared (in other words as soon as the wine drinkers of the world start drinking this stuff) prices will return to normal. In fact, Romano thinks that prices have bottomed-out and will start to go back up by the end of the year, and may be very close to their 2003 levels by late spring 2005.2) As we all know, if stored properly a good red wine will improve in the bottle. Obsolescence/spoilage is not a factor.3) Romano likes to turn over its inventory about four times a year. Actually, they don?t have a choice, because they don?t have a lot of excess cash. They must keep their business cycle at a reasonable length. However, this whole industry, from growers to distributors to retailers, is characterized by ?slow payers?. Romano, itself, seldom pays less than then 90 days after delivery! On the other hand, businesses eventually pay. A time-honored, unwritten code of conduct is very much evident in this industry.4) Romano?s sales for the year ended 5/31/04 were $2.1 million, and net income was 120,000. Sales, net income, and cash flow from operations were all less than what they were for year ending 5/31/03.The following is the company?s balance sheet as of 5/31/04.Romano Wine CompanyBalance SheetMay 31, 2004Cash 85,000 A/P 450,000A/R (NRV) 500,000 S/T Debt 500,000Inventory 750,000 L/T Debt 875,000PPE (NBV) 950,000Equity 460,000Total 2,285,000 Total 2,285,0005) Assume the current FASB Codification text is the accounting guidance in place during case timeframe.ToRomano Wine Company. Dear Sir,We have gone through the various issues related with valuation of Red Wines as on 31st May, 2004. As per our analysis following is the situation and value is derived as per valuation norms.Current Scenario:Wholesale and retail price of Red Wine have declined significantly (30% to 40%) over the last four months near balance sheet date. As per our research it is found that price fall is due to excess production of red wine and it is assumed that price will become normal as soon as demand of red wine will increase. Demand of wine is expected to increase by year end of 2005.Accounting Issue:To value French Red Wine as on 31st May 2004, the main issue is how to deal with current fall in price as on balance sheet date which seems to be temporary.Solution:As per standard prescribed for valuation of inventories, inventories should be valued atLower ofa) Cost of Inventoryb) Net Realizable ValueHere, Cost of Inventory means purchased price of inventory plus cost of conversion plus other cost incurred in bringing the inventories into their present location and condition and Net Realizable Value means Expected Selling price less Expected cost incurred to sell.Note: Purchase cost can be calculated by using First in First out Method or Weighted Average Cost Method.Material cannot be valued lower than its cost price until expected price of finished product is less than value of Material. If expected price of finished product is less than purchase price of material than material should be valued at its replacement cost at that time.However, current fall in price can be ignored if NRV is more than cost price.As per current Situation,Total value of Inventory as on 31st May, 2004: $ 750,0001/3rd of total inventory is Red Wine, so value of red wine as per balance sheet is $ 750000*1/3= $ 250000.Other information related to price and stock is as under:Purchased cost $120 per caseStock 2100 CasesNormal Sale price $220 per caseCurrent sale price $146 per caseReplacement cost $80 per caseNote: It is assumed that purchase cost is weighted average cost.Since as per valuation norms, stock should be valued at lower of cost or Net realizable value whichever is lower,Cost of inventory: 2100 cases * $120 = $ 2, 52,000Net Realizable Value: 2100 cases * $146 = $ 3, 06,600Hence value of red wines should be $ 252000 which is the cost priceValue of Red Wine should be increased by $ 2,000 (252000-250000)Impact of revised valuation on Income Statement of 2003-04: Profit will increase by $ 2000 as the closing inventory would increase so revised profit will be $ 1, 22,000.Impact of revised valuation on Income Statement of 2004-05: Profit will decrease by $ 2000 as the Opening Stock would be understated leading to a rise in profits.Impact of revised valuation on Balance sheet as on 31-05-04: Current Asset and Profit will increase by $ 2000 and the same will correspond to the dual aspect concept.Revised Balance sheet as on 31st May, 2004 is as under:Revised Balance Sheet as on 31-05-04Equity 462,000 PPE (NBV) 950,000L/T Debt 875,000 Inventory (750000+2000) 752,000S/T Debt 500,000 A/R (NRV) 500,000A/P 450,000 Cash 85,000$ 2,287,000 $ 2,287,000Replacement cost should be ignored for the above valuation as expected sale price of finished product is more than price of material so the costs of the materials are irrelevant for the purpose of the valuation.Mr. XOn behalf of XYZ Company,15th June, 2004


Paper#38445 | Written in 18-Jul-2015

Price : $42