need loan template that automatically calcs late fee
 

I'm trying to find a loan template that will allow me to enter payments made
by date and automatically calc late fee and new balance. Late fee is 5% of
payment due but the payment due changes with each late payment.