Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Safu
 
Posts: n/a
Default APR - Annual Percentage Rate to Actual Interest Rate

Please if anybody can help me how to calculate back the APR rate to Actual
Interest Rate.
Loan = 10K @ 96 mth = 13.1210%
So 13.1210% = 7.75% (Actual Interest Rate)

Any formula that can help me?
  #2   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

what is the EMI you are paying...?

- Mangesh



"Safu" wrote in message
...
Please if anybody can help me how to calculate back the APR rate to Actual
Interest Rate.
Loan = 10K @ 96 mth = 13.1210%
So 13.1210% = 7.75% (Actual Interest Rate)

Any formula that can help me?



  #3   Report Post  
Safu
 
Posts: n/a
Default

What is EMI stand for?

"Mangesh Yadav" wrote:

what is the EMI you are paying...?

- Mangesh



"Safu" wrote in message
...
Please if anybody can help me how to calculate back the APR rate to Actual
Interest Rate.
Loan = 10K @ 96 mth = 13.1210%
So 13.1210% = 7.75% (Actual Interest Rate)

Any formula that can help me?




  #4   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

Sorry, its the Equal Monthly Installment.
or the equaly monthly repayment towards the loan

Mangesh



"Safu" wrote in message
...
What is EMI stand for?

"Mangesh Yadav" wrote:

what is the EMI you are paying...?

- Mangesh



"Safu" wrote in message
...
Please if anybody can help me how to calculate back the APR rate to

Actual
Interest Rate.
Loan = 10K @ 96 mth = 13.1210%
So 13.1210% = 7.75% (Actual Interest Rate)

Any formula that can help me?






  #5   Report Post  
Safu
 
Posts: n/a
Default

OK, EMI is 168.75

"Mangesh Yadav" wrote:

Sorry, its the Equal Monthly Installment.
or the equaly monthly repayment towards the loan

Mangesh



"Safu" wrote in message
...
What is EMI stand for?

"Mangesh Yadav" wrote:

what is the EMI you are paying...?

- Mangesh



"Safu" wrote in message
...
Please if anybody can help me how to calculate back the APR rate to

Actual
Interest Rate.
Loan = 10K @ 96 mth = 13.1210%
So 13.1210% = 7.75% (Actual Interest Rate)

Any formula that can help me?








  #6   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

Hi Safu,

The figure 168.75 is a result of the formula
=PMT(13.12%/12, 96, -10000)

Infact I had asked you for the EMI as I wanted to know from where you are
getting at the rate of 7.75%

As Ron pointed out, can you tell us from where you got the 7.75% figure.

- Mangesh


"Safu" wrote in message
...
OK, EMI is 168.75

"Mangesh Yadav" wrote:

Sorry, its the Equal Monthly Installment.
or the equaly monthly repayment towards the loan

Mangesh



"Safu" wrote in message
...
What is EMI stand for?

"Mangesh Yadav" wrote:

what is the EMI you are paying...?

- Mangesh



"Safu" wrote in message
...
Please if anybody can help me how to calculate back the APR rate

to
Actual
Interest Rate.
Loan = 10K @ 96 mth = 13.1210%
So 13.1210% = 7.75% (Actual Interest Rate)

Any formula that can help me?








  #7   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Thu, 12 May 2005 08:14:01 -0700, "Safu"
wrote:

Please if anybody can help me how to calculate back the APR rate to Actual
Interest Rate.
Loan = 10K @ 96 mth = 13.1210%
So 13.1210% = 7.75% (Actual Interest Rate)

Any formula that can help me?


I don't understand how you develop an actual interest rate of 7.75%, given your
values (and your monthly payment from another thread).

How are you defining "ACTUAL interest rate"?


--ron
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I caluclate an Annual Percentage Rate in Excel? Lisa M Excel Worksheet Functions 32 April 22nd 23 04:11 AM
Effective Annual Interest Rate John Excel Worksheet Functions 4 April 4th 23 12:45 PM
Annual Percentage Rate for Mortgage Tristan Excel Discussion (Misc queries) 3 February 5th 05 04:37 PM
Annual Percentage Rate sts111 Excel Discussion (Misc queries) 1 February 1st 05 01:26 PM
APR - Annual Percentage Rate marlia Excel Worksheet Functions 2 December 9th 04 09:05 PM


All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"