If interest is paid monthly, then the value of the CD doesn't change on a
monthly basis.

If you mean interest is compounded monthly, then just use the FV function,
as in
=FV(IntRate/12,n,0,CDAmount)
Simply build a table where n increases from 1 to the term of the CD.

If you want to build an accumulation table, monthly interest will be:
=PrevBalance*IntRate/12
Simply build a table where you add that to the starting amount of the CD.

Note that these calculations will almost never match the bank's, because of
they may use a different compounding period. But you'll be within pennies.

Regards,
Fred

"thehed" wrote in message
...
I undestand the use of the FV formulas in Excel to calculate Future
Value of an investment. I am looking for a way to calculate and
display the amounts of a CD on a monthly basis, sort of like an
amortization schedule for a mortgage.

Let's say the interest is paid monthly I would like to enter the
Initial amount, interest rate, term, etc. and have a chart showing
value each month. I can probably do it manually, for each month. I
was wondering if there is a formula, or easier, way to do it.

Thanks for your help.