Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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} Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started