Hi Michelle,
Happy to help you walk through the analysis on this! I made a copy of the rental analysis template my business uses: Michelle's Rental Analysis
On the surface, the deal seems to have tight, if not negative cashflow. Feel free to play with some of the numbers that I was guessing on. For example, I took a swing at a 5% interest rate, 30 year term for you $168,000 loan. You can make adjustments to that to see how it influences the figures.
Some other numbers to keep in mind:
- I put vacancy at 0% because of your guaranteed rental income
- I have a 5% allowance for property management and repairs/ maintenance.
- I put in some initial numbers for property tax/ insurance. You will need to adjust this based on the property. This was a complete guess.
- Water and Sewer was a guess as well.
- Sanity check in any of the other categories...some may be zero...but some may not be.
Based on the numbers currently in (which will change), the deal seems to have a poor cap rate, negative cashflow, and all in all a relatively bad deal. The only potential upside you have is the expectation that the property will appreciate quickly and you will be able to sell for significantly more than you purchased for.
Please let me know if you have any specific questions and/or if you need help working through the analysis.