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 Sales 2019 2020 2021 2022 $14,922 $15,370 $15,831 $16,306 $16,795 2,628 2,705 2,786 2,869 2,956 5,604 5,772 5,945 6,123 6,307 NOPAT NOA Support Dashboard Aditya a. Forecast the terminal period values assuming a 1% terminal period growth for all three model inputs, that is Sales, NOPAT, and NDA Note: Round your answers to the nearest whole dollar. Sales S NOPAT S NOAS 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,414 million, and noncontrolling interest (NCD) from the balance sheet of $287 million, Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56) Stock price per share: s c. Colgate-Palmolive's stock closed at $64,03 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? Stock price is overvalued d. The forecasts you completed assumed a terminal growth rate of 16. 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: $ 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 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 Sales 2019 2020 2021 2022 $14,922 $15,370 $15,831 $16,306 $16,795 2,628 2,705 2,786 2,869 2,956 5,604 5,772 5,945 6,123 6,307 NOPAT NOA Support Dashboard Aditya a. Forecast the terminal period values assuming a 1% terminal period growth for all three model inputs, that is Sales, NOPAT, and NDA Note: Round your answers to the nearest whole dollar. Sales S NOPAT S NOAS 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,414 million, and noncontrolling interest (NCD) from the balance sheet of $287 million, Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56) Stock price per share: s c. Colgate-Palmolive's stock closed at $64,03 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? Stock price is overvalued d. The forecasts you completed assumed a terminal growth rate of 16. 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: $ 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