But what if you discovered all the bad stuff during due diligence and the seller does not want to lower the price to cure these deficiencies?

Ya, I'd argue that if you can't even use excel properly for something as simple as a small multifamily Pro Forma, you probably aren't very capable when it comes to analysis, and an online calc isn't going to patch that deficiency. 

This virus has revealed all the cracks and deficiencies of their system.  

As far as being able to "requalify" her you can't do that, but you can still attempt to accumulate this info yourself for the future if you need to pursue a deficiency judgement.

Those deficiencies are very obvious. 

One concern I have is that if the appraisal comes in low,/i want the option to re-negotiate the price without risk of being put in the position of paying the deficiency or loosing my earnest money.

There are different "flavors" of appreciation; when you purchase a distressed property below market value and repair it's deficiencies to bring it back up to a realistic, non-distressed, retail market value (ARV) in a matter that costs you less than the value you added, that is NOT speculating IMO.

Not only kick the tires, but take a dive into the inner workings, once under contract order a home inspection a completely neutral opinion, my opinion is you want to know everything there is to know in advance, have the turnkey provider complete a Removal of Contingency Addendum during the purchase process for any deficiencies defined in the home inspection.3) Absolutely challenge the PM f you go Turnkey your provider is a one stop shop, they offer the asset from the starting line and manage , you get the supreme level of accountability.

Her response was that as per the lease the tenant was responsible for utilities and that it would have been the tenant's responsibility to have a plumber inspect the property, remedy any deficiencies, and obtain the certificate of compliance.

(See attached Exhibit A – Corporate Map)One of these corporations, Integrity Funding Group/Marycrest Development, has a large financial lenderwho has obtained a deficiency judgment which relates to real estate properties in which the Debtor was apersonal guarantor.Debtor has filed this Chapter 11 case in order to reorganize his financial affairs and make payments to hispersonal creditors to the best of his financial ability.