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?   

They just need the tools to handle the distressed conditions. 

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.

They're great at generating leads for your pipeline, not as great at appointments.3) Make sure they have the right tools, the right dialer and data are super key.

Partner with Other Investors: One option is to collaborate with other investors or partners who might be willing to put up the EMD in exchange for a portion of the profit.

This makes it an essential tool in the capital structure, particularly in challenging financial circumstances.Overall, while both Mezzanine Debt and Preferred Equity have their unique benefits, the choice between them should be guided by the specific needs of the project and the financial goals of the investors.

Hey I also tool Richard Garcias masterclass/mentorship.