Estimating Share Value Using the DCF Model 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. Module Reported Forecast Horizon Period Terminal $ millions 2018 2019 2020 2021 2022 Period $108,203 $115,777 $123,882 $132,553 $141,832 $144,669 12,073 12,967 13,875 14,846 15,885 16,203 25,546 27,332 29,245 31,292 33,483 34,152 Sales NOPAT NOA 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 $27,424 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: $ 519 x b. Home Depot stock closed at $190.06 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? Stock price is appropriately valued +

Estimating Share Value Using the DCF Model 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. Module Reported Forecast Horizon Period Terminal $ millions 2018 2019 2020 2021 2022 Period $108,203 $115,777 $123,882 $132,553 $141,832 $144,669 12,073 12,967 13,875 14,846 15,885 16,203 25,546 27,332 29,245 31,292 33,483 34,152 Sales NOPAT NOA 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 $27,424 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: $ 519 x b. Home Depot stock closed at $190.06 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? Stock price is appropriately valued +

Name: Estimating Share Value Using the DCF ModelFollowing are forecasts of
Uploaded: 2024-03-20T06:33:21.000Z
Channel: Bartleby
Description: 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.ModuleForecast Horizon Perio

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: What is the return on sales for fiscal year 2019 2018?

A: Return on sales=Operating ProfitNet Sales×100

Q: Estimating Share Value Using the DCF Model Following are forecasts of Home Depot's sales, net…

A: Discounted cash flow is a method to find out the real present value of the investment by discounting…

Q: Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales,…

A: Answer information:Step 1:Firm value:Firm value is the determination of the actual value of the firm…

Q: a. Use the financial statements along with the additional information below to forecast property,…

A: Step 1 As per US GAAP , all the property , plants and equipment's should be present in the books of…

Q: Estimating Share Value Using the DCF Model Following are forecasts of Home Depot’s sales, net…

A: Value per share refers to the ratio computed by dividing the common shareholders by the number of…

Q: Forecasting an Income Statement ADP reports the following income statement. AUTOMATIC DATA…

A: Income statement is part of financial statements. It includes revenue and expenses of a period.…

Q: Compute the Sales Growth Index and select the best Answer: 12/31/2020…

A: Sales growth index = Net sales year 2 / Net sales year 1

Q: Current Assets Cash and cash equivalents Receivables, net Inventories, net Assets held for sale…

A: Ratio Analysis -The ratio is the technique used by the prospective investor or an individual or…

Q: Estimating Share Value Using the ROPI Model Following are forecasts of Home Depot's sales, net…

A: Given: Discount rate (WACC) "r" = 7.85% Terminal period growth rate = 2% Common shares outstanding =…

Q: Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for…

A: DCF stands for Discounted Cash Flow, which is a financial valuation method used to estimate the…

Q: Assume General Motors announced a quarterly profit of $119 million for 4th quarter 2022. Below is a…

A: Total assets is always equal to the sum of total liabilities and stockholders' equity. The…

Q: Creek Enterprises Income Statement for the Year Ended December 31, 2022 Sales revenue Less: Cost of…

A: Income Statement: It is a part of financial statement of a company in which revenue and expenses are…

Q: The following amounts were taken from the financial statements of Crane Company: Total assets 2020…

A: Profit Margin - Net Profit Margin Is The Percentage Of Total Sales After Deducting All Expenses From…

Q: Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales,…

A: A horizontal forecasted report is prepared for the purpose of analyzing the current performance and…

Q: 不 Net sales, net income, and total assets for Alex Shipping, Inc., for a five-year period follow:…

A: Approach to solving the question: Detailed explanation: Summary of Calculations:2019 Net Sales:…

Q: Preparation of Common Size Statements for Vertical Analysis Financial statements for Steele Inc.…

A: Introduction: An income statement with a common size is one in which each line item is stated as a…

Q: Estimating Share Value Using the DCF Model Assume following are forecasts of Abercrombie & Fitch's…

A: Data given: Discount rate (WACC) = 13.3%, Terminal period growth rate = 1% Common shares outstanding…

Q: Required: (a) Based on the provided financial statements, calculate IBEX Company's RNOA ratio for…

A: The Return on Net Operating Assets (RNOA) ratio is a financial metric used to assess a company's…

Q: INCOME STATEMENT, 2022 Sales Cost Net income BALANCE SHEET, YEAR-END Assets $ 7,500 Total 5,900 $…

