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