How to calculate compound interest?

Jakest

New Member
Joined
Oct 10, 2019
Messages
7
hello first post here

i want to learn to calculate compound interest using excel
how do i do that?

let say i have 1000$ and it gets 10% raised every week
how do i calculate the total growth in 1 year?
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Finalfight40

Active Member
Joined
Apr 24, 2018
Messages
273
Office Version
365
Platform
Windows
Can you not use the same idea provided in the link by Special-k99?

Where you have

=A1*(1+B1)^C1

where A1 is the initial value
B1 is the interest
C1 is the number of weeks
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

First step is to determine if your interest rate is

A. 10% per year
or
B. 10% per week ...

Formula is = Amount * (1+i)^52

A. gives a result : 142'042.93

B. gives a result : 1'105.06

There is a tiny difference ...!!!
 
Last edited:

Jakest

New Member
Joined
Oct 10, 2019
Messages
7
let say i get 10$ every week
and im getting 10% raise every week

how much it will be the amount in 52 and 104 weeks?
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Impressive 10% per week ... !!!

Mathematically :

1'000 * ( 1 + 10% ) ^ 52 = 142' 042.93

1'000 * ( 1 + 10% ) ^ 104 = 20'176'194.52
 

Finalfight40

Active Member
Joined
Apr 24, 2018
Messages
273
Office Version
365
Platform
Windows
shouldn't be 10 instead of 1,000?
Also i just want to add something else you said which either i misunderstood or James missed.

For your newest example did you want to add 10% interest AND an extra $10 each week?
 

Forum statistics

Threads
1,089,597
Messages
5,409,183
Members
403,256
Latest member
Viq

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top