Estimating Share Value Using the ROPI Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive...
Fantastic news! We've Found the answer you've been seeking!
Question:
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. 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 Terminal period growth rate 1% Reported Forecast Horizon Period Terminal millions 2018 Sales NOPAT NOA 2019 2020 2021 2022 $15,544 $16,010 $16,491 $16,985 $17,495 $ 2,737 2,818 2,902 2,989 3,079 5,837 6,012 6,193 6,378 6,570 Period 17,670 3,110 6,636 b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income (ROPI) model using the following assumptions and the information above. Assumptions Discount rate (WACC) Common shares outstanding 5.70% 862.9 million Net nonoperating obligations (NNO) $5,640 million Noncontrolling interest (NCI) $299 million Reported ($ millions) 2018 2019 Forecast Horizon 2020 2021 2022 Terminal Period ROPI (NOPAT - [NOABeg x rw]) $ $ $ $ Present value of horizon ROPI Cum present value of horizon ROPI $ Present value of terminal ROPI NOA Total firm value Less (plus) NNO Less NCI Firm equity value $ Shares outstanding (millions) $ Stock price per share c. Colgate-Palmolive's 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? 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? Value e. What would WACC have to be to warrant the actual stock price on February 21, 2019? WACC % Estimating Share Value Using the ROPI 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 Terminal period growth rate 1% Reported Forecast Horizon Period Terminal millions 2018 Sales NOPAT NOA 2019 2020 2021 2022 $15,544 $16,010 $16,491 $16,985 $17,495 $ 2,737 2,818 2,902 2,989 3,079 5,837 6,012 6,193 6,378 6,570 Period 17,670 3,110 6,636 b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income (ROPI) model using the following assumptions and the information above. Assumptions Discount rate (WACC) Common shares outstanding 5.70% 862.9 million Net nonoperating obligations (NNO) $5,640 million Noncontrolling interest (NCI) $299 million Reported ($ millions) 2018 2019 Forecast Horizon 2020 2021 2022 Terminal Period ROPI (NOPAT - [NOABeg x rw]) $ $ $ $ Present value of horizon ROPI Cum present value of horizon ROPI $ Present value of terminal ROPI NOA Total firm value Less (plus) NNO Less NCI Firm equity value $ Shares outstanding (millions) $ Stock price per share c. Colgate-Palmolive's 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? 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? Value e. What would WACC have to be to warrant the actual stock price on February 21, 2019? WACC %
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
(2) Raw materials inventory DEBIT: 24,000 Accounts payable CREDIT: 24,000 Match the letter that best describes with this transaction Descriptions: (a) To record sale of products (b) To record jobs...
-
In this problem you will be given a dataset containing customers, promotions given to them, and their transactions. Your task will be to predict which customers will respond to the given promotions....
-
2. LIMIT COMPARISON TEST: SPECIAL CASES The Limit Comparison Test is most often used when the limit L= lim ak lies in the interval (0, oo). In the case where L is zero or infinity, we can still...
-
How does a methanotroph differ from a methanogen? Which pathway for C1 assimilation found in methanotrophs is most energetically efficient and why?
-
The manager of the Taylor Company has consulted you, the controller, as to which of the following plans you would recommend in acquiring the use of a piece of heavy equipment: 1. Purchase the...
-
What accounts are affected, and how, when rent received in advance is initially recorded as a revenue?
-
Consider the following data for three different companies: The patterns of cash flows for these firms differ. One firm is a growth firm that is expanding rapidly, another firm is in danger of...
-
Total Costs + Direct Material Conversion Beginning inventory $ 7,560 $ 24,825 + Costs Added in March $ 25,400 $ 58,562
-
Write formally correct defect incorporation reactions and the corresponding mass action equilibrium constants for the following. Refer to the table of ionic radii (Table 1.2) for guidance. If you...
-
{U** W This bar is 0.2 meters long and moving 22.1 m/s through a magnetic field of 58 mT. What is the induced electromotive force in the bar? Round to two decimal places. EMF = unit If the resistor...
-
If an edge detector is as follows: Convolve image f(x)with go Convolve f(x)with go to form h(x). h(x)-h(x) Compute h(x) = 0-01 Find zero-crossings of h3 (x). e 1|X to form h (x). a. Describe how...
-
Define Secondary Traumatic Stress, Compassion Fatigue aka burnout, and self - care. Then explain how YOU personally can be affected and what steps would you do for selfcare? Question: Define Trauma...
-
What types of federal taxes can be managed through the Electronic Federal Tax Payment System (EFTPS)? Explain briefly
-
Nena ( an 8 0 ' s pop band from Germany ) sang a song about 9 9 balloons ( they were "luftballoons" in German, but in English, they were "red balloons" ) . If the sound level of a single balloon...
-
Compensation Report for the Year 2020 1. HR Manager Salary: 60,000 2. Bonus: 4% of annual salary 3. Paid Time Off: 20 days per year 4. Public Holidays recognized: 11 days 5. Benefits: 1. Health...
-
Listed below are several terms and phrases associated with basic assumptions, broad accounting principles, and constraints. Pair each item from List A (by letter) with the item from List B that is...
-
Kelly Petroleum Company has a large oil and natural gas project in Oklahoma. The project has been organized into two production centers (petroleum production and natural gas production ) and one...
-
Describe how the use of return on investment as a measure of managerial performance can result in a lack of goal congruence.
-
Return on investment is sometimes used to evaluate opportunities for capital investment. Why are discounted cash flow methods (net present value, internal rate of return) preferable for this purpose?
Study smarter with the SolutionInn App