XIRR Function


M

Marty

My computer is too old to download the XIRR function in Exel to
calculate quarterly returns from contributions made at irregular
intervals & amounts to my 401k.

Does anybody know of a online tool or calculator that can be used by
plugging in the contribution amounts & dates? Thanks

~Marty~
 
Ad

Advertisements

R

Ron Rosenfeld

My computer is too old to download the XIRR function in Exel to
calculate quarterly returns from contributions made at irregular
intervals & amounts to my 401k.

Does anybody know of a online tool or calculator that can be used by
plugging in the contribution amounts & dates? Thanks

~Marty~
Too old?

I don't know about a web site, but XIRR has been part of Excel for ten to
fifteen years. I know it was part of Excel 4.0 (1992) It doesn't have to
be "downloaded" but is part of the Analysis Tool Pak that has been
distributed with Excel.

If you look at HELP for the function, you will see instructions as to how
to install it.
--ron
 
Ad

Advertisements

M

Mark Bole

Marty said:
My computer is too old to download the XIRR function in Exel to
calculate quarterly returns from contributions made at irregular
intervals & amounts to my 401k.

Does anybody know of a online tool or calculator that can be used by
plugging in the contribution amounts & dates? Thanks
No, but straight-line depreciation of the percentage of your computer
used for supporting investment income is potentially deductible on your
personal 1040 Schedule A, subject to 2% AGI floor.... maybe time to buy
a new computer?

Never heard of "downloading" the XIRR function... what version of Excel
are you running?

Most salary-deferral plans, such as 401k, involve predictable deductions
from your paycheck... is there some reason why you are making
"irregular" contributions to your 401k?

-Mark Bole
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top