Complete the following problems Projecting Revenue, Costs of Goods Sold and Inventory.
Use the following data for Waltons in Years X and X to project revenues, cost of goods sold, and inventory for Year X Assume that Waltons Year X 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 places beyond the decimal point.
Waltons data in millions
Year X Year X Year X
Revenue $ $
Cost of Goods Sold
Ending Inventory
Inventory Turnover
Average Inventory
Replace the with your answers and show your work below.
