Rents there are 3 tenants, each occupying 100,000 Sf. Each tenant pays rent of $20 Sf/Yr. Costs are as follows: Insurance costs are $1.00 Sf/XLpaid at the end of the year. Common area utilities are $1.50 Sf/Yr. Repairs and Maintenance is $0.75 SF/Yr. There is also a management fee equal to 2% of total revenue. 

Required:

Create an Excel Spreadsheet to demonstrate Rents, Costs.

Calculate the NOI.