You should write a com to handle it.
Very simple job.
~Justin
----- Original Message -----
From: "Johnson, Dana" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 01, 2000 7:28 PM
Subject: RE: Net Present Value NPV()
> Hey Justin
>
> thanks a million
>
> the total situations is as follows
>
> 1. Webbased equipment buyout calculation to determine amount of upgrade
> uses NPV() and PV functions
>
> 2. Needed to be asp based however asp does not support NPV()
>
> 3. Looking to provide functionality in cold fusion to call from asp form
>
> currently I'm using CF 4.51 IIS4 sp4
>
>
>
> Dana E. Johnson
> Sr. Web Developer
> CIT
> VTF/Technology Financing Services
> [EMAIL PROTECTED]
> (904) 620-7458
>
>
>
> -----Original Message-----
> From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 01, 2000 10:02 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Net Present Value NPV()
>
>
> NPV = C0 + C1 / (1+r) + C2 / (1+r)2 + ... + Cn / (1+r)n
>
> so something like
>
> if:
> values is an array of rates and
> rate is the rate
>
> then:
>
> <cfset NPV = values[1]>
> <cfloop from=2 to=#ArrayLen(values)# index=C>
> <cfset temp =0>
> <cfset temp = Value[c]/(1+rate) ^ c>
> <cfset NPV + temp>
> </cfloop>
>
>
> Let me know how you get on, and I'll create a custom tag for it .....
>
>
> ~Justin MacCarthy
>
>
> ----- Original Message -----
> From: "Johnson, Dana" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 01, 2000 2:43 PM
> Subject: Net Present Value NPV()
>
>
> > does anybody have a workaround for the VB function NPV() for use in cold
> > fusion.
> >
> > Dana E. Johnson
> > Sr. Web Developer
> > CIT
> > VTF/Technology Financing Services
> > [EMAIL PROTECTED]
> > (904) 620-7458
> >
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> >
>
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
