I am looking for a formula for calculating APY on CDs.
 

In Excel there is a canned calculation for Yield, but I am looking for a
specific calculation for the OCC required APY disclosure. Does anyone know
where such a calcualtion can be found. I am having issues in finding the
actual formula to build such a function on a spreadsheet.