Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function help with Calculating Interest for two different investme
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.. |
#2
|
|||
|
|||
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.. |
#3
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Calculating Interest where rate changes per quarter | Excel Discussion (Misc queries) |