Three rates show up whenever you read a financial product, and mixing them up is expensive. This guide works through all three from the definition, shows the conversion between them, and covers the cases where the conversion breaks down.
Plain interest (simple rate) is the nominal rate applied to the original principal only.
A = P \left(1 + r \cdot t\right)
Compound interest applies the rate to the running balance, so interest itself earns interest.
A = P \left(1 + \frac{r}{n}\right)^{nt}
APY (annual percentage yield) is what you actually earn once compounding is folded in. It is the r that makes the compound-interest equation equal A for n = 1:
\text{APY} = \left(1 + \frac{r}{n}\right)^{n} - 1
CAGR is a different animal: it is the constant annual rate that takes a starting value P to an ending value A over t years, with no assumption about intermediate values.
\text{CAGR} = \left(\frac{A}{P}\right)^{\frac{1}{t}} - 1
Deposit $1,000 at a nominal 5% for 5 years.
Plain interest:
A = 1000 \times (1 + 0.05 \times 5) = 1250
Compounded monthly at the same nominal rate:
A = 1000 \times \left(1 + \frac{0.05}{12}\right)^{60} \approx 1283.36
Compounded annually:
A = 1000 \times 1.05^{5} = 1276.28
APY of the monthly account:
\text{APY} = \left(1 + \frac{0.05}{12}\right)^{12} - 1 \approx 0.051162