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. 

[Bob Schulte]

Hi Will,

Your portfolio dashboard idea sounds like a solid plan! But instead of spending 6–10 hours building it from scratch, you might want to check out Bryt Software.

It has built-in spreadsheet reports that track NOI, COC, and ROI, plus custom reporting options if you need to track any personalized metrics. And if you're stumped on recalling the exact mathematical functions for your payoff calculations, Bryt's Payoff Calculator can handle the math for you.

There are also other options like Stessa and DealCheck, both built for real estate investors. They offer automated financial reporting and dashboards that track cash flow, expenses, and ROI, so you don't have to update spreadsheets manually.

I hope this helps. If you end up building your own, I’d love to hear how it turns out!