Profitability spreadsheet

3 Replies

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

What all does it do that the "Real Estate Calculator" here on BP doesn't?

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

Free eBook from BiggerPockets!

Ultimate Beginner's Guide Book Cover

Join BiggerPockets and get The Ultimate Beginner's Guide to Real Estate Investing for FREE - read by more than 100,000 people - AND get exclusive real estate investing tips, tricks and techniques delivered straight to your inbox twice weekly!

  • Actionable advice for getting started,
  • Discover the 10 Most Lucrative Real Estate Niches,
  • Learn how to get started with or without money,
  • Explore Real-Life Strategies for Building Wealth,
  • And a LOT more.

Lock We hate spam just as much as you

Join the Largest Real Estate Investing Community

Basic membership is free, forever.