Week 11 Assignment - YOUR NAME

Complete the following problems Projecting Revenue, Costs of Goods Sold and Inventory.

Use the following data for Waltons in Years X-1 and X to project revenues, cost of goods sold, and inventory for Year X+1. Assume that Waltons Year X+1 revenue growth rate, gross profit margin, and inventory turnover will be identical to Year X.

Project the average inventory balance in Year X and use it to compute the implied ending inventory balance.

Round to the nearest dollar except for Inventory Turnover (IT). For IT round to 2 places beyond the decimal point.

Waltons (data in millions)

	Year X-1	Year X	Year X+1
Revenue	$ 58,790	$ 63.541	?
Cost of Goods Sold	38,518	42,445	?
Ending Inventory	7,250	7,350	?
Inventory Turnover		?
Average Inventory			?

Replace the ? with your answers and show your work below.