Thread: APY CD Formula
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default APY CD Formula

On May 9, 10:47 am, sross002
wrote:
The interest isn't compounded daily. It takes effect at takeout after
6 months. So I guess it's semi-annually.


It would take a year for $1000 to grow to about $1030 at 6% compouned
semi-annually.

Be careful with terminology. The industry is quite fickle about
this. And I would not be surprised if it varies from one country to
another.

In the US, CD interest can __compound__ at one frequency (typically
daily), but it might be __paid__ at another frequency (for example,
monthly, semi-annually, annually, or at maturity).

Another fickle area of terminology is the terms "interest rate", "APR"
and "APY". For example, it is quite common for US institutions to
misuse the term "APR" where they mean APY (i.e. compounded rate),
whereas controlling US law uses the term "APR" to refer to the
(simple) interest rate.

Originally, you asked how to compute the "APY" for a "6% CD". (Oops,
I never answered __that__ question. I leaped ahead to your next
question, namely: the total amount after 6 months.)

So I interpreted 6% to be the annual simple interest rate, for which
the daily rate is determined by 6%/365 (or 366), at least for FDIC-
insured US CDs. (That is, they are following the US "Truth in
Savings" regulations.)

But the "6%" might be the APY, and you care obviously unclear about
the compounding frequency.

Get your facts straight, then post back with the details.



On May 9, 10:47*am, sross002
wrote:
The interest isn't compounded daily. *It takes effect at takeout after 6
months. *So I guess it's semi-annually.



"sross002" wrote:
How should I input the dates? *These formulas aren't working. *My answer
should be like $1,029.30. *What could be wrong?


"joeu2004" wrote:


On May 8, 4:17 am, sross002
wrote:
Can someone help me with an APY formula for a 6% CD
investment of $1,000 with interest compounded daily?


I just want to know what the total amount will be
after 6 months if I invest $1,000.


Assume that A1 and A2 have the starting and ending dates. *Then either
of the following formulas should do the trick, whichever you feel more
comfortable with:


=fv(6%/365, A2-A1, 0, -1000)


=1000 * (1 + 6%/365)^(A2-A1)


Caveat: *In the US, financial institutions can (and usually do) use
366 instead of 365 in leap years.