Caculate yield over a period of time

[Guest]

I have range A2:B7 bonus shares history of a company.I am looking for a
function in E3 to get Number of shares I hold On Sale date(E2).My data is
Col A -------------Col B ---------Col C ------Col D ----------Col E
1. Date -------------BonusRatio--- ------ ------Buy Date ----- Sale Date
2. 07-Jul-2004 ------ 1:1 ---- ------- -----10-Feb-2005 ---
25-Aug-2006
3. 03-Mar-2005 ----- 1:5 ---- -------- ---- 100 --- ?
4. 19-Jan-2006 ----- 1:1
5. 25-jan-2007 ------ 1:2
6.
7.

D2=shares buy date,D3= number of shares bought.I am looking for a function
in E3,how many shares I hold on sale date i.e on 25-aug-2006(sharesI
bought+bonus shares yield).answer is 240.

 

[Bill Kuunders]

how about

=(D3*(1+B3))*(1+B4)
and for the next period
=((D3*(1+B3))*(1+B4))*(1+B5)

note the extra brackets


but you do need to change the ratio's into decimals
b3 = 0.2
b4 =1
b5=0.5

 

[Guest]

Mr.Bill, your formula is not right.You have given a constant formula to my
question.When I am changing sale date(25-Aug_2006) with other dates it is
giving wrong results.The formula should autumatically calculate time period
from Bonus table range A2:B7.

 

[Bill Kuunders]

Please post the question again, perhaps with a couple of examples and
results.

 

[Guest]

Please refer to my new post named "Bonus Yield calculation".Thanks.