Excel 2016

In cell E19, enter a VLookup function to calculate the annual base rent for the first unit based on Unit Type. Use the 2018 Rental Assumptions table in your formula and make sure to calculate annual rent. Copy your formula down the column to cell E42.

	2018 Rental Assumptions
	Unit Type	Rent /Month	# of Units	RSF per Unit	Total RSF by Unit Type
	1 Bedroom	$1,500	4	830	3,320
	2 Bedroom	$2,100	10	995	9,950
	3 Bedroom	$2,700	6	1,475	8,850
	Small Commercial	$3,200	3	1,200	3,600
	Large Commercial	$4,400	1	2,100	2,100
	Total		24		27,820