0

What is the formula to get the Interest percentage from Interest Rate?

Given :

Principal Amount : $1000 Interest Rate : $1 / Month Number of payments : 10

What is the formula to fetch the percentage ? (APR %)

Improve this question

1 Answer 1

Reset to default
1

The monthly percentage rate is 0.1% ($1/$1000). The annualized percentage rate would then be that monthly rate compounded 12 times , or

(1 + 0.001 ^ 12) - 1 = 0.012 = 1.2%

More generally, the formula is

((1 + periodic_rate) ^ (periods_per_year) - 1)

Note that the fact that there are only 10 payments is irrelevant in calculating APR - only the periodic rate and the number of periods in a year matter.

Improve this answer
1
  • Thank you, I am looking for the generic formula. Values i shared is only a sample. Having the formula plugged in a spreadsheet will help me to generate more details
    – goofyui
    Mar 29, 2019 at 14:50

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .