Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for AT&T for 2019 through 2022 a. Forecast the terminal period

Estimating Share Value Using the DCF Model

Following are forecasted sales, NOPAT, and NOA for AT&T for 2019 through 2022

a. Forecast the terminal period values assuming a 2% terminal period growth rate.

Round answers to the nearest dollar.

Reported Forecast Horizon
$ millions 2018 2019 2020 2021 2022 Terminal Period
Sales $170,756 $181,001 $191,861 $203,373 $215,576 Answer?

NOPAT 20,895 22,082 23,407 24,812 26,300 Answer?

NOA 369,039 390,931 414,387 439,251 465,607 Answer?

b. Estimate the value of a share of AT&T common stock using the discounted cash flow (DCF) model as of December 31, 2018; assume a discount rate (WACC) of 5.7%, common shares outstanding of 7,281.6 million, net nonoperating obligations (NNO) of $175,155 million, and noncontrolling interest (NCI) from the balance sheet of $9,795 million.

Rounding instructions:

  • Use rounded answers for subsequent computations.

  • Round answers to the nearest whole number unless otherwise noted (do not round shares outstanding).
  • Round discount factor to 5 decimal places and stock price per share to two decimal places.
  • Use negative signs for your FCFF and Present value of horizon FCFF answers, when appropriate. Otherwise, do not use negative signs with your answers.

TXRH Reported Forecast Horizon Terminal
$ thousands 2018 2019 2020 2021 2022 Period
Increase in NOA Answer

Answer

Answer

Answer

Answer

FCFF (NOPAT - Increase in NOA) Answer

Answer

Answer

Answer

Answer

Discount factor [1 / (1 + rw)t ] Answer

Answer

Answer

Answer

Present value of horizon FCFF Answer

Answer

Answer

Answer

Cumulative PV of horizon FCFF Answer

Present value of terminal FCFF Answer

Total firm value Answer

NNO Answer

NCI Answer

Firm equity value Answer

Shares outstanding

Answer

Stock Price Per share =

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Investing Market Analysis Valuation Techniques And Risk Management

Authors: Benedetto Manganelli

1st Edition

3319063960,3319063979

More Books

Students also viewed these Finance questions