Calculate Balance of Mortgage Loan At the End of the Current Term

It’s so easy.

=FV(P24, ROUNDUP(DATEDIF(P16, P15, "d") / (365.25 / P19), 0), P23, -O30)