Question

In: Finance

Projecting revenues, cost of goods sold, and inventory use the following data for Walgreens in years...

Projecting revenues, cost of goods sold, and inventory

use the following data for Walgreens in years 11 and 12 to project revenues, cost of goods sold, and inventory for year +1. Assume that Walgreen's year +1 revenue growth rate, gross profit margin and inventory turnover will be identical to year 12. Project the average inventory balance in year+1 and use it to compute the implied ending inventory balance.

Walgreens (data in millions) Year 11 Year 12

Sales revenues $53,762 $59,034

Cost of goods sold $38,518 $42,391

Ending inventory $ 6,791 $ 7,249

Solutions

Expert Solution

Calculating Sales revenue growth rate and projecting sales revenue for year +1

Sales growth rate = (Sales in year 12 / Sales in year 11) - 1 = (59034 / 53762) - 1 = 1.098061 - 1 = 9.8061% = 9.81%

Sales revenue for year +1 = Sales for year 12 x (1 + growth rate) = 59034 (1 + 9.81%) = 59034 x 1.0981 = 64825.23

Sales revenue for year +1 = 64825.23

Projecting cost of goods sold for year +1

Gross profit for year 12 = Sales revenue - Cost of goods sold = 59034 - 42391 = 16643

Gross profit margin for year 12 = Gross profit margin for year +1 = Gross profit / Sales = (16643 / 59034)

Gross profit for year + 1 = (Gross profit margin for year +1) x (sales for year +1) = (16643/59034) x 64825.23 = 18275.68

Cost of goods sold for year +1 = Sales - Gross profit = 64825.23 - 18275.68 = 46549.55

Cost of goods sold for year +1 = 46549.55

Projecting average inventory for year + 1

Average inventory for year 12 = (ending inventory for year 11 + Ending inventory for year 12) / 2 = (6791 + 7249) / 2 = 7020

We know that

Inventory turnover ratio for year 12 = inventory turnover ratio for year + 1

(Cost of goods sold 2012 / Average inventory of 2012) = (Cost of goods sold for year + 1 / Average inventory for year + 1)

( 42391 / 7020) = (46549.55 / Average inventory for year + 1)

Average inventory for year + 1 = (46549.55 x 7020) / 42391 = 7708.66

Average inventory for year +1 = 7708.66

Computing implied ending inventory for year + 1

Average inventory for year + 1 = (ending inventory for year 12 + Ending inventory for year +1) / 2

7708.66 = (7249 + + Ending inventory for year +1) / 2

7708.66 x 2 = 7249 + Ending inventory for year +1

Ending Inventory for year + 1 = 7708.66 x 2 - 7249 = 8168.32

Ending inventory for year + 1 = 8168.32


Related Solutions

