BP has various tools to help you analyze your deals (rentals, flips, wholesale, etc). : https://www.biggerpockets.com/investment-calculators7.

Are there any tools/strategies to calculate a high appreciation market vs high cash flow market?   

It makes sense they do that for safety reasons but how frustrating for you! 

They just need the tools to handle the distressed conditions. 

There are no other safety concerns or visible signs of the fire left intact.

We can review creative finance options and a few up&coming trends like MTR's with tools like pad split, etc.

I've been looking at opportunities from investment firms like Open Door Capital, et al, and I would like to know if anybody has a recommendation for a spreadsheet or tool for analyzing these deals?

Don’t fall for his free real estate calculator or any of his other free tools—many real estate gurus use the same tactics.

I think "what about my wife and kids" and their safety.

Also, put any repairs pointed out by the inspector into the following categories (by priority)1) Health & Safety - to avoid tenant injury and potential lawsuits2) Property Preservation - to stop further costlier damages3) Government Required - city inspection repairs & S84) Marketing Negative Impact - who'll rent a house with purple bedrooms?