Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the total returns on the portfolio investment using the information below Progress of share portfolio begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} hline & & & & & begin{tabular}{l} As
Calculate the total returns on the portfolio investment using the information below
Progress of share portfolio \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & & & & & \begin{tabular}{l} As at \\ Oct \\ 4th \\ 2023 \end{tabular} & \begin{tabular}{l} As at Oct \\ 4 th 2023 \end{tabular} & \begin{tabular}{l} As at Nov \\ 2nd 2023 \end{tabular} & \begin{tabular}{l} As at \\ Nov 2nd \\ 2023 \end{tabular} & \begin{tabular}{l} As at Oct \\ 4 th 2023 \end{tabular} & \begin{tabular}{l} As at Nov \\ 2nd 2023 \end{tabular} \\ \hline \begin{tabular}{l} QT \\ Y \end{tabular} & \begin{tabular}{l} Share \\ Descripti \\ on \end{tabular} & Beta & \begin{tabular}{l} Portfol \\ io Beta \end{tabular} & \begin{tabular}{l} Buy/Se \\ II \end{tabular} & \begin{tabular}{l} Buy \\ price \\ per \\ share \\ now \end{tabular} & \begin{tabular}{l} Buy \\ Value \\ Total \end{tabular} & \begin{tabular}{l} Present \\ Value \end{tabular} & \begin{tabular}{l} Gross \\ Book \\ Profit or \\ Loss \end{tabular} & \begin{tabular}{l} Distributi \\ on % \end{tabular} & \begin{tabular}{l} Distributi \\ on % \end{tabular} \\ \hline 70 & AAPL & \begin{tabular}{l} 1.3 \\ 0 \end{tabular} & & B & \begin{tabular}{l} 174.1 \\ 1 \end{tabular} & \begin{tabular}{l} 12,187. \\ 70 \end{tabular} & \begin{tabular}{l} 12,286. \\ 40 \end{tabular} & 98.70 & 14.70 & 14.10 \\ \hline 37 & MSFT & \begin{tabular}{l} 0.8 \\ 8 \end{tabular} & & B & \begin{tabular}{l} 318.2 \\ 5 \end{tabular} & \begin{tabular}{l} 11,775. \\ 25 \end{tabular} & \begin{tabular}{l} 12,847. \\ 88 \end{tabular} & \begin{tabular}{l} 1,072. \\ 63 \end{tabular} & 14.21 & 14.75 \\ \hline 51 & v & \begin{tabular}{l} 0.9 \\ 5 \end{tabular} & & B & \begin{tabular}{l} 231.0 \\ 0 \end{tabular} & \begin{tabular}{l} 11,781. \\ 00 \end{tabular} & \begin{tabular}{l} 14,989. \\ 41 \end{tabular} & \begin{tabular}{l} 3,208 \\ 41 \end{tabular} & 14.21 & 17.21 \\ \hline \begin{tabular}{l} 22 \\ 0 \end{tabular} & & \begin{tabular}{l} 0.5 \\ 9 \end{tabular} & & B & 54.88 & \begin{tabular}{l} 12,073. \\ 60 \end{tabular} & \begin{tabular}{l} 12,430. \\ 00 \end{tabular} & 356.40 & 14.57 & 14.27 \\ \hline 86 & GOOG & 1.5 & & B & \begin{tabular}{l} 136.0 \\ 9 \end{tabular} & \begin{tabular}{l} 11,703. \\ 74 \end{tabular} & \begin{tabular}{l} 11,142. \\ 16 \end{tabular} & \begin{tabular}{l} (561.5 \\ 8) \end{tabular} & 14.12 & 12.79 \\ \hline 97 & KMB & \begin{tabular}{l} 0.4 \\ 0 \end{tabular} & & B & \begin{tabular}{l} 120.2 \\ 6 \end{tabular} & \begin{tabular}{l} 11,665. \\ 22 \end{tabular} & \begin{tabular}{l} 11,662. \\ 31 \end{tabular} & (2.91) & 14.07 & 13.39 \\ \hline 30 & voo & \begin{tabular}{l} 1.0 \\ 0 \end{tabular} & & B & \begin{tabular}{l} 389.9 \\ 1 \end{tabular} & \begin{tabular}{l} 11,697. \\ 30 \end{tabular} & \begin{tabular}{l} 11,757. \\ 90 \end{tabular} & 60.60 & 14.11 & 13.50 \\ \hline \multicolumn{3}{|c|}{ Total } & 0.95 & & & \begin{tabular}{l} 82,883. \\ 81 \end{tabular} & \begin{tabular}{l} 87,116. \\ 06 \end{tabular} & \begin{tabular}{l} 4,232 \\ 25 \end{tabular} & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|} \hline & & & & \begin{tabular}{l} As at \\ Nov \\ 3rd \\ 2023 \end{tabular} & & \begin{tabular}{l} As at Nov \\ 17 th 2023 \end{tabular} & \begin{tabular}{l} Since \\ Oct 4th \\ 2023 \end{tabular} & \begin{tabular}{l} As at Nov \\ 17 th 2023 \end{tabular} \\ \hline QTY & \begin{tabular}{l} Share \\ Description \end{tabular} & Beta & \begin{tabular}{l} Portfolio \\ Beta \end{tabular} & Buy/Sell & \begin{tabular}{l} Bury \\ price \end{tabular} & \begin{tabular}{l} Bury Valuc \\ Total \end{tabular} & \begin{tabular}{l} Present \\ Valuc \end{tabular} & \begin{tabular}{l} Gross \\ Book \end{tabular} & \begin{tabular}{l} Distribution \\ % \end{tabular} \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & & & & & \begin{tabular}{l} per \\ share \\ now \end{tabular} & & & \begin{tabular}{l} Profit or \\ Loss \end{tabular} & \\ \hline 70 & AAPL & 1.30 & & Hold & 174.24 & 12,196.80 & 13,317.50 & 1,129.80 & 15.27 \\ \hline 54 & MSFT & 0.88 & & B & 349.63 & 18,880.02 & 20,174.94 & 8,399.69 & 23.14 \\ \hline 59 & v & 0.95 & & B & 245.12 & 14,462.08 & 14,717.55 & 2,936.55 & 16.88 \\ \hline 257 & KO & 0.59 & & B & 57.40 & 14,751.80 & 14,697.83 & 2,642.23 & 16.86 \\ \hline 86 & GOOG & 1.5 & & s & N/A & N/A & N/A & ? & N/A \\ \hline 97 & KMB & 0.40 & & Hold & 121.29 & 11,765.13 & 11,859.22 & 161.92 & 13.60 \\ \hline 30 & Voo & 1.00 & & Hold & 397.92 & 11,937.60 & 12,419.70 & 722.40 & 14.24 \\ \hline \multicolumn{3}{|c|}{ Portfolio Beta } & 0.86 & & & & & & \\ \hline & & & & & & & & & \\ \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