Regarding lowering the SP to make the deal work, it's my understanding that lenders calculate the LTV/CLTV on the LESSOR of the contract sales price or appraised value. Therefore if the contract sales price is $800,000 and the appraised value is $1 million, the lender will base their down payment requirement on the $800k, not the $1m.