Simple-interest mortgage: Why tracking payoff is so tricky Irregular payment posting affects interest calculation.

For downloadable spreadsheet that you can use click on the following link. 

Click here for the spreadsheet download