find the correct answers for part B and D. Everything with a green check is already correct, use that to your advantage instead of trying to reinvent the wheel and solve what has already been solved (like the last guy that wasted one of my monthly questions). PLEASE SET UP ANSWERS IN A TABLE SO THEY ARE EASY TO DISTINGUISH!! Thank you.

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 groweh rate. c. Colgate-Palmolive's stock closed at $66.70 on February 21,2019 , the date the Form 10K was filed with the SEC. How does your valuation estimate compare with this closing price? d. The forecasts you completed assumed a terminal growh 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