Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for AT&T...
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 AT&T 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 2% Reported Forecast Horizon Period $ millions 2018 Sales NOPAT NOA 2019 $173,923 24,062 372,206 2020 2021 $184,168 $195,028 $206,540 $218,743 $ 25,249 26,574 27,979 29,467 394,098 417,554 442,418 468,774 2022 Terminal Period 223,117.86 30,056.34 478,149.48 b. Estimate the value of a share of AT&T common stock using the discounted cash flow (DCF) model as of December 31, 2018 using the following assumptions and the information above. Assumptions Discount rate (WACC) 5.70% 7,281.6 million Common shares outstanding Net nonoperating obligations (NNO) $178,322 million Noncontrolling interest $12,962 million Reported Forecast Horizon Increase in NOA ($ millions) FCFF (NOPAT - Increase in NOA) 2018 $ 2019 21,892 $ 3,357 Present value of horizon FCFF 2020 23,456 $ 3,118 3,175.97 2,790.78 2021 24,864 $ 3,115 2,637.75 2022 26,356 $ 3,111 2,492.3 Terminal Period 9,375.48 20,680.86 Cum. present value of horizon FCFF $ 0 x Present value of terminal FCFF 0 x Total firm value Less (plus) NNO Less NCI 443,204.6 x 178,322 12,962 Firm equity value $ 251,920.6 x Shares outstanding (millions) Stock price per share $ 7,281.6 34.6 x c. AT&T closed at $30.85 on February 20, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? Higher d. If WACC has been 6.2%, what would the valuation estimate have been? Value $ 26.3 x What about if WACC has been 5.2%? Value $ 45.53 x Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for AT&T 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 2% Reported Forecast Horizon Period $ millions 2018 Sales NOPAT NOA 2019 $173,923 24,062 372,206 2020 2021 $184,168 $195,028 $206,540 $218,743 $ 25,249 26,574 27,979 29,467 394,098 417,554 442,418 468,774 2022 Terminal Period 223,117.86 30,056.34 478,149.48 b. Estimate the value of a share of AT&T common stock using the discounted cash flow (DCF) model as of December 31, 2018 using the following assumptions and the information above. Assumptions Discount rate (WACC) 5.70% 7,281.6 million Common shares outstanding Net nonoperating obligations (NNO) $178,322 million Noncontrolling interest $12,962 million Reported Forecast Horizon Increase in NOA ($ millions) FCFF (NOPAT - Increase in NOA) 2018 $ 2019 21,892 $ 3,357 Present value of horizon FCFF 2020 23,456 $ 3,118 3,175.97 2,790.78 2021 24,864 $ 3,115 2,637.75 2022 26,356 $ 3,111 2,492.3 Terminal Period 9,375.48 20,680.86 Cum. present value of horizon FCFF $ 0 x Present value of terminal FCFF 0 x Total firm value Less (plus) NNO Less NCI 443,204.6 x 178,322 12,962 Firm equity value $ 251,920.6 x Shares outstanding (millions) Stock price per share $ 7,281.6 34.6 x c. AT&T closed at $30.85 on February 20, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? Higher d. If WACC has been 6.2%, what would the valuation estimate have been? Value $ 26.3 x What about if WACC has been 5.2%? Value $ 45.53 x
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
ABC Company acquired 60,000 shares of DEF Incorporated's 200,000 ordinary shares on January 2, 2019 for P 4,000,000 when the net assets of DEF Incorporated was P 12,000,000. The excess of acquisition...
-
A flat coil enclosing an area of 0.10 m2 is rotating at 60 rev/s, with its axis of rotation perpendicular to a 0.20-T magnetic field. (a) If there are 1 000 turns on the coil, what is the maximum...
-
The parameters of the circuit in Figure P6.67 are \(V_{C C}=9 \mathrm{~V}, R_{L}=4 \mathrm{k} \Omega\), \(R_{C}=6 \mathrm{k} \Omega, R_{E}=3 \mathrm{k} \Omega, R_{1}=150 \mathrm{k} \Omega\), and...
-
Saxon wants to know if its profitability performance has increased from 20x6 to 20x7. The company had net income of $24,000 in 20x6 and $25,000 in 20x7. Total assets were $200,000 at the end of 20x5,...
-
Cookie Monster Inc. is a company that specializes in the development of software that tracks Web browsing history of individuals. A sample of browser histories is provided in the file CookieMonster....
-
Which statement best describes the difference between the QTIP trust and the power of appointment trust? Question 10 options: Both qualify for the marital deduction Only the QTIP trust qualifies for...
-
Use the table to answer the questions below. SECTORS Output: Inputs: Com Wheat Fertilizer 42.3 Cows Beef Cheese Burgers Pizza Resources Rent Wages Profit Value Added Corn 133 Amt as Final Product...
-
ABC Corporation, which is subject to a 30% income tax rate, is considering a P1,050,000 asset that will result in the following over its seven-year life: Total revenue: P1,190,000; Total operating...
-
Explain what types of individual investor would be interested in bonds, as opposed to putting their money into stocks or savings accounts.
-
(a) Heather borrowed $5000 from her grandmother as a down payment on her first car. She promised to repay the debt in 2 years at 7% per annum, simple interest. How much should Heather repay her...
-
You are a software engineer and you are asked to collect and model the requirements of a training center that offers a set of training courses. The system should save the information of the offered...
-
In America, a criminal trial jury maintains the right of jury nullification, declaring not-guilty despite evidence to the contrary due to disagreements with the law being applied in the case. It is...
-
You are given the following (Useful) null and alternative hypothesis: LaTeX: H_0 : mu equals 12.3 LaTeX: H_a : mu less than 12.3 The test statistic for this hypothesis test is LaTeX: z_0= -2.70. All...
-
Write a paper by answer the following question: Should Recycling Be Mandatory?
-
Bond Features Define the following terms related to bonds payable. Debenture bonds Secured bonds Convertible bonds Callable bonds Face value of the bonds Face rate of interest Issue price
-
Do you agree with this statement: All liabilities could be legally enforced in a court of law? (Appendix)
-
Effect of Bond Issuance A bond with a face value of $10,000 is issued at a discount of $800 on January 1, 2008. The face rate of interest on the bond is 7%. Required 1. Was the market rate at the...
Study smarter with the SolutionInn App