50.1K

Verified Solution

Link Copied!

hello. I need help. i have tracked the following stocks over last few months as well as the indices.. I need help liquidating my stocks and computing the rate of return. i also need the weighted average rate of return based on my original portfolio. Plz help all the info for the stocks is below only anwser if you know plz and ty will like. I really need help.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 4. & A & B & c & D & E & F & G & H \\ \hline 1 & & & & & & & & \\ \hline 2 & & & & & & & & \\ \hline 3 & & & & \multicolumn{5}{|c|}{ Stock Price or Index } \\ \hline 4 & & Stock or Index & & 31-Aug & 7-Sep & 14-Sep & 21-Sep & 28-5 \\ \hline 5 & & MICROSOFT CORPORATION (XNAS:MSFT) & & 328.05 & 331.06 & $340.37 & \$ 319.53 & \$ 314.3 \\ \hline 6 & & APPLE INC. (XNAS:AAPL) & & 189.03 & 176.25 & $175.62 & \$ 173.93 & \$ 171.9 \\ \hline 7 & & AMAZON.COM, INC. (XNAS:AMZN) & & 138.41 & 135.10 & $144.82 & $129.33 & $126.3 \\ \hline 8 & & IMeta Platforms, Inc. (XNAS:META) & & 297.69 & 299.89 & \$ 309.48 & $295.73 & $305.7 \\ \hline 9 & & NETFLIX, INC. (XNAS:NFLX) & & 434.97 & 438.47 & $404.05 & \$ 384.15 & $377.7 \\ \hline 10 & & NASDAQ Composite Index & & 14,077.10 & 13,676.01 & 13,926.37 & 13,223.99 & 13,249 \\ \hline 11 & & DOW JONES INDU AVERAGE NDX & & 34,772.59 & 34,452.13 & 34,881.15 & 34,070.42 & 33,730. \\ \hline 12 & & S\&P 500 INDEX & & 4,517.72 & 4,442.38 & 4,500.27 & 4,330.00 & 4,310 \\ \hline 13 & & Russell 2000 INDEX & & 1,905.53 & 1,858.06 & 1,863.13 & 1,783.13 & 1,798 \\ \hline 14 & & & & 8 & & & & \\ \hline 15 & & Stock or Index & \multicolumn{2}{|c|}{ Number of Shares } & & & & \\ \hline 16 & & MICROSOFT CORPORATION (XNAS:MSFT) & 305 & 100,055.25 & & & & \\ \hline 17 & & & 529 & 99,994.23 & & & & \\ \hline 18 & & AMAZON.COM, INC. (XNAS:AMZN) & 723 & 100,068.19 & & & & \\ \hline 19 & & Meta Platforms, Inc. (XNAS:META) & 336 & 100,024.11 & & & & \\ \hline 20 & & NETFLIX, INC. (XNAS:NFLX) & 230 & 100,041.95 & & & & \\ \hline 21 & & & Total & $500,183.72 & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 4. & A & B & c & D & E & F & G & H \\ \hline 1 & & & & & & & & \\ \hline 2 & & & & & & & & \\ \hline 3 & & & & \multicolumn{5}{|c|}{ Stock Price or Index } \\ \hline 4 & & Stock or Index & & 31-Aug & 7-Sep & 14-Sep & 21-Sep & 28-5 \\ \hline 5 & & MICROSOFT CORPORATION (XNAS:MSFT) & & 328.05 & 331.06 & $340.37 & \$ 319.53 & \$ 314.3 \\ \hline 6 & & APPLE INC. (XNAS:AAPL) & & 189.03 & 176.25 & $175.62 & \$ 173.93 & \$ 171.9 \\ \hline 7 & & AMAZON.COM, INC. (XNAS:AMZN) & & 138.41 & 135.10 & $144.82 & $129.33 & $126.3 \\ \hline 8 & & IMeta Platforms, Inc. (XNAS:META) & & 297.69 & 299.89 & \$ 309.48 & $295.73 & $305.7 \\ \hline 9 & & NETFLIX, INC. (XNAS:NFLX) & & 434.97 & 438.47 & $404.05 & \$ 384.15 & $377.7 \\ \hline 10 & & NASDAQ Composite Index & & 14,077.10 & 13,676.01 & 13,926.37 & 13,223.99 & 13,249 \\ \hline 11 & & DOW JONES INDU AVERAGE NDX & & 34,772.59 & 34,452.13 & 34,881.15 & 34,070.42 & 33,730. \\ \hline 12 & & S\&P 500 INDEX & & 4,517.72 & 4,442.38 & 4,500.27 & 4,330.00 & 4,310 \\ \hline 13 & & Russell 2000 INDEX & & 1,905.53 & 1,858.06 & 1,863.13 & 1,783.13 & 1,798 \\ \hline 14 & & & & 8 & & & & \\ \hline 15 & & Stock or Index & \multicolumn{2}{|c|}{ Number of Shares } & & & & \\ \hline 16 & & MICROSOFT CORPORATION (XNAS:MSFT) & 305 & 100,055.25 & & & & \\ \hline 17 & & & 529 & 99,994.23 & & & & \\ \hline 18 & & AMAZON.COM, INC. (XNAS:AMZN) & 723 & 100,068.19 & & & & \\ \hline 19 & & Meta Platforms, Inc. (XNAS:META) & 336 & 100,024.11 & & & & \\ \hline 20 & & NETFLIX, INC. (XNAS:NFLX) & 230 & 100,041.95 & & & & \\ \hline 21 & & & Total & $500,183.72 & & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer