Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 2019 2020 2021 2022 Sales $14,300 $14,729 $15,172 $15,626 $16,095 NOPAT 2,518 2,593 2,670 2,750 2,833 NOA 5,370 5,531 5,698 5,868 6,044 Required a. Forecast the terminal period values assuming a 1% terminal period growth for all three model inputs, that is Sales, NOPAT, and NOA. Note: Round your answers to the nearest whole dollar. Sales $ 0 X NOPAT $ 0 x 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.7%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,189 million, and noncontrolling interest (NCI) from the balance sheet of $275 million. Stock price per share: $ 0 C. Colgate-Palmolive's stock closed at $61.36 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 1%. What if the terminal rate had been 2%. 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 X % 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 2019 2020 2021 2022 Sales $14,300 $14,729 $15,172 $15,626 $16,095 NOPAT 2,518 2,593 2,670 2,750 2,833 NOA 5,370 5,531 5,698 5,868 6,044 Required a. Forecast the terminal period values assuming a 1% terminal period growth for all three model inputs, that is Sales, NOPAT, and NOA. Note: Round your answers to the nearest whole dollar. Sales $ 0 X NOPAT $ 0 x 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.7%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,189 million, and noncontrolling interest (NCI) from the balance sheet of $275 million. Stock price per share: $ 0 C. Colgate-Palmolive's stock closed at $61.36 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 1%. What if the terminal rate had been 2%. 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 X %
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started