Homework Help is Here – Start Your Trial Now!
Business
Finance
Estimating Share Value Using the ROPI 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 $15,544 Sales NOPAT NOA 2,737 5,837 Terminal period sales $ Terminal period NOPAT $ Terminal period NOA S 2019 a. Forecast the terminal period values for Sales, NOPAT, and NOA, assuming a 1% terminal period growth rate. Note: Round answers to the nearest dollar. 17,670 ✓ 3,110 ✓ 6,636 ✔ 2020 2021 2022 $16,010 $16,491 $16,985 $17,495 2,818 2,902 2,989 3,079 6,012 6,193 6,378 6,570 b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income (ROPI) model. Assume a discount rate (WACC) of 5.70%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,640 million, and noncontrolling interest (NCI) frombthe balance sheet of $299 million. Note: Round answers to two decimal places. $75.93 c. Colgate-Palmolive stock closed at $66.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? Stock price is overvalued d. The forecasts assumed a terminal growth rate of 1%. If the terminal growth rate had been 2%, what would the estimated stock price have been? Note: Round answers to two decimal places. $ 92.54 x e. What would WACC need to be to warrant the actual stock price on February 21, 2019? Note: Round answer to two decimal places (for example, 0.0674533 = 6.75%). 75.93 * %

Estimating Share Value Using the ROPI 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 $15,544 Sales NOPAT NOA 2,737 5,837 Terminal period sales $ Terminal period NOPAT $ Terminal period NOA S 2019 a. Forecast the terminal period values for Sales, NOPAT, and NOA, assuming a 1% terminal period growth rate. Note: Round answers to the nearest dollar. 17,670 ✓ 3,110 ✓ 6,636 ✔ 2020 2021 2022 $16,010 $16,491 $16,985 $17,495 2,818 2,902 2,989 3,079 6,012 6,193 6,378 6,570 b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income (ROPI) model. Assume a discount rate (WACC) of 5.70%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,640 million, and noncontrolling interest (NCI) frombthe balance sheet of $299 million. Note: Round answers to two decimal places. $75.93 c. Colgate-Palmolive stock closed at $66.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? Stock price is overvalued d. The forecasts assumed a terminal growth rate of 1%. If the terminal growth rate had been 2%, what would the estimated stock price have been? Note: Round answers to two decimal places. $ 92.54 x e. What would WACC need to be to warrant the actual stock price on February 21, 2019? Note: Round answer to two decimal places (for example, 0.0674533 = 6.75%). 75.93 * %

Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
See similar textbooks
icon
Related questions
Topic Video
Question
100%

please answer b, d & e

Estimating Share Value Using the ROPI 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 $15,544 $16,010 $16,491 $16,985 $17,495 NOPAT 2,737 2,818 2,902 2,989 3,079 NOA 5,837 6,012 6,193 6,378 6,570 a. Forecast the terminal period values for Sales, NOPAT, and NOA, assuming a 1% terminal period growth rate. Note: Round answers to the nearest dollar. Terminal period sales 17,670 Terminal period NOPAT $ 3,110 v Terminal period NOA 24 6,636 v b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income (ROPI) model. Assume a discount rate (WACC) of 5.70%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,640 million, and noncontrolling interest (NCI) frombthe balance sheet of $299 million. Note: Round answers to two decimal places. $ 75.93 c. Colgate-Palmolive stock closed at $66.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? Stock price is overvalued d. The forecasts assumed a terminal growth rate of 1%. If the terminal growth rate had been 2%, what would the estimated stock price have been? Note: Round answers to two decimal places. $ 92.54 e. What would WACC need to be to warrant the actual stock price on February 21, 2019? Note: Round answer to two decimal places (for example, 0.0674533 = 6.75%). 75.93
Transcribed Image Text:Estimating Share Value Using the ROPI 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 $15,544 $16,010 $16,491 $16,985 $17,495 NOPAT 2,737 2,818 2,902 2,989 3,079 NOA 5,837 6,012 6,193 6,378 6,570 a. Forecast the terminal period values for Sales, NOPAT, and NOA, assuming a 1% terminal period growth rate. Note: Round answers to the nearest dollar. Terminal period sales 17,670 Terminal period NOPAT $ 3,110 v Terminal period NOA 24 6,636 v b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income (ROPI) model. Assume a discount rate (WACC) of 5.70%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,640 million, and noncontrolling interest (NCI) frombthe balance sheet of $299 million. Note: Round answers to two decimal places. $ 75.93 c. Colgate-Palmolive stock closed at $66.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? Stock price is overvalued d. The forecasts assumed a terminal growth rate of 1%. If the terminal growth rate had been 2%, what would the estimated stock price have been? Note: Round answers to two decimal places. $ 92.54 e. What would WACC need to be to warrant the actual stock price on February 21, 2019? Note: Round answer to two decimal places (for example, 0.0674533 = 6.75%). 75.93
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS