Real Estate Deal Analysis & Advice
Market News & Data
General Info
Real Estate Strategies
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hospitable-deef083b895516ce26951b0ca48cf8f170861d742d4a4cb6cf5d19396b5eaac6.png)
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_trust-2bcce80d03411a9e99a3cbcf4201c034562e18a3fc6eecd3fd22ecd5350c3aa5.avif)
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_1031_exchange-96bbcda3f8ad2d724c0ac759709c7e295979badd52e428240d6eaad5c8eff385.avif)
Real Estate Classifieds
Reviews & Feedback
Updated about 6 years ago on . Most recent reply
![Greg Devlin's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/1223685/1621510384-avatar-gregd100.jpg?twic=v1/output=image/crop=450x450@0x37/cover=128x128&v=2)
What am I missing on this deal?
Most Popular Reply
![Tom Shallcross's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/1059043/1727827493-avatar-toms219.jpg?twic=v1/output=image/crop=2204x2204@0x0/cover=128x128&v=2)
Hi @Greg Devlin - thanks for sharing. Obviously there is more than just the spreadsheet numbers that go into the deal, so just want to call that our so your not overlooking the other attributes that can make/break a good deal. Please then take it one step further to make sure the end result aligns with the personal goals you have set forward. Lastly, ensure you get actuals for the numbers above to validate....
Now that my disclaimer is out of the way :), I've provided my cashflow analysis below. You can use the BP calculators to run these numbers, but below is my quick summary on how I would evaluate the numbers (and correct me if I incorrectly input any of your data):
6,175 - Monthly Rent
(1,499) - Monthly Debt which is rough guess of 75% LTV on 20yr commercial term
(432) 7% Vacancy
(494) 8% Property Management
(235) Monthly Property Taxes
(325) Monthly Insurance
(925) Water
(250) Landscaping/Snow - I added
(550) Heat/Gas
(185) Trash
(100) Repairs
(308) 5% Cap EX
872 Monthly CF
So you're at roughly $100/door and this assumes you don't need to make any upfront renovation to the property (which I would assume you do need to do something). There is a lot more that goes into the equation. If you have a gameplan to decrease expenses, have tenants pay for some of these expenses, or raise rents, your CF and NOI numbers can look much better. At the current purchase price, the CAP Rate is coming out rather high - roughly 9%-11% depending on how you evaluate expenses - which you'd need to compare with other multi's in the area to see if inline. Cash-on-Cash is high as well if running numbers of 25% Down payment.
Long-story-short: If 100/door aligns with your expectations/goals, it works with these conservative numbers. Expenses seem high and if there is a way to meter water and make tenants pay (and check if that is norm in the area) or knock out some of these larger expenses, numbers work much better. If you have some sort of value-add strategy to make increase NOI, go for it but I don't see this as a turn-key purchase.