Get the missed payments of Loan (no. of days & amounts)

Good day..


What is the formula to get the missed payments of loan (No. of days & Amounts). Attach is a sample file -->> SampleFile.xlsx

Hope someone can help me.

Thanks in advance.



Me `o-'

if i got it
PS rate is too high for PMT