Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. Colgate Palmolive (CL) Reported $ millions Sales NOPAT NOA Forecast Horizon Period 2018 2019 2020 2021 2022 $15,544 $16,010 $16,491 $16,985 $17,495 2,737 2,818 2,902 2,989 3,079 5,837 6,012 6,193 6,378 6,570 Required a. 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 $ 17,670 NOPAT $ 3,110 NOA $ 6,636 b. 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,640 million, and noncontrolling interest (NCI) from the balance sheet of $299 million. Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56). Stock price per share: $ 0 c. Colgate-Palmolive's stock closed at $66.70 on February 21, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? d. The forecasts you completed assumed a terminal growth rate of 1%. What if the terminal rate had been 2%. What would your estimated stock price have been? Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56). Stock price per share: $ 0 e. What would WACC have to be to warrant the actual stock price on February 21, 2019? Note: Round percentage to two decimal places (for example, round 15.555% to 15.56%). WACC 0 % Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. Colgate Palmolive (CL) Reported $ millions Sales NOPAT NOA Forecast Horizon Period 2018 2019 2020 2021 2022 $15,544 $16,010 $16,491 $16,985 $17,495 2,737 2,818 2,902 2,989 3,079 5,837 6,012 6,193 6,378 6,570 Required a. 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 $ 17,670 NOPAT $ 3,110 NOA $ 6,636 b. 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,640 million, and noncontrolling interest (NCI) from the balance sheet of $299 million. Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56). Stock price per share: $ 0 c. Colgate-Palmolive's stock closed at $66.70 on February 21, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? d. The forecasts you completed assumed a terminal growth rate of 1%. What if the terminal rate had been 2%. What would your estimated stock price have been? Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56). Stock price per share: $ 0 e. What would WACC have to be to warrant the actual stock price on February 21, 2019? Note: Round percentage to two decimal places (for example, round 15.555% to 15.56%). WACC 0 %
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 accounting questions
-
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH's...
-
For 7a-c, use u1= 4. Round your answers to the nearest thousandth. a. For a geometric series with r = 0.7, find S10 and S40. b. For r = 1.3, find S10 and S40. c. For r = 1, find S10 and S40. d. Graph...
-
* Round all answers to the nearest whole dollar What amount of Service Revenue was recognized on January 1, 2019? Determine the amount of (1) payment of P&I On January 1, 2019, Pitchfork, Inc....
-
The enzyme Stell participates in several distinct MAP kinase signaling pathways in the budding yeast S. cerevisiae. What is the substrate for Ste 11 in the mating factor signaling pathway? When a...
-
Describe five factors that managers often consider when determining the significance of a variance.
-
Which of the following describes crevice corrosion? (A) Corrosion that occurs preferentially along grain boundaries (B) Corrosion that results from the combined action of an applied tensile stress...
-
Present a critical appraisal of the argument that only one international standardsetting institution is needed to establish financial reporting standards relating to environmental issues.
-
Compare the Acceleration and Containment strategies for supporting user computing, and provide a rationale for why a firm might choose one or the other.
-
calculate the most current days of working capital (DWC) for Samsung and How does this company's ratio compare to those of its competitors?
-
You have been asked by management to explain the variances in costs under your inpatient capitates contract. The following data is provided. Requirements: 1: What dollar amount of the total variance...
-
What are the nuanced implications of disruptive innovation on traditional business models, and how can firms proactively adapt their strategic management approaches to foster sustained competitive...
-
Describe and apply the components of the reviewing stage, including a FAIR test, proofreading, and feedback.
-
Robert W. Selander, former president and CEO of MasterCard, was asked, What are the most important leadership lessons you have learned? He responded by describing some of his international...
-
Use the story line approach to presentations.
-
Describe characteristics of cultural intelligence, its importance for global business leaders, and approaches to developing it.
-
A. Describe each of the three components in the AIM planning process for business messages: audience analysis, idea development, and message structuring. B. Explain the general nature of excellence...
-
Wearable technology seems to be increasing over the last few decades. With the advent of the 2020 COVID-19 pandemic on business, wearable technology increased. You may have some, such as Apple's...
-
A company produces earbuds. The revenue from the sale of x units of these earbuds is R = 8x. The cost to produce x units of earbuds is C = 3x + 1500. In what interval will the company at least break...
-
Assume American Airlines acquires a regional airline in the mid western United States for $450 million. American Airlines allocates $150 million of the purchase price to landing rights at various...
-
Exhibit 8.21 presents selected financial statement data for three chemical companies: Monsanto Company, Olin Corporation, and NewMarket Corporation. (NewMarket was formed from a merger of Ethyl...
-
Choosing the functional currency is a key decision for translating the financial statements of foreign entities of U.S. firms into U.S. dollars. Qing Corporation, a U.S. firm that sells car...
-
Under atmospheric conditions the acetone-chloroform azeotrope boils at \(64.6^{\circ} \mathrm{C}\) and contains 33.5 mole per cent acetone. The vapour pressures of acetone and chloroform at this...
-
A system was prepared by partially decomposing \(\mathrm{CaCO}_{3}\) into an evacuated space. What is the number of degrees of freedom \((f)\) for the system?
-
Prove that chemical potentials of two phases in equilibrium are equal.
Study smarter with the SolutionInn App