"The sum of the old property's sale price, minus the existing mortgage, and subtracting the closing/selling costs equals the new properties sale price, to the penny."

If the old property sold for $500,000 but had a $400,000 mortgage, and the new property cost only $100,000, I think you're in trouble.