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

[Chad Olsen]

@Pete Fiannaca I'm actually working on building this up for myself right now. I've gotten a good portion of what you are talking about into my sheets, but not the forecasting and mortgage stuff yet. I do have plans for including things like that as well as actual income and expenses so as to calculate the volatility of a given property and portfolio. I would recommend that you also look to incorporate reserves, break even ratio and debt coverage ratio at a minium into your analysis. These are my key metrics for purchasing rental properties.

Feel free to reach out.