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

Use the following data for Walton$$s in Years X$-1$ and X to project revenues, cost of goods sold, and inventory for Year X$+1.$ Assume that Walton$$s 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.

Walton$$s $($data in millions$)$

Year X$-1$ Year X Year X$+1$

Revenue $ $58,790$ $ $63,541?$

Cost of Goods Sold $38,51842,445?$

Ending Inventory $7,2507,350?$

Inventory Turnover $?$

Average Inventory $?$

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