ISO Complex Amortization Schedule

[BNR_ 1980]

I am in search of a complex Amortization Schedule.
Loan has Prime Payment changes (floating rate) with monthly payment changes. I will be running the am schedule to audit a payment change mid stream on the loan. This would be a term loan with regular P&I payments.

I need a way to enter outstanding accrued interest that has accrued since the last payment date which would also account for rate changes in the last month or principal reductions.

Also I need a way to enter if the maturity date is different then the due date on the loan. Example due date the 1st and maturity date the 20th.

Thanks! Nancy

 

[gaz_chops]

Welcome to the forum, best to start with posting a sample of your data using the XL2BB option, showing what you data layout is and also show what you need help with and what answers you expect.