Get the latest news and alerts!

# How to Calculate APY in Excel

Microsoft Excel is a computer spreadsheet program released in the Microsoft Office software package. Excel is a powerful data organization and management tool which allows users to perform complex calculations. APY, or annual percentage yield, is the amount of interest accrued on money over a year, taking into account any interest compounding, which can be calculated quickly using Excel

## Step 1

Open Excel and start with a blank worksheet. The formula for APY is: APY= (1+(i/N))^N-1, where "i" is the nominal interest rate, and "N" is the number of compounding periods per year. "N" would equal 12 for monthly compounding, and 365 for daily. For yearly compounding APY= the nominal interest rate.

Video of the Day

## Step 2

In cell A1 type "i," in cell B1 type "N," and in cell C1, type "APY."

## Step 3

In cell A2 type the nominal interest rate in percent, and in column B2 type the compounding periods per year.

## Step 4

Click on cell C2 and press the equals button.

## Step 5

Enter the APY formula, referring back the cells for values of "i," and "N" as needed. By clicking on a certain cell, Excel will enter the value of those cells into your formula. So, click on cell A2 for "i" and cell B2 for "N." The formula should look like this: =(1+(A2/B2))^B2-1. Press enter when you are finished entering the formula. It will give you the interest rate in decimal form.