Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
=(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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Effective Annual Interest Rate | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Annualised interest rate | Excel Worksheet Functions | |||
Annual Percentage Rate | Excel Discussion (Misc queries) | |||
Calculating Interest where rate changes per quarter | Excel Discussion (Misc queries) |