software

I've been looking for an Excel s/s that will perform financial ROI's,
including periodic additons/withdrawals, such as the online app found at
cgi.money.cnn.com/tools/retur...returnrate.jsp.

I've searched high and low to no avail.

I want this app for a website that tracks investments for its users for a
particular 401 sort of pension plan.

Thanks!!!

On Mon, 2 Jan 2006 12:11:28 -0600, quot;Frankquot; gt; wrote:

gt;
gt;I've been looking for an Excel s/s that will perform financial ROI's,
gt;including periodic additons/withdrawals, such as the online app found at
gt;cgi.money.cnn.com/tools/retur...returnrate.jsp.
gt;
gt;I've searched high and low to no avail.
gt;
gt;I want this app for a website that tracks investments for its users for a
gt;particular 401 sort of pension plan.
gt;
gt;Thanks!!!
gt;
gt;

You could certainly set one up using the XIRR worksheet function.
--ron

I believe the reason you haven't found anything is that the programming for this
is so simple, people just do it themselves. All you need to do is enter a column
of the cash flows, with a corresponding column of dates, and feed this
information to XIRR.

If you don't want to develop your own spreadsheet, most people would use Quicken
or Money as a preferred alternative. You can pick up previous versions for under
$30 on eBay.

--
Regards,
Fredquot;Frankquot; gt; wrote in message
...
gt;
gt; I've been looking for an Excel s/s that will perform financial ROI's,
gt; including periodic additons/withdrawals, such as the online app found at
gt; cgi.money.cnn.com/tools/retur...returnrate.jsp.
gt;
gt; I've searched high and low to no avail.
gt;
gt; I want this app for a website that tracks investments for its users for a
gt; particular 401 sort of pension plan.
gt;
gt; Thanks!!!
gt;
gt;
gt;
I should have mentioned I'm using Excel 2000. I did the analysis pak add-in
and have tried the xirr, but can't get it to work, no matter how I enter the
dates. I tried even using the DATE function to list the dates but to no
avail. When I check microsoft, I find xirr referred to for Excel 2003 but
not for Excel 2000. Does XIRR not work in Excel 2000?

Thanks!!quot;Fred Smithquot; gt; wrote in message
...
gt;I believe the reason you haven't found anything is that the programming for
gt;this is so simple, people just do it themselves. All you need to do is
gt;enter a column of the cash flows, with a corresponding column of dates, and
gt;feed this information to XIRR.
gt;
gt; If you don't want to develop your own spreadsheet, most people would use
gt; Quicken or Money as a preferred alternative. You can pick up previous
gt; versions for under $30 on eBay.
gt;
gt; --
gt; Regards,
gt; Fred
gt;
gt;
gt; quot;Frankquot; gt; wrote in message
gt; ...
gt;gt;
gt;gt; I've been looking for an Excel s/s that will perform financial ROI's,
gt;gt; including periodic additons/withdrawals, such as the online app found at
gt;gt; cgi.money.cnn.com/tools/retur...returnrate.jsp.
gt;gt;
gt;gt; I've searched high and low to no avail.
gt;gt;
gt;gt; I want this app for a website that tracks investments for its users for a
gt;gt; particular 401 sort of pension plan.
gt;gt;
gt;gt; Thanks!!!
gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Ah! Got it! Forgot to properly format the results cell.

Thanks for the insights!!

quot;Frankquot; gt; wrote in message
...
gt;I should have mentioned I'm using Excel 2000. I did the analysis pak
gt;add-in and have tried the xirr, but can't get it to work, no matter how I
gt;enter the dates. I tried even using the DATE function to list the dates
gt;but to no avail. When I check microsoft, I find xirr referred to for Excel
gt;2003 but not for Excel 2000. Does XIRR not work in Excel 2000?
gt;
gt; Thanks!!
gt;
gt;
gt; quot;Fred Smithquot; gt; wrote in message
gt; ...
gt;gt;I believe the reason you haven't found anything is that the programming
gt;gt;for this is so simple, people just do it themselves. All you need to do is
gt;gt;enter a column of the cash flows, with a corresponding column of dates,
gt;gt;and feed this information to XIRR.
gt;gt;
gt;gt; If you don't want to develop your own spreadsheet, most people would use
gt;gt; Quicken or Money as a preferred alternative. You can pick up previous
gt;gt; versions for under $30 on eBay.
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt; Fred
gt;gt;
gt;gt;
gt;gt; quot;Frankquot; gt; wrote in message
gt;gt; ...
gt;gt;gt;
gt;gt;gt; I've been looking for an Excel s/s that will perform financial ROI's,
gt;gt;gt; including periodic additons/withdrawals, such as the online app found at
gt;gt;gt; cgi.money.cnn.com/tools/retur...returnrate.jsp.
gt;gt;gt;
gt;gt;gt; I've searched high and low to no avail.
gt;gt;gt;
gt;gt;gt; I want this app for a website that tracks investments for its users for
gt;gt;gt; a
gt;gt;gt; particular 401 sort of pension plan.
gt;gt;gt;
gt;gt;gt; Thanks!!!
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;