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

The Answer is in the image, click to view ...

Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

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

Help me step by step with specific instructions for every step 1 Download and open the file named exploring_e07_grader_h1.xlsx, and then save the Grader Assignment file with the following...

2020 Rental Assumptions Extra Credit Per 10 Unit Type 1 Bedroom 2 Bedroom 3 Bedroom Small Commercial Large Commercial Total Rent /Month $1,600 $2,200 $2,800 $3,200 $4,400 459 Total RSF by Unit Type...

excel project- real estate investment 1.0 Step Instructions Points Possible 0 Start Excel. Download and open the file named Excel Project In the Nor sheet, calculate the Total Rentable Square Feet...

EXCELProject - Real Estate Investment 1.0 Project Description: You are an investor in mixed-use (residential and commercial real estate. You have identified a building as your next investment. Having...

I just need the commands/functions for the questions. Does not have to be the actual answers, just a guide to see if I'm completing this correctly. Thanks! Step Instructions Points Possible 1 Start...

1 Open the Excel the file Student_Excel_Comp_Cap1_Winter_Revenue.xlsx downloaded with this project. 2 On the Idaho Store worksheet, in the range B9:B16, use the Fill Series feature to enter interest...

Base Price Commission Package Tour Description Departure Base Cost $1,699 2.5% 10 Adventures in Canada 2016/6/11 $1,699.00 $1,749 3.0% 20 Check Out the Czech Republic! 2016/6/4 $1,799.00 $1,799 3.5%...

Hi, I need help with this spreadsheet, 29 and 30 do not have to be completed. I appreciate it.Thank You!!! Step Instructions Points Possible Start Excel. Download and open the file named Excel Prest...

N 1 2020 Rental Assumptions Extra Credit 2 # of Units 10 Unit Type Rent/Month 1 Bedroom $1,600 2 Bedroom $2,200 3 Bedroom $2,800 Small Commercial $3,200 Larse Commercial $4,400 Total $14,200 RSF per...

You are required to identify an individual factors affecting green warehousing for investigation in your selected county. Main Body o Introduction of a key construct(s) such as green warehousing,...

Continental Photo, Inc., is a portrait photography company. Alex Riley, a black man, applied for a position as a photographer with Continental. Riley submitted an application and was interviewed. In...

You have an APR of 7 . 5 % with continuous compounding. The EAR is 2 . 2 5 % 7 . 7 0 8 7 . 6 5 % 7 . 5 0 0 5

Discuss the policy statement concept and identify three focus areas / procedures where a clearpolicy statement / operating procedure

Jessie and Ashton had offered Sandra more money to stay in her current role with the company. What problems could have occurred if Sandra had accepted their offer?

How might employers ask employees about components of a total rewards program without creating unrealistic expectations? One answer is to ask employees, although there might be concern that by...

Why do you think Tracey did not care about her benefits? What should Ravi do to ensure that his other employees do not feel the same way? Ravi Singh sat at his desk and wondered what his next steps...