i used the following in a previous project, maybe it might help you:
(for calculating payments)
public function calculatePMT(PV:Number, IR:Number, YEARS:Number):Number {
var newIR:Number = IR/12;
var newNP:Number = YEARS*12;
return Math.round((PV*(newIR/100)) / (1-Math.pow(1+(newIR/100), -newNP)));
}
(for calculating present value)
public function calculateBond(PMT:Number, IR:Number,
YEARS:Number):Number {
var newIRb:Number = (IR/100)/12;
var newNPb:Number = YEARS*12;
var v:Number = Math.pow(1+newIRb, -newNPb);
var pv:Number = PMT*(1-v)/newIRb;
return Math.round(pv);
}
--- In [email protected], "valdhor" <valdhorli...@...> wrote:
>
> Do a google search for your requirements. For example, searches on NPV
> and IRR yielded the following:
>
> http://www.ehow.com/how_2187130_calculate-net-present-value-npv.html
> http://www.s-anand.net/Calculating_IRR.html
>
> You will then need to convert these algorithms to Actionscript (I
> could not find any Actionscript examples).
>
>
> --- In [email protected], "Pete Appleby" <boneoh@> wrote:
> >
> > Hi, everybody!
> >
> > I need to find Flex 3 functions to calculate NPV, IRR, and NPER just
> > like in Excel. Are these out there anywhere? I don't want to reinvent
> > the wheel.
> >
> > Thanks!
> >
> > Pete
> >
>
