Excel formula for compound interest?

Asked by: Marcos Osborne

A more efficient way of calculating compound interest in Excel is applying the general interest formula: FV = PV(1+r)n, where FV is future value, PV is present value, r is the interest rate per period, and n is the number of compounding periods.

What is compound formula in Excel?

Explanation: An easy and straightforward way to calculate the amount earned with an annual compound interest is using the formula to increase a number by percentage: =Amount * (1 + %) . In our example, the formula is =A2*(1+$B2) where A2 is your initial deposit and B2 is the annual interest rate.

What is the formula for calculating compound interest?

The mathematical formula for calculating compound interest, A=P(1+r/n)^nt, uses four simple numbers to allow you to see how much money plus interest you’ll have after the number of time periods, or compound periods. ‘A’ represents the accrued amount of your principal plus interest, which is the total.

What is the formula for monthly compound interest in Excel?

Compound Interest Formula with Monthly Contributions in Excel. If the interest is paid monthly then the formula for future value becomes, Future Value = P*(1+r/12)^(n*12).

How do I make a compound interest table in Excel?

Annual compound interest schedule

  1. =balance * rate. and the ending balance with:
  2. =balance+(balance*rate) So, for each period in the example, we use this formula copied down the table:
  3. =C5+(C5*rate) With the FV function. …
  4. =FV(rate,1,0,-C5)

How do you calculate simple interest and compound interest in Excel?

Calculate compound interest

  1. Calculate simple interest. The general formula for simple interest is: interest = principal * rate * term So, using cell references, we have: = C5 * C7 * C6 = 1000 * 10 * 0.05 = 500.
  2. Annual compound interest schedule. …
  3. Compare effect of compounding periods.