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/
