Constant loan payments vs. constant payments of principal
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
|