Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jw
 
Posts: n/a
Default Annual interest rate

Excel 2003.

This is fairly basic.

Say you borrow X amount of dollars with an obligation to pay back Y
amount of dollars (Y X; lump sum) 6 months from the date of the loan.


Which Excel function is appropriate to determine the interest rate on
an annualized basis?

Thanks very much.

  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

=(Y/X)^n - 1

where n is the number of periods per year (in this case, 2)

In article .com,
"jw" wrote:

Excel 2003.

This is fairly basic.

Say you borrow X amount of dollars with an obligation to pay back Y
amount of dollars (Y X; lump sum) 6 months from the date of the loan.


Which Excel function is appropriate to determine the interest rate on
an annualized basis?

Thanks very much.

  #3   Report Post  
David Billigmeier
 
Posts: n/a
Default

=(Y/X)^2-1 to get the effective annual interest rate (what you are actually
paying yearly taking into account compounding of interest)

=(Y/X-1)*2 to get the APR
--
Regards,
Dave


"jw" wrote:

Excel 2003.

This is fairly basic.

Say you borrow X amount of dollars with an obligation to pay back Y
amount of dollars (Y X; lump sum) 6 months from the date of the loan.


Which Excel function is appropriate to determine the interest rate on
an annualized basis?

Thanks very much.


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
Effective Annual Interest Rate John Excel Worksheet Functions 4 April 4th 23 12:45 PM
APR - Annual Percentage Rate to Actual Interest Rate Safu Excel Worksheet Functions 9 May 18th 05 05:03 AM
Annualised interest rate Linda Adams Excel Worksheet Functions 2 May 5th 05 06:14 AM
Annual Percentage Rate sts111 Excel Discussion (Misc queries) 1 February 1st 05 02:26 PM
Calculating Interest where rate changes per quarter Dean Strudwick Excel Discussion (Misc queries) 1 December 7th 04 12:36 AM


All times are GMT +1. The time now is 04:22 PM.

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

About Us

"It's about Microsoft Excel"