#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,560
Default CUMIPMT

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default CUMIPMT

The total interest paid to maturity would simply be

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


"David" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,560
Default CUMIPMT

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


"Duke Carey" wrote:

The total interest paid to maturity would simply be

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


"David" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default CUMIPMT

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

"David" wrote:

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


"Duke Carey" wrote:

The total interest paid to maturity would simply be

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


"David" wrote:

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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,560
Default CUMIPMT

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


"Duke Carey" wrote:

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

"David" wrote:

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


"Duke Carey" wrote:

The total interest paid to maturity would simply be

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


"David" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
THE CUMIPMT() IS NOT PRESENT? EXCEL FINANCIAL Excel Worksheet Functions 4 April 21st 06 12:58 AM
THE CUMIPMT() IS NOT PRESENT? EXCEL FINANCIAL Charts and Charting in Excel 2 December 20th 05 07:16 AM
Cannot get CUMIPMT to work in Excel Norbert J Excel Worksheet Functions 5 June 18th 05 08:33 PM
CUMIPMT #NAME error Steve @ Keane Excel Worksheet Functions 3 April 27th 05 03:25 PM
CUMIPMT Dorlon Excel Worksheet Functions 1 February 14th 05 04:49 PM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"