hi i really need help on this i know its alot but please
Go to the allocation tab Calculate the value of your positions of Apple, Google, and Microsoft. You start out with $100,000. Then you maltiply that by the allocation percent for each stock and divide by the price to find the number of shares purchased. The number of shares stays constant but the price changes. Calculate the sum of those values to calculate the porfolio value. Calculate the returns on the portfolio and the benchmark, QQQ Those returns are linked to the Portfolio Evaluation tab. Go to that tab and do the performance evaluation calculations. Instructions Portfolio Evaluation Allocation \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Daic & APL. & GOOG & MSET & QQQ & ANI._pos & G00G_pen & MSVT_pos & Porifolio Value & \begin{tabular}{l} Pertfolio \\ Retura \end{tabular} & \begin{tabular}{l} Benchmark \\ Return \end{tabular} & \begin{tabular}{l} Partfelle Starting \\ Valee \end{tabular} \\ \hline 121/22 & $129.21 & 5kx.73 & 523771 & 2644872 & $40,00000 & & & & & & \\ \hlinet/23 & $143.40 & 5007 & $245.63 & 293.337 & & & & & & & \\ \hline 3/1/23 & 5164.23 & $10400 & $26.48 & 3195325 & & & & & & & \\ \hline 41/23 & 5168.99 & sics22 & 5305.52 & 321.6525 & & & & & & & \\ \hline 5/1/23 & 5176.53 & 512337 & $326.32 & 347.011 & & & & & & & \\ \hline W1/23 & 5193.45 & $120.97 & 5339.13 & 368.3807 & & & & & & & \\ \hline 7/23 & $19593 & 5133.11 & 5334.53 & 383.1254 & & & & & & & \\ \hline 8/23 & 51737 & 513735 & $32641 & 377+436 & & & & & & & \\ \hline 9/23 & 5170.58 & 513185 & 5315.11 & 357.7521 & & & & & & & \\ \hline 101/23 & 5170.55 & 512530 & 513743 & 350.87 & & & & & & & \\ \hline 11/1/23 & $150.70 & 513302 & 53714 & 3883 & & & & & & & \\ \hline 12123 & 5104.71 & 513364 & $3748 & 398.67 & & & & & & & \\ \hline \end{tabular} Instructions Portfolio Evaluation Allocation \begin{tabular}{|c|c|c|c|c|} \hline Date & Portfolio Ret & Bench Ret & Cumulative Portfolio Ret & Cumulative Bench Ret \\ \hline 1/1/23 & 0.00% & 0.00% & & \\ \hline 2/1/23 & 0.00% & 0.00% & & \\ \hline 3/1/23 & 0.00% & 0.00% & & \\ \hline 4/1/23 & 0.00% & 0.00% & & \\ \hline 5/1/23 & 0.00% & 0.00% & & \\ \hline 6/1/23 & 0.00% & 0.00% & & \\ \hline 7/1/23 & 0.00% & 0.00% & & \\ \hline 8/1/23 & 0.00% & 0.00% & & \\ \hline 9/1/23 & 0.00% & 0.00% & & \\ \hline 10/1/23 & 0.00% & 0.00% & & \\ \hline 11/1/23 & 0.00% & 0.00% & & \\ \hline \multirow[t]{2}{*}{12/1/23} & 0.00% & 0.00% & & \\ \hline & Portfolio & Benchmark & \begin{tabular}{l} 3 Month Treasury as of \\ December 13th \end{tabular} & \\ \hline \multicolumn{5}{|l|}{ Anuual Return } \\ \hline \multicolumn{5}{|l|}{ Anaual Stdev } \\ \hline \multicolumn{5}{|l|}{ Sharpe } \\ \hline \multicolumn{5}{|l|}{ Beta } \\ \hline \multicolumn{5}{|l|}{ Treynor } \\ \hline Alpha & & & & \\ \hline \end{tabular}