Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
THE CUMIPMT() IS NOT PRESENT? | Excel Worksheet Functions | |||
THE CUMIPMT() IS NOT PRESENT? | Charts and Charting in Excel | |||
Cannot get CUMIPMT to work in Excel | Excel Worksheet Functions | |||
CUMIPMT #NAME error | Excel Worksheet Functions | |||
CUMIPMT | Excel Worksheet Functions |