APY formula

How to calculate APY by hand

Use our step by step plan to find APY by hand

  1. Gather data: annual rate, compounding frequency and initial balance
  2. Use the APY formula: APY= (1+(i/n))^n-1
  3. Apply the data and perform the calculation
  4. Multiply APY by initial balance

How to calculate APY in Excel

  1. Gather data: annual rate, compounding frequency and initial balance
  2. Use the APY formula: APY= (1+(i/N))^N-1
  3. Full fill cells A1 and A2 with data
  4. Enter the APY formula, referring back the cells for values of "i," and "n" as needed.
  5. Get Results