Please answer the following questions using this document as your template: Name Date Complete the following problems Pr
Posted: Wed Jul 06, 2022 6:28 pm
questions using this document as your template: Name Date 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 $ 58,790 38,518 7,250 Year X $ 63,541 42,445 7,350 Revenue Cost of Goods Sold Ending Inventory Inventory Turnover Average Inventory Replace the "?" with your answers and show your work below. ? Year X+1 ? ? ? ?
Please answer the following