Question

Question text Valuation Using Income Statement Multiples The following table provides summary data for Target and...

Question text

Valuation Using Income Statement Multiples

The following table provides summary data for Target and its competitors, Kohl's and Wal-Mart.

(in millions) Target Kohl's Wal-Mart
Company assumed value -- $23,098 $237,306
Equity assumed value -- $22,470 $198,288
NOPAT $3,159 $1,152 $13,354
Net income $2,787 $1,109 $12,178
Net nonoperating obligations (assets) $10,109 $628 $39,018
Common shares outstanding 860 shares 321 shares 41 shares

(a) Compute the price to NOPAT ratio for both Kohl's and Wal-Mart.

Round your answers to two decimal places.
Kohl's Answer

Mark 0.00 out of 1.00


Wal-Mart Answer

Mark 0.00 out of 1.00



(b) Use Kohl's and Wal-Mart as comparables, along with the company value to NOPAT ratios from part (a), and then estimate for Target its company intrinsic value, its equity intrinsic value, and its equity intrinsic value per share. (Round the intrinsic value and equity intrinsic value to the nearest million and the value per share to the nearest cent.)

Average of the two rounded ratios in (a) above
Answer

Mark 0.00 out of 1.00

(Round to two decimal places.)

Use your rounded answer above to calculate the following:

Intrinsic value $Answer

Mark 0.00 out of 1.00

million
Equity intrinsic value $Answer

Mark 0.00 out of 1.00

million
Equity intrinsic value per share $Answer

Mark 0.00 out of 1.00



(c) Compute the price to net income ratio for both Kohl's and Wal-Mart.

Round your answers to two decimal places.
Kohl's Answer

Mark 0.00 out of 1.00


Wal-Mart Answer

Mark 0.00 out of 1.00



(d) Use Kohl's and Wal-Mart as comparables, along with the equity to net income ratios from part (c), and then estimate for Target its equity intrinsic value and its equity intrinsic value per share. (Round the equity intrinsic value to the nearest million and the value per share to the nearest cent.)

Average of the two rounded ratios in (c) above
Answer

Mark 0.00 out of 1.00

(Round to two decimal places.)

Use the rounded average calculated above to calculate the following:
Equity intrinsic value $Answer

Mark 0.00 out of 1.00


Equity intrinsic value per share $Answer

Homework Answers

Answer #1

Answer :-

a) Price to NOPAT (Kohl) = $23,098 / $1152 = 20.05

Price to NOPAT (Wal-mart) = $237,306 / $13,354 =17.77

b) Avg. Price to NOPAT = (20.05 + 17.77)/2 = 18.91

company Intrinsic Value (Target) = 18.91*$3159 = $59,737.00

Equity Intrinsic Value = Company Intrinsic Value - Net Non Operating Obligations

Target :-

Equity Intrinsic Value = ($59,737- $10,109) = $49,628

Equity Intrinsic Value per Share = $49,628/ 860 = $57.71

c) Equity Value to Net income :-

Kohl = Equity Assumed Value / Net Income

= $22,470 / $1,152

= 19.50

Wal Mart = $198,288 / $12,178 = 16.28

Avg. Equity value to Net Income = (19.50+ 16.28)/2 = 17.89

d) Equity Value for Target :-

= $2,787*17.89

= $49,859.43

Equity Value Per Share of Target :-

= $49,859.43 / 860

