Question: Estimating Share Value Using the DCF Model Module are forecasted sales, NOPAT, and NOA for AT&T for 2019 through 2022 Note: Complete the entire

Estimating Share Value Using the DCF Model Module 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 Sales NOPAT NOA 2019 $173,560 2020 $183,805 $194,665 $206,177 $218,380 2021 2022 Period $ 0 24,886 26,211 27,616 29,104 393,735 417,191 442,055 468,411 0 0 23,699 371,843 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,959 million Noncontrolling interest $12,599 million Increase in NOA ($ millions) FCFF (NOPAT - Increase in NOA) Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ 0 $ 0 Present value of horizon FCFF Cum. present value of horizon FCFF $ Present value of terminal FCFF 0 ooo 0 0 0 $ 0 0 0 0 0 0 0 0 0 0 Total firm value 0 Less (plus) NNO 0 Less NCI 0 Firm equity value $ 0 Shares outstanding (millions) 0 $ Stock price per share 0 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? d. If WACC has been 6.2%, what would the valuation estimate have been? Value $ What about if WACC has been 5.2%? Value +A $ 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A US motivational speaker was brought in by a South African private company as part of its annual general meeting to speak to the sales and marketing staff. Part of the presentation included...

ent Attempt in Progress Sunland Company purchased treasury stock with a cost of $15700 during 2022. During the year, the company paid dividends of $20800 and issued bonds payable for proceeds of...

Developmental psychology Describe your understanding of the applied research fields in psychology. Provide an example of how you would apply your knowledge of these research fields to your selected...

Below are Infographics from the Congressional Budget Office showing Mandatory Spending and Discretionary Spending for FY2022. Examine the types of Mandatory and Discretionary Spending and their...

An analyst predicts that there is a 40% chance that the U.S. economy will perform well. If the U.S. economy performs well, then there is an 80% chance that Asian countries will also perform well. On...

In certain cases where X-ray diffraction is unsuitable for determining the structure of a crystal, neutron diffraction can be used. Instead of X-rays, a beam of neutrons is used to analyze the...

Is the literature review well balanced, presenting evidence on both (or all) sides of the issue?

An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers and tractors in each marketing region as well as...

Exercise 9-08 On July 1, 2019, Sandhill Co. purchased new equipment for $90,000. Its estimated useful life was 5 years with a $10,000 salvage value. On December 31, 2022, the company estimated that...

The classical viewpoint of management emphasizes ways to ______. Multiple choice question. manage work more efficiently achieve economies of scale foster first-mover advantage enhance employee...

Case Study Elegant Firm Parti: Recently you attended a presentation by Dr Ales, renowned entrepreneur and business leader, who spoke at length about the development of an accounting information...

1. Prepare a differential analysis to determine whether Wantum - Cardz should accept the special sales order. 2. Now assume that the Hall of Fame wants special hologram baseball cards. Wantum - Cardz...

JAGUAR LAND ROVER PLC: BOND VALUATION Jaguar Land Rover Automotive plc (JLR), a wholly owned subsidiary of the Indian company Tata Motors Limited, announced, on March 3, 2015, an issue of Senior...

Exercise 14-36 (Algo) Comparing Business Units Using Economic Value Added (EVA) (LO 14-4) Lauderdale Corporation is organized in three geographical divisions (regions) with managers responsible for...

make a copy of Capstone project (task_manager.py) and save it in the Dropbox folder for this project. Also, copy and paste the text files (user.txt and tasks.txt) that accompanied the previous...

Your firm is contemplating the purchase of a new $625,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $69,000 at...

Tiger, Inc. signed a lease for equipment on July 1, 2007.The lease is for 10 years (the useful life of the asset).The first of 10 equal annual payments of $500,000 was made on July 1, 2007.The...

12.57 U.S. population growth The table shows the approximate U.S. population size (in millions) at 10-year intervals beginning in 1900. Let x denote the number of decades since 1900. That is, 1900 is...

12.52 Predicting cell phone weight Refer to the cell phone data file on the books website. Regress y = weight on x = capacity of battery, excluding the outlier (phone no. 70). a. Stating the...

12.51 Understanding an ANOVA table For a random sample of Indian states, the ANOVA table shown refers to hypothetical data on x = tax revenue in Indian rupees and y = agricultural subsidies in Indian...