Valuation Using Price-to-NOA Multiple and PB Multiple

The following table provides summary data for Target Corp. and its competitors, Kohls Corp. and Walmart Stores Inc.

(in millions)	Target	Kohl's	Wal-Mart
Company assumed value	--	$13,255	$251,159
Equity assumed value	--	$9,254	$209,830
Net operating assets	$21,671	$9,492	$124,940
Book value of equity	$12,957	$5,491	$83,611
Net nonoperating obligations (assets)	$8,714	$4,001	$41,329
Common shares outstanding	640.2 shares	186.0 shares	3,262.0 shares

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

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

Wal-Mart Answer

(b) Use Kohls and Walmart as comparables, along with the price to NOA ratios from part a, and then estimate for Target its company intrinsic value, its equity intrinsic value, and its equity intrinsic value per share.

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

(Rounded to two decimal places.)

Use your rounded answer above to calculate the following:

Round company intrinsic value and equity intrinsic value to the nearest million. Round equity intrinsic value to the nearest cent.

Company intrinsic value $Answer

million Equity intrinsic value $Answer

million Equity intrinsic value per share $Answer

(c) Compute the PB ratio for both Kohl's and Wal-Mart.

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

Wal-Mart Answer

(d) Use Kohl's and Wal-Mart as comparables, along with the PB 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

(Round to two decimal places.)

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

million Equity intrinsic value per share $Answer