APR ignores compounding; APY includes it. For a savings account, APY is what you actually earn.
APY is always equal to or greater than APR, with the gap increasing as compounding frequency increases.
APY = (1 + APR/n)ⁿ − 1
Where n is the number of compounding periods per year.
A savings account advertised at 5% APR compounded monthly (n = 12):
APY = (1 + 0.05/12)¹² − 1
= (1.00417)¹² − 1
= 1.05116 − 1
= 5.116%
You earn 5.116%, not 5%.
Credit card “APR” is required by law in the US, but interest typically compounds daily. A credit card with 20% APR has an effective APY of:
APY = (1 + 0.20/365)³⁶⁵ − 1
≈ 22.13%
The card costs you 22.13% per year, not 20%. Many consumers underestimate credit card costs because of this.
| Compounding | APY |
|---|---|
| Annual (n=1) | 5.000% |
| Semi-annual (n=2) | 5.063% |
| Quarterly (n=4) | 5.095% |
| Monthly (n=12) | 5.116% |
| Daily (n=365) | 5.127% |
| Continuous (e^0.05) | 5.127% |
When shopping for savings products, prefer APY. When evaluating loan costs, the true rate is the APY — even though lenders typically advertise APR (which is lower).
Because APY includes the effect of compounding: interest earned in early periods itself earns interest in later periods. APR is the simple annual rate that ignores this.
APY tells you the actual annual cost. A 20% APR credit card with daily compounding has an effective APY of about 22%. Lenders advertise APR because it sounds lower.
The four percentage formulas in Excel: percentage of a number, percentage change, percent of total, and formatting cells...
The same formulas work in Google Sheets as in Excel, with a few keyboard shortcut and formatting differences.
The percent key on different calculators does different things — here's what to expect on phone, desktop, and four-funct...