where is the formula for calculating the APR   

Financial credit agreements display the rate in terms of APR (the Annual 
Percentage Rate).   There is an IT formula usually embedded in spreadsheet 
software.   I cannot find it.   Where is it located.

date: Tue, 13 Dec 2005 05:55:03 -0800   author:   slimcut

RE: where is the formula for calculating the APR   

Take a look at the RATE function in Excel help.



"slimcut" wrote:

> Financial credit agreements display the rate in terms of APR (the Annual 
> Percentage Rate).   There is an IT formula usually embedded in spreadsheet 
> software.   I cannot find it.   Where is it located.

date: Tue, 13 Dec 2005 06:19:03 -0800   author:   Scott Wagner

Re: where is the formula for calculating the APR   

Did you search for "rate" in XL Help?

Take a look at EFFECT(), NOMINAL(), and RATE(). Note that EFFECT() is an 
Analysis Toolpak Add-in function (Tools/Add-ins...).

In article ,
 "slimcut"  wrote:

> Financial credit agreements display the rate in terms of APR (the Annual 
> Percentage Rate).   There is an IT formula usually embedded in spreadsheet 
> software.   I cannot find it.   Where is it located.

date: Tue, 13 Dec 2005 07:27:28 -0700   author:   JE McGimpsey