I am looking for assistance in calculating tiered rates for a money market account. I am using the APYWIN 2.1 calculator, but I keep getting an APY Violation on the second part of the second tier. Does anyone have any other suggestions on calculators they use and could recommend? Or offer assistance with the APYWIN? I have reached out to the OCC, but have not heard back. It is a two tiered account - I have been able to get the first tier to work out, just not the second since it is a blended rate. Any input would be appreciated. Thanks!

Give us the details

You can also use an Excel document to make the calculation if you have someone in your organization with Excel skills.

We are looking to do a 12 month introductory rate: Tier 1 1.75% APY for up to $250,000, Tier 2 at 1.35% APY for $250,000+. After the 12 month intro period, it would drop down to our base rates (I already have these calculated). I am having issues getting the proper rates to disclose for the introductory period. For Tier 1, the rate would be 1.74%, but I am having difficulty with Tier 2 since it would be a blended rate. Any insight would be appreciated.

If this is variable rate account - how is there an introductory period?? You mean these are fixed rate accounts?

Plus you have not given us the interest rates and compounding periods.

This is technically a variable account, not fixed rate. We are offering a rate adjuster of 1.30% for the introductory period of 12 months - Tier 1 1.75% APY for up to $250,000 and Tier 2 1.35% APY for $250,000+. I was able to determine the rate for Tier 1 at 1.74%, but have not been able to determine the rate for Tier 2 and that is why I have reached out. It will be a blended rate.

Our base will be Tier 1 .45% APY for up to $250,000 and Tier 2 .05% APY for $250,000+. I show the rates for those to be .45% for Tier 1 and between .45%-.18% APY for Tier 2 (those were calculated previously by the Compliance Officer before me).

Interest is compounded monthly and we use 365 for days in a year.

I apologize if I am not explaining clearly. I have only been in the Compliance Officer position since October and have not had experience in calculating rates like this yet. Thank you.