Question: Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. Forecast Horizon Period Colgate

 Estimating Share Value Using the DCF Model Following are forecasted sales,

Estimating Share Value Using the DCF 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 2020 2021 2021 2022 Sales 514,456 514,889 515337 SI5,795 $15270 | HAT 2.505 2621 2.669 2,780 26 5.591 5.9326110 NOW Required a. Forecast the terminal periad values assuming a 1% terminal period grawth for all three model inputs, that is Sales, NOPAT, and NOA Note: Round your answers to the nearest whole dollar. Sales 0 * NOPAT D NOA$ 0 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.74, common shares outstanding of 862.9 million, nec nonoperating obligations (NNO) of $5.245 million, and noncontralling interest INCI) from the balance sheet of $278 million. Stock price per share: O X C. Colgate-Palmolive's stock closed at 562 03 on February 21, 2019, the date the Form 10-K vos filed with the SEC. How does your valuation estimate compare with this closing price? Stock price is overvalued + d. The forecasts you completed assumed a terminal growth rate of 154. What if the terminal rate had been 29. What would your estimated stock price have been? Stock price per share: 0 x e. What would WACC have to be to warrant the actual stock price on February 21, 2019? WACC 0 Estimating Share Value Using the DCF 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 2020 2021 2021 2022 Sales 514,456 514,889 515337 SI5,795 $15270 | HAT 2.505 2621 2.669 2,780 26 5.591 5.9326110 NOW Required a. Forecast the terminal periad values assuming a 1% terminal period grawth for all three model inputs, that is Sales, NOPAT, and NOA Note: Round your answers to the nearest whole dollar. Sales 0 * NOPAT D NOA$ 0 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.74, common shares outstanding of 862.9 million, nec nonoperating obligations (NNO) of $5.245 million, and noncontralling interest INCI) from the balance sheet of $278 million. Stock price per share: O X C. Colgate-Palmolive's stock closed at 562 03 on February 21, 2019, the date the Form 10-K vos filed with the SEC. How does your valuation estimate compare with this closing price? Stock price is overvalued + d. The forecasts you completed assumed a terminal growth rate of 154. What if the terminal rate had been 29. What would your estimated stock price have been? Stock price per share: 0 x e. What would WACC have to be to warrant the actual stock price on February 21, 2019? WACC 0

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!