Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

hi i really need help on this i know its alot but please image text in transcribed
image text in transcribed
image text in transcribed
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}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sport Finance

Authors: Gil Fried, Steven Shapiro, Timothy D. Deschriver

2nd Edition

0736067701, 978-0736067706

More Books

Students also viewed these Finance questions

Question

=+c) What is the response?

Answered: 1 week ago