help please! this is an excel project due tonight.

930 Bridgeport Avenue is a two-story, three-unit building in a desirable urban neighborhood near a large university campus that vou are entertaining purchasing and holding as a long-term investment. It Is currently listed for $235,000 or $78,333 per unit. The first floor contains a 28R/1BA unit rented for $950 per month. The second floor contains two 1BR/1BA units. The front unit has a private balcony and is rented for $750 per month, and the other unit is rented for $700 per month. The seller's representative provided you with historical income data suggesting that the seller has collected about. $35 per month from each tenant in the form of late fees, pet fees, and laundry income. The property also has a detached garage accessible from the alley that one of the tenants currently rents for an additional $30 per month. A local property manager you met at the wedding of a mutual friend who manages several buildings in this neighborhood told you that the rentals rates at the building appear reasonable and that vacancy rates have historically hovered around 5.00% with some seasonable variability around the beginning and end of the fall semester. Historically, rents have increased by about 5% per year, while other income tends to remain flat, increasing maybe 1% per year. As a back-of-the-envelope measure, operating expenses in this market typically run at about 35% of effective gross income