I think that you are looking for ipmt.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"lalli945" wrote:

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