Compound interest in Excel is calculated using the standard formula A = P(1 + r/n)^(nt), where P is the starting principal, r is the annual rate written as a decimal, n is the number of compounding periods per year, and t is the number of years. You can either type this formula into any cell, or use Excel's built-in FV function to produce the same result with a single named operation. The compound interest calculation is what makes a savings balance grow faster than it would under simple interest: each time interest is credited, that interest is added to the balance, and the next period's interest is calculated on the larger base. Excel is the natural choice when you want a reusable spreadsheet, side-by-side scenario comparisons, or a calculation tied to other rows of data in your workbook. A browser-based calculator such as the Compound Interest Calculator is the natural choice when you want a quick answer without building columns and cell references. Both approaches use the same math, so the results match to the cent when the inputs match.
The Compound Interest Formula and What Each Variable Means
The compound interest formula has just four variables you control, plus one result that the formula returns. Spelling out what each piece means keeps mistakes out of your spreadsheet and makes it easy to troubleshoot when a result looks wrong. The formula is the same one used by banks, brokerages, and exam questions, and it is the same formula that the Compound Interest Calculator runs under the hood, as described in the standard reference on compound interest.
| Variable | What it stands for | How it appears in Excel |
|---|---|---|
| P | Starting principal, the lump sum you deposit or invest at the start | A cell reference such as B1 containing 1000 |
| r | Annual interest rate written as a decimal (10% becomes 0.10) | The annual rate divided by 100, or stored already in decimal form |
| n | Number of compounding periods per year | 1 for annual, 2 for semiannual, 4 for quarterly, 12 for monthly, 365 for daily |
| t | Number of years the money stays invested | A whole number or a fraction such as 5 or 7.5 |
| A | Final amount, the result the formula returns | The cell where the formula lives |
Two related quantities follow from A. The interest earned is simply A minus P, and the effective annual rate (often called APY) is the rate that, compounded once per year, would produce the same final amount. The effective rate is always higher than the nominal rate when n is greater than 1, and the gap widens as n grows. The future value of a single lump sum is also documented separately as a general finance concept, which is useful background if you want to extend the formula to annuities or perpetuities.
How to Calculate Compound Interest in Excel
Excel gives you two main ways to land on the same answer: type the formula directly into a cell, or call the built-in FV function. The formula approach is best when you want to see every variable in plain sight, while the FV function is best when you want a single, named operation that other people can read at a glance. Both methods use the same math, and the same formula appears in the future value reference used across finance textbooks.
Method 1: Type the formula directly
- Put the principal in cell B1, the annual rate as a decimal in B2, the compounding periods per year in B3, and the number of years in B4.
- In any other cell, type =B1*(1+B2/B3)^(B3*B4) and press Enter.
- Excel returns the final amount A. Subtract the principal to get the interest earned.
Method 2: Use the FV function
- Put the principal in B1, the annual rate in B2, the periods per year in B3, and the years in B4.
- In another cell, type =FV(B2/B3, B3*B4, 0, -B1) and press Enter.
- FV returns the future value with the sign convention that money paid out is negative; multiply by -1 if you want a positive number on display.
Worked example, both methods. Deposit $1,000 at a 10% annual rate for 5 years, compounding once per year. With the direct formula: A = 1000 × (1 + 0.10/1)^(1×5) = 1000 × 1.10^5 = 1000 × 1.61051 = $1,610.51. The interest earned is $1,610.51 − $1,000 = $610.51. With the FV function on the same numbers, the cell returns $1,610.51 as well. The country-specific decimal separator in Excel is a comma in many locales, so if your version uses commas, swap the commas in the formula for semicolons.
How to Calculate Compound Interest in Your Browser
When you do not need a reusable spreadsheet, the Compound Interest Calculator handles the same calculation without any cell setup. It runs locally in your browser, so none of your figures are uploaded or stored. The calculator is built around the compounding-frequency effect, so switching the frequency dropdown is the fastest way to see how the same principal grows differently under annual, semiannual, quarterly, monthly, or daily compounding.
- Enter your starting principal and the annual interest rate.
- Pick how often interest compounds — annually, semiannually, quarterly, monthly, or daily — and the number of years.
- Read the final amount and the total interest earned, and switch the frequency to see the compounding effect.
Because the calculator and Excel share the same formula, a result you get in one should match the other to the cent when the inputs match. If you ever see a discrepancy, the usual cause is the rate being entered as a percentage (10) instead of a decimal (0.10) in the spreadsheet, or the compounding frequency being chosen differently in each tool. The calculator also lets you change just one variable at a time, which is the cleanest way to test whether the spreadsheet formula is wired up correctly.
Why Compounding Frequency Changes the Result
All five compounding frequencies in the calculator use the same formula, but the value of n changes how often interest is credited. Each time interest is credited, it joins the balance, and the next period's interest is calculated on that larger base. More frequent crediting means interest starts earning interest sooner, which is why daily compounding produces a larger final balance than monthly, which beats quarterly, which beats annual. The mathematical reason is that (1 + r/n)^(nt) grows as n grows, holding r and t constant.
| Compounding frequency | Periods per year (n) | Direction of the effect |
|---|---|---|
| Annually | 1 | Baseline; interest is credited once a year |
| Semiannually | 2 | Credited twice a year; modest lift over annual |
| Quarterly | 4 | Credited every three months; clearly above annual |
| Monthly | 12 | Credited each month; meaningful difference at higher rates |
| Daily | 365 | Credited every day; the largest balance of the five options |
The same comparison at higher rates, larger balances, or multi-decade horizons shows the gap widening rather than shrinking, which is the practical reason banks and brokerages always advertise the APY alongside the nominal rate. The APY is the effective annual yield after crediting frequency is factored in, and it is the only number you can compare directly across products with different compounding schedules. For an apples-to-apples comparison, run the calculator once per product using its stated rate and compounding schedule, then read the final amount and the interest earned side by side.
When the Calculator Is and Isn't the Right Tool
The Compound Interest Calculator focuses on a single lump sum and the effect of compounding frequency. It assumes a fixed rate, no additional deposits or withdrawals, and no taxes or fees, so it is a planning aid rather than a guarantee. If you plan to add money every month or year, the model is not the right fit, and a Savings Calculator built around recurring contributions is the better choice. For non-compounding interest, a Simple Interest Calculator handles the flat-interest case in a single step.
Real returns vary, and tax treatment differs by account and country. Confirm the exact compounding schedule, rate, and any fees with your bank or a licensed financial professional before making a decision based on a calculated figure. The compound interest model is also the right foundation for thinking about certificates of deposit, many bonds, and any investment quoted with a fixed nominal rate and a stated compounding schedule, so the tool can be used to compare offers across product types. When the rate is 0%, there is no growth, so the final amount equals the principal and the interest earned is zero, which is a useful sanity check the next time you build the formula in a spreadsheet.