View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith
 
Posts: n/a
Default Amortization template for uneven monthly payments

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

--
Regards,
Fred


"DOUG ODOM" wrote in message
...
Need an amortization template for uneven monthly payments for multiple years.