10.5 Projecting Revenues, Cost of Goods Sold, and Inventory. Use the following hypothetical data for Walgreens...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
10.5 Projecting Revenues, Cost of Goods Sold, and Inventory. Use the following hypothetical data for Walgreens in 2014 and 2015 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Walgreens's Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2015. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Walgreens (data in millions) 2015 LO 10-2 Sales revenues Cost of goods sold Ending inventory 2014 $76,392 $103,444 $54,823 $ 76,520 $ 6,076 $ 8,678 LO 10-2 10.15 Identifying Financial Statement Relations. Partial forecasts of finan- cial statements for Watson Corporation appear in Exhibit 10.7 (income statement), Exhibit 10.8 (balance sheet), and Exhibit 10.9 (statement of cash flows). Selected amounts have been omit- ted, as have all totals (indicated by XXXX). REQUIRED Determine the amount of each of the following items. a. Dividends declared and paid during Year 1. b. Depreciation expense for Year 1 assuming that Watson Corporation neither sold nor retired depreciable assets during Year 1. c. Inventories at the end of Year 2. d. Interest expense on borrowing during Year 2, with an interest rate of 7%. e. Other current liabilities at the end of Year 2. f. Property, plant, and equipment at the end of Year 3 assuming that Watson Corporation neither sold nor retired depreciable assets during Year 3. g. Retained earnings at the end of Year 3. h. Long-term debt at the end of Year 3. i. The income tax rate for Year 4. j. Purchases of inventories during Year 4. Sales Cost of goods sold Selling and administrative Interest expense Income taxes Net income Exhibit 10.7 Watson Corporation Partial Income Statements (Problem 10.15) Year 0 Actual Year +1 Projected Year +2 Projected $ 46,000 $ 50,600 (29,900) (32,890) $ 56,672 XXXX $ 64,606 Year +3 Projected Year +4 Projected $ 74,943 (40,702) (46,465) (10,580) (11,638) (12,468) (13,567) (14,989) (3,907) (4,298) d (3,866) (5,227) (565) (621) (1,372) (2,265) (2,892) $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX Exhibit 10.8 Watson Corporation Partial Balance Sheets (Problem 10.15) Year 0 Year +1 Actual Projected Year +2 Projected Year +3 Projected Year +4 Projected ASSETS Cash $ 1,200 $ 664 $ 206 $ 416 $ 1,262 Accounts receivable 8,000 8,433 8,855 10,420 12,286 Inventories 7,500 8,223 10,711 11,333 Fixed assets Cost 110,400 120,445 126,467 Accumulated depreciation (33,100) (36,112) (37,917) f (45,352) 169,895 (50,938) Total Assets $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX LIABILITIES AND SHAREHOLDERS' EQUITY Accounts payable $ 2,500 $ 2,801 $ 3,107 $ 3,376 $ 3,828 Notes payable Other current liabilities 6,500 3,300 6,852 3,630 7,195 8,467 4,635 9,982 5,376 Long-term debt 45,000 49,094 51,549 h 69,251 Total Liabilities $ XXXX Common stock $ 15,000 $ XXXX $ 17,233 Retained earnings 21,700 Total Shareholders' Equity $ XXXX 22,043 $ XXXX $ XXXX $ 17,539 23,700 $ XXXX $ XXXX $ 22,434 $ 24,319 g 31,082 $ XXXX $ XXXX $ XXXX Total Liabilities and Shareholders' Equity $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX OPERATIONS Exhibit 10.9 Watson Corporation Partial Statements of Cash Flows (Problem 10.15) Year 0 Actual Year +1 Projected Year +2 Projected Year +3 Projected Year +4 Projected $ 5,370 Net income $ 1,048 $ 1,153 $ XXXX $ 4,206 Depreciation 2,378 b 1,805 7,435 5,586 Change in accounts receivable (394) (433) (422) (1,565) (1,866) Change in inventories (657) (723) (1,322) (1,166) (622) Change in accounts payable Change in other current liabilities Cash Flow from Operations INVESTING Acquisition of fixed assets FINANCING 274 301 306 269 452 300 330 436 569 741 $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX $(9,130) $(10,045) $(6,022) $(24,796) $(18,632) Change in notes payable $ 320 $ 3352 $ 343 $ 1,272 $ 1,515 Change in long-term debt 3,721 Change in common stock 2,029 4,094 2,233 2,455 306 10,107 7,595 Dividends (750) a (891) Cash Flow from Financing $ XXXX $ XXXX $ XXXX $ XXXX 4,895 (1,016) $ XXXX 1,885 (1,178) Change in Cash $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX 10.5 Projecting Revenues, Cost of Goods Sold, and Inventory. Use the following hypothetical data for Walgreens in 2014 and 2015 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Walgreens's Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2015. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Walgreens (data in millions) 2015 LO 10-2 Sales revenues Cost of goods sold Ending inventory 2014 $76,392 $103,444 $54,823 $ 76,520 $ 6,076 $ 8,678 LO 10-2 10.15 Identifying Financial Statement Relations. Partial forecasts of finan- cial statements for Watson Corporation appear in Exhibit 10.7 (income statement), Exhibit 10.8 (balance sheet), and Exhibit 10.9 (statement of cash flows). Selected amounts have been omit- ted, as have all totals (indicated by XXXX). REQUIRED Determine the amount of each of the following items. a. Dividends declared and paid during Year 1. b. Depreciation expense for Year 1 assuming that Watson Corporation neither sold nor retired depreciable assets during Year 1. c. Inventories at the end of Year 2. d. Interest expense on borrowing during Year 2, with an interest rate of 7%. e. Other current liabilities at the end of Year 2. f. Property, plant, and equipment at the end of Year 3 assuming that Watson Corporation neither sold nor retired depreciable assets during Year 3. g. Retained earnings at the end of Year 3. h. Long-term debt at the end of Year 3. i. The income tax rate for Year 4. j. Purchases of inventories during Year 4. Sales Cost of goods sold Selling and administrative Interest expense Income taxes Net income Exhibit 10.7 Watson Corporation Partial Income Statements (Problem 10.15) Year 0 Actual Year +1 Projected Year +2 Projected $ 46,000 $ 50,600 (29,900) (32,890) $ 56,672 XXXX $ 64,606 Year +3 Projected Year +4 Projected $ 74,943 (40,702) (46,465) (10,580) (11,638) (12,468) (13,567) (14,989) (3,907) (4,298) d (3,866) (5,227) (565) (621) (1,372) (2,265) (2,892) $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX Exhibit 10.8 Watson Corporation Partial Balance Sheets (Problem 10.15) Year 0 Year +1 Actual Projected Year +2 Projected Year +3 Projected Year +4 Projected ASSETS Cash $ 1,200 $ 664 $ 206 $ 416 $ 1,262 Accounts receivable 8,000 8,433 8,855 10,420 12,286 Inventories 7,500 8,223 10,711 11,333 Fixed assets Cost 110,400 120,445 126,467 Accumulated depreciation (33,100) (36,112) (37,917) f (45,352) 169,895 (50,938) Total Assets $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX LIABILITIES AND SHAREHOLDERS' EQUITY Accounts payable $ 2,500 $ 2,801 $ 3,107 $ 3,376 $ 3,828 Notes payable Other current liabilities 6,500 3,300 6,852 3,630 7,195 8,467 4,635 9,982 5,376 Long-term debt 45,000 49,094 51,549 h 69,251 Total Liabilities $ XXXX Common stock $ 15,000 $ XXXX $ 17,233 Retained earnings 21,700 Total Shareholders' Equity $ XXXX 22,043 $ XXXX $ XXXX $ 17,539 23,700 $ XXXX $ XXXX $ 22,434 $ 24,319 g 31,082 $ XXXX $ XXXX $ XXXX Total Liabilities and Shareholders' Equity $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX OPERATIONS Exhibit 10.9 Watson Corporation Partial Statements of Cash Flows (Problem 10.15) Year 0 Actual Year +1 Projected Year +2 Projected Year +3 Projected Year +4 Projected $ 5,370 Net income $ 1,048 $ 1,153 $ XXXX $ 4,206 Depreciation 2,378 b 1,805 7,435 5,586 Change in accounts receivable (394) (433) (422) (1,565) (1,866) Change in inventories (657) (723) (1,322) (1,166) (622) Change in accounts payable Change in other current liabilities Cash Flow from Operations INVESTING Acquisition of fixed assets FINANCING 274 301 306 269 452 300 330 436 569 741 $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX $(9,130) $(10,045) $(6,022) $(24,796) $(18,632) Change in notes payable $ 320 $ 3352 $ 343 $ 1,272 $ 1,515 Change in long-term debt 3,721 Change in common stock 2,029 4,094 2,233 2,455 306 10,107 7,595 Dividends (750) a (891) Cash Flow from Financing $ XXXX $ XXXX $ XXXX $ XXXX 4,895 (1,016) $ XXXX 1,885 (1,178) Change in Cash $ XXXX $ XXXX $ XXXX $ XXXX $ XXXX
Expert Answer:
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
A General Power bond carries a coupon rate of 9.5%, has 9 years until maturity, and sells at a yield to maturity of 8.5%. (Assume annual interest payments.) a. What interest payments do bondholders...
-
Use the following hypothetical data for Walgreens in 2014 and 2015 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Walgreens's Year +1 revenue growth rate, gross...
-
Stores (Wal-Mart) is the largest retailing firm in the world. Building on a base of discount stores, Wal-Mart has expanded into warehouse clubs and Supercenters, which sell traditional discount store...
-
What is the purpose of a Notice of Assessment?
-
The data in Table 12.12 are reproduced from Case Study 12.1 and represent employees laid off by the U.S. Department of Labor. a. Compute the odds of being retained to being laid off for each ethnic...
-
At September 30, 2018, the accounts of Spring Mountain Medical Center (SMMC) include the following: Accounts Receivable ........................................... $145,000 Allowance for Bad Debts...
-
Comparing Cheap Dates Around the World. Comparison of prices or costs across different country and currency environments requires translation of the local currency into a single common currency. This...
-
An investor purchases a stock for $38 and a put for $.50 with a strike price of $35. The investor sells a call for $.50 with a strike price of $40. What is the maximum profit and loss for this...
-
14. (6 pts.) The figure below shows the graph of the derivative f'(x). x1 12 23 24 T 5 ggs snil saU (ziq 8).ST WV = (x)\\ ni mod suley & campicupation At which of the points 0, x1, x2, x3, x4 and X5,...
-
Question 4 (0.75 points) The journal entry from the Sales Quote is posted immediately to the General Ledger. True False
-
magine you are in the process of planning to launch a new business venture in Canada. Your task is to conduct a comprehensive financial analysis to determine the initial funding requirements for your...
-
First, evaluate Gareth Hinds's use the graphic sound device (CLANG) in panel 15 as an interpretation of the text of the epic poem. Then, review lines 659-680 of the epic poem Beowulf , which describe...
-
# The Bells # Edgar Allen Poe theBells = ''' HEAR the sledges with the bells, Silver bells! What a world of merriment their melody foretells! How they tinkle, tinkle, tinkle, In the icy air of night!...
-
1 . Make a list of the industry's key success factors and measures of competitive strength or weakness. 2 . Assign weights to each competitive strength measure based on its perceived importance.
-
Suppose you currently have $5,000 in your savings account. You will withdraw $2,000 for a vacation to Costa Rica in two years (t = 2), and you will add $5,000 to your account in five years (t = 5)....
-
I am looking for feedback on this discussion post. Do you agree with what my classmate wrote? Public Health is the science of preventing disease with the intent to improve the health of the global...
-
Suppose you need to answer any four of seven essay questions on a history test and you can answer them in any order. a. How many different question combinations are possible? b. What is the...
-
Following are the unit costs of making and selling a single product at a normal level of 5,000 units per month and a current unit selling price of $90: Consider each requirement separately. Label all...
-
Mechanic's Aids Company operates 20 injection molding machines in the pro- duction of tool boxes of four different sizes, named the Apprentice, the Handyman, the Journeyman, and the Professional....
-
Lieberman Clothing Company manufactures its own designed and labeled sports attire and sells its products through catalog sales and retail outlets. While Lieberman has for years used activity-based...
Study smarter with the SolutionInn App