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,056 NOPAT 3,269 NOA 23,720 2019 2021 2022 Period 2020 $79,124 $83,780 $87,234 $92,296 $93,428 4,102 3,572 4,451 3,939 4,717 24,197 26,107 26,677 28,711 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 296 7.63% Common shares outstanding 517.80 million Net nonoperating obligations (NNO) $12,423 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) Reported 2018 Forecast Horizon 2019 2020 2021 2022 Terminal Period $ 0 * $ 0 x $ 0 x $ 0 x $ 0 * 0 x 0 x 0 x 0 * 0 x 0 % 0 0 x 0 x Present value of horizon FCFF Cum. present value of horizon FCFF $ 9,335.06 Present value of terminal FCFF 65,996.54 x Total firm value 75,331.6 x NNO 12,423 Firm equity value $ 62,908.6 Shares outstanding (millions) 0 x Stock price per share $ 0 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,056 NOPAT 3,269 NOA 23,720 2019 2021 2022 Period 2020 $79,124 $83,780 $87,234 $92,296 $93,428 4,102 3,572 4,451 3,939 4,717 24,197 26,107 26,677 28,711 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 296 7.63% Common shares outstanding 517.80 million Net nonoperating obligations (NNO) $12,423 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) Reported 2018 Forecast Horizon 2019 2020 2021 2022 Terminal Period $ 0 * $ 0 x $ 0 x $ 0 x $ 0 * 0 x 0 x 0 x 0 * 0 x 0 % 0 0 x 0 x Present value of horizon FCFF Cum. present value of horizon FCFF $ 9,335.06 Present value of terminal FCFF 65,996.54 x Total firm value 75,331.6 x NNO 12,423 Firm equity value $ 62,908.6 Shares outstanding (millions) 0 x Stock price per share $ 0 x
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Question Description RangeFilterTester.java import java.util.ArrayList; class RangeFilterTester { public static void main( String[] args) { ArrayList accounts = new ArrayList(); accounts.add(new...
-
Show the products of each of the followingreactions: (a) FAD FADH2 CHCH-CH2CH2CHzCsCOA Acyl-CoA dehydrogenase (b) Enoyl-CoA hydratase Product of (a) + H20 NAD+ NADH/H* (c) Product of (b)...
-
For each of the research situations described in Exercises 23 to 25, draw a figure that illustrates simple effects analyses appropriate to test the study's research hypothesis. Exercises 23...
-
Which of the following is the most reliable method for making capital budgeting decisions? a. NPV method b. ARR method c. payback method d. post-audit method
-
Life-cycle costing. Maximum Metal Recycling and Salvage receives the opportunity to salvage scrap metal and other materials from an old industrial site. The current owners of the site will sign over...
-
Required information Comprehensive Problem 0 7 - 6 3 ( LO 0 7 - 1 , LO 0 7 - 2 , LO 0 7 - 3 , LO 0 7 - 4 ) ( Algo ) [ The following information applies to the questions displayed below. ] During 2 0...
-
When it comes to labor relations, which of the following would not be likely under a true stakeholder model of corporate governance
-
What questions should be asked before making an employee's dismissal final?
-
What are the challenges in integrating smart infrastructure with existing legacy systems in urban environments ? Explain
-
In your business, assets, and liabilities have historically varied with sales. Assets are usually 80percent of sales, and liabilities are usually 53percent of sales.Your sales next year will be...
-
Explain and distinguish with examples primary data and secondary data.
-
Federalism in the United States has evolved since this country's founding. The federal government and state governments frequently disagree on each other's roles or responsibilities. When these...
-
American International Group ( AIG ) stood at the centre of the financial crisis of 2 0 0 8 . It was one of the main institutions issuing credit default swaps. With default rates increasing and the...
-
Propose a reasonable mechanism for the following reaction. OH
-
WorldCom changed its name to MCI. Go to www.CFO.com and enter the words extreme makeover into the search box. From a review of the article, identify the major steps the new CFO carried out to fix...
-
A tree with eight vertices, exactly two of degree three. Draw a graph with the given characteristics.
-
A connected graph with eight vertices, exactly two of degree 3 , which is not a tree. Draw a graph with the given characteristics.
Study smarter with the SolutionInn App