Profitability spreadsheet

[Travis Beehler]

Hello all!

I've posted earlier about a spreadsheet I use to determine profitability of a home that I'm looking at purchasing.  I was soon asked by many people for a link to the spreadsheet.  So, I have decided to put a post up and share a permanent link for the spreadsheet.

Here's a quick rundown of what it does.

Calculates mortgage payment.

Calculates down payment (assumed 25%, but can be adjusted)

Calculates taxes, insurance, property management fees, misc. fees, etc.

It also will take into account maintenance, estimated revenue increases, advertising, utilities, total cash outlays, etc.etc.

At the bottom of the spreadsheet in red is your total net profit or loss.  At the top of the spreadsheet it shows you how much you'll profit per year with and without a property manager.

All fields can be modified to your specific needs.

I got this spreadsheet years ago from someone on the internet and have tweaked it to my needs, so I can't take 100% credit for it.

Hope this helps everyone out!  If you have any questions or issues, please feel free to let me know!

https://www.dropbox.com/s/ea4nz29qq294du8/Bigger%2...

Travis

[Travis Beehler]

It actually looks very similar to the one you talk about here.  I say try them both, see which one works best for you. :)

Travis