where is the formula for calculating the APR

G

Guest

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.
 
J

JE McGimpsey

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...).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP!!!!!APR calculations in exvel 8
APR (Annual Percentage Rate) calculator 3
APR Fee Calculation 1
What is the formula to calculate APR with no payments? 4
Calculating APR for Adjustable Rates 1
Formula for calculating the diffrence between two dates 1
Annual Percentage Rate 1
APR calculation for Mortgages with a balloon payment. 6

Top