Estimating Share Value Using the DCF 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 DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. Colgate Palmolive (CL) Reported $ millions Sales NOPAT NOA Forecast Horizon Period 2018 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 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 $ 17,670 NOPAT $ 3,110 NOA $ 6,636 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,640 million, and noncontrolling interest (NCI) from the balance sheet of $299 million. Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56). Stock price per share: $ 0 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? Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56). Stock price per share: $ 0 e. What would WACC have to be to warrant the actual stock price on February 21, 2019? Note: Round percentage to two decimal places (for example, round 15.555% to 15.56%). WACC 0 % Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. Colgate Palmolive (CL) Reported $ millions Sales NOPAT NOA Forecast Horizon Period 2018 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 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 $ 17,670 NOPAT $ 3,110 NOA $ 6,636 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,640 million, and noncontrolling interest (NCI) from the balance sheet of $299 million. Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56). Stock price per share: $ 0 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? Note: Round your final answer to two decimal places (for example, round $15.555 to $15.56). Stock price per share: $ 0 e. What would WACC have to be to warrant the actual stock price on February 21, 2019? Note: Round percentage to two decimal places (for example, round 15.555% to 15.56%). WACC 0 %
Expert Answer:
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH's...
-
For 7a-c, use u1= 4. Round your answers to the nearest thousandth. a. For a geometric series with r = 0.7, find S10 and S40. b. For r = 1.3, find S10 and S40. c. For r = 1, find S10 and S40. d. Graph...
-
* Round all answers to the nearest whole dollar What amount of Service Revenue was recognized on January 1, 2019? Determine the amount of (1) payment of P&I On January 1, 2019, Pitchfork, Inc....
-
The enzyme Stell participates in several distinct MAP kinase signaling pathways in the budding yeast S. cerevisiae. What is the substrate for Ste 11 in the mating factor signaling pathway? When a...
-
Calculate the return on total assets for 2014 and evaluate the result against the industry average in Exhibit 18.11, explaining why it compares favorably or unfavourably (round to two decimal...
-
If the wage goes up 20 percent and the quantity of labor supplied increases by 5 percent, whats the elasticity of labor supply?
-
Plaintiff purchases a new car that has defects in its paint job. Three times the dealership repaints the care, but to no avail. The plaintiff continues to drive the car as he has no other option in...
-
Relative Sales Value Method During 2011, Crawford Furniture Company purchases a carload of wicker chairs. The manufacturer sells the chairs to Crawford for a lump sum of $60,000, because it is...
-
Bryson College is a highly politicized organization (Table 3.7). What changes in the organization of the college would be necessary for Bryson to become a professionalized organization? A...
-
Medical Testing Labs, Inc., provides routine testing services for blood banks in the Los Angeles area. Tests are supervised by skilled technicians using equipment produced by two leading competitors...
-
On September 1, 2017, Hancock Company entered into two forward exchange contracts to purchase 250,000 euros each in 90 days. The relevant exchange rates are as follows: Forward Rate For Dec. 1, 2017...
-
Suppose that consumers' disposable income increased by $341 billion and their spending increased by $299 billion.What was the MPC? Suppose the government increases spending on education by $30...
-
These are the instructions for the homework assignment. 1.Evaluate the reasonableness of a suspicion of fraud2.Create a preliminary fraud hypothesis3.Test and refine the fraud hypothesis through...
-
Find the error for the proposed solution. Then correct the proposed solution. 8x+1.5=3x+0.6 5x=0.9 (5x)/(5)=(0.9)/(5) x=0.18
-
1. Explain in detail the difference between a relational database and a NOSQL Database 2. Describe various data models for NOSQL database. Explain how data model play an important role in your NOSQL...
-
Lilac Corporation is an accrual method taxpayer. Lilac's corporate effective tax rate was 35% in 2023 and 21% in 2024 (due to the change in the law regarding corporate tax rates). A. Lilac...
-
Suppose that you have collected the following information for your firm's stock. Next dividend payment (per share) = $2. o Next meaning paid after one period. Dividends are growing at a rate of 2%...
-
A company produces earbuds. The revenue from the sale of x units of these earbuds is R = 8x. The cost to produce x units of earbuds is C = 3x + 1500. In what interval will the company at least break...
-
Assume American Airlines acquires a regional airline in the mid western United States for $450 million. American Airlines allocates $150 million of the purchase price to landing rights at various...
-
Exhibit 8.21 presents selected financial statement data for three chemical companies: Monsanto Company, Olin Corporation, and NewMarket Corporation. (NewMarket was formed from a merger of Ethyl...
-
Choosing the functional currency is a key decision for translating the financial statements of foreign entities of U.S. firms into U.S. dollars. Qing Corporation, a U.S. firm that sells car...
-
Using Mendels data from the experiment in Figure 2.8, conduct a chi square test to determine if the data agree with Mendels law of independent assortment. Mendels data: THE DATA P cross F1 generation...
-
On rare occasions, an organism may have three copies of a chromosome and therefore three copies of the genes on that chromosome (instead of the usual number of two copies). The alleles for each gene...
-
Explain how the miR-200 family of miRNAs behave as tumorsuppressor genes. What happens when their expression is blocked or decreased?
Study smarter with the SolutionInn App