Real Estate Deal Analysis & Advice
Market News & Data
General Info
Real Estate Strategies

Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal


Real Estate Classifieds
Reviews & Feedback
Updated over 10 years ago on . Most recent reply

Good Investment or Look for Another?
Hi! I'm new to this so I'd appreciate help in analyzing this deal. Here we go:
Home: 301 Cline Falls Dr, Holly Springs, NC
Info: Built 2005, 1470 Sq Ft
Purchase Price: $169,900
Downpayment (20%): $33,980
Estimated Monthly Rent: $1,300
Gross Annual Rental Income: $15,600
Mortgage: $8,264.24
Taxes: $1,701
Insurance: $500
Vacancy (10%): $1,560
Repairs and Maintenance (5%): $780
HOA: $996
Monthly Cash Flow: $149.06
Yearly Cash Flow: $1,788.76
Cap Rate: 5.92
Cash on Cash Return: 32.54
Are my estimates reasonable for vacancy, repairs and maintenance?
What do you think of the cash flow, cap rate, and cash on cash?
Most Popular Reply

Originally posted by @Christopher R.:
Is there a quick way to incorporate the CapEx in my spreadsheet? For example, can I compute it as a percentage of the rent? How do you guys normally estimate this number?
The 50% rule includes money for cap ex. I once did a reserve calculation for capital expenses and figured it should be about $1300 a year for a row house in Baltimore. I think that is a pretty conservative number. Now I simply figure about $1500 a year for repairs and capital expenses per Rowhouse. By the end of this year I should have enough history to adjust that number based on our actual results.
Our properties here in Baltimore are often 50+ years old. We took a property that we thought would need little work becuase the tenant seemed quite happy. Only after we acquire the property did she mention that the old landlord had to clean out the drain line every few months. We had an $1800 bill to run a new drain line to the curb because the original was full of roots. The point being older housing stock may have more unexpected expenses.
If you want to build a reserve chart on a spreed sheet it is pretty easy just list all the items down one column, the list how long they will last, then list the prices, then calculate how much is needed per year.
WH - 6 years - $600 =$100/yr
furnace - 10 years - $3500 = $350/yr
Windows - 20 years - $2500 = $125/yr
do this for Roof, flooring, appliances, etc
If you are buying an existing property you can estimate the remaining life of the items. A roof might last 20 years but the roof on your property may only have 9 years of life left.