Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 2, 2019, which we label fiscal year 2018. 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. Reported Forecast Horizon Period Terminal $ millions 2018 Sales $76,006 NOPAT NOA 3,269 23,670 2019 2020 2021 2022 Period $79,124 $83,730 $87,234 $92,246 $93,428 4,052 3,572 4,401 3,939 4,667 24,197 26,057 26,677 28,661 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.63% Common shares outstanding 517.80 million Net nonoperating obligations (NNO) $12,373 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. ($ millions) Increase in NOA FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF Reported 2018 Forecast Horizon 2019 2020 2021 2022 Terminal Period $ 0 x $ 4,052 x 3,764.75 x 1,860 $ 620 $ 1,712 1,477.87 3,781 3,032.54 1,984 $ 1,955 (90) 4,757 1,456.85 Cum. present value of horizon FCFF $ 9,732.01 x Present value of terminal FCFF 64,223.14 * Total firm value NNO 73,955.15 x 12,373 Firm equity value $ 61,582.15 x Shares outstanding (millions) 517.8 Stock price per share $ 118.93 x Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 2, 2019, which we label fiscal year 2018. 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. Reported Forecast Horizon Period Terminal $ millions 2018 Sales $76,006 NOPAT NOA 3,269 23,670 2019 2020 2021 2022 Period $79,124 $83,730 $87,234 $92,246 $93,428 4,052 3,572 4,401 3,939 4,667 24,197 26,057 26,677 28,661 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.63% Common shares outstanding 517.80 million Net nonoperating obligations (NNO) $12,373 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. ($ millions) Increase in NOA FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF Reported 2018 Forecast Horizon 2019 2020 2021 2022 Terminal Period $ 0 x $ 4,052 x 3,764.75 x 1,860 $ 620 $ 1,712 1,477.87 3,781 3,032.54 1,984 $ 1,955 (90) 4,757 1,456.85 Cum. present value of horizon FCFF $ 9,732.01 x Present value of terminal FCFF 64,223.14 * Total firm value NNO 73,955.15 x 12,373 Firm equity value $ 61,582.15 x Shares outstanding (millions) 517.8 Stock price per share $ 118.93 x
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Recession is defined as... a) increase in unemployment b) decrease in consumer spending c) two consecutive quarters of negative economic growth d) both A & B
-
Information from Snelling Companys financial statements follows. Average number of shares outstanding was 16,000 for 2011 and 15,000 for 2010. Required Compute the following ratios for Snelling...
-
Show that Joule-Thomson coefficient \(\left(\mu_{\mathrm{JT}} ight.\) ) of an ideal gas is zero.
-
In fact, Congress did this in 1981. Depreciable lives were shorter than before; corporate tax rates were essentially unchanged (they were lowered very slightly on income below \(\$ 50,000\) ); and...
-
Total costs and unit costs, A student association has hired a band and a caterer for a graduation party. The band will charge a fixed fee of $1,000 for an evening of music, and the caterer will...
-
13,18 ou Find the vector, given its magnitude and direction angle. 5 13. u = 10,0 = 750 14. u = 8, 0 = 2250 5 15. Ju = 12, 0 = 1050 16. u = 20, 0 = 150 action of the given vector. r
-
Kiely's firm faces the following production function: Q-5-LI KI, where Q is the amount of products produced by the firm, L is the number of hours of labour employed, and K is the amount of capital...
-
In August and September 2005, Hurricanes Katrina and Rita caused extraordinary flooding in New Orleans, Louisiana. Many homes were severely damaged or destroyed, and of those that survived, many...
-
What are the three most dangerous risk exposures for organizations at the moment?
-
What is the difference between change and transformation? How do accelerated change and accelerated transformation differ?
-
Which of the capabilities discussed in this chapter is the most important to succeeding at digital transformation and digital business?
-
Angioplasty is a medical procedure in which an obstructed blood vessel is widened. In some cases, a wire mesh tube, called a stent, is placed in the vessel to help it remain open. A study was...
-
The Royalty Gold Corporation prospects for undiscovered gold deposits around the world. The company is currently investigating a possible site on the island of Milos off the coast of Greece in the...
-
Parkin Industries, a U.S. company, acquired a wholly-owned subsidiary, located in Italy, at the beginning of the current year, for 200,000. The subsidiary's functional currency is the euro. The...
-
Examine two of the innovation centers listed in the chapter. How are they similar? Different? Do they focus on any different aspects of healthcare innovation?
-
The creation and operation of a single-organ-focused hospital is what form of healthcare innovation?
-
What can organizations do to discourage the ability to be creative and to innovate?
Study smarter with the SolutionInn App