Growth Rate?

[INCOMETAX111]

Dear i have some data like :

>3 months return =40%
>2months return =30%
>1months return =20%
>10days return = 3%
>3 days return =8%

then how to calculate growth rate ?

 

[p45cal]

Annual growth? Maybe:
=(1+40%)^(1/(3/12))-1 3 months is 3/12 years
=(1+30%)^(1/(2/12))-1 2 months is 2/12 years
=(1+20%)^(1/(1/12))-1 1 months is 1/12 years
=(1+3%)^(1/(10/365))-1 10 days is approx 10/365 years
=(1+8%)^(1/(3/365))-1 3 days is 3/365 years

ps. it would be nice if you occasionally said thanks to those who try to help you…

 

[BobBridges]

I'm guessing the same as p45cal, that you're looking for annual growth rate. But I don't understand his suggested answers. I'm thinking you want an interest rate, like this:

40% over three months works out to 1744% annual interest (that is, (1 + 40%)^3 - 1).

30% over two months is 3872% ((1+30%)^6 - 1).

20% each month is 8282% annually.

3% over ten day is 1941% annually.

8% over three days is 10656% annually.

Those are all ludicrously high interest rates, so maybe I've misunderstood what you want.

 

[p45cal]

But I don't understand his suggested answers.

I was trying to keep the fractions of a year in plain sight, the bits in red.
BTW, in your first formula are you sure that's not meant to be ^4 rather than ^3? (3 months is a quarter of a year, not a third)

 

[INCOMETAX111]

Annual growth? Maybe:
=(1+40%)^(1/(3/12))-1 3 months is 3/12 years
=(1+30%)^(1/(2/12))-1 2 months is 2/12 years
=(1+20%)^(1/(1/12))-1 1 months is 1/12 years
=(1+3%)^(1/(10/365))-1 10 days is approx 10/365 years
=(1+8%)^(1/(3/365))-1 3 days is 3/365 years

ps. it would be nice if you occasionally said thanks to those who try to help you…

thank you so much dear

 

[BobBridges]

Right you are, 3 months is a quarter of a year. I checked my answers, but not well enough.

I see now what you were saying. The lack of punctuation confused me before; all I saw that the formula was "(1+40%)^(1/(3/12))-1 3", followed by the claim that "months is 3/12 years".