= $57.98

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Valuation Using Income Statement Multiples The following table provides summary data for Target and its competitors,...
Valuation Using Income Statement Multiples The following table provides summary data for Target and its competitors, Kohl's and Wal-Mart. (in millions) Target Kohl's Wal-Mart Company assumed value -- $21,598 $242,306 Equity assumed value -- $20,970 $203,288 NOPAT $3,139 $1,152 $13,354 Net income $2,777 $1,109 $12,178 Net nonoperating obligations (assets) $10,109 $628 $39,018 Common shares outstanding 860 shares 321 shares 41 shares (a) Compute the price to NOPAT ratio for both Kohl's and Wal-Mart. Round your answers to two decimal places....
Question text Valuation Using the PE Multiple The following table provides summary data for Applied Materials...
Question text Valuation Using the PE Multiple The following table provides summary data for Applied Materials Inc. and its competitors, KLA Tencor Corporation and Lam Research Corporation. (in millions) Applied Materials KLA Tencor Lam Research Company assumed value - $10,000 $11,739 Equity assumed value - $9,197 $13,454 NOPAT $1,444 $440 $674 Net income $1,377 $479 $769 Net nonoperating obligations (assets) $(1,369) $803 $(1,715) Common shares outstanding 1,160.0 157.9 158.5 a. Compute the price to net income ratio for both KLA...
Valuation Using Price-to-NOA Multiple The following table provides summary data for Cerner Corporation (CERN) and its...
Valuation Using Price-to-NOA Multiple The following table provides summary data for Cerner Corporation (CERN) and its competitors, Allscripts Healthcare Solutions (MRDX) and McKesson (MCK). (in millions) CERN MDRX MCK Company assumed value -- $1,960 $23,685 Equity assumed value -- $1,624 $21,268 Net operating assets $1,484 $1,620 $ 9,487 Book value of equity $2,834 $1,284 $ 7,070 Net nonoperating obligations (assets) $(1,350) $ 336 $ 2,417 Common shares outstanding 172.1 shares 172.4 shares 197.0 shares (a) Compute the price to net...
Valuation Using the PE Multiple The following table provides summary data for Applied Materials Inc. and...
Valuation Using the PE Multiple The following table provides summary data for Applied Materials Inc. and its competitors, KLA Tencor Corporation and Lam Research Corporation. (in millions) Applied Materials KLA Tencor Lam Research Company assumed value - $9,790 $11,529 Equity assumed value - $8,987 $13,244 NOPAT $1,444 $440 $674 Net income $1,377 $421 $711 Net nonoperating obligations (assets) $(1,369) $803 $(1,715) Common shares outstanding 1,160.0 157.9 158.5 a. Compute the price to net income ratio for both KLA Tencor Corporation...
Question 30 Not yet answered Marked out of 7.00 Flag question Question text Valuation Using the...
Question 30 Not yet answered Marked out of 7.00 Flag question Question text Valuation Using the PE Multiple The following table provides summary data for Applied Materials Inc. and its competitors, KLA Tencor Corporation and Lam Research Corporation. (in millions) Applied Materials KLA Tencor Lam Research Company assumed value - $10,000 $11,739 Equity assumed value - $9,197 $13,454 NOPAT $1,444 $440 $674 Net income $1,377 $479 $769 Net nonoperating obligations (assets) $(1,369) $803 $(1,715) Common shares outstanding 1,160.0 157.9 158.5...
14. The following table provides summary information for Max Corp. and its competitors Bernhard, Inc. and...
14. The following table provides summary information for Max Corp. and its competitors Bernhard, Inc. and Eva Co. Use the information to compute the net income multiple for Bernhard and Eva. In addition, using Bernhard and Eva as comparables, compute Max’s equity intrinsic value and equity intrinsic value per share. Max Bernhard Eva Company assumed value $667,964 $948,663 Equity assumed value 408,990 805,408 NOPAT $140,584 65,456 102,841 Net income 138,024 60,304 97,853 Net nonoperating obligations 215,648 258,974 143,255 Common shares...
Question text Estimating Share Value Using the DCF Model Following are the income statement and balance...
Question text Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018...
Valuation of Merger Target Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million...
Valuation of Merger Target Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt; its beta is 1.15 (given its target capital structure). Vandell has $9.28 million in debt that trades at par and pays an 7.1% interest rate. Vandell’s free cash flow (FCF0) is $2 million per year and is expected to grow at a constant rate of 4% a year. Vandell pays a 30% combined...
Valuation of Merger Target Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million...
Valuation of Merger Target Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt; its beta is 1.45 (given its target capital structure). Vandell has $10.43 million in debt that trades at par and pays an 7.3% interest rate. Vandell’s free cash flow (FCF0) is $2 million per year and is expected to grow at a constant rate of 6% a year. Vandell pays a 35% combined...
Valuation of Merger Target Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million...
Valuation of Merger Target Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt; its beta is 1.45 (given its target capital structure). Vandell has $9.68 million in debt that trades at par and pays an 7.8% interest rate. Vandell’s free cash flow (FCF0) is $1 million per year and is expected to grow at a constant rate of 5% a year. Vandell pays a 35% combined...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT