Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Target Corporation describes itself as an upscale discounter that provides high-quality, on-trend merchandise at attractive prices in clean, spacious and guest-friendly stores. Target has over

Target Corporation describes itself as "an upscale discounter that provides high-quality, on-trend merchandise at attractive prices in clean, spacious and guest-friendly stores." Target has over 350,000 employees and operates over 1,700 stores in the United States. The firm recently opened stores in Canada, andit has an online business component. Target also offers branded proprietary credit and debit cards.

Part A Target Corporation: ROIC

For the fiscal year ending January 31, 2012, Target's EBIT was $5,322,* and its tax rate was 34.3 percent. Its short-term borrowings were $3,786, and its long-term debt was $13,697. In addition, the firm's book value of equity was $15,821.

1.Estimate Target's return on invested capital or ROIC.

2.Compare it with Walmart's. Are you surprised at the difference?

* All amounts related to Target are in millions of dollars, unless otherwise noted.

Part B Target Corporation: ROE

For the fiscal year ending January 31, 2012 (2011), Target had total revenues of (in millions) $69,865 ($67,390) and net earnings of $2,929 ($2,920). Its total assets were $46,630 ($43,705) and its equity was $15,821 ($15,487).

1.Estimate Target's return on equity (ROE) for each of these two years, using the DuPont decomposition to indicate the profit margin, the asset turnover, and the firm's financial leverage.

2.Why has the ROE changed?

3.How would you compare the ROE drivers for Walmart and Target?

Part C Target Corporation: Cost of Capital

According to its annual report, as of January 31, 2012, Target's borrowing costs averaged 4.6 percent, and its tax rate was 34.27 percent. A research report estimated Target's cost of capital at 10.5 percent. The firm had interest-bearing debt of $17,483. Moreover, Target's stock was trading at $50.81 per share, and there were 679.1 million shares outstanding. Now, let's assume Target's amount of debt is also a market value estimate of the debt. Let's also assume the current debt and equity values are at Target's optimal capital structure.

1.Based on market value estimates, what is Target's cost of capital?

2.How does it compare to Walmart's, and what explains the difference?

Part D Target Corporation: EVA

Earlier, you were provided with the information necessary to estimate Target's operating profit (EBIT) after-tax, also known as NOPAT; invested capital (the book value of equity plus interest-bearing debt); cost of capital; and market value of equity. Based on this information,

1.Estimate Target's EVA for the year that ended on January 31, 2012.

2.Was Target adding value?

3.Did Target have a positive market value added or MVA?

4.How did Target's EVA and MVA compare with Walmart's EVA and MVA?

Part E Target Corporation: EV/EBITDA Analysis

Let's suppose you forecast Target's EBIT for the year ending January 31, 2013, to be $5,352, and you forecast Target's depreciation and amortization to be $2,361. A research analyst determines that an appropriate forward-looking EV/EBITDA multiple for Target is 6.9 times. Based on this information,

1.Estimate Target's enterprise value, or EV.

2.Next, incorporating the value of Target's debt, estimate the firm's value of equity.

3.Finally, based on 679.1 million shares outstanding, estimate the intrinsic value per share and compare it with Target's stock price on January 31, 2012, of $50.81.

4.Based on this analysis, is Target's stock overvalued or undervalued?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Management

Authors: Eugene F. Brigham, ‎ Joel F. Houston

11th edition

324422870, 324422873, 978-0324302691

More Books

Students also viewed these Finance questions