| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked Check Boxes | Excel Discussion (Misc queries) | |||
| calculating time | Excel Discussion (Misc queries) | |||
| Calculating Cells n% displayed in a cell? | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Threaded Mode
