Formula to guesstimate the delinquent mortgage balance?

[Brooke T.]

Hello All!

I'm looking at purchasing a property subject to an existing Deed of Trust.(I'm bidding on the second position) The owner passed away in early 2019. There was a Notice of Sale on that DOT posted in February 2020 and subsequently canceled 6 months later. I have ran the amortization at the interest rates for when the loan was originated, and have a good idea of the balance was in early 2019, February 2020, and August 2020 when the Trustees sale was canceled. Does anyone know of a formula to calculate (Guesstimate really) the current balance assuming the mortgage is currently delinquent? I'm not sure how delinquency compounds in amortization? Additionally, If the Trustees sale was canceled, is that reason to believe it was potentially caught up at such time? Called the Trustee to ask, and not surprisingly they were no help. I do know 100% that the second position did not pay the delinquent balance to protect their position. Either the bank just decided to cancel the sale (but why would they do that?) meaning the mortgage is now close to three years delinquent; or possibly an heir or someone caught the payments up, but didn't bother transfer title, and is now letting the second foreclose?? I'm not sure what to make of that but if anyone has a formula to calculate how delinquent payments are compounded, something I could use to get a rough estimate of what the worst case might be that would be FANTASTIC!!! Thank you so much!