Q: Estimating Share Value Using the ROPI Model Following are forecasts of Whole Foods sales, net…

A: WACC of 6%NNO of $242 millionTo Find:Value of a share

Q: Price earning ratio: market price per common share/ earning per share $3,388/$42.64= 79.46 (Amazon…

A: The Price Earnings ratio of the company in valuation that is Amazon has been increased in the…

Q: Below is Company A's balance sheet at the end of 2022. What is the Earnings before taxes (EBT) of…

A: Income statement is one of the three important financial statements that a company prepares. The…

Q: Estimating Share Value Using the ROPI Model Following are forecasts of Illinois Tool Works Inc.…

A: WACC of 7.35% NNO of $6,204 million To Find: Value of a share

Q: Vertical Analysis Two income statements for Cornea Company Follow: Cornea Company Imcome…

A: The vertical analysis analyse the financial statements as the percentage of sales in vertical form.

Q: Selected comparative financial statements of Korbin Company follow. Sales Cost of goods sold Gross…

A: Income statement is the financial statement which is prepared by the entity for reporting and…

Q: d) Calculate the P/E and P/BV multiples for both years. ANSWER 2020 2021 P/E P/BV

A: Data given: Description 2020 2021 Total Assets ($) 2705890 3008228 Total Liabilities ($)…

Q: Estimating Share Value Using the DCF Model Following are forecasts of Home Depot's sales, net…

A: Discounted cash flow is a method to find out the real present value of the investment by discounting…

Q: Compute the five debt management ratios for 2022 and 2023.

A: To compute the five debt management ratios for Steele Inc., we need to use the following formulas:…

Concept explainers

Financial Ratios

A Ratio refers to a figure calculated as a reference to the relationship of two or more numbers and can be expressed as a fraction, proportion, percentage, or the number of times. When the number is determined by taking two accounting numbers derived from the financial statements, it is termed as the accounting ratio.

Return on Equity

The Return on Equity (RoE) is a measure of the profitability of a business concerning the funds by its stockholders/shareholders. ROE is a metric used generally to determine how well the company utilizes its funds provided by the equity shareholders.

Topic Video

Question

Estimating Share Value Using the DCF Model
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.
Module
Forecast Horizon Period
Reported
Terminal
$ millions 2018
2019
2020
2021
2022 Period
Sales
$108,203 $115,777 $123,882 $132,553 $141,832 $144,669
12,073 12,967 13,875 14,846 15,885 16,203
25,546 27,332 29,245 31,292 33,483 34,152
NOPAT
NOA
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 $27,424
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: $ 519
b. Home Depot stock closed at $190.06 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?
Stock price is appropriately valued ✰

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction to Value per share

VIEW

Step 2: Calculation of Value per Share

VIEW

