How do I set up an APR calculation in Excel?

G

Guest

I would like to set up a spreadsheet template to calculate an Annual
Percentage Rate based on a series of cells containing the appropriate
required parameters for this calculation.

I am looking for the formula or serioes of formulas necessary to perfrom
this calculation.
 
G

Guest

There are functions to do what you want, actually there are a lot of them.
Probobly the easiest one to use is Rate
=RATE(Nper,DollorsAmt,NegAmt)
Go to your functions and choose Financial and look for "Rate." The function
is explained in "help."

Just supply the amounts you desire to calculate in what ever cells you want
and reference them in the formula.
 

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

Problem displaying a calculation result in a user form 2
How do I create the formula for this calculation? 1
Unexplainable Worksheet Function Calculation Process 7
What should my calculation settings be? 2
Improving Nested Formula Calculation Efficiency 2
Excel Calculation is faster when visible than when Visible=False? 9
Sheet calculation target cell 2
How do I set up a weighted percentage formula in Excel? 1

Top