@Terri Never I'm not sure where you got this purchase price. It is currently up for auction with local auctioneer Pamela Rose. Starting bid is $850,000. There are things on your report that I believe are unrealistic:
Loan terms: this looks like a residential loan. I don't think you'll find 30 yrs @5% for a commercial loan. Loan points and closing costs seem low as well.
Expenses: When I looked at the auction material, they did not specify any operating expenses beyond taxes. In that case, you have to make some broad and conservative assumptions to protect yourself. If you overestimate, then that's a bonus, but you don't want to underestimate.
- Vacancy: This is a C-ish area, I would give it north of 10%, maybe 11% or 12% as a realistic long-term vacancy rate. They say it's 100% filled currently, but you have no idea what their long-term numbers are.
- Capex: If you're doing repairs upfront, then you might get away with your 5% number but again I would go more conservative with 10%
- Water & Sewer: This is 19 units. Maybe $40 per unit = $760/mo
- Insurance: I have no idea, I don't own any apartment buildings.
- Property Taxes: Auction Brochure states $8,042/half = $1,340/mo
- Repairs: OK
- Electricity: You'll need additional information on who pays utilities. Auction materials do not specify. If it's included in rent, which I suspect it is because those stated rents are kind of high, in my opinion, for the area. Unless you find out for sure that electric is a tenant expense, I would give it $70 per unit per month, or $1,330.
- Garbage: I assume an apartment that size has a dumpster that needs picked up every week or so, you'd have to call somewhere to get a quote.
- Property Management: You don't have this in your model, but the auction materials note that it is professionally managed. Interpret that to mean they have a contract that you will at least have to honor until it runs it's course. Assume 10-12%.
With all those things considered, that should put you toward a more reasonable cap rate. Hope this helps.