You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Calculating APY for CD

Calculating APY for CD

Price: FREE

What formula can I use to determine the Annual Percentage Yield (APY) for a
Certificate of Deposit. The interest rate is 5.10% annually 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.

Visit publisher's web-site: Calculating APY for CD

Category and Tags: ExcelTutorials :

Related Tutorials

apr to apy

Free: Yes
Tags: Excel › Functions

I was looking for two formulas. One if I have an APR, to be able to insert that and get the APY. Same thing in reverse.if I have an APY to input it

APY and Interest rate calculation

Free: Yes
Tags: Excel ›

What is the formula to have the interest rate change based on the APY? I have amounts between 100 to 10,00 with Interest rate and APY. When I change the APY I want it to calculate interest rate for all the fields with different amounts and APY with the new interest rate based on the new APY. How can I copy the same formula for all the other columns.

Convert average daily yield to APY

Free: Yes
Tags: Excel › Functions

I have a spreadsheet that tracks
my investments, and calculates the daily return as a percentage, which I then have averaged to show the average daily yield. I have come up with another formula that shows compounding interest, but it needs the APY to get proper calculation. What I want to be able to do is convert the average daily yield to an APY, which will change as daily average changes.

Calculating Deciles

Free: Yes
Tags: Excel ›

I'm asking for help in calculating deciles values for certain columns in my attached spread sheet. I have a inserted comment along side each column that I need help with. Would you please take a look and give me your feedback.

Not Calculating

Free: Yes
Tags: Excel › Functions

I have a formula in 2 worksheets that work fine. I copied one of the worksheets and changed the data. The new worksheet is not calculating the formula "=AVERAGE(IF((F4:F31>=(H2))*(F4:F31<=(J2)),Q4:Q31) )". Any ideas on why this is not calculating? I have Excel 2002 SP3.

Related Applications & Scripts

CF Time Span Calculation

Free: Yes
Tags: CFML › Excel Date and Time

Script allows developers to easily embed the functionality of calculating end time from a given start time and span into in 1/2 hour increments.
REQUIRES Cold Fusion 5.0 or MX to run- Uses "CreateTimeSpan" to translate both start time and time span into minutes. That way only a simple addition is required to determine end time.-"TimeFormat" is then used to return the start time and end time back to a HH:MM based time format.-Several of the "TimeFormat" formatting options are provided with this script.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing