View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lotus123
 
Posts: n/a
Default Effective interest paid - need formula/function


Since your payments are not equal, you will want to use the IRR
function. This would require you to list out all of the payments as
such:

55000
-5038
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
-2519
0
1

=IRR(above range)

The answer is 0.84% x 12 = 10%

Of course, I assumed you had the "free" month at the end....instead of
immediately after the double-month at the beginning.


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=486294