Index Question

Consider the following information on $4$ securities$,$ where all prices are quoted as at $4$:$00$pm on that day;

$\backslash$table$[[,$Stock A$,$Stock B$,$Stock C$,$Stock D$],[,$Price,# out,Price,# out,Price,# out,Price,# out,$],[$Day t$=0,26,200,50,100,5,1000,150,50,],[$Day t$=1,24\mathrm{.}50,?,53,?,3,?,53,?,],[$Day t$=2,24,?,46\mathrm{.}50,?,1\mathrm{.}90,?,55\mathrm{.}75,?,],[$Day t$=3,25\mathrm{.}25,?,46\mathrm{.}80,?,9\mathrm{.}20,?,56\mathrm{.}50,?,]]$

Further, let the following hold;

At $4$:$01$pm on day $t=0,$ Stock $D$ split $3$:$1$

At $4$:$01$pm on Day $t=1,$ Stock B paid a $15\%$ stock dividend

At $4$:$01$pm on Day $t=2,$ Stock C split $1$:$5($reverse$)$

Calculate the index values and daily returns using the price$-$weighting methodology. Which stock$($s$)$ is$($are$)$ driving the index value? Why?

Calculate the index values and daily returns using the market$-$weighting methodology, assuming a starting value of $100.$ Which stock$($s$)$ is$($are$)$ driving the index value? Why?

Calculate the index values and daily returns using the equal$-$weighting methodology, assuming a starting value of $100,$ and an initial investment of $$100$ in each security

Calculate the index values and daily returns using the geometric return or value$-$line methodology, assuming a starting base value of $100$

Please provide a solution to using the excel