Here's a rough and ready algorithm in Javascript. It might give you
something to work with.
Steve
----------------------------------------------
steve baty
senior analyst
red square :: internet design & development
www.redsquare.com
<ph>+612 8596 4030
<fax>+612 8596 4001
<mob>+61 417 061 292
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew
Dickinson
Sent: Wednesday, 25 June 2003 9:28
To: CFAussie Mailing List
Subject: [cfaussie] Re: OT : How to IIR in CF or Access ?
Yes, Steve, you got it.
I misunderstood my supervisor's accent. And he's now found some of the
help in Access and Excel about it.
The basic issue is that IRR (got it right this time) is calculated by
function, which CF4 cannot handle. Of course, this will fall nicely into
place when we upgrade to MX, but we need it working by Tuesday (July
1st,
when the new legislation comes into effect).
If anyone has a blazingly brilliant idea of how to do a function-type
calculation in CF4, we'd love to hear it. In the meantime, we're
considering non-CF alternatives, even (*gasp* *horror*) using
ASP........
> Just to clarify, are you after IIR or IRR (internal rate of return)?
>
> ----------------------------------------------
> steve baty
> senior analyst
> red square :: internet design & development
> www.redsquare.com
> <ph>+612 8596 4030
> <fax>+612 8596 4001
> <mob>+61 417 061 292
----------------------------------------
> > IIR is a financial industry term used in the calculation of compound
> > interest. Apparently it's either tricky or not possible to calculate
> using
> > CF, but may be possible with MSAccess.
> >
> > Anyone with finance industry experience know of any routines which
> work
> > for this calculation ? We are trying to calculate Comparison Rates,
in
> > order to comply with some recent government legislation (briefly, to
> show
> > an interest rate on the loan which reflects all fees and costs).
> >
> > ---
> > You are currently subscribed to cfaussie as:
> [EMAIL PROTECTED]
> > To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> >
> > MX Downunder AsiaPac DevCon - http://mxdu.com/
>
>
************************************************************************
> ****
> If this communication is not intended for you and you are not an
> authorised
> recipient of this email you are prohibited by law from dealing with or
> relying on the email or any file attachments. This prohibition
includes
> reading, printing, copying, re-transmitting, disseminating, storing or
> in
> any other way dealing or acting in reliance on the information. If
you
> have received this email in error, we request you contact ABN AMRO
> Morgans
> Limited immediately by returning the email to
[EMAIL PROTECTED]
> and destroy the original. We will refund any reasonable costs
associated
> with notifying ABN AMRO Morgans. This email is confidential and may
> contain
> privileged client information. ABN AMRO Morgans has taken reasonable
> steps
> to ensure the accuracy and integrity of all its communications,
> including
> electronic communications, but accepts no liability for materials
> transmitted. Materials may also be transmitted without the knowledge
of
> ABN
> AMRO Morgans. ABN AMRO Morgans Limited its directors and employees do
> not
> accept liability for the results of any actions taken or not on the
> basis
> of the information in this report. ABN AMRO Morgans Limited and its
> associates hold or may hold securities in the companies/trusts
mentioned
> herein. Any recommendation is made on the basis of our research of
the
> investment and may not suit the specific requirements of clients.
> Assessments of suitability to an individual's portfolio can only be
made
> after an examination of the particular client's investments, financial
> circumstances and requirements.
>
************************************************************************
> ****
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
>
> MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
Title: Calculating IRR
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
