Valuation Using Income Statement Multiples The following table provides summary data for Target and its competitors, Kohl's and Wal-Mart.
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 $322,123 Company assumed value Equity assumed value $13,487 $10.922 $272,541 NOPAT $3,260 $980 $8,312 Net income $2,937 $801 $6,670 Net nonoperating obligations (assets) $11,340 $2,565 $49,582 Common shares outstanding 510.9 shares 159.0 shares 2,844.0 shares (a) Compute the price to NOPAT ratio for both Kohl's and Wal-Mart. Round your answers to two decimal places. Kohl's 13.76 Wal-Mart 38.75 (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 26.26 (Round to two decimal places.) Use your rounded answer above to calculate the following: Intrinsic value $ 48,087.27 x million Equity intrinsic value $ 74,261 Equity intrinsic value per share $ 75.11 x million x (c) Compute the price to net income ratio for both Kohl's and Wal-Mart. Round your answers to two decimal places. Kohl's 13.64 Wal-Mart 40.86 (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 27.25 (Round to two decimal places.) Use the rounded average calculated above to calculate the following: Equity intrinsic value $ 80,028 X Equity intrinsic value per share $ 156.64 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 $322,123 Company assumed value Equity assumed value $13,487 $10.922 $272,541 NOPAT $3,260 $980 $8,312 Net income $2,937 $801 $6,670 Net nonoperating obligations (assets) $11,340 $2,565 $49,582 Common shares outstanding 510.9 shares 159.0 shares 2,844.0 shares (a) Compute the price to NOPAT ratio for both Kohl's and Wal-Mart. Round your answers to two decimal places. Kohl's 13.76 Wal-Mart 38.75 (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 26.26 (Round to two decimal places.) Use your rounded answer above to calculate the following: Intrinsic value $ 48,087.27 x million Equity intrinsic value $ 74,261 Equity intrinsic value per share $ 75.11 x million x (c) Compute the price to net income ratio for both Kohl's and Wal-Mart. Round your answers to two decimal places. Kohl's 13.64 Wal-Mart 40.86 (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 27.25 (Round to two decimal places.) Use the rounded average calculated above to calculate the following: Equity intrinsic value $ 80,028 X Equity intrinsic value per share $ 156.64
