Amortization template for uneven monthly payments

F

Fred Smith

You're probably better off to "roll your own" amortization table. You need four
columns: Date, Payment, Interest, Balance.

Interest = Balance from previous row * Interest Rate / 12
Balance = Previous Balance - Payment + Interest.

Copy down until Balance = 0
 
Top