Question: P 1 3 - 2 1 . Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate - Palmolive

P13-21. Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive for 2019 through 2022.Colgate Palmolive \$ millionsReported 2018 Required a. Forecast the terminal period values assuming a \(1\%\) terminal period growth for all three model inputs: Sales, NOPAT, and NOA. 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. 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? What do you believe are some reasons for the difference? 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? \( e \). What would WACC have to be to warrant the actual stock price on February 21,2019, given a terminal growth rate of \(2\%\)? f. Perform a sensitivity analysis of the estimated stock price (see Exhibit 13.4). Estimate the company's stock price by varying the terminal growth rate from \(1\%\) to \(3\%\) in 50 basis point increments, and the WACC from \(4.7\%\) to \(6.7\%\) in 50 basis point increments. This will yield 25 stock prices.
P 1 3 - 2 1 . Estimating Share Value Using the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!