Estimating Share Value Using the DCF 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 2019 2020 2021 2022 Period   Sales $4,663 $4,803 $4,947 $5,096 $5,249 Answer     NOPAT 821 845 871 897 924 Answer     NOA 1,751 1,804 1,858 1,913 1,971 Answer     b. Estimate the value of a share of Colgate-Palmolive common stock using the discounted cash flow (DCF) model using the following assumptions and the information above. Assumptions     Discount rate (WACC) 5.70%   Common shares outstanding 259.0 million Net nonoperating obligations (NNO) $1,692 million Noncontrolling interest (NCI) $90 million       Reported     Forecast Horizon   Terminal   ($ millions) 2018 2019 2020 2021 2022 Period   Increase in NOA   Answer   Answer   Answer   Answer   Answer     FCFF (NOPAT - Increase in NOA)   Answer   Answer   Answer   Answer   Answer     Present value of horizon FCFF   Answer   Answer   Answer   Answer       Cum. present value of horizon FCFF Answer               Present value of terminal FCFF Answer               Total firm value Answer               Less (plus) NNO Answer               Less NCI Answer               Firm equity value Answer               Shares outstanding (millions) Answer               Stock price per share Answer               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? Answer   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   Answer     e. What would WACC have to be to warrant the actual stock price on February 21, 2019?   WACC   Answer

Calculate the Return on Shareholder equity % ratio for Urban Outfitters for both 2018 and 2019. Be sure to report in percentages & round your answer to 2 decimal place.

es Given the information below for Seger Corporation, compute the expected share price at the end of 2022 using price ratio analysis. Assume that the historical (arithmetic) average growth rates will remain the same for 2022. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Year Price 2016 $ 97.60 2017 $ 103.50 2018 $ 102.20 2019 $ 99.70 2020 $ 121.20 2021 $ 136.60 EPS CFPS 2.80 8.22 3.51 4.31 5.01 7.95 8.95 9.00 9.28 11.07 12.37 13.48 SPS 52.60 57.60 57.00 60.50 71.70 79.70 Using PE ratio Using P/CF ratio Using P/S ratio Share Price

For XYZ Corporation, the book value per share at the end of 2021 Is 31.46, ROI is .1, and earnings per share for 2022 (at the end of the year) are 4.57. What is the value of residual earnings per share for 2022? O2.38 1.42 O 3.57 O 1.13

Estimating Share Value Using the DCF Model Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 3, 2019, which the company labels fiscal 2018. Module Forecast Horizon Period Reported Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $108,203 $115,777 $123,882 $132,553 $141,832 $144,669 12,073 12,967 13,875 14,846 15,885 16,203 25,546 27,332 29,245 31,292 33,483 34,152 NOPAT NOA Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating obligations (NNO) of $27,424 million. Required a. Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) model as of February 3, 2019. Note: Do not round until your final answer; round your final answer to two decimal places. Stock price per share: $ 519 b. Home Depot stock closed at $190.06 on March 28, 2019, the…

See Table 2.5 LOADING... showing financial statement data and stock price data for Mydeco Corp. Suppose Mydeco's costs and expenses had been the same fraction of revenues in 2016-2019 as they were in 2015. What would Mydeco's EPS have been each year in this case? Calculate the new EPS for 2016-2019 below:  (Round dollar amounts and number of shares to one decimal place. Round percentage amount and the EPS to two decimal places.)

The management of Kosoko traders wants to establish theamount of financial needs for the next two years.Thebalance sheet of the firm as at 31stDecember 2016 is asfollows:Shs.‘000’Net fixed assets 124,800Stock 38,400Debtors 28,800Cash 7,200TotalAssets 199,200Financedby:Ordinary share capital 84,000Retained earnings 35,20012%long-term debt 20,000Trade creditors 36,000Accrued expenses 24,000TOTAL 199,200For the year ended 31st December,2016sales amounted to sh.240,000,000.The firm projects that the sales will increase by15%in 2017and 20% in 2018.After tax profit on sales has been 11% but the management ispessimistic about future operating costs and use anafter-tax profit on sales rate of 8%per annum by 2018.The firmintends to maintain it's dividend pay out ratio 80%.Assets areexpected to vary with sales,while trade creditors and accruedexpenses form the spontaneous sources of financing.Any external financing will be effected through the use of commercial paper.calculate amount of external…

Estimating Share Value Using the ROPI ModelFollowing are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018.   Reported Horizon Period   $ millions 2018 2019 2020 2021 2022 Terminal Period Sales $14,768 $15,654 $16,593 $17,589 $18,644 $19,017 NOPAT 2,711 2,880 3,053 3,236 3,430 3,499 NOA 9,462 10,028 10,630 11,268 11,944 12,183 Answer the following requirements assuming a discount rate (WACC) of 7.35%, a terminal period growth rate of 2%, common shares outstanding of 328.1 million, and net nonoperating obligations (NNO) of $6,204 million.(a) Estimate the value of a share of ITW’s common stock using the residual operating income model (ROPI) model as of December 31, 2018. Instructions:   Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not round), and stock price per share. Round discount factors to 5 decimal places. Round stock…

Stock price of ABC company at the end of 2018 was $85. In 2019 the quarter end stock prices are $94, $80, $75, and $70 for the 1st, 2nd, 3rd, and 4th quarters respectively. If company pays $4.8 dividend at the end of each quarter what is the annual return for 2019?

A firm has the following accounts and financial data for 2020: Sales = 30000 Cost of goods sold = 3000 Accounts payable = 500 Accounts receivables = 100 Number of shares of Common stocks = 1000 Preferred stock dividends = 95 operating expenses = 700 Interest expense=200 Tax rate = 25% Current liability = 1000 PRICE IS 7 What is the firm's earnings available to common shareholders for 2020? WHAT IS THE P/E RATIO? WHAT IS THE EPS