Using a dynamic formula to calculate value of reinvested dividends over time periods

Hi Everyone,

I am trying to calculate the value of reinvested dividends on a daily basis over changing time periods. I can't seem to find an ideal formula that works for me without the dynamic array values requiring the value above it to calculate itself.

All I want to do is create a dynamic array that will identify if a dividend is paid on a date which will then be "reinvested' back into the company and grow at the same rate that the share price moves. All the dividends must be reinvested at the dates they are paid out (in my case go ex-div) and accumulate on top of the dividends that have been reinvested and grown at prior dates.

And if I extend the time period the calculations will change to accommodate a longer or shorter period which I can plot on a chart.

In the mini-sheet, dynamic arrays for the share price and price returns are dynamic (grey) but the dividend reinvestment array is static (white). The dividend information (Amount and date) are in the table on the right.

Also the start date is assumed to be when an investor buys the share. So any dividends paid out before the start period are irrelevant as they would not have received those amounts.

I'm not too sure if this is possible but I seriously would appreciate the help. I've been stuck on it for a while.

Apologies Ali,

This is my first post on a forum and I was unaware of this rule.

Thanks for letting me know.