jklist via OfficeKB.com wrote:
The FV formula works. Altthough I don't understand
the 365*42 part.

I wrote "*D2", not "*42". In the table you posted previously,
column D contained the term of the CD in years. I said that
I assume that Sr No 1 (i.e. the first CD) is in row 2. Ergo, D2
is the term in years of the first CD. As you copy the formula
down, the relative reference will change to D3, D4, etc,
always representing the term in years for the corresponding
CD.

HTH.