Rental Property Staus-January Cost of Number of Rent Profit Occupied Property Address Rooms Maintenence 528 Ivy Court 1 350 125 Yes 395 4th Street South 4 1200 275 Yes 147 Cross Street 900 225 Yes 787 8th Street 600 2 150 No 97 Walnut Street 2 600 150 No 966 B Street 3 900 225 Yes 836 Pleasant Street 1200 275 No 782 Andover Court Yes 1 350 125 530 Woodland Drive 1 350 125 Yes 702 Tanglewood Drive 3 900 225 Yes 127 Linden Avenue 3 900 225 No 395 Lake Avenue 2 600 150 Yes Carl's Campus Rentals Cost of Deposit Rooms Rent Maintenence $1,200 $900 $600 $275 4 $450 $225 $600 $300 $150 2 $350 $200 $125 1 In column E, use the IF Function to calculate profit. If the property is Occupied, then profit will equal Rent minus Cost of Maintenance. If the property is not Occupied, then the profit will equal 0