Building a portfolio dashboard

[Will Daugherty]

I've seen posts on here from a few years ago about rental portfolio dashboards, but all seem to be inconclusive or suggest a software subscription to have such a reporting tool. I am planning to build a portfolio dashboard for my properties in Excel, and I have a pretty good idea of what I want to see about them individually and combined. I already have an investment analysis workbook built that tells me everything I need to know to make a purchase decision, NOI, COC, ROI, and if the property will achieve the appropriate coverage ratio to be funded. I've been at this a while and have over 70% equity in my combined portfolio, and I'm over 50 years of age, so I don't look at creative financing options. Fortunately, I just call the bank and tell the address of the property I am under contract on, and when I want to close. So, I don't want to expand that tool beyond what it is today.

1) If anyone out there knows of such a dashboard for a small investor (I have 5 commercial leases and 14 residential), please share the information on where I can buy a template.

2) If any of you are interested in working together to develop this tool, I am happy to meet and build a wish list for features that we can divide up the work and complete it faster.  I suspect I can build this in 6 to 10 hours, but it is always helpful to have another brain on the job. 

3) There is an advanced function I would like to build, but sadly I can't recall the mathematical functions necessary to make the calculations.  I would like a payoff planner that helps me navigate the various maturity dates and interest rates of my (15 due in 5) mortgages so that I gain the best financial advantage when paying down principal balances.  If anyone can point me in the right direction for this math, I will see if I can get it built into this dashboard.

Thank you to any who can provide guidance, insight or want to collaborate.