Google for "loan amortization " and Excel.

There are plenty of variables to take into account and you will find PLENTY
of examples


"david saddler" wrote:

Loan template for repayment over 101 months showing capital amount and
interest