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

There are about 100 copies of Office 2000 (which is the disk you need)
for sale on eBaby but the software costs about $100. I Googled "IRR
Function" and found one site that offers onlince calculations.
Frank

Hey Frank
I found the site for the IRR function too,But I am fairly certain I need
the XIRR function, which I can not find an online tool.Thanks
~Marty~

Marty,
How about this one: http://www.datadynamica.com/irr.asp
There is a way to create an IRR function in Excel but it requires the
"solver" function which you probably don't have.
Frank

Hi group

I found what I was looking for.Maybe this will help all my fellow
feds.Thanks Frank & everybody.

http://www.tsptalk.com/utilities.html

~Marty~

On Apr 18, 6:21 pm, big_rag...[at]webtv.net (Marty) wrote:
- quote -

Marty,

How about this one: http://www.datadynamica.com/irr.asp

There is a way to create an IRR function in Excel but it requires the
"solver" function which you probably don't have.

Frank

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

There are about 100 copies of Office 2000 (which is the disk you need)
for sale on eBaby but the software costs about $100.
I Googled "IRR Function" and found one site that offers onlince
calculations.
Frank

Hey Frank

I found the site for the IRR function too,But I am fairly certain I need
the XIRR function, which I can not find an online tool.Thanks

~Marty~

On Apr 16, 2:08 pm, big_rag...[at]webtv.net (Marty) wrote:
- quote -

There are about 100 copies of Office 2000 (which is the disk you need)
for sale on eBaby but the software costs about $100.

I Googled "IRR Function" and found one site that offers onlince
calculations.

Frank

On Tue, 17 Apr 2007 16:03:47 -0500, big_ragu50[at]webtv.net (Marty) wrote:

- quote -

I don't know if you can install the ATP without the original disk. And you
won't get that with a new computer (unless you purchase the program with
the computer).

Perhaps the person who gave you the computer has the disks?


--ron

Which version of Excel do you have?
If you have Excel 2000, are you sure the prompts for installing the
Analysis Tool Pak say you have to INSTALL Office 2000, or do they say
you need to insert the Disk for that program.
Whatever, it should be available on your original Excel disks. And if
this was an OEM install, your OEM should have sent you the disks with
the computer.
--ron

Hey Ron

Thanks for all your help.The Add On prompt (Anylasas Tool Pack) does say
to insert the Disc for that program.

My old jalopy computer was given to me,so there is no original Excel
disks.I will eventually buy a new computer,but probably not until next
year.

~Marty~

On Tue, 17 Apr 2007 10:46:49 -0500, "Elizabeth Richardson"
<erichktn[at]worldnet.att.net> wrote:

- quote -

Another possibility -- pay via profit sharing plans calculated
quarterly which result in constant monthly plus variable quarterly
contributions to the 401K.

"Mark Bole" <makbo[at]pacbell.net> wrote in message
news:cA4Vh.240$H_.3[at]newssvr21.news.prodigy.net...
- quote -

from my version (Excel 2000; 9.0.2720):
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu.

On Tue, 17 Apr 2007 10:07:29 -0500, big_ragu50[at]webtv.net (Marty) wrote:

- quote -

Which version of Excel do you have?

If you have Excel 2000, are you sure the prompts for installing the
Analysis Tool Pak say you have to INSTALL Office 2000, or do they say you
need to insert the Disk for that program.

Whatever, it should be available on your original Excel disks. And if this
was an OEM install, your OEM should have sent you the disks with the
computer.
--ron

"Mark Bole" <makbo[at]pacbell.net> wrote in message > Most salary-deferral plans, such as 401k, involve predictable deductions
- quote -

At least one reason:

People who are paid at an hourly rate, or who work overtime as non-exempt
personnel have paychecks that vary from pay period to pay period. Most 401k
contributions are a percentage, so the amount contributed will also vary.

Elizabeth Richardson

big_ragu50[at]webtv.net (Marty) wrote:
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

Ron

I cant install it.The prompts state that I need to install Microsoft
Office 2000.I guess if this program is very small, my computer might be
able to install it.Now I have to figure out how to install it.It states
I need the disc.Maybe I will try Office Max.Thanks Ron.If you have any
other ideas,let me know.

~Marty~

Marty wrote:
- quote -

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

On Mon, 16 Apr 2007 14:08:15 -0500, big_ragu50[at]webtv.net (Marty) wrote:

- quote -

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

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~