Hi,
if the annual grows of a number is 1%
how much is the grows for each one of the 12 month?
i.e. in a spreadsheet I want to show a starting number
which grows by a part of 1% each month.
After 12 months the total grows should be 1%.
Thanks so much,
Wil
calculate an annual 1% grows - how much grows is that for every one of the 12 months
-
-
Re: calculate an annual 1% grows - how much grows is that for every one of the 12 mon
Hi Wilfried,
Welcome to the forum..
explained here ...https://support.microsoft.com/en-us/kb/141695 -
Re: calculate an annual 1% grows - how much grows is that for every one of the 12 mon
well, maybe I just don't understand this,
but what I need is
January the starting amount is 1000,
in December it is 1010 -
so it grew by one percent.
How do I figure out, what the growing percentage was in February, March, etc.
and ends up being 1% after 12 months.
just dividing 1% by 12 (abt. 0.08% per month) won't work
because it grows a tiny bit more every month.
So, I know what the end result is, I just can not figure out,
how how to create that spreadsheet, where it shows the grows percentage per month
in order to add up to 1% after 12 months.
Thanks,
Wil -
Re: calculate an annual 1% grows - how much grows is that for every one of the 12 mon
its is correct
if its 12 per annum 1000*1%=10
which is 1/12= 0.083333%
0.083333 *12 =1010+1000 =1010
The interest is only calculated once not monthly
-
Re: calculate an annual 1% grows - how much grows is that for every one of the 12 mon
if you compound 1000 over 12 month at 0.083% you get 1010.00559343
-
-
Re: calculate an annual 1% grows - how much grows is that for every one of the 12 mon
This may help !!!
[tr]
1000 @ 1% for a year =1000 +(1000*0.01) = 1000*(1+0.1)=1000*1.01 = 1010
If you just want to know how it will grow if compounded monthly to achieve the same "1010", you have to find the 12th root of 1.01 this equals 1.01^(1/12) =1.00082953811if you then compound your 1000 over 12 months, which equals 1010.
[TABLE="width: 268"]
[td][/td]
[td]Yearly Rate
[/td]
[td]Mthly rate
[/td]
[/tr]
[tr]
[td][/td]
[/tr]
[TD="align: right"]1.01[/TD]
[TD="align: right"]1.000829538[/TD]
[tr]
[td]Month
[/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]
[TD="align: right"]1[/TD]
[TD="align: right"]1000.830[/TD]=1000*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]2[/TD]
[TD="align: right"]1001.660[/TD]=C4*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]3[/TD]
[TD="align: right"]1002.491[/TD]=C5*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]4[/TD]
[TD="align: right"]1003.322[/TD]=C6*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]5[/TD]
[TD="align: right"]1004.155[/TD]=C7*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]6[/TD]
[TD="align: right"]1004.988[/TD]=C8*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]7[/TD]
[TD="align: right"]1005.821[/TD]=C9*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]8[/TD]
[TD="align: right"]1006.656[/TD]=C10*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]9[/TD]
[TD="align: right"]1007.491[/TD]=C11*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]10[/TD]
[TD="align: right"]1008.326[/TD]=C12*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]11[/TD]
[TD="align: right"]1009.163[/TD]=C13*$C$2
[/td]
[/tr]
[tr]
[td]
[TD="align: right"]12[/TD]
[TD="align: right"]1010.000[/TD]=C14*$C$2
[/td]
[/tr]
[/TABLE]
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!