LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Interest Rate Help

I need help with the formula for figuring out what the 'real' interest
rate is when you pay a loan off early. Example car loan:

$10,000 (borrowed) 5% @ 60 months, Total with interest is: 11,322.74

Now:
I do the same as above but apply an extra $500 to the principle each
month and pay off the loan in 16 months and only pay $336.75 in
interest. What is my new 'real' interest rate for this loan?

Thanks in advance for anyone who can help! mitch

 
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
Compound Interest Rate or Growth Rate 1944-71222 Excel Worksheet Functions 2 March 15th 10 04:38 AM
to compute interest rate from principal and interest amount PVJ Excel Discussion (Misc queries) 3 December 28th 05 05:01 PM
Mtge calculation (Dly compound interest and multiple interest rate Spudson Excel Programming 2 November 3rd 05 07:49 PM
APR - Annual Percentage Rate to Actual Interest Rate Safu Excel Worksheet Functions 9 May 18th 05 05:03 AM
Effective rate of Interest and Copounding Interest jnorton Excel Worksheet Functions 3 April 13th 05 03:11 AM


All times are GMT +1. The time now is 04:53 AM.

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"