Enter a formula in cell H24 to calculate Weighted Average Shares. Here are a couple of hints. You will need to add 100% to the stock dividend rate before you multiply that value in the formula. You will need an =IF for the stock split because if there is no split (the value in column G is blank) you need to multiply by 1 not 0. Excel reads a blank cell as a 0 in formulas.

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G & H \\ \hline \begin{tabular}{l} Months with \\ transactions \\ to issue or \\ repurchase \\ stock. \end{tabular} & & \begin{tabular}{l} Number of \\ Shares \end{tabular} & \begin{tabular}{l} \# of months \\ shares are \\ outstanding \end{tabular} & \begin{tabular}{l} out of 12 Months in \\ the year \end{tabular} & \begin{tabular}{l} Enter the \% of the stock \\ dividend for all \\ transactions prior to \\ month the dividend \\ occurs. \end{tabular} & \begin{tabular}{l} Enter the stock split \\ amount (ex: 2 for a 2:1 \\ split) for all transactions \\ prior to the month the \\ split occurs. \end{tabular} & \begin{tabular}{l} Weighted Average \\ Shares \end{tabular} \\ \hline January & Beginning Balance & 150,000 & 12 & 12 & 10% & 2 & 2 \\ \hline March & Issued Shares & 13,000 & 10 & 12 & 10% & 2 & 2 \\ \hline May & Purchased Treasury Shares & (500) & 8 & 12 & 10% & 6 & 2 \\ \hline June & Sold Treasury Shares & 200 & 7 & 12 & 10% & 2 & 2 \\ \hline September & Sold Treasury Shares & 100 & 4 & 12 & & 2 & 2 \\ \hline TOTAL & & & & & & & \\ \hline \end{tabular}