CalcGlideDATA & CALCULATION
English

Compound Interest Calculator

Calculate compound interest and the total.

Open this template in the spreadsheet

Inputs

Result

Formula

Total = principal × (1 + annual rate ÷ (100 × n))^(n × years), where n is the number of compounding periods a year: 1, 2, 4, or 12. Interest = total − principal.

Calculation