Do It all tracking tool...

[Pete Fiannaca]

Hey BP Community -

Apologies in advance, but I didn't see a clear cut category to put this post in, so I left it here in a spot that might get some viewership. Not sure if this has come up before, but I'm looking for leads on a portfolio forecasting tool (preferably via Excel). I'll explain.

Wondering if anyone has ever created, or seen, a spreadsheet that allows you to input properties as they are acquired; along with all relevant data like contract price, down payment, taxes, anticipated NOI, etc., and summarizes the individual properties into a "totals" table.

For example, it's easy for me to know what my net cash flow is and equity in property #1 is any any given time. What if though, I want to forecast my total debt, total equity, and total cashflow, 6 years down the road after acquiring 4 or 5 properties. This spreadsheet would obviously need to be pretty complex as it would need to keep a month by month tabulation of monthly payments on each property (assuming a loan) as well as principle being paid down and factoring that into total debt vs. equity, so on and so forth.

I'm hoping that example gets the list across. Again, would like to use it to forecast. Any leads would be great. If no leads, I might venture into making it myself. Pondering if something like that would be useful to others besides myself...

Best,

P