Excel Software.
If i have invested 5000 on 13.11.2005 for 03 years so what will be the interest saperately for every year ( quaterly compounded ). Some thing I want like as below.
Int for 13.11.2005 to 31.04.2006 say A plus principal say B = C
Int for 01.04.2006 to 31.04.2007 say D plus C
thus A,B,C and D should reflect in diffrent column or raws.
Thus by entering amount, value date, rate of interest, and the two dates for which interesr is required i.e. 01.04.2006 to 31.03.2007 like this. but all should come in one sequence.
I hope that any one will definetly help me in this matter.
Thanking you.
If i have invested 5000 on 13.11.2005 for 03 years so what will be the interest saperately for every year ( quaterly compounded ). Some thing I want like as below.
Int for 13.11.2005 to 31.04.2006 say A plus principal say B = C
Int for 01.04.2006 to 31.04.2007 say D plus C
thus A,B,C and D should reflect in diffrent column or raws.
Thus by entering amount, value date, rate of interest, and the two dates for which interesr is required i.e. 01.04.2006 to 31.03.2007 like this. but all should come in one sequence.
I hope that any one will definetly help me in this matter.
Thanking you.