Skip to main content
Dileep_NR
Dileep_NR
Inspiring
July 23, 2010
Question

Calculates the constant interest rate of an investment with regular paymets (APR)

  • July 23, 2010
  • 1 reply
  • 1160 views

Hi All,

     How we Calculates annual percentage of rate (APR)


Eg: we have RATE() method in excel.

In coldfusion, is ther is any built in method for that or using java object?

Please help

    This topic has been closed for replies.

    1 reply

    Dileep_NR
    Dileep_NRAuthor
    Inspiring
    July 27, 2010

    Any help on  this?

    A
    Adam Cameron.
    Inspiring
    July 27, 2010

    Well I can confirm there's no inbuilt CF function that covers this: it's a bit out of CF's niche.

    I would also be surprised if there is a native Java method to cover it too, although a quick google on your part should answer that question.

    If I was faced with this and had drawn a blank regarding a native CF or Java solution, I'd just roll my own function.  I can't imagine the algorithm is terribly complicated.

    --
    Adam

    D
    Dan_Bracuk
    Inspiring
    July 27, 2010

    One could always check cfifb.org or riagorge.com to see if anyone has already rolled their own and made it avaialable.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices