Grow a principal by a rate compounded over a number of periods.
Copy this formula
=A2*(1+B2)^C2Multiply the principal (A2) by (1 + rate)^periods. The result is the future balance; subtract the principal to get the interest earned. For monthly compounding, use the monthly rate and number of months.
=1000*(1+0.05)^10→$1,628.89$1,000 at 5% for 10 years.
Interest only
=A2*(1+B2)^C2 - A2Subtracts the principal to show earnings.
Use the monthly rate and month count: =A2*(1+annual/12)^(years*12).
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.