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