"The final rules are the result of several months of advocacy and collaboration between NAR, our members, and the administration," says NAR President John Smaby.

Assuming the following, I don’t understand why the bank would care..1) I have 10-15% of my own capital in2) they have 80% LTV3) debt service and all other relevant ratios are in good order If my note with the seller gets forgiven it only enhances the banks position. 

Would anyone be willing to collaborate and assist me in modifying the spreadsheet.

They provide disclosures to you, hold the tenant / buyer accountable for their commitment in following the customized credit enhancement action plan.3.

It won’t be a total loss since I own a second home adjacent to the lot and part of the reason for the purchase was to enhance the water view and allow a dock to be built which needed permission from the adjacent owner (me) to build within the setbacks.

But not implementing the MOST requested feature enhancement in 3 years is inexcusable and unacceptable. 

Any BP Stats PhD's out there that want to collaborate for fun and profit?

However if you can look at longer time horizon and become a buy and hold investor who occasionally sells a property then 1031 exchanges can be the most powerful tool in your arsenal for tax relief and enhancing ROI

Using an artificially enhanced 2005 value to justify making a sound investment decision in today's real estate climate holds no water.I congratulate you on your success.

Be prepared that this process also requires major collaboration of your tenants.