Answer:
APY = (1 +r/n)^n -1
Explanation:
Each period the principal is multiplied by 1 plus the periodic rate: 1 + r/n. For n periods in a year, the effective multiplier is (1 +r/n)^n. The value after this multiplication includes the principal, so to find the interest, we need to subtract the principal. The effective rate is ...
APY = (1 +r/n)^n -1
_____
You didn't ask, but the effective rates for the accounts shown are given in the attachment. The formula bar shows the formula used, and the highlighted cell shows the highest APY.
(I find a spreadsheet is a simple way to do repetitive calculations with minimal chance of error.)