Need help with #VALUE! error

Hi All

I posted this earlier but now it's too far down the forum to get answered. Attached is a sheet I downloaded to which I added columns starting with K. I believe that something is preventing the values in columns D, E, and I from being read as numbers once the loan is repaid. From that point forward VALUE errors are returned.

Can it be fixed?

Thank you

Charlie