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