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 Terminal millions 2018 2019 Sales $173,923 NOPAT 24,062 NOA 372,206 2020 2021 2022 $184,168 $195,028 $206,540 $218,743 $ 25.249 26.574 27.979 29,467 394,098 417,554 442,418 468,774 Period 232,474 280,589 498,822 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 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 Terminal millions 2018 2019 Sales $173,923 NOPAT 24,062 NOA 372,206 2020 2021 2022 $184,168 $195,028 $206,540 $218,743 $ 25.249 26.574 27.979 29,467 394,098 417,554 442,418 468,774 Period 232,474 280,589 498,822 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
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
1. Was 1MDB a fraudulent venture from the beginning? Why or why not? 2. How did the US Government become involved in the 1MDB saga? 3. What does the involvement of so many financial institutions in...
-
What is EVA? How does it differ from ROI and residual income?
-
(a) What are the crucial concerns for an American company attempting to protect its intellectual property rights abroad? (b) What U.S. laws apply to the transfer of various technologies and products...
-
Read Joseph McCafferty's article entitled "Misgivings" at CFO.com (January 2007); https://www.cfo.com/accounting-tax/2007/01/misgivings/ (accessed 12/10/19). a. Discuss your thoughts about...
-
Alarico Printing owned a piece of equipment that cost $16,200 and on which it had recorded $9,000 of accumulated depreciation. The company disposed of the equipment on January 2, the first day of...
-
Panguitch Company is closing its managerial accounting records for the year. During the year, manufacturing overhead has been UNDER-applied. The journal entry to record closing of the manufacturing...
-
You are the new HR Manager for Company X, reporting to the General Manager (GM) of the company. When you examined the current Compensation & Benefits (C&B) structure of your new company, you found...
-
what is tj. percentage price change for a 10 year zero coupon treasury bond when interest rates fall from 10 to 9%.
-
In your portfolio, you have two stocks. You have a 50% investments in Stock A and 50% investment in Stock B. Stock A has a standard deviation of 25% and a beta of 1.2. Stock B has a standard...
-
On September 3, 2021, the Robers Company exchanged equipment with Phifer Corporation. The facts of the exchange are as follows: Original cost Accumulated depreciation Fair value Robers' Asset...
-
Identify three business practices that hinder proper cost assignment to segments of a company. Explain each business practices
-
Ayayai Company lost most of its inventory in a fire in December just before the year-end physical inventory was taken. Corporate records disclose the following. Inventory (beginning) $ 80,800 Sales...
-
Assume an organic compound has a partition coefficient between water and ether equal to 8.17. If there are initially 9.49 grams of the compound dissolved in 90.0 mL of water, how many grams will...
-
2. In the circuit given in Figure 2, i,(t) = 5.67cos(5t)A and v (t) = 70.71 cos(5t 60) V a) Find the equivalent load impedance. State whether the load is inductive or capacitive. b) Calculate the...
-
In a competitive labor market in equilibrium, a. a firms MRP = MP MR. b. a firms MRP = MP P. c. a firms MRP = MRC. d. a firms wage = MRC. e. all of the preceding are true.
-
In a competitive labor market, a. a firm is a wage taker. b. a firm can hire all the labor it wishes to at the market wage. c. a firm hires a small fraction of the total market quantity of labor...
-
The marginal resource cost of an input a. is the amount an added unit of an input adds to a firms total cost. b. exceeds the market wage in a competitive industry. c. is less than the market wage in...
Study smarter with the SolutionInn App