Howdy @Mark Williams
Lots of issues with this analysis. Let me answer your questions first, then, I will provide comments and my own questions.
Billing tenants for owner paid utilities will depend on what is acceptable practices in that area. In some areas owners will use RUBS (Ratio Utility Billing System) to bill back tenants. It is handled through a third party company. Others have added an additional fee to tenant bill.
Any change in rent (including adding utility costs) must be in writing usually with 60 notice. You definitely need to work the rents up to appropriate Market rates. Be sure the property condition is up to the market standards. Annual rent raises is acceptable and encouraged. Just make sure they are reasonable and in step with the area rates. Again, make sure the property condition justifies the raise. Be prepared to cover Vacancies while you are transitioning rent rates. Your projected Vacancy reserves (7%) is too low. I never go below 8.34% (one month rent). There is already one Vacancy. I would not be surprised to see yours higher while you are catching up to the market rates.
Comments on Analysis:
1. This is a Commercial Property (5 plus units). It must be evaluated that way to determine the correct Value using NOI and Cap Rate. It appears you are using the Sellers asking price. Bad mistake! They will always inflate numbers, leave other important information out, all to make the property look as a great deal. How did you arrive at the Purchase price?
2. Since this is a Commercial deal you must use Commercial Financing. The terms are much different than what you have. 25% Down payment is fine. However, the amortization length (30) will be shorter (15 to 25 years). And it will have a balloon payment that will be due in 3 to 7 years. You need to do some research on these type loans.
3. You state the owner pays for the Gas and Water Utilities. You did not include any in your Expenses. What about common area Electric? Are there any security lights?
4. Your CapEx and Repair percentages (3%) are too low. Do you already have Cash Reserves capable of covering any major repairs that may all of a sudden occur? Do you know the current condition of all the properties major components and appliances and their life expectancy? Probably not. I strongly recommend you increase them to 10% CapEx and 5% Repairs until to have accurate information.
5. You did not include Insurance.
6. Who is responsible for Lawn care and Snow removal?
7. You should also add an entry for Miscellaneous expenses (5%) to cover things like Pest management, unit turnover, accounting, Legal, etc.
8. Break down individual unit rent rates. What is the other income ($770)?
Obviously after make the above adjustments you will have different results for Cap Rate, NOI, Cash Flow, CCR, 2% Rule, not to mention the property value.