Calculating APY for CD
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
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.
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.
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.
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
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.