Home 
Search 
Today's Posts 
#1




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




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)^21 to get the effective annual interest rate (what you are actually
paying yearly taking into account compounding of interest) =(Y/X1)*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  


Similar Threads  
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) 