3

I have been considering either renewing my CD (Certificate of Deposit) from my local Credit Union which is at 1.35% APR (1.3591 %) dividend rate (monthly compounded) for one year. I recently noticed another local credit Union that has a regular share account with a dividend rate of 2.25% APR (2.27 APY), but the dividends are paid quarterly.

Not exactly sure which would be better. If you could provide the formula to calculate the total interest gained at the end of the term (One year, in this example) for both types, would be great.

Rick
  • 241
  • 1
  • 6

1 Answers1

4

Excel has two functions you can use:

  • EFFECT to calculate the APY given an APR rate and the number of periods.
  • NOMINAL to calculate the APR given the APY and the number of periods.

Your question has the CD with a APR and the savings account that mentions both APR and APY. So convert them both to APY to compare them. The savings account (2.27 APY) will return more money based on the numbers in your question (2.27% vs 1.56%)

The previous part was the math part of the answer. The following takes into other considerations.

For this case the Savings account will return a larger amount of money if the conditions don't change. The CD rate is guaranteed, but the savings account could change every business day. The savings rate could go up, or down.

If you expect the savings account rate to rain higher than the CD you might not want to lock into the CD. If you expect the savings rate will drop then get the CD. Of course there are penalties if you cash in the CD early.

mhoran_psprep
  • 148,961
  • 16
  • 203
  • 418