Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

Walgreens Year +1 Projection using MS Excel and Computing Implied Ending Inventory Balance

Walgreens is leading chain of drugstores in the united states. Use the following data for walgreens in years 7 and 8 to project revenues, cost of goods sold and inventory for year +1. Assume that walgreens year +1 revenue growth rate, gross profit margin and inventory turnover will be identical to year 8. Project the average inventory balance in year +1 and use it to compute the implied ending inventory balance.

Sales revenue year 7 =53762 year 8=59034

Cost of good sold year 7= 38518 year 8=42391

ending inventory year 7=6791 year 8=7249

Show more
  • @
  • 1 order completed
ANSWER

Tutor has posted answer for $5.00. See answer's preview

$5.00

******** ** PDF and *****

Click here to download attached files: Walgreen 1.pdf
Click here to download attached files: Walgreen 2.xls
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question