Loan Amortization Cashflow Tie out

This deals with an fully amortized loan with monthly prepay, default rate, constant severity and recovery lag.

Please check the below excel,

Cashflow