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 2019 2020 2021 2022 $15,562 $16,028 $16,509 $17,003 $17,513 $ 2,755 2,836 2,920 3,007 3,097 Period NOA 5,855 6,030 6,211 6,396 6,588 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) 5.70% 880.9 million Common shares outstanding Net nonoperating obligations (NNO) $5,658 million Noncontrolling interest (NCI) $317 million Reported 2018 2019 Forecast Horizon 2020 Terminal 2021 2022 Period ROPI (NOPAT- [NOABeg xrw]) $ $ $ $ $ ($ millions) 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 5 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 2019 2020 2021 2022 $15,562 $16,028 $16,509 $17,003 $17,513 $ 2,755 2,836 2,920 3,007 3,097 Period NOA 5,855 6,030 6,211 6,396 6,588 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) 5.70% 880.9 million Common shares outstanding Net nonoperating obligations (NNO) $5,658 million Noncontrolling interest (NCI) $317 million Reported 2018 2019 Forecast Horizon 2020 Terminal 2021 2022 Period ROPI (NOPAT- [NOABeg xrw]) $ $ $ $ $ ($ millions) 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 5 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
-
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) 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...
-
1.The purpose of using a balanced scorecard is for: Multiple Choice A.companies to make sure their business activities align with strategy. B.companies to compare themselves with their competitors....
-
What is physiologically unique about Methanopyrus compared with another methanogen such as Methanobacterium? What is physiologically unique about Archaeoglobus?
-
The Brandt Company presents the following December 31, 2007 balance sheet: The following information is also available: 1. Current assets include cash $3,800, accounts receivable $18,500, notes...
-
What is the formula for calculating the accounts receivable turnover ratio?
-
Whitewater Adventures manufactures two models of kayaks, Basic and Deluxe, using a combination of machining and hand finishing. Machine setup costs are driven by the number of setups. Indirect...
-
Q2 Interfaces16 PointsGrading comment: For each of the following, tell if the code will compile. If so, no explanation is needed. If not, explain why. Syntax errors, if any, are inadvertent and...
-
Prove that in (, F, P), VA, B = F we have: and - (i) |P(ANB) P(A)P(B)| 1 (ii) P(A) P(B)| P(A^B) . -
-
You have $ 1 0 0 , 0 0 0 to invest in either Stock D , Stock F , or a risk - free asset. You must invest all of your money. Your goal is to create a portfolio that has an expected return of 1 1 . 8...
-
in paragraph 4, page 424. The situation mirrors the way we were once fitter-or, at least, leaner-when everyday life required more physical effort, in everything from shovelling coal into the furnace...
-
An insulated beaker with negligible mass contains liquid water with a mass of 0.245 kg and a temperature of 75.9 C. Part A How much ice at a temperature of -10.7C must be dropped into the water so...
-
Jonathan Talbert is a high net worth Canadian with an average tax rate of 35% and marginal tax rate of 40%. He contributes $6,000 into his RRSP, then purchases that much worth of LSVCCs whose...
-
Find an analytic function. whose. Ycosy). part is forsing - Yo
-
Give a reason for each answer chosen to get a point. 1. In January 2019, SS Fund Pte. Ltd Singapore entered into agreement with PT AS to provide long term loan for USD 50.000.000. The Loan bear...
-
1. Following are information about Alhadaf Co. Cost incurred Inventory Purchases Sales Adverting expense Salary Expense Depreciation Beginning Inventory Ending Inventory Amount 118,000 350.000 90,000...
-
Determine the maturity date and compute the interest for each of the following notes: a. b. C. d. e. Date of Note August 5.. May 10... October 20. July 6 September 15. Principal Interest Rate (%)...
-
Compute the interest accrued on each of the following notes receivable held by Southland, Inc., on December 31: Round your answer to the nearest dollar. Maker Date of Note Principal Interest Rate (%)...
-
Jamie's Fabrics accepts cash, personal checks, and two credit cards when customers buy merchandise. With the Great American Bank Card, Jamie's Fabrics receives an immediate deposit in its checking...
Study smarter with the SolutionInn App