The formula below can be used to calculate how much interest you, or John in this case, will earn each month with compounded interest:
APY= (1 + r/n) n – 1
r- annual interest rate
n- number of compounding periods (monthly would be 12)