Ongoing Investment Analysis for Owners?

[James Haywood]

Hey all, 

I own a bunch of my own properties, but I do manage properties for other owners as well.   I think BP and a lot of the internet is full of pre-buying Real Estate analysis.  As in, there are a bunch of calculators and Excel spreadsheets out there that will project or estimate if the deal is a good buy.   BUT I don't feel like there is really anything out there to CONFIRM or AFFIRM that you made a good purchase. 

I have demo'd and used various Property Management software over the years.  They all do really solid accounting.  Cash flow / Balance sheets / etc. 

Most of them do not really analyze your piece of property. Metrics like Cash-on-cash return, ROI, NOI, Net Worth, Loan-to-Value.... these things change every month, every year.

As a property manager AND owner, I want to be able to look at my properties each year and see where I am at.  Similar to a stock portfolio.  Stocks are easy because you can pretty easily see... "Oh, I made 8% return this year on my investment."   But how do we do this in real estate without manually calculating things.  

I have used Stessa, which is great, but it doesn't connect to my PM software.  So I need to manually upload everything and categorize it.  It's tedious.  At that point, I'd rather just have a pre-built excel sheet I open once a year and type in my years'  expenses and income. 

Anyone have a spreadsheet like that?  Or maybe a software like Stessa with an open API I can work with?  Or another solution?  Again, not a PRE-buy analysis... but an ongoing one.

I'd be open to buying a spreadsheet of this magnitude.  Ha!