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, 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
Get step-by-step solutions from verified subject matter experts
