The Cash Flow Analysis for Our Rental Property at Year End 2012

Rental Property Cash Flow Analysis ReportAll has been pretty quiet on the rental front. Our tenant is paying on time and reporting no issues. Be sure to scan the real estate category of this blog to see our history with this rental property.

Today I thought I’d share the cash flow analysis of our first six months (ending December 31, 2012). We moved out of the townhouse (aka purchased it for rental on July 1, 2012). We rented it out on August 15, 2012 and have maintained the same tenant.

Cash Flow Analysis

Rent Collected

$500.00 Holding Deposit
387.50 August Rent (prorated, less holding deposit)
1,775.00 September Rent
1,775.00 October Rent
1,775.00 November Rent
1,745.00 December Rent (less tenant repairs)

Total Rents Collected $7,957.50

We also collected a $1775.00 security deposit, which I’m not including in my calculation. Those paying attention all along will notice that my rent is $25 higher than I previously estimated. So that’s a win.

Expenses Paid

$5,054.22 Mortgage Payments for 6 Months
1,602.71 Property Taxes (pro-rated for 6 months)
1,069.00 HOA Dues for 6 Months (includes $19 in late fees)
210.50 Repairs Before Move-In
75.00 Repairs After Move-In Inspection Form Completed

Total Expenses Paid $8,011.43

I didn’t make an insurance payment in the last half of 2012 so that didn’t pop it’s ugly head up on this report. But it will for the 2013 report, of course.

The late fees on the HOA dues are of course a pain in the rear. My fault totally there. For some reason when I switched the payment coming from Capital One 360 to Chase (where our real estate checking account is), the HOA company didn’t like the payments. I’ve since corrected the issue, but due to some negligence I’m out the $19. Oh well, could have been worse I guess.

Total Cash Flow -$53.93

I’d say we made it through the first six month period quite nicely given that we didn’t have a tenant for one and a half months. I’ve got my current tenant on a two year lease so we should have a solid 12 months of rent to collect in 2013, with roughly the same expenses (plus, the insurance I mentioned above). The report for 2013 should be cash flow positive in the $2,000-$4,000 range.

As a bonus, the tax loss on this property is going to be pretty substantial for 2012 with first year depreciation and all of these expenses to include. It should end up helping us quite a bit in reducing our taxable income. I look forward to sharing that report with you soon.

What are your thoughts on the cash flow report? Does this make you more or less interested in buying a rental property? Do you think I have a good investment on my hands? Or do you see it as a wash, and better than having sold the place for a loss?




Last Edited: February 23, 2013 @ 12:27 pm
About Philip Taylor

Philip Taylor, aka "PT", is a husband and father of two. He created PT Money back in 2007 to share his thoughts on money and to meet others passionate about managing their finances. All the content on this blog is original, and created or edited by PT. Read more about Philip Taylor, and be sure to connect with him on Twitter, Facebook, or view the Philip Taylor+ Google profile.

9 comments
MJTM
MJTM

Does your mortgage include principal payments? or is it an interest only?

 

If it is a fully amortized loan then you are probably asset positive

Philip Taylor
Philip Taylor moderator

 @MJTM It's a standard 30 year fixed loan. So you take the principal payments out of your cash flow analysis?

Yakezie
Yakezie

 @Philip Taylor  @MJTM Probably best to leave principal in as it's more conservative and can't easily be extracted.

Pennysaver Pam
Pennysaver Pam like.author.displayName 1 Like

I think investing in rental property is a wise decision.  And it looks like it won't take long until it is profitable for you. My husband and I would love to rent out property in the future as well as we think it's a good way to diversify our investments, instead of having everything in mutual funds, etc.  Glad things are working out for you so far.

BillyMurph
BillyMurph

@ptmoney Is that your first one? How have you enjoyed it so far? Does it make you more/less interested in doing more?

bidzbuzz
bidzbuzz like.author.displayName 1 Like

This is great Phil:-)  I will pass it onto my son who has a basement suite rented out.....

I'm sure he will find it interesting

HullFinancial
HullFinancial

Personally, I aim to have a little more cash flow in my properties, as the insurance will drag you down a little further and you'll probably continue to have some maintenance costs. Still, if you can be pretty close to CF breakeven pre-tax, then you'll wind up in the good when it's all said and done, since you're not having to bump into the standard deduction for mortgage interest given that it's a rental. It's a heck of a lot better than selling for a loss. If you can hold onto it (and keep it rented out) long enough, then you'll either a) pay off the mortgage and have nice positive CF, or get back to at least breakeven on the capital gain of the sale.

 

A potential topic to cover, if you haven't already, would be the depreciation recapture rules on the sale of a rental property. A lot of people aren't aware of it and certainly don't understand it.

Philip Taylor
Philip Taylor moderator

 @HullFinancial What have you found is your vacancy rate across your properties? Obviously I was affected by the 1.5 months (effectively 3 months if you extrapolate) vacancy. I'm hoping to improve upon that in 2013 and see a nice positive cash flow.

 

Now don't go giving me work to do. I studied those rules once, but you know I've since forgotten them. Seriously, thanks for the push.

HullFinancial
HullFinancial

 @Philip Taylor On the Virginia property, our vacancy is 14%. We refused to let pets and opened it up in the late fall, when few people were looking to rent - or, at least, few people without pets. In our Texas properties, the rate is a touch below 8%. We have a great property manager who keeps them filled, and a great working relationship with her where she birddogs properties for us and has renters lined up as soon as we can close on the property and get it into move-in condition.