Hi
I have a series of 5 capital payments over a period of years and then two repayments with a few years in between. How can i use excel to calculate the inherent interest rate if it was compound and simple.
So, say:
Loans out of:
5 June 1998 68,900
5 June 1999 98,950
5 June 2001 384,900
5 June 2002 1,600
1 February 2003 8,000
Repayments
1 January 2003 300,000
31 March 2009 281,250
I have a series of 5 capital payments over a period of years and then two repayments with a few years in between. How can i use excel to calculate the inherent interest rate if it was compound and simple.
So, say:
Loans out of:
5 June 1998 68,900
5 June 1999 98,950
5 June 2001 384,900
5 June 2002 1,600
1 February 2003 8,000
Repayments
1 January 2003 300,000
31 March 2009 281,250
