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 almost 5 years ago on . Most recent reply
![Cooper Weisbach's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/1728666/1621515090-avatar-cooperw9.jpg?twic=v1/output=image/crop=1440x1440@0x82/cover=128x128&v=2)
3-Unit Phoenix, AZ Property Analysis
Hey Everyone! My name is Cooper Weisbach.
The property I'm looking to get involved in is a 6-bed tri-plex out in Phoenix. The property is listed for $305,000 but has been on the market for about a month and was originally listed at $335,000. The listing states the owners pay no utilities, the roof was replaced last year, there is a new water heater in one of the units, the AC was just replaced last summer(super important in AZ), and there are no HOA fees. Additionally, the property definitely has good forced appreciation potential.
I looked on Zillow.com and rents in the area are around $1,000 for similar properties. The MLS posting said property taxes for 2019 were $763(The analysis below uses $2K as I was just recently informed of the MLS tax info). I'm not sure what home insurance rates would be so I estimated $2,000 based on a BP post of someone inquiring for a 4-Unit in Scottsdale. In the post, they said a minimum of $1 million coverage was recommended for a 4-Unit. The poster had coverage for $300K @ $1K per month. An agent replied saying that they would triple the coverage to $1 million and it would be a minimal increase in price. I factored in 5% of rent a month for vacancy, 10% for repairs, and 11% for Cap EX. No HOA or utilities are paid for by the owner. Lastly, I did two analyses: one with property management(as Brandon says you don't want to manage forever) and one without(I am looking to gain experience); additionally, I did some best and worst-case scenarios to get a picture of the extremes and I believe this property looks very promising.
For my analyses, I created my own calculator on excel based on a template J. Scott put out. I made some modifications but I do know that the math is correct(triple checked)!
I assumed a $10K for immediate improvements, $5K for closing costs, and $1K for miscellaneous. I looked at the property with rents at $1K for each unit: one for prop management and one without. Then rents at $800 with prop management and one without. I'm assuming a conventional loan with 20% down over 30 years @ 4% and a purchase price of $300k. All cash flows are based on the expenses mentioned above. Thanks a bunch for reading!
P.S. I created an excel calculator because I really want to understand how the math behind the analysis works. I find this helps me get more comfortable and helps build some intuition in terms of being able to gauge the overall picture before doing a complete analysis on the property. Also, thank you to Melanie Johnston of Tru Realty for the help so far. She is a very friendly agent if anyone is looking in AZ!
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1587198341-Screen_Shot_2020-04-18_at_1.23.59_AM.png)
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1587198342-Screen_Shot_2020-04-18_at_1.23.45_AM.png)
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1587198343-Screen_Shot_2020-04-18_at_1.23.09_AM.png)
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1587198344-Screen_Shot_2020-04-18_at_1.22.51_AM.png)
Most Popular Reply
![Paul Welden's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/66750/1621413871-avatar-paulwelden.jpg?twic=v1/output=image/crop=2800x2800@0x0/cover=128x128&v=2)
@Cooper Weisbach
I think min down payment will be 25%
I think your interest rate will be more than 4%.
I found comparable rents at $800/mo. So, I would scrap the $1000/mo scenario.