Tim Dailey Note investing was actually one of the concepts I'd never even considered before attending the relevant session this weekend. It sounds to me like something I'll definitely look at once cash is available. Right now I'm not sure how I'd finance a good opportunity in that realm, but I welcome thoughts on that.
Would love to meet up sometime. It's nice to know there are other locals on this forum!
Raymond B. i definitely hope someone takes me up on the offer. Let's face it, everyone has skill sets and while it may be easy for one person to give me a play by play for structuring wholesale deals, that to me still sounds overwhelming. On the other hand, making a dynamic spreadsheet that you can use over and over is something I actually enjoy doing. So please, overwhelm me! :)
Mark Updegraff Thank you sir. I'll say, considering that BiggerPockets was an unknown quantity to me before this, shilling out $250 bucks (I was late to register but thanks to Marty Boardman's video clips I found out about it in time) seemed a bit on the risky side. No regrets here, whatsoever! I hope you can make it to this beautiful city next time!
As for the work I've done, most of the models are deemed proprietary by my clients. Thus I can't just email over a comprehensive model to show how those multi-family forecasts are set up. But they can't stop me from sharing some generalities. And of course I'd be happy to work through a specific version with you as needed.
Basically I structure a multi-tabbed spread sheet to accomodate the following areas:
A summary - it's always nice to have something print-friendly that captures the salient points of your deal for investors (or whomever)
An operations tab - details like units, rates, inflation assumptions, etc.
A finance tab - it seems like every time I work with a new client, three new financing structures materialize. General ones like an interest only loan, mezzanine and some form of equity split are very common for the $10+ million deals.
A tab to show returns (for the various investor categories)
and sometimes a tab for charts, comparable properties, scenario analysis and more.
One thing I've learned is that in the multi-family market, it's usually sufficient to model operating (property management) expenses by assuming certain costs per door (or unit or apartment, etc.) In senior housing, we build in a lot more detail. There are tabs dedicated to human resources (you've got care givers, nurses, marketers and more, all delineated by occupancy demand) along with other detail for the various care-based specializations.
All that to say...if you have a specific scenario, formula, calculation, whatever...let's talk and I'm happy to help you leverage the technology to make life easier.