how do you calculate compound interest with multiple payments?

W

Wahine15

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?
 
F

Fred Smith

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

joeu2004

Fred said:
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.
Click to expand...

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"})
 
F

Fred Smith

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

joeu2004

Fred said:
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.
Click to expand...

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

V. BALASUBBRAMANIAN

Dear Friend,

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

with kind regards
 
V

V. BALASUBBRAMANIAN

Dear Friend,

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

with kind regards
 
Top