Hey @Account Closed, I'm pretty familiar with the Laconia, NH market (especially downtown) and would be happy to share some insight. This property is not as promising as you'd hope. I'm going to work my way down your report and provide feedback on each section starting with the "Property Information".
Purchase Price: $265,000 - list price, no comment
Purchase Closing Costs: $5,300 - purchase closing costs + due diligence costs are higher for an 8 unit. Commercial appraisal is around $1500, inspection is around $1000, attorney fees are $2000, transfer tax is $2000, title insurance around $1000
Estimated Repair Costs: $30,000 - you're underbudgeting by a very large factor on this. A quick look at the siding shows that it looks pretty rough... especially on the upper level. If you wanted to vinyl wrap (which would be cheapest) all of the siding going 4 stories up with such narrow spaces between buildings, you'd be looking at least $30K just to do all that... maybe more. The roof is still tar and gravel according to the tax card, so unless that's been replaced very recently, expect to put on a rubber membrane roof (once again, four stories up) in the next five years. This doesn't account for any interior unit renovation... this repair cost estimate should be doubled, if not tripled to account for the deferred maintenance.
After Repair Value: $350,000 - Unfortunately this might not be too generous of an estimate. 4 story apartment buildings with no elevators are not very desirable. The location of this building is also not desirable and the resale value may not be there. I just helped a client buy an 11 unit in the Weirs Beach area of Laconia and that sold for just over $450,000 and that was in as turnkey condition that older buildings could be... in a super location.
FINANCING - Your loan assumptions are should look more like this: "75% LTV , 20 YR amortization, 5 YR term, 5.5% interest = monthly P&I of $1,367.18
RENT - Not sure where $6700/mo is coming from... The current rent roll is: $700/mo, $750/mo, $750/mo, $750/mo, $750/mo, $600/mo, $800/mo (was vacant at the time rent roll was submitted), $750/mo. This totals $5850/mo rents or $70,200/yr gross rents.
EXPENSES - Vacancy (4%): too low. Downtown Laconia is a tough market and considering more than half of these tenants have been in the building less than 6 months, and almost all of the tenants no more than 1 year, its clear turnover is a problem. Vacancy should be at least 10% until stabilized. CapEx (3%): too low. See notes on Rehab Cost Estimates for why this is too low... should be at least 5% + amortizing the cost of any major capital items coming up in the next 5 years. Management (6%): too low. I struggled to find a property manager for my client in his property in Laconia. Best deal I found was 9%... worst was 15%! I'd factor in 9% here. Property Taxes ($3,442): accurate. Insurance: ($2,848): accurate. Repairs (6%): accurate assuming you renovate units as needed with initial rehab. Misc ($8,880): ? I'm assuming this is all of the other expenses which is slightly low. Snow = $600/yr, Heat = $4,929/yr, Electric = $3,343/yr, Trash = $652/yr, Water/Sewer (not listed) = approx. $1500/yr. In total "Misc" should be $11,024.
ANALYSIS -
Gross Rental Income = $70,200
Vacancy (10%) = $7,020
CapEx (5%) = $3,510
Management (9% of effective gross) = $5,687
Taxes = $3,442
Insurance = $2,848
Repairs (6%) = $4,212
Snow = $600
Heat = $4,929
Electric = $3,343
Trash = $652
Water/Sewer = $1,500
Operating Expenses = $37,743
Debt Service = $16,406
Net Operating Income = $32,457
Cash Flow (after debt service) = $16,051 or $1,338/mo
Purchase Price = $265,000
Cap Rate (of purchase price) = 12.25%
Cap Rate (of price + rehab) = 9.55%
Total Cash Needed = $66,250 + $75,000 (rehab costs) = $141,250
ROI = 11.36%
Final analysis - While this property isn't the fantastic homerun deal you hoped, it is still a reasonably good investment assuming your rehab costs (which are just estimates) stay under $75,000 and you can come up with the cash out of pocket to perform all necessary improvements to the property over the next few years. Your actual cap rate (because you have to consider the cap rate of your price + rehab costs) ends up being just over a 9.5 cap. Not bad, but not over the moon. Be wary of any unforeseen issues with the building that might create a lot of rehab cost. Judge this based on the interior of the unit and how much work they need. If they're all in rough shape, then you need to be budgeting $10K/unit to turn them over in addition to all exterior work/systems work needed. Also, take note, if you finance any renovation costs rather than pulling cash out of your pocket, your debt service becomes more expensive and your ROI goes down. The New Hampshire Lakes Region can be tricky for investing sometimes... so be careful where you buy!