Take a look at:
http://office.microsoft.com/en-us/te...CT011815531033
or other templates in the same site.
--
Gary's Student
"jklist" wrote:
Hello friends,
Need some expert advice from you all.
I have a spreadsheet which has a record of CD which my manager is planning
for the company and need to calculate the total value of each as well as
cumulative values.
I do not know how the banks calculate interest for cd and would like your
guidance on the same.
The coloums are as follows :
A B C D
E F
Sr.no--Principal amt --- Interest --- Years ---- End value --- Commulative
total
1 100,000 5.35 1
2 35,000 5.00 .6
3.
4.
5.
Please advice on the correct formula to be used.
Thanks
JKL