J
jklist
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
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