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,006 NOPAT 3,269 NOA 23,670 2019 2020 2021 $79,124 $83,730 $87,234 $92,246 2022 Period $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) Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ Present value of horizon FCFF 527 $ 3,525 3,276.02 1,860 $ 620 $ 1,984 $ 1,712 3,781 1,478.7 3,035.08 x 1,955 1,458.47 x (90) 4,757 Cum. present value of horizon FCFF $ 9,248.27 x Present value of terminal FCFF 63,371.8 x Total firm value 72,620.07 x NNO 12,373 Firm equity value $ 60,247.07 X Shares outstanding (millions) 517.8 Stock price per share $ 116.35

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!

You are given the following price information on various default-free, US treasury bonds. All prices are based on face value of $1,000. The price of the 1-year zero-coupon bond is $950. The price of...

Kenley Corporation Comparative Balance Sheets June 30, 2013 and June 30 2014 Assets 2013 2014 Cash 12,500 69,900 Accounts Receivable 36,000 31,000 Inventory 51,400 46,400 Prepaid Expenses 2,600 3,200...

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...

Boeing Company was scheduled to deliver several of its 747-400 jumbo jetliners to Northwest Airlines by December 31, 1988. Northwest set that deadline because it needed the $16 million in investment...

Einstein Construction Co. specializes in building replicas of historic houses. Bree Andrus, president of Einstein Construction, is considering the purchase of various items of equipment on July 1,...

7. Using the information from Exhibit 8.18 and calculations from Question 1, calculate BrandCos equity value using the cash-flow-to-equity model. How does your valuation compare with your answers in...

=+b) What aspect of these data may make the Kruskal-Wallace test more appropriate for these data than the ANOVA methods of Chapter 20?

Amy and Lester are partners in operating a store. Without consulting Amy, Lester enters into a contract to purchase merchandise for the store. Amy contends that she did not authorize the order and...

\\\\table[[Finished goods inventory, June 1, $65,000 , $19,500 ,(e)],[Cost of goods manufactured,331,500,(c),68,300],[Cost of finished goods available for sale,(a) $185,300 , $107,300 ,],[Finished...

The Captain Company began operations on January 1, 2014. The company estimated that $0.10 of warranty costs will be incurred for each $1 of sales. In 2014, Captain

First Month of Operations The following transactions took place during the first month of operations of Mother Mollys Childcare. On May 1, Molly invests $50,000 to open Mother Mollys Childcare. On...

10. DJIA (LO4, CFA2) On May 31, 2022, the DJIA opened at 33,160.59. The divisor at that time was .15173. Suppose on this day the prices for 29 of the stocks remained unchanged and I stock increased...

Burdeno Appliances has two divisions, Sales and Financing. Sales is responsible for selling Burdenos inventory and maintaining inventory for future sale. Financing Division takes loan applications,...

Jason went to the post office and bought both 41-cent stamps and 26-cent postcards and spent $10.28. The number of stamps was 4 more than twice the number of postcards. How many of each did he buy?

Albany Division is considering the acquisition of a new asset that will cost $540,000 and have a cash flow of $184,000 per year for each of the four years of its life. Depreciation is computed on a...

The stockholders' equity of TVX Company at the beginning of the day on February 5 follows: Common stock-$20 par value, 150,000 shares authorized, 66,000 shares issued and outstanding Paid-in capital...

In muscle tissue, the ratio of phosphorylase a to phosphorylase b determines the rate of conversion of glycogen to glucose 1phosphate. Classify how each event affects the rate of glycogen breakdown...

We argued that the diversification effect occurs whenever the correlation between the two securities is below LO.1

The relationship between the expected return on individual securities and the expected return on a portfolio made up of these securities.

The relationship between the standard deviations of individual securities, the correlations between these securities, and the standard deviation of a portfolio made up of these securities. LO.1