Figuring Out the Math

[CountValentine]

I don't think it's a math problem specifically I believe it was something to do with how they calculate the apy perhaps how often they compound.

They figure the APY correctly. My mistake was I thought APY was the same as APR, they are not. The formula I posted calculates the APR and I need it to calculate the APY. Probably better to ask in the excel thread now.

APY calculates with compounding.
APR does not use compounding.

[Yo ssi]

They figure the APY correctly. My mistake was I thought APY was the same as APR, they are not. The formula I posted calculates the APR and I need it to calculate the APY. Probably better to ask in the excel thread now.

APY calculates with compounding.
APR does not use compounding.

The math still doesn't add up.
Try using this link and put in the output from the Excel (APR) the APY result doesn't get to the rate shown

[CountValentine]

The math still doesn't add up.
Try using this link and put in the output from the Excel (APR) the APY result doesn't get to the rate shown

I give up!!!