Step 3: Comparison of Valuation estimation

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Please detailed
Forecast an Income StatementSeagate Technology reports the following income statement for fiscal 2019. SEGATE TECHNOLOGY PLC Consolidated Statement of Income For Year Ended June 28, 2019, $ millions Revenue $20,780 Cost of revenue 14,916 Product development 1982 Marketing and administrative 906 Amortization of intangibles 46 Restructuring and other, net (44) Total operating expenses 17,806 Income from operations 2,974 Interest income 168 Interest expense (448) Other, net 50 Other expense, net (230) Income before income taxes 2,744 (Benefit) provision for income taxes (1,280) Net income $4,024 Forecast Seagate’s 2020 income statement assuming the following income statement relations ($ millions). Revenue growth 5% Cost of revenue 71.8% of revenue Product development 9.5% of revenue Marketing and administrative 4.4% of revenue Amortization of intangibles No change Restructuring and other, net $0 Interest income No change…
Obtain Target Corporation's annual report for its 2018 fiscal year (year ended February 2, 2019) at http://investors.target.com a. What was Target's gross margin percentage for the fiscal year ended February 2, 2019 (2018) and 2017? Use "Sales" for these computations b. What was Target's Return on Sales percentage for 2018 and 2017? Use "Total Revenue" for these computations. c. Target's return on ales percentage for 2017 was higher than it was in 2018. Ignoring taxes, how much higher would Target's 2018 net income have been if it's return on sales percentage in 2018 had been the same as for 2017?
Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. a. Forecast the terminal period values assuming the following terminal period growth rate. Assumption Terminal period growth rate 1% Reported Forecast Horizon Period Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $15,544 $16,010 $16,491 $16,985 $17,495 Answer NOPAT 2,737 2,818 2,902 2,989 3,079 Answer NOA 5,837 6,012 6,193 6,378 6,570 Answer b. Estimate the value of a share of Colgate-Palmolive common stock using the discounted cash flow (DCF) model using the following assumptions and the information above. Assumptions Discount rate (WACC) 5.70% Common shares outstanding 863.0 million Net…
Estimating Share Value Using the DCF ModelAssume following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,750 $ 4,500 $ 5,400 $ 6,480 $ 7,776 $ 7,853 NOPAT 464 539 654 794 982 960 NOA 1,320 1,602 1,933 2,332 2,791 2,802 Answer the following requirements assuming a discount rate (WACC) of 13.3%, a terminal period growth rate of 1%, common shares outstanding of 86.2 million, and net nonoperating obligations (NNO) of $(261) million (negative NNO reflects net nonoperating assets such as investments rather than net obligations).(a) Estimate the value of a share of Abercrombie & Fitch common stock using the discounted cash flow (DCF) model as of January 29, 2011. Rounding instructions: Round answers to the nearest whole number unless noted otherwise. Use your rounded answers for…
Estimating Share Value Using the ROPI Model Following 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 $13,990 $14,409 $14,842 $15,287 $15,746 NOPAT 2,463 2,536 2,612 2,690 2,771 NOA 5,253 5,411 5,574 5,740 5,913 a. Forecast the terminal period values for Sales, NOPAT, and NOA, assuming a 1% terminal period growth rate. Note: Round answers to the nearest dollar. Terminal period sales 2$ 15,903 Terminal period NOPAT $ 2,799 Terminal period NOA 2$ 5,972 b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income (ROPI) model. Assume a discount rate (WACC) of 5.70%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,076 million, and noncontrolling interest (NCI) from the balance sheet of $269 million. Note: Round answers to two decimal places. $ 0 c. Colgate-Palmolive stock…
Refine Assumptions for PPE ForecastFollowing are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income (loss) before income taxes 5,197 Income tax provision 547 Net income (loss) 4,650 Net (income) loss attributable to noncontrolling interests (19) Net income (loss) attributable to Medtronic $ 4,631 Consolidated Balance Sheet ($ millions) April 26, 2019 Current assets Cash and cash equivalents $ 4,393 Investments 5,455 Accounts receivable, less…
Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are income statements and balance sheets for Cisco Systems. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Cisco Systems Consolidated Statements of Income Years Ended December ($ millions) July 27, 2019 July 28, 2018 Revenue Product $33,544 $31,570 Service 11,093 10,854 Total revenue 44,637 42,424 Cost of sales Product 12,782 12,407 Service 3,763 3,695 Total cost of sales 16,545 16,102 Gross margin 28,092 26,322 Operating expenses Research and development 5,656 5,446 Sales and marketing 8,231 7,948 General and administrative 1,571 1,844 Amortization of purchased intangible assets 129 190 Restructuring and other charges 277 308 Total operating expenses 15,864 15,736 Operating income 12,228 10,586 Interest income 1,125 1,297 Interest expense (739) (811) Other…
Use the Ulta annual report to calculate profit margin, total debt ratio, and cash ratio for the year ending in 2021.
Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Reported Forecast Horizon Period Terminal $ millions Sales NOPAT NOA 2021 2022 2020 2018 2019 $57,472 $58,326 $59,192 $60,072 $60,964 3,179 3,218 3,140 3,052 3,102 4,844 4,657 4,718 4,781 4,592 Period $61,568 3,244 4,887 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 1% Discount rate (WACC) 7.8% Common shares outstanding 135.60 million Net nonoperating obligations (NNO) $(5,569) million Noncontrolling interest $0 million NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities. (a) Estimate the value of a share of Humana's common stock using the…
Current Attempt in Progress Operating data for Grouper Corp. are presented as follows. Net sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2022 $840,000 540,120 133,560 57,120 31,920 77,280 2021 $610,000 405,650 80,520 46,970 26,840 50,020 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)
Calculate the Return on Shareholder equity % ratio for Urban Outfitters for both 2018 and 2019. Be sure to report in percentages & round your answer to 2 decimal place.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS