Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 3, 2019, which the company labels fiscal 2018. Forecast Horizon Period Reported $ millions 2018 Sales $124,433 NOPAT 13,884 NOA 29,378 $133,144 14,912 31,432 2019 Terminal Period 2020 2021 2022 $142,464 $152,436 $163,107 $166,369 15,956 17,073 18,268 18,633 33,632 35,986 38,505 39,275 Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating obligations (NNO) of $31,538 million. Required a. Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) model as of February 3, 2019. Note: Do not round until your final answer; round your final answer to two decimal places. Stock price per share: $Answer b. Home Depot stock closed at $218.57 on March 28, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price?

Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 3, 2019, which the company labels fiscal 2018. Forecast Horizon Period Reported $ millions 2018 Sales $124,433 NOPAT 13,884 NOA 29,378 $133,144 14,912 31,432 2019 Terminal Period 2020 2021 2022 $142,464 $152,436 $163,107 $166,369 15,956 17,073 18,268 18,633 33,632 35,986 38,505 39,275 Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating obligations (NNO) of $31,538 million. Required a. Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) model as of February 3, 2019. Note: Do not round until your final answer; round your final answer to two decimal places. Stock price per share: $Answer b. Home Depot stock closed at $218.57 on March 28, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price?

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter6: Accounting For Financial Management

Section: Chapter Questions

Problem 12P

See similar textbooks

Similar questions

Roseau Company is preparing its annual earnings per share amounts to be disclosed on its 2019 income statement. It has collected the following information at the end of 2019: 1. Net income: 120,400. Included in the net income is income from continuing operations of 130,400 and a loss from discontinued operations (net of income taxes) of 10,000. Corporate income tax rate: 30%. 2. Common stock outstanding on January 1, 2019: 20,000 shares. 3. Common stock issuances during 2019: July 6, 4,000 shares; August 24, 3,000 shares. 4. Stock dividend: On October 19, 2019, the company declared a 10% stock dividend that resulted in 2,700 additional outstanding shares of common stock. 5. Common stock prices: 2019 average market price, 30 per share; 2019 ending market price, 27 per share. 6. 7% preferred stock outstanding on January 1, 2019: 1,000 shares. Terms: 100 par, nonconvertible. Current dividends have been paid. No preferred stock issued during 2019. 7. 8% convertible preferred stock outstanding on January 1, 2019: 800 shares. The stock was issued in 2018 at 130 per share. Each 100 par preferred stock is currently convertible into 1.7 shares of common stock. Current dividends have been paid. To date, no preferred stock has been converted. 8. Bonds payable outstanding on January 1, 2019: 100,000 face value. These bonds were issued several years ago at 97 and pay annual interest of 9.6%. The discount is being amortized in the amount of 300 per year. Each 1,000 bond is currently convertible into 22 shares of common stock. To date, no bonds have been converted. 9. Compensatory share options outstanding: Key executives may currently acquire 3,000 shares of common stock at 20 per share. The options were granted in 2018. To date, none have been exercised. The unrecognized compensation cost (net of tax) related to the options is 4 per share. Required: 1. Compute the basic earnings per share. Show supporting calculations. 2. Compute the diluted earnings per share. Show supporting calculations. 3. Show how Roseau would report these earnings per share figures on its 2019 income statement. Include an explanatory note to the financial statements.
Cost of Goods Sold, Income Statement. and Statement of Comprehensive Income Gaskin Company derives the following items from its adjusted trial balance as of December 31, 2019: The following; additional information is also available. The December 31, 2019, ending inventory is 14,700. During 2019, 4,200 shares of'common stock were outstanding the entire year. The income tax rate 30% on all items of income. Required: 1. As a supporting document for Requirements 2 and 3, prepare a separate schedule for Gaskins cost of goods sold. 2. Prepare a 2019 single-step income statement. 3. Prepare a 2019 multiple-step income statement. 4. Prepare a 2019 statement of comprehensive income.
Ratio Analysis Rising Stars Academy provided the following information on its 2019 balance sheet and state mcnt of cash flows: Long-term debt S 4,400 Interest expense S 398 Total liabilities 8,972 Net income 559 Total assets 38,775 Interest payments 432 Total equity 29,803 Cash flows from operations 1.015 Operating income 1.223 Income tax expenses 266 Income taxes paid 150 Required: Calculate the following ratios for Rising Stars: (a) debt to equity, (b) debt to total assets, (c) long-term debt to equity, (d) times interest earned (accrual basis), and (e) times interest earned (cash basis). (Note: Round answers to three decimal places.) CONCEPTUAL CONNECTION Interpret these results. 3.What does it mean if a bond is callable
Recording Various Liabilities Glenview Hardware had the following transactions that produced liabilities during 2020: a. Purchased merchandise on credit for $30,000. ( Note: Assume a periodic inventory system.) b. Year-end wages of $10,000 were incurred, but not paid. Related federal income taxes of $1,200, Social Security of $620 (employee portion), and Medicare taxes of $145 were with-held from employees. c. Year-end estimated income taxes payable, but unpaid, for the year were $42,850. d. Sold merchandise on account for $1,262, including state sales taxes of S48. ( Note: Assume a periodic inventory system.) e. Employers share of Social Security and Medicare taxes for the period were $620 and $145, respectively. f. Borrowed cash under a 90-day, 9%, $25,000 note. Required: Prepare the entry to record each of these transactions (treat each transaction independently).
Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020. Prepare Hellers partial income statements (through gross profit) for 2019 and 2020. RE22-2 Heller Company began operations in 2019 and used the LIFO method to compute its 300,000 cost of goods sold for that year. At the beginning of 2020, Heller changed to the FIFO method. Heller determined that its cost of goods sold under FIFO would have been 250,000 in 2019. For 2020, Hellers cost of goods sold under FIFO was 360,000, while it would have been 410,000 under LIFO. Heller is subject to a 21% income tax rate. Compute the cumulative effect of the retrospective adjustment on prior years income (net of taxes) that Heller would report on its retained earnings statement for 2020.
Prince Corporations accounts provided the following information at December 31, 2019: What should be the current balance of retained earnings? a. 520,000 b. 580,000 c. 610,000 d. 670,000
Ratio Analysis Consider the following information taken from the stockholders equity section: How do you interpret the companys payout and profitability performance? Required: 1. Calculate the following for 2020. (Note. Round answers to two decimal places.) 2. CONCEPTUAL CONNECTION Assume 2019 ratios were: and the current year industry averages are: How do you interpret the companys payout and profitability performance?
LONG-TERM FINANCING NEEDED At year-end 2019, total assets for Arrington Inc. were 1.8 million and accounts payable were 450,000. Sales, which in 2019 were 3.0 million, are expected to increase by 25% in 2020. Total assets and accounts payable are proportional to sales, and that relationship will be maintained; that is, they will grow at the same rate as sales. Arrington typically uses no current liabilities other than accounts payable. Common stock amounted to 500,000 in 2019, and retained earnings were 475,000. Arrington plans to sell new common stock in the amount of 130,000. The firms profit margin on sates is 5%; 35% of earnings will be retained. a. What were Arringtons total liabilities in 2019? b. How much new long-term debt financing will be needed in 2020? (Hint: AFN - New stock = New long-term debt.)
The Jimenez Corporation’s forecasted 2020 financial statements follow, along with some industry average ratios. Calculate Jimenez’s 2020 forecasted ratios, compare them with the industry average data, and comment briefly on Jimenez’s projected strengths and weaknesses. Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2020 Jimenez Corporation: Forecasted Income Statement for 2020 Jimenez Corporation: Per Share Data for 2020 Notes: aIndustry average ratios have been stable for the past 4 years. bBased on year-end balance sheet figures. cCalculation is based on a 365-day year.
The following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.
Using the following Company W information, prepare a Retained Earnings Statement. Retained earnings balance January 1, 2019, $43,500 Net income for year 2019, $55,289 Dividends declared and paid for year 2019, $18,000
Comprehensive The following are Farrell Corporations balance sheets as of December 31, 2019, and 2018, and the statement of income and retained earnings for the year ended December 31, 2019: Additional information: a. On January 2, 2019, Farrell sold equipment costing 45,000, with a book value of 24,000, for 19,000 cash. b. On April 2, 2019, Farrell issued 1, 000 shares of common stock for 23,000 cash. c. On May 14, 2019, Farrell sold all of its treasury stock for 25,000 cash. d. On June 1, 2019, Farrell paid 50, 000 to retire bonds with a face value (and book value) of 50, 000. e. On July 2, 2019, Farrell purchased equipment for 63, 000 cash. f. On December 31, 2019, land with a fair market value of 150,000 was purchased through the issuance of a long-term note in the amount of 150,000. The note bears interest at the rate of 15% and is due on December 31, 2021. g. Deferred taxes payable represent temporary differences relating to the use of accelerated depreciation methods for income tax reporting and the straight-line method for financial statement reporting. Required: 1. Prepare a spreadsheet to support a statement of cash flows for Farrell for the year ended December 31, 2019, based on the preceding information. 2. Prepare the statement of cash flows. (Appendix 21.1) Spreadsheet and Statement Refer to the information for Farrell Corporation in P21-13. Required: 1. Using the direct method for operating cash flows, prepare a spreadsheet to support a 2019 statement of cash flows. (Hint: Combine the income statement and December 31, 2019, balance sheet items for the adjusted trial balance. Use a retained earnings balance of 291,000 in this adjusted trial balance.) 2. Prepare the statement of cash flows. (A separate schedule reconciling net income to cash provided by operating activities is not necessary.)