If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating APY for CD
Hi,
What formula can I use to determine the Annual Percentage Yield (APY) for a Certificate of Deposit. The interest rate is 5.10% anually with the interest added back daily. The bank told me that the interest rate is 5.10% and that would be 5.20% APY. How would they know what the APY would be? Hope I'm making sense. Thanks for the help, Starlin |
#2
|
|||
|
|||
Calculating APY for CD
Hello:
I don't know how the bank does things. Banks, in some cases supported by statute, have played fast and loose with finance rules, in particular when they report the yield on loan documents. In finance the effective annual rate is computed by: EAR = (1+i/j)^j -1 Where i is the nominal annual rate, j is frequency of compounding per year. (Note, for example, the APR is computed by (i/j)*j, which understates the true effective rate.) So for your data the solution would be: (Put the following in a cell and format as percent =(1+.051/365)^365 -1 = 5.2319% Pieter Vandenberg Starlin Dotson wrote: : Hi, : What formula can I use to determine the Annual Percentage Yield (APY) for a : Certificate of Deposit. The interest rate is 5.10% anually with the : interest added back daily. The bank told me that the interest rate is 5.10% : and that would be 5.20% APY. How would they know what the APY would be? : Hope I'm making sense. : Thanks for the help, : Starlin |
#3
|
|||
|
|||
Calculating APY for CD
Thanks
"vandenberg p" wrote in message ... Hello: I don't know how the bank does things. Banks, in some cases supported by statute, have played fast and loose with finance rules, in particular when they report the yield on loan documents. In finance the effective annual rate is computed by: EAR = (1+i/j)^j -1 Where i is the nominal annual rate, j is frequency of compounding per year. (Note, for example, the APR is computed by (i/j)*j, which understates the true effective rate.) So for your data the solution would be: (Put the following in a cell and format as percent =(1+.051/365)^365 -1 = 5.2319% Pieter Vandenberg Starlin Dotson wrote: : Hi, : What formula can I use to determine the Annual Percentage Yield (APY) for a : Certificate of Deposit. The interest rate is 5.10% anually with the : interest added back daily. The bank told me that the interest rate is 5.10% : and that would be 5.20% APY. How would they know what the APY would be? : Hope I'm making sense. : Thanks for the help, : Starlin |
#4
|
|||
|
|||
Calculating APY for CD
Hello:
Your are welcome and one more thing. Some banks compound at one time interval and pay at another. For example they may quote a rate as being compounded daily but paid quarterly. Which means in some cases if you withdraw the funds between quarters you do not get the interest for that quarter, other pay to the date of withdrawal. On a CD this would make no difference since you have fixed time period and I am sure have been warned about early withdrawal penalities. Pieter Vandenberg Starlin Dotson wrote: : Thanks : "vandenberg p" wrote in message : ... : Hello: : : I don't know how the bank does things. Banks, in some cases supported by : statute, have played fast and loose with finance rules, in particular : when they report the yield on loan documents. : : In finance the effective annual rate is computed by: : : EAR = (1+i/j)^j -1 : : Where i is the nominal annual rate, j is frequency of compounding per : year. : (Note, for example, the APR is computed by (i/j)*j, which understates the : true effective rate.) : : So for your data the solution would be: : : (Put the following in a cell and format as percent : : =(1+.051/365)^365 -1 = 5.2319% : : Pieter Vandenberg : : Starlin Dotson wrote: : : Hi, : : : What formula can I use to determine the Annual Percentage Yield (APY) : for a : : Certificate of Deposit. The interest rate is 5.10% anually with the : : interest added back daily. The bank told me that the interest rate is : 5.10% : : and that would be 5.20% APY. How would they know what the APY would be? : : Hope I'm making sense. : : Thanks for the help, : : Starlin : : |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
report preview different than printout when calculating totals | Holly | Setting Up & Running Reports | 7 | March 15th, 2006 02:09 PM |
Calculating...... over and over.. and over | titlepusher | General Discussion | 3 | June 13th, 2005 08:09 PM |
Calculating one record/Form | Tiffany | Using Forms | 2 | May 27th, 2005 04:06 AM |
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | RICHARD | Worksheet Functions | 1 | March 15th, 2005 05:49 PM |
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | RICHARD | General Discussion | 0 | March 1st, 2005 01:53 PM |