All Forum Posts by: Will Daugherty

Jake - I have a sheet I built for an investment a couple of years ago.  I was the underwriting partner, and a 1/3 investor.  This workbook was used to forecast the purchase of 6 lots, build on them, handle loan disbursements at milestones, gantt chart the construction, and show cash flows from operating the homes as short term rentals.  There are probably a few too many tabs in it for you, because there were three partners and the equity arrangements were calculated as well, but I do think it is a decent starting point if you need to build something custom.  The bank liked it quite a bit.  I'm new to the forum, so I'm not sure if I am allowed to post contact info.  Just message me here and I will give you a copy of what I built.

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.