Question: 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

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

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!

The Endangered Species Act (ESA) charges the National Marine Fisheries Service (a federal agency) with the duty to ensure that any proposed action by the Council does not jeopardize any threatened or...

An income statement for Sam's Bookstore for the first quarter of the year is presented below. Sam's Bookstore Income Statement For Quarter Ended March 31 Sales $910,000 Cost of goods sold 560,000...

Managerial AccountingDwight Donovan, the president of Campbell Enterprises, isconsidering two investment opportunities. Because of limitedresources, he will be able to invest in only one of them. P 2...

What is the consequence of acquiring replacement property after the 180-day exchange period? The exchange is denied, and taxes apply A penalty is imposed but the exchange remains valid A special...

Estimating Share Value Using the DCF Model Assume following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29,...

Estimating Share Value Using the ROPI Model Assume following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29,...

Question 6 Tries remaining: 1 Marked out of 25.00 P Flag question Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax...

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 January 30, 2016...

Just need the answers to the spaces with the red X's. Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net...

Estimating Share Value Using the DCF Model Assume following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29,...

Sultan and Company makes rugs, selling them to furniture and carpet stores. During the most recent year, actual fixed and variable overhead were $245,000 and $603,250, respectively. Sultan applies...

LCD Industries purchased a supply of electronic components from Entel Corporation on November 1, 2021. In payment for the $24.7 million purchase, LCD issued a 1-year installment note to be paid in...

why does Geographic dispersion has different impacts as team members are flung across spatial, temporal, and configurational arrangements

Consider the Following Molecule: HN- Px NH a) Determine the reducible representation of the SALC group orbitals formed from the p, atomic orbitals of the outer atoms in the molecule shown atoms Co b)...

Assume that concrete creations used the FIFO method rather than the weighted average in its process costing system. Determine the equivalent units of production for the forming department for the...

Platypus Ltd owns all of the share capital of Wallaby Ltd. In relation to the following intragroup transactions, all parts of which are independent unless specified, prepare the consolidation...

All of the shares of ABC Inc, a CCPC are owned by Peter. In addition to being the sole shareholder of ABC Inc., Peter works full time in the business. ABC Inc. has established generous benefit...

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Value Paid. Florence owns a shop that has products within the value range of $10. She wants to make a prediction of the mean value a customer would pay for her products by checking whether on average...

Retail gas, part 2. In Exercise 30 we looked at the weekly average retail price (cents per gallon) of regular gas nationwide from 2002 through the early part of 2007. Heres a time series plot: d)...

Online purchase. A boutique owner claims that 15% of her total customers prefer to purchase online in comparison to her other walk-in customers. Another boutique owner wants to know whether her...