CUMIPMT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 22 Aug 2006 18:47 GMT

Hi Group,

The Cumipmt function returns the cumulative interest paid given a set
interest rate, principle, periods, type and the time period you want to
cover. Does anyone know the algebra behind the function? And I am not realy
interested in "between" periods, but would be happy with the total paid to
maturity date. I was hoping to find a single formula like X= (1+i)^(n-1) or
somthing similar.

Thanks,

Signature

David

Reply to this Message

Duke Carey - 22 Aug 2006 19:42 GMT

The total interest paid to maturity would simply be

[pmt amount ] * [# pmts] - [principal amount]

> Hi Group,
>
[quoted text clipped - 6 lines]
>
> Thanks,

Reply to this Message

David - 22 Aug 2006 20:34 GMT

Hi Duke,

This would work, but I would need a similar formula for the principle amount
and I am tryng to not use an excel function, but the underlying mathimatical
function. Thank you for your thoughts.

Signature

David

> The total interest paid to maturity would simply be
>
[quoted text clipped - 10 lines]
> >
> > Thanks,

Reply to this Message

Duke Carey - 22 Aug 2006 21:14 GMT

See the formulas at this site - perhaps you can work with them to get what
you want

http://www.arachnoid.com/lutusp/finance.html#tutorial

> Hi Duke,
>
[quoted text clipped - 16 lines]
> > >
> > > Thanks,

Reply to this Message

David - 22 Aug 2006 22:23 GMT

Thanks again Duke, but none of these finds the cumulative interest paid. I
have looked via google and come pretty close on it, but not quite right. That
is how I ended up here, thought someone might know the correct formula.

Have a good day.

Signature

David

> See the formulas at this site - perhaps you can work with them to get what
> you want
[quoted text clipped - 21 lines]
> > > >
> > > > Thanks,

Reply to this Message