With regard to point 1 you can use CUMIPMT and CUMPRINC to determine the
interest accrued and principal amount (see how to use it on
http://www.auditexcel.co.za/financial.html ).

"proshail" wrote:

1. Firstly i want to calculate interest for an Fixed Investment
eg.. 2500 is invested at 9% p.a. rate of interest for 120 months i want to
calculate the accrued interest and Amount of Investment (Principal Amount +
Interest) for end of 12, 24, 36 ....etc. till 120th month.

2. Second i want to calculate interest for recurring deposit say 100 is
invested every month at a rate 9% for total period of 120 month then interest
and principal amounts at end of 12, 24, 36... etc. till 120th month..