CUMIPMT

[David]

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,

 

[Duke Carey]

The total interest paid to maturity would simply be

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

 

[David]

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.

--
David

The total interest paid to maturity would simply be

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

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,

 

[Duke Carey]

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,

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.

--
David

The total interest paid to maturity would simply be

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

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,

 

[David]

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.
--
David

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,

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.

--
David

The total interest paid to maturity would simply be

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


:

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,