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 Sales NOPAT NOA 2018 $173,439 2019 23,578 371,722 2020 2021 2022 $183,684 $194,544 $206,056 $218,259 $ 24,765 26,090 27,495 28,983 393,614 417,070 441,934 468,290 Period 222,624.18 29,562.66 477,655.8 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) Common shares outstanding 5.70% 7,281.6 million Net nonoperating obligations (NNO) $177,838 million Noncontrolling interest $12,478 million Forecast ($ millions) Increase in NOA FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF Cum. present value of horizon FCFF $ Present value of terminal FCFF Reported 2018 Horizon Terminal 2019 2020 2021 2022 $ 21,892 $ 2,873 2,718.07 23,456 2,634 2,357.58 $ 24,864 $ 2,631 26,356 2,627 $ Period 9,366 20,197 2,227.9 2,104.55 9,408 747 x Total firm value 555,269 x Less (plus) NNO 177,838 Less NCI 12,478 Firm equity value $ 0 x Shares outstanding (millions) 7,281.6 Stock price per share $ 0 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 Terminal millions Sales NOPAT NOA 2018 $173,439 2019 23,578 371,722 2020 2021 2022 $183,684 $194,544 $206,056 $218,259 $ 24,765 26,090 27,495 28,983 393,614 417,070 441,934 468,290 Period 222,624.18 29,562.66 477,655.8 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) Common shares outstanding 5.70% 7,281.6 million Net nonoperating obligations (NNO) $177,838 million Noncontrolling interest $12,478 million Forecast ($ millions) Increase in NOA FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF Cum. present value of horizon FCFF $ Present value of terminal FCFF Reported 2018 Horizon Terminal 2019 2020 2021 2022 $ 21,892 $ 2,873 2,718.07 23,456 2,634 2,357.58 $ 24,864 $ 2,631 26,356 2,627 $ Period 9,366 20,197 2,227.9 2,104.55 9,408 747 x Total firm value 555,269 x Less (plus) NNO 177,838 Less NCI 12,478 Firm equity value $ 0 x Shares outstanding (millions) 7,281.6 Stock price per share $ 0 x
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Identify any one non governmental / non-profit organization in Toronto locality. Brief introduction to the organization that includes the following information: Vision/Mission Services / Programs...
-
Graph the three functions y = xa, y = ax, and y = log ax on the same screen for two or three values of a >. For large values of x, which of these functions has the largest values and which has the...
-
Kile Company borrows $90,000 on July 1 from the bank by signing a $90,000, 8%, 1-year note payable. Prepare the journal entries to record (a) The proceeds of the note and (b) Accrued interest at...
-
For each of the following transactions, indicate whether the account in parentheses should be debited or credited, and give the reason for your answer. a. Purchased land for cash. (Cash) b. Sold an...
-
As of June 30, 2012 (the computation date for the 2013 tax rate), Amanda Company had a negative balance of $1,015 in its unemployment reserve account in State A. The company's average payroll over...
-
On May 1, 20X4, Louella Corp. purchased equipment with a total cost of $4,000,000. The company financed the purchase by taking out a 9-month, 12%, note. The face value of the note plus interest is...
-
Where in the World Is Timbuk2? Outsourcing, Offshoring, and Mass Customization 10.4135/9781526462381 What are the distribution channels that Timbuk2 use? Characterize each of the channels and their...
-
Shady Inc. manufactures outdoor umbrellas. The company has the capacity to produce 100,000 units per year, but it currently produces and sells 75,000 units per year. The following information relates...
-
How do you calculate Private Investment per capita ($) and Government consumption per capita ($)?? What is the formula used and how can i do in excel? Another question is do i add more zeros to this...
-
1. Smith Corp. stock had the following information: Price as of 12/31/19 $75 per share Price as of 12/31/18 $87 per share Dividend received during the year $2,50 What is the stock's total return for...
-
Doran Technologies produces a single product. Expected manufacturing costs are as follows: Variable costs Direct materials $4.00 per unit Direct labor $1.20 per unit Manufacturing overhead $0.95 per...
-
1. What is the payback period for a project with the following cash flows? Cash flows 0 1234 (12,300) 2,300 5,450 2,750 2,600
-
I have a question about Atomic absorption spectroscopy. Which method is better internal standard method or calibration curve method, when quantifying the iron component in stainless steel? and please...
-
Using Apple, demonstrate how the differentiation strategy can be well implemented.
-
Can a defendant's assertion of a generalized affirmative defense of good faith be struck by a federal court under FRCP 8 as factually insufficient?
-
The Farm Company is considering investing in solar panels to generate enough power to run its irrigation system. The local utility company has agreed to purchase any unused power generated by the...
-
JB Enterprises has a cost of capital of 12%. Calculate the present value of the following investment opportunities: a. An investment project promises a return of \($3,000\) at the end of year 3 and...
Study smarter with the SolutionInn App