Using the four NOI calculations and the square footage from the previous tab, calculate what the Highest & Best Use for the investment property.
Assume that the expected return is 12%, and the estimated growth is 3%.
Also assume that the building costs are $100 per square foot.
Data Input Box:
	Office		Retail		Apartment		Warehouse
NOI yr 1	$0		$0		$0		$0
Return or r	0.00%		0.00%		0.00%		0.00%
Growth or g	0.00%		0.00%		0.00%		0.00%
Building Costs	0		0		0		0
HIGHEST and BEST USE ANALYSIS:
			Implied Property Value		Building Costs		Implied Land Value
Use	Year 1 NOI	R
Office	$0	0.00%	#DIV/0!		0		#DIV/0!
Retail	0	0.00%	#DIV/0!		0		#DIV/0!
Apartment	0	0.00%	#DIV/0!		0		#DIV/0!
Warehouse	0	0.00%	#DIV/0!		0		#DIV/0!