View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lalli945 lalli945 is offline
external usenet poster
 
Posts: 2
Default Constant loan payments vs. constant payments of principal

Hi,

I´m looking for a formula/function that calculates loan payments with a
constant payment on the principal (plus intrests on the remaining
principal),not equal payments throughout the loan period (annuitet) like PMT
gives.

In other words, a formula/function that would give me payment that is always
a fixed payment of the principal plus intrests (and the intrests part gets
smaller and smaller as the principal is paid up).

Any help greatly appreciated.

Thanks