LO 10-2 10.5 Projecting Revenues, Cost of Goods Sold, and Inventory. Use the following hypothetical data for Walgreens in 2021 and 2022 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2022. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Walgreens (data in millions) Sales revenues Cost of goods sold Ending inventory 2021 $76,392 $54,823 $ 6,076 2022 $103,444 $ 76,520 $ 8,678

LO 10-2 10.5 Projecting Revenues, Cost of Goods Sold, and Inventory. Use the following hypothetical data for Walgreens in 2021 and 2022 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2022. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Walgreens (data in millions) Sales revenues Cost of goods sold Ending inventory 2021 $76,392 $54,823 $ 6,076 2022 $103,444 $ 76,520 $ 8,678

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter10: Forecasting Financial Statement

Section: Chapter Questions

Problem 5QE: Use the following hypothetical data for Walgreens in Years 11 and 12 to project revenues, cost of...

See similar textbooks

Similar questions

Use the following information relating to Clover Company to calculate the inventory turnover ratio, gross margin, and the number of days sales in inventory ratio, for years 2022 and 2023.
None
Use the following information relating to Clover Company to calculate (a) the inventory turnover ratio, (b) gross margin, and (c) the number of days' sales in inventory ratio, for years 2022 and 2023. Assume a year has 365 days. Do not round intermediate calculations and round your final answers to 3 decimal places. Year 2021 Year 2022 Year 2023 Year 2022 Year 2023 Sales $260,000 305,000 333,000 Cost of Goods Sold $187,500 241,250 242,250 Inventory Turnover Average Inventory $25,000 30,000 38,000 Gross Margin Days' Sales in Inventory
Use the following information relating to Clover Company to calculate (a) the inventory turnover ratio, (b) gross margin, and (c) the number of days' sales in inventory ratio, for years 2022 and 2023. Assume a year has 365 days. Do not round intermediate calculations and round your final answers to 3 decimal places. Cost of Average Sales Goods Sold Inventory Year 2021 $260,000 $177,500 $25,000 Year 2022 305,000 221,250 30,000 Year 2023 343,000 242,250 35,000 Inventory Gross Days' Sales Turnover Margin in Inventory Year 2022 Year 2023
Analyze the influence of factors on the level of return on sales (ROS). Choose the proper method of factor analysis. Year 200A Year 200B Sales, $'000 56000 58421 Cost of goods sold, $'000 48000 50024
2 The following figures are for the year 2020: Inventory 1.1.2020 $4000 Inventory 31.12.2020 6000 Purchases 52,000 A uniform rate of markup of 20% is applied. Required: Calculate the gross profit and the sales figures using the income statement approach.
Questions: 1. What would be the amount of decrease in gross profit due to the change in selling price assuming the selling prices were 10% lower during 2020? 2. What would be the amount of change in gross profit assuming the quantity sold increases by 5% from 2019 to 2020? 3. What would be the percentage changes in cost price assuming the quantity sold increases by 5% from the base year to 2020?
j.Quick ratio is ____________ times. k.Inventory turnover is ________ times. l.Average collection period is RM__________ days.
Consider the following information for two companies in 2023: Company A Sales Cost of goods sold Average inventory $442,592 211,589 142,726 Company B $324,835 157,780 112,300 Based only on gross profit margin and days inventory outstanding, Enter 1 if Company A is more efficient with its inventory and more profitable selling it than Company B. Enter 2 if Company A is more efficient with its inventory but less profitable selling it than Company B. Enter 3 if Company A is less efficient with its inventory but more profitable selling it than Company B. Enter 4 if Company A is less efficient with its inventory and less profitable selling it than Company B.
Hah
Whitby Inc. is a wholesaler that uses a perpetual inventory system. The company's accounting records provided the following transactions for Product B during the fiscal year ended on December 31, 2020. Date Transactions Units Unit Cost Sale Price March 5 Purchase $ 9 19,000 10,000 8,000 16,000 June 15 Sale $27 September 19 November 20 Purchase Sale 11 30 Additional information: • The beginning inventory consisted of 7,000 units at a total cost of $56,000. • All sales are made on account with credit terms, 2/10, n/30. • Customers who purchased 10,000 units on November 20 paid the amount due within the discount period. All other customers paid their accounts receivable after the discount period. At the start of each question below, we indicate whether the First-in, First-out (FIFO) method or the Weighted Average Cost (WAC) method is used.
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working