• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to find interest rate

Roudi

New Member
I have a large spread sheet with some 260 customers and the person who originally set it up it entered some data that is not correct. Mostly it all related to interest rate where my customers are paying a monthly that’s not equal the calculated rate of interest they are supposed to pay. This is one example the person was set up with a loan of 1,900.00 and they are paying 70.85 a month for 36 months. I would like to know how to calculate this to find the interest rate they are paying. I know it's 20.25% but how can I calculate this to come up with the answer? But for some reason they set up paying only 63.85 a month for the 36 months. After entering several interest rates in the Loan Amortization Schedule I came up with 12.82% interest. Instead of me going through every one of them to find their exact interest rate they are paying now is there a formula I can use to do this?
 
Use RATE() function.

For your calculation...
=RATE(36,-70.85,1900)*12

36 = nper = number of period over which the loan is to be paid
-70.85 = pmt = fixed payment amount per period
1900 = pv = present value of loan

So if 63.85 is monthly payment...
=RATE(36,-63.85,1900)*12

This assumes you are using Actual/360 schedule.
 
Use RATE() function.

For your calculation...
=RATE(36,-70.85,1900)*12

36 = nper = number of period over which the loan is to be paid
-70.85 = pmt = fixed payment amount per period
1900 = pv = present value of loan

So if 63.85 is monthly payment...
=RATE(36,-63.85,1900)*12

This assumes you are using Actual/360 schedule.
Yes and it worked GREAT! Thanks for the help
 
Back
Top