However, the new ADU laws in California that went into effect Jan 1 2020 may provide a loophole.As I understand the laws, they say that the city cannot use lot coverage to prevent you from building an ADU under certain circumstances, therefore I wonder if I could do the following:STEP #1: Convert two garages into uncovered carports, causing them to be removed from the lot coverage and bringing our lot coverage well below 45%.

The appreciated value of 95k, will have a new effective cap rate with new buyer.  

Not one of our 3 buyers or 1 seller that were under contract were effected. 

That’s what’s really effecting my score.

We were ready to evict, waiting till March, when the 90 day eviction moratorium by Governor Cuomo went into effect.

The election, by the way, is irrevocable and is not a no-brainer, it could create undesirable side effects.

The snowball effect is real.

I think it's the drugs currently being taken or the linger effects of spending many younger years of life in a self-induced haze. 

Just keep changing that one cell.This eliminates a computationally intensive and messy nested if-then statement that doesn't scale. 

The calculation for calculating NOI for a NNN leased property is a follows:Rental Income+ Reimbursement Income (Tenant reimbursing the landlord for operating expenses)= Subtotal- Vacancy/Collection Loss (% Applied to the subtotal)= Effective Gross Income- Real estate taxes (Typically reimbursed in a NNN lease)- Insurance (Typically reimbursed in a NNN lease)- Maintenance (This will depend on if single-tenant building or multi)- Utilities (Could be nothing is single-tenant building)- Management Fees (Typically reimbursed in a NNN lease)- General/Admin Expenses (Typically reimbursed in a NNN lease)- Reserve for replacement (Tenants do not typically reimburse for this)= NOINOI/Cap Rate = Market Value