I have a series of unequal payments over unequal time periods. I would like
to calculate the compounded interest of these payments. Is there an easier
way than setting this up in a table?

have a look in the help index for financial functions or XIRR

--
Don Guillett
SalesAid Software

"Wahine15" wrote in message
...
I have a series of unequal payments over unequal time periods. I would
like
to calculate the compounded interest of these payments. Is there an
easier
way than setting this up in a table?

To answer your second question, you need to set up a table with each payment and
the date made. Then feed this table to XIRR.

--
Regards,
Fred


"Wahine15" wrote in message
...
I have a series of unequal payments over unequal time periods. I would like
to calculate the compounded interest of these payments. Is there an easier
way than setting this up in a table?

Fred Smith wrote:
"Wahine15" wrote:
I have a series of unequal payments over unequal time periods. I would like
to calculate the compounded interest of these payments. Is there an easier
way than setting this up in a table?

To answer your second question, you need to set up a table with each payment and
the date made. Then feed this table to XIRR.

While I prefer to do it that way, too, the following paradigm works
just fine:

XIRR({-10000,-1000,-2000,30000},
{"1/1/2000","3/4/2001","5/6/2003","10/4/2006"})

You're correct. But you still have to list each payment and each date. I think
the OP was hoping you could specify a count, as in 10 payments of $x, followed
by 14 payments of $y, etc. (as some HP calculators support).

But XIRR isn't that smart.

--
Regards,
Fred


wrote in message
ups.com...
Fred Smith wrote:
"Wahine15" wrote:
I have a series of unequal payments over unequal time periods. I would
like
to calculate the compounded interest of these payments. Is there an easier
way than setting this up in a table?

To answer your second question, you need to set up a table with each payment
and
the date made. Then feed this table to XIRR.

While I prefer to do it that way, too, the following paradigm works
just fine:

XIRR({-10000,-1000,-2000,30000},
{"1/1/2000","3/4/2001","5/6/2003","10/4/2006"})

Fred Smith wrote:
You're correct. But you still have to list each payment and each date. I think
the OP was hoping you could specify a count, as in 10 payments of $x, followed
by 14 payments of $y, etc. (as some HP calculators support).
But XIRR isn't that smart.

I agree: that is a nice feature that I miss (since I use an HP 12C
extensively). But that does not sound like "a series of unequal
payments over unequal time periods", which the OP wrote. I suspect
that the OP was referring to a PV table where she would derive the
discount rate using a binary search. I sometimes resort to that
myself, especiallly when I get tired of trying to find a "guess" that
helps the brain-dead Excel algorithms. But that is neither here nor
there.

Dear Friend,

I could solve your problem, if you could send me a copy of your account
statement to my email address: with all your
requirements.

with kind regards,


--
V. BALASUBBRAMANIAN
------------------------------------------------------------------------
V. BALASUBBRAMANIAN's Profile: http://www.officehelp.in/member.php?userid=4556
View this thread: http://www.officehelp.in/showthread.php?t=1219891

Posted from - http://www.officehelp.in

Dear Friend,

I could solve your problem, if you could send me a copy of your account
statement to my email address: with all your
requirements.

with kind regards,


--
V. BALASUBBRAMANIAN
------------------------------------------------------------------------
V. BALASUBBRAMANIAN's Profile: http://www.officehelp.in/member.php?userid=4556
View this thread: http://www.officehelp.in/showthread.php?t=1219891

Posted from - http://www.officehelp.in

Thanks all. This has been helpful. Think I've got it from here.

"V. BALASUBBRAMANIAN" wrote:


Dear Friend,

I could solve your problem, if you could send me a copy of your account
statement to my email address: with all your
requirements.

with kind regards,


--
V. BALASUBBRAMANIAN
------------------------------------------------------------------------
V. BALASUBBRAMANIAN's Profile: http://www.officehelp.in/member.php?userid=4556
View this thread: http://www.officehelp.in/showthread.php?t=1219891

Posted from - http://www.officehelp.in