Suppose a company's cost of goods sold for years 2 and 3 were $283,310 and $299,390 respectively. Also suppose that inventory had a balance of $34,740 at the end of year 1, $35,168 at the end of year 2, and $36,356 at the end of year 3. If the annual growth in total revenues is 8.42% for the foreseeable future, calculate the forecasted inventory balance at the end of year 5. Assume the same inventory turnover in all future years as that in year 3 calculated using the average asset balances. Also assume the same gross margin % in all future years as that in year 3. Note that year 3 is the latest year with reported results, while years 4 onwards are all forecasted years.

Suppose a company's cost of goods sold for years 2 and 3 were $283,310 and $299,390 respectively. Also suppose that inventory had a balance of $34,740 at the end of year 1, $35,168 at the end of year 2, and $36,356 at the end of year 3. If the annual growth in total revenues is 8.42% for the foreseeable future, calculate the forecasted inventory balance at the end of year 5. Assume the same inventory turnover in all future years as that in year 3 calculated using the average asset balances. Also assume the same gross margin % in all future years as that in year 3. Note that year 3 is the latest year with reported results, while years 4 onwards are all forecasted years.

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

Data taken from the records of XYZ Co. revealed the following for 2020: Inventory - January 1 :P2,000,000; Net purchases : P7,000,000; Inventory - December 31 : P2,800,000; Sales Returns and allowances: P750,000. Gross profit based on net sales is 20%. How much is the gross sales for 2020? A. P7,000,000 B. P7,750,000 C. P8,500,000 D. P9,125,000 E. answer not given
The company had the following inventory at end-of-year prices: $1,230,000 in 2016 (base year), $1,345,000 in 2017, and $1,350,000 in 2018. The price index is 1.02 in 2017 and 1.03 in 2018. What is the LIFO effect in 2018? Round to the nearest whole number.
The condensed financial statements of Blossom Company for the years 2019 and 2020 are presented below. BLOSSOM COMPANY Balance Sheets December 31 (in thousands) 2020 2019 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 630 560 Inventory 580 510 Prepaid expenses 130 160 Total current assets 1,670 1590 Property, plant, and equipment (net) 410 380 Investments 170 170 530 510 Intangibles and other assets $2,780 $2,650 Total assets $980 $950 Current liabilities Long-term liabilities 600 500 Stockholders' equity-common 1,200 1,200 Total liabilities and stockholders equity $2780 $2,650 BLOSSOM COMPANY Income Statements For the Year Ended December 31 (in thousands) 2019 2020 $3,920 $3,580 Sales revenue Costs and expenses Cost of goods sold 1,130 1050 Selling & administrative expenses 2400 2,330 Interest expense 10 20 Total costs and expenses 3,540 3400 Income before income taxes 380 180 Income tax expense 152 72 $228 $108 Net income
From the following hypothetical data for Riffa Co. in 2018 and 2019 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Riffa's Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2019. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Cost of Goods Sold Gross Profit Ending Inventory Riffa Co. Required: Calculate the followings for Riffa Co. (consider 3 decimal places) 1. Sales Revenue and Growth Rate for Y+ 1 year. 2. Inventory Turnover for 2019. 3. Forecasted Gross Profit for Y+1. 4. Projected Average Inventory Balance in Year +1 5. Projected Ending Inventory for Year + 1. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac) 2018 48520 30560 6480 2019 56520 36800 8260
From the following hypothetical data for Riffa Co. in 2018 and 2019 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Riffa's Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2019. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Cost of Goods Sold Gross Profit Ending Inventory Riffa Co. Required: Calculate the followings for Riffa Co. (consider 3 decimal places) 1. Sales Revenue and Growth Rate for Y+ 1 year. 2. Inventory Turnover for 2019. 3. Forecasted Gross Profit for Y+1. 4. Projected Average Inventory Balance in Year +1 5. Projected Ending Inventory for Year + 1. 2018 48520 30560 6480 2019 56520 36800 8260
At the EOQ, what is the firm’s total inventory costper year, assuming safety stock = 15 units?
Please find: Days' sales in inventory, Receivables Turnover, Equity Multipli Use information from the balance sheet and income statement to calculate the following financial ratios and the market value added (MVA). (Whenever balance sheet numbers are used to calculate financial ratios, please ensure that you use the average of the 2019 and 2020 numbers in your calculation. To calculate MVA, you can assume that the average book value number for common stock and paid-in-surplus is the amount that the shareholders initially invested in the company.)
The following information was available for Concord Company at December 31, 2020: beginning inventory $163000; ending inventory $117000; cost of goods sold $1330000; and sales $1360000. Concord's inventory turnover in 2020 was O 9.5 times. O 9.7 times. O 11.4 times. O 8.2 times.
The 2020 financial statements of Crane Company reported a beginning inventory of $79000, an ending inventory of $119000, and cost of goods sold of $683100 for the year. Crane’s inventory turnover for 2020 is 8.6 times. 5.7 times. 6.9 times. 4.7 times.
Inventory Turnover Calculate the company's inventory turnover for 2020 and compare the result to the industry average.
A) Calculate the following liquidity ratios for 2020. 1. Working capital- 2.Current Ratio- 3. Acid test ratio- 4. Accounts receivable turnover- B) calculate the following liquidity ratios for 2020. 1. Average collection period (in days)- 2. Inventory turnover (in times)- C) calculate the average days to sell inventory for 2020. 1. Average days to sell 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. 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