All of their fortune 500 companies seem to have business models that will have trouble sustaining any real growth against new tech.

The nuts and bolts of putting together an Excel model?

Happy to share my excel model and my approach.

This is still a very tricky area for lenders as there are not many "industry-standard" tried and true rules - many DSCR Lenders and buyers of these loans are still wary of the SRO model - that being said, it is a lot easier and more flexible to underwrite on an acquisition if you are buying and the property could be utilized as a LTR / MTR or STR as that allows for a more tailored projection (as long as the property doesn't have unique or altered characteristics that would require it to be a SRO / MTR)

For me below is a short list, but bear in mind that my specific STR investment model is 'vacation house for free'. 

We modeled out at various nightly price points using 50% occupancy and the property would likely provide a nice return.

@Noah Condon unfortunately you can't use the 1031 for a pure flipping model. 

Multifamily syndicators many pausing distributions so investors getting hosed on those for years and now they seek safety.What's awesome about investment credit grade tenant is what you model out is typically what you get.

It is common that you would have to do floodplain modeling but then be able to build your site as long as your finished floor is above the 100-yr floodplain elevation. 

I am using the latest software to manage my business, including Houzz Pro and Hover, both providing imaging technology to scan and measure homes while providing 3-D modeling technology accurately.