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 $ millions 2018 2019 Sales $76,106 2020 2021 2022 $79,124 $83,830 $87,234 $92,346 Terminal Period $93,428 NOPAT 3,269 NOA 23.770 4,152 3,572 4,501 3,939 4,767 24,197 26,157 26,677 28,761 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 ($ millions) Reported 2018 2019 Net nonoperating obligations (NNO) $12,473 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. Terminal Period Forecast Horizon 2020 2021 2022 Increase in NOA $ FCFF (NOPAT- Increase in NOA) 427 $ 3,725 v 1,960 $ 2,362 x 520 2.481 x 2.084 $ 2,605 x 560 X 3,457 x Present value of horizon FCFF 2,067 x 2,039 X 1,990 X 1.941 x Cum. present value of horizon FCFF $ 8,037 x Present value of terminal FCFF 45,757 x Total firm value 53,794 x NNO (11,723) x Firm equity value $ 42,071 x Shares outstanding (millions) 517.8 Stock price per share 81.25 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 $ millions 2018 2019 Sales $76,106 2020 2021 2022 $79,124 $83,830 $87,234 $92,346 Terminal Period $93,428 NOPAT 3,269 NOA 23.770 4,152 3,572 4,501 3,939 4,767 24,197 26,157 26,677 28,761 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 ($ millions) Reported 2018 2019 Net nonoperating obligations (NNO) $12,473 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. Terminal Period Forecast Horizon 2020 2021 2022 Increase in NOA $ FCFF (NOPAT- Increase in NOA) 427 $ 3,725 v 1,960 $ 2,362 x 520 2.481 x 2.084 $ 2,605 x 560 X 3,457 x Present value of horizon FCFF 2,067 x 2,039 X 1,990 X 1.941 x Cum. present value of horizon FCFF $ 8,037 x Present value of terminal FCFF 45,757 x Total firm value 53,794 x NNO (11,723) x Firm equity value $ 42,071 x Shares outstanding (millions) 517.8 Stock price per share 81.25 x
Expert Answer:
Related Book For
Financial And Managerial Accounting For MBAs
ISBN: 9781618533593
6th Edition
Authors: Peter D. Easton
Posted Date:
Students also viewed these accounting questions
-
Write the following function in terms of unit step function: f (t) = { 3t, 0
-
A level circuit is run a total distance of 10 km from BM 30 to set three other benchmarks in the vicinity of a construction project (see figure below). The level loop consists of four instrument set-...
-
What is the time value of money? Including present and future value. How would a financial expert interpret it?
-
The following paired sample data have been obtained from normally distributed populations. Construct a 90% confidence interval estimate for the mean paired difference between the two population...
-
A random sample of 500 adult residents of Maricopa County found that 385 were in favor of increasing the highway speed limit to 75 mph, while another sample of 400 adult residents of Pima County...
-
From the following accounts of Resch Restore, Inc., prepare the businesss statement of retained earnings for the year ended January 31, 2010: Retained Earnings Dividends Clo Clo 110,000 Feb 1 82,000...
-
Price Corporation has 100 shares of common stock outstanding. Price repurchased all of Pennys 30 shares for $35,000 cash during the current year. Three years ago, Penny received the shares as a gift...
-
5. A property was purchased for $9772.00 down and payments of $993.00 at the end of every sixmonths for 3 years. Interest is 3% per annum compounded monthly. What was the purchase price of the...
-
(1 point) Are the following statements true or false? * 1. If i and w are any two vectors, then ||i+ w||= |||| + ||W||: 2. For any scalar C and any vector U, we have cu| = cU|. ? 3. The value of U ...
-
The baseball caps are sold to retailers for $15 each. Actual unit sales for the second quarter and budgeted unit sales for the third quarter plus October are as follows: May (actual) June (actual)...
-
Lars Corp. receives 1 round of financing equal to $10M at a $15M pre-money valuation.The VC receives participating preferred stock with a 1x liquidation preference and 2.5x cap. If the company is...
-
Selling goods and services to governmental organizations is often complex and time consuming. However, it can be lucrative because of the very large dollar volume of the purchases made by...
-
Dr. Evita Pajanustan, a CPA and PHD graduate of Harvard University, USA opened a consultancy firm on March 1 by leasing an office space. She invested cash of P500,000 and Furniture and Fixtures of...
-
Fedland Inc. will issue new common stock to finance an expansion. The existing common stock just paid a $6.80 dividend, with dividends expected to grow at a constant rate of 4% indefinitely. The...
-
Unless otherwise specified, assume that all matrices in these exercises are n x n. Determine which of the matrices in Exercises 1-10 are invertible. Use as few calculations as possible. Justify your...
-
A container holds 2.0 mol of gas. The total average kinetic energy of the gas molecules in the container is equal to the kinetic energy of an 8.0 10-3-kg bullet with a speed of 770 m/s. What is the...
-
Restore the file Drone City Ch 12 (Backup) that you downloaded from the student companion site and then do the following like you did in the chapter: Create a new client in the Fixed Asset Manager...
-
When is the Fixed Asset Manager synchronized with the fixed asset list?
-
What information is provided by the Fixed Asset Managers Depreciation Schedule by G/L Account Number report?
Study smarter with the SolutionInn App