Estimating Share Value Using the DCF Model

Following are forecasted sales, NOPAT, and NOA for Colgate$-$Palmolive Company for $2019$ through $2022.$

Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places.

a$.$ Forecast the terminal period values assuming the following terminal period growth rate.

Assumption

b$.$ Estimate the value of a share of Colgate$-$Palmolive common stock using the discounted cash flow $($DCF$)$ model using the following assumptions and the information above.

c$.$ Colgate$-$Palmolive's stock closed at $$66\mathrm{.}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?

e$.$ What would WACC have to be to warrant the actual stock price on February $21,2019?$