|
|
Thnx for the Help..
Regards
"Adrian M" wrote:
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..
|