Use the following information to complete the charts and calculate cost of goods sold, ending inventory,...
Use the following information to complete the charts and calculate cost of goods sold, ending inventory, and gross profit under the FIFO, LIFO, and Weighted Average methods. Units Cost Units Retail Oct. 1 Beginning Inventory 120 $39 Oct. 3 Sales 90 $100 Oct. 5 Purchase 140 $40 Oct. 12 Sales 110 $100 Oct. 18 Sales 45 $100 Oct. 26 Purchase 160 $43
Inventory data are presented below. Please calculate the ending inventory and the cost of goods sold...
Inventory data are presented below. Please calculate the ending inventory and the cost of goods sold (at 1/31) using the methods listed below. 1/1 - Beginning inventory 6 units at $5 1/10 - Purchase                           11 units at $6 1/15 - Sale 13 units 1/20 - Purchase                           15 units at $7 1/25 - Sale                                   11 units Inventory                 Cost of Goods Sold Periodic FIFO a) $__________ b) $__________ Periodic LIFO c) $__________ d) $__________ Periodic Weighted Average e) $__________...
1. Use the following data to determine the cost of goods manufactured: Beginning finished goods inventory...
1. Use the following data to determine the cost of goods manufactured: Beginning finished goods inventory $ 12,600 Direct labor used 32,400 Beginning work in process inventory 9,000 General and administrative expenses 15,300 Direct materials used 42,300 Ending work in process inventory 10,800 Indirect labor 8,100 Ending finished goods inventory 11,300 Indirect materials 15,300 Depreciation—factory equipment 9,300 2. Current information for the Healey Company follows: Beginning raw materials inventory $ 31,200 Raw material purchases 76,000 Ending raw materials inventory 32,600...
From the following, calculate the cost of ending inventory and cost of goods sold for the...
From the following, calculate the cost of ending inventory and cost of goods sold for the weighted-average method, ending inventory is 56 units. (Round your intermediate calculations and final answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 6 $ 2.70 April 10 9 3.20 May 15 13 3.70 July 22 14 3.95 August 19 19 4.70 September 30 19 4.90 November 10 33 5.10 December 15 15 5.50 cost of ending inventory? Cost of...
From the following, calculate the cost of ending inventory and cost of goods sold for the...
From the following, calculate the cost of ending inventory and cost of goods sold for the LIFO method, ending inventory is 54 units. (Round your answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 6 $ 1.00 April 10 9 1.50 May 15 13 2.00 July 22 14 2.25 August 19 19 3.00 September 30 19 3.20 November 10 33 3.40 December 15 15 3.80 Cost of ending inventory $ Cost of goods sold $
Cost of Goods Sold and Ending Inventory for each of the following methods:
Calculate the following:Cost of Goods Sold and Ending Inventory for each of the following methods:a.    FIFOb.    LIFOc.     Weighted Average  Units                    Unit Cost7/1      Beginning Inventory 100 107/5      Purchases                                                     500 157/15    Sales                                                              400                             7/20    Purchases                                                     200 20
Calculation of Cost of Goods Sold: Periodic Inventory System Prepare the cost of goods sold section...
Calculation of Cost of Goods Sold: Periodic Inventory System Prepare the cost of goods sold section for Adams Gift Shop. The following amounts are known: Beginning merchandise inventory $27,050 Ending merchandise inventory 22,550 Purchases 77,125 Purchases returns and allowances 4,055 Purchases discounts 5,745 Freight-in 230 Adams Gift Shop Cost of Goods Sold Cost of goods sold: $ $ $ $ $ Cost of goods sold $
Schedules of Cost of Goods Manufactured and Cost of Goods Sold; Income Statement The following data...
Schedules of Cost of Goods Manufactured and Cost of Goods Sold; Income Statement The following data from the just completed year are taken from the accounting records of Mason Company: Sales .......................................... $524,000 Direct labor cost.................................. $70,000 Raw material purchases............................ $118,000 Selling expenses ................................. $140,000 Administrative expenses ........................... $63,000 Manufacturing overhead applied to work in process ...... $90,000 Actual manufacturing overhead costs ................. $80,000 Inventories Beginning of End of Year Year Raw materials.............. $7,000 $15,000 Work in process............ $10,000 $5,000...
DEF Manufacturing Company presented the following data: Cost of goods manufactured and cost of goods sold...
DEF Manufacturing Company presented the following data: Cost of goods manufactured and cost of goods sold were P375,000 and P300,000, respectively. Purchases of raw materials amounted to twice as much as the net income before tax. Gross margin based on sales was 40%. There were no purchase returns but the sales returns amounted to P10,000. Inventory valuations were as follows: Raw materials on hand at the end of the period was 1/3 as much as much as at start. Work...
From the following? information, calculate the cost of ending inventory and cost of goods sold using...
From the following? information, calculate the cost of ending inventory and cost of goods sold using the? (a) FIFO,? (b) LIFO, and? (c) weighted-average methods. Units Cost January 1 Beginning Inventory 4 $7 March 6 Purchased 6 2 August 9 Purchased 4 9 December 10 Purchased 5 1 The ending inventory reveals eighteight items unsold
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT