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. $ millions Sales NOPAT NOA Forecast Horizon Period Reported 2018 2019 2020 2021 2022 $99,547 $106,515 $113,971 $121,949 $130,485 $133,095 Terminal Period 11,107 11,930 12,765 13.658 14,614 14,907 23,502 25,145 26,905 28,789 30,804 31,420 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 $25,230 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: $ 0 x b. Home Depot stock closed at $174.86 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. $ millions Sales NOPAT NOA Forecast Horizon Period Reported 2018 2019 2020 2021 2022 $99,547 $106,515 $113,971 $121,949 $130,485 $133,095 Terminal Period 11,107 11,930 12,765 13.658 14,614 14,907 23,502 25,145 26,905 28,789 30,804 31,420 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 $25,230 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: $ 0 x b. Home Depot stock closed at $174.86 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?

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)

10th Edition

ISBN:9781337902571

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter3: Financial Statements, Cash Flow, And Taxes

Section: Chapter Questions

Problem 19SP

See similar textbooks

Similar questions

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?
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.
Profitability Ratios Katrina Corp. is a publicly traded company on a large stock exchange. Katrinas financial statement for 2019 and 2018 included the following data: Required: Calculate Katrinas earnings per share as it would be reported on the 2019 income statement.
Rate of Change nalyses eiher Company presents the following condcnsed comparative income statements for 2020, 2019, and 2018: Required: Next Level Prepare rate of change analyses for Teicher for 2019 and 2020 living year to year growth rates. What favorable or unfavorable trends do your analyses reveal about Teicher Companys financial performance?
Leverage Cook Corporation issued financial statements at December 31, 2019, that include the following information: Balance sheet at December 31,2019 Assets $8,000,000 Liabilities $1,200,000 Stockholders' equity (300,000 shares) $6,800,000 Income statement for 2019: Income from operations $1,200,000 Less: Interest expense (100,000) Income before taxes $1,100,000 Less: Income taxes expense (0,30) (330,000) Net income $ 770,000 The levels of assets, liabilities, stockholders' equity, and operating income have been stable in recent years; however, Cook Corporation is planning a 51,800,000 expansion program that will increase income from operations by $350,000 to $1,550,000, Cook is planning to sell 8.5% notes at par to finance the expansion. Required: What earnings per share does Cook report before the expansion?
Net Income and Comprehensive Income At the beginning of 2019, JR Companys shareholders equity was as follows: During 2019, the following events and transactions occurred: 1. JR recognized sales revenues of 108,000. It incurred cost of goods sold of 62,000 and operating expenses of 12,000, 2. JR issued 1,000 shares of its 5 par common stock for 14 per share. 3. JR invested 30,000 in available-for-sale securities. At the end of the year, the securities had a fair value of 35,000. 4. JR paid dividends of 6,000. The income tax rate on all items of income is 30%. Required: 1. Prepare a 2019 income statement for JR which includes net income and comprehensive income ignore earnings per share). 2. For 2016 prepare a separate (a) income statement (ignore earnings per share) and (b) statement of comprehensive income.
Rate of Change Analyses and Ratios Analyses The following are Cohen Companys comparative financial statements for 2020, 2019, and 2018: Additional information: Credit sales were 65% of net sales in 2019 and 60% in 2020. At the beginning of 2020, 400 shares of common stock were issued, the first sale of stock in several years. Cohen is concerned. Although it increased the dividends paid per share by 5% in 2020 and its 2020 net income is higher than 2019 net income, the market price of its common stock dropped from 22 per share at the beginning of 2020 to 21 per share at year-end. Required: 1. For 2019 and 2020, prepare rate of change analyses for the income statements and balance sheets of Cohen using a year-to-year approach. 2. For 2019 and 2020, compute the following ratios; (a) current, (b) inventory turnover, (c) receivables turnover, (d) net profit margin, (e) earnings per share, (f) return on total assets, (g) return on shareholders equity, and (h) debt-to-assets. 3. Next Level Based on your results, discuss the possible reasons for the decrease in the market price per share in 2020.
Estimating Share Value Using the DCF ModelFollowing 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 Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $103,875 $111,146 $118,927 $127,251 $136,159 $138,882 NOPAT 11,590 12,448 13,320 14,252 15,250 15,555 NOA 24,524 26,239 28,075 30,040 32,144 32,786 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 $26,327 million. Requireda. 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…
Estimating Share Value Using the DCF ModelFollowing are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 30, 2016 Reported Horizon Period Terminal $ millions 2016 2017 2018 2019 2020 Period Sales $74,673 $76,166 $77,689 $79,243 $80,828 $81,636 NOPAT 3,360 3,427 3,496 3,566 3,637 3,674 NOA 22,402 22,850 23,307 23,773 24,248 24,491 Answer the following requirements assuming a terminal period growth rate of 1%, a discount rate (WACC) of 6%, common shares outstanding of 602 million, and net nonoperating obligations (NNO) of $8,488 million.Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of January 30, 2016. Instructions: Round all answers to the nearest whole number, except for discount factors and stock price per share. Round discount factors to 5 decimal places. Round stock price per share to two decimal places. Do not use negative signs…
Estimating Share Value Using the ROPI ModelFollowing are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018. Reported Horizon Period $ millions 2018 2019 2020 2021 2022 Terminal Period Sales $14,768 $15,654 $16,593 $17,589 $18,644 $19,017 NOPAT 2,711 2,880 3,053 3,236 3,430 3,499 NOA 9,462 10,028 10,630 11,268 11,944 12,183 Answer the following requirements assuming a discount rate (WACC) of 7.35%, a terminal period growth rate of 2%, common shares outstanding of 328.1 million, and net nonoperating obligations (NNO) of $6,204 million.(a) Estimate the value of a share of ITW’s common stock using the residual operating income model (ROPI) model as of December 31, 2018. Instructions: Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not round), and stock price per share. Round discount factors to 5 decimal places. Round stock…
Estimating Share Value Using the ROPI ModelFollowing are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018. Reported Horizon Period $ millions 2018 2019 2020 2021 2022 Terminal Period Sales $14,768 $15,654 $16,593 $17,589 $18,644 $19,017 NOPAT 2,711 2,880 3,053 3,236 3,430 3,499 NOA 9,462 10,028 10,630 11,268 11,944 12,183 Answer the following requirements assuming a discount rate (WACC) of 7.35%, a terminal period growth rate of 2%, common shares outstanding of 328.1 million, and net nonoperating obligations (NNO) of $6,204 million.(a) Estimate the value of a share of ITW’s common stock using the residual operating income model (ROPI) model as of December 31, 2018. Instructions: Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not round), and stock price per share. Round discount factors to 5 decimal places. Round stock…
Estimating Share Value Using the DCF ModelFollowing are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. Forecast Horizon Period Colgate Palmolive (CL) Reported $ millions 2018 2019 2020 2021 2022 Sales $14,456 $14,889 $15,337 $15,796 $16,270 NOPAT 2,545 2,621 2,699 2,780 2,863 NOA 5,428 5,591 5,759 5,932 6,110 Requireda. Forecast the terminal period values assuming a 1% terminal period growth for all three model inputs, that is Sales, NOPAT, and NOA.Note: Round your answers to the nearest whole dollar.Sales $AnswerNOPAT $AnswerNOA $Answerb. Estimate the value of a share of Colgate-Palmolive common stock using the discounted cash flow (DCF) model; assume a discount rate (WACC) of 5.7%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,245 million, and noncontrolling interest (NCI) from the balance sheet of $278 million.Stock price per share: $Answerc. Colgate-Palmolive’s stock closed…