Question: begin{tabular}{|c|c|c|c|c|c|c|c|c|} hline & A & B & C & D & E & F & G & H hline 1 & multicolumn{8}{|c|}{ STANDARD &

$\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D &$

$E & F & G & H \\ \hline 1 & \multicolumn{8}{|c|}{$

$STANDARD \& POOR'S 500 (S\&P 500) SHARPE RATIO } \\ \hline 2$

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & \multicolumn{8}{|c|}{ STANDARD \& POOR'S 500 (S\&P 500) SHARPE RATIO } \\ \hline 2 & Date & \begin{tabular}{c} S\&P 500 \\ adjusted \\ price \end{tabular} & \begin{tabular}{l} Annual \\ return \end{tabular} & \begin{tabular}{l} One \\ year risk- \\ free \\ return \end{tabular} & \begin{tabular}{l} S\&P \\ minus \\ risk- \\ free \end{tabular} & & & \begin{tabular}{l} S\&P 500 minus \\ risk-free return \end{tabular} \\ \hline 3 & \#\#\#\#\#\#\#\# & 329.08 & & & & & Mean & \\ \hline 4 & \#\#\#\#\#\#\# & 343.93 & & 6.82% & & & Standard deviation & \\ \hline 5 & \#\#\#\#\#\#\#\# & 408.78 & & 4.12% & & & Sharpe ratio & \\ \hline 6 & H\#\#\#\#\#\#\# & 438.78 & & 3.61% & & & & \\ \hline 7 & \#\#\#\#\#\#\#\# & 481.61 & & 3.63% & & & & \\ \hline 8 & \#\#\#\#\#\#\#\# & 470.42 & & 7.20% & & & & \\ \hline 9 & \#\#\#\#\#\#\#\# & 636.02 & & 5.18% & & & & \\ \hline 10 & \#\#\#\#\#\#\#\# & 786.16 & & 5.51% & & & & \\ \hline 11 & \#\#\#\#\#\#\#\# & 980.28 & & 5.51% & & & & \\ \hline 12 & \#\#\#\#\#\#\#\# & 1,279.64 & & 4.53% & & & & \\ \hline 13 & \#\#\#\#\#\#\#\# & 1,394.46 & & 5.98% & & & & \\ \hline 14 & \#\#\#\#\#\#\#\# & 1,366.01 & & 5.32% & & & & \\ \hline 15 & \#\#\#\#\#\#\#\# & 1,130.20 & & 2.17% & & & & \\ \hline 16 & H\#\#\#\#\#\#\#\# & 855.7 & & 1.32% & & & & \\ \hline 17 & \#\#\#\#\#\#\#\# & 1,131.13 & & 1.26% & & & & \\ \hline 18 & H\#\#\#\#\#\#\# & 1,181.27 & & 2.75% & & & & \\ \hline 19 & \#\#\#\#\#\#\#\# & 1,280.08 & & 4.38% & & & & \\ \hline 20 & \#\#\#\#\#\#\#\# & 1,438.24 & & 5.00% & & & & \\ \hline 21 & \#\#\#\#\#\#\#\# & 1,378.55 & & 3.34% & & & & \\ \hline 22 & & 825.88 & & 0.37% & & & & \\ \hline 23 & \#\#\#\#\#\#\#\# & 1,073.87 & & 0.47% & & & & \\ \hline 2 & & 1286.12 & & 0.20% & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Date & price & return & return & free & & risk-free return \\ \hline \#\#\#\#\#\#\# & 329.08 & & & & Mean & \\ \hline \#\#\#\#\#\#\#\# & 343.93 & & 6.82% & & Standard deviation & \\ \hline \#\#\#\#\#\#\# & 408.78 & & 4.12% & & Sharpe ratio & \\ \hline \#\#\#\#\#\#\#\# & 438.78 & & 3.61% & & & \\ \hline \#\#\#\#\#\#\#\# & 481.61 & & 3.63% & & & \\ \hline \#\#\#\#\#\#\#\# & 470.42 & & 7.20% & & & \\ \hline \#\#\#\#\#\#\# & 636.02 & & 5.18% & & & \\ \hline & 786.16 & & 5.51% & & & \\ \hline \#\#\#\#\#\#\#\# & 980.28 & & 5.51% & & & \\ \hline \#\#\#\#\#\#\#\# & 1,279.64 & & 4.53% & & & \\ \hline & 1,394.46 & & 598% & & & \\ \hline |\#\#\#\#\#\#\# & 1,366.01 & & 5.32% & & & \\ \hline \#\#\#\#\#\#\# & 1,130.20 & & 2.17% & & & \\ \hline \#\#\#\#\#\#\# & 855.7 & & 1.32% & & & \\ \hline & 1,131.13 & & 1.26% & & & \\ \hline \#\#\#\#\#\#\#\# & 1,181.27 & & 2.75% & & & \\ \hline & 1,280.08 & & 4.38% & & & \\ \hline & 1,438.24 & & 5.00% & & & \\ \hline & 1,378.55 & & 3.34% & & & \\ \hline | H\#\#\#\#\#\#\# & 825.88 & & 0.37% & & & \\ \hline & 1,073.87 & & 0.47% & & & \\ \hline H\#\#\#\#\#\#\# & 1,286.12 & & 0.29% & & & \\ \hline H\#\#\#\#\#\#\# & 1,312.41 & & 0.12% & & & \\ \hline & 1,498.11 & & 0.16% & & & \\ \hline & 1,782.59 & & 0.13% & & & \\ \hline & 1,994.99 & & 0.10% & & & \\ \hline \end{tabular} \begin{tabular}{l|l|l|l} \hline 1 & & Genjamin Braham & Barren Wuffett \\ \hline 2 & Mean return & 14% & 12% \\ \hline 3 & Standard deviation & 16% & 11% \\ \hline 4 & & & \\ \hline 5 & Risk-free rate & 3% & \\ \hline 6 & & & \\ \hline 7 & Section a. & & \\ \hline 8 & Sharpe ratio & & \\ \hline 9 & Which fund manager is better? & & \\ \hline 10 & & & \\ \hline 11 & Section b. & & \\ \hline 12 & Target standard deviation & & \\ \hline 13 & Weight in Barren Woffett & & \\ \hline 14 & Weight in risk-free & & \\ \hline 15 & Average return & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & \multicolumn{8}{|c|}{ STANDARD \& POOR'S 500 (S\&P 500) SHARPE RATIO } \\ \hline 2 & Date & \begin{tabular}{c} S\&P 500 \\ adjusted \\ price \end{tabular} & \begin{tabular}{l} Annual \\ return \end{tabular} & \begin{tabular}{l} One \\ year risk- \\ free \\ return \end{tabular} & \begin{tabular}{l} S\&P \\ minus \\ risk- \\ free \end{tabular} & & & \begin{tabular}{l} S\&P 500 minus \\ risk-free return \end{tabular} \\ \hline 3 & \#\#\#\#\#\#\#\# & 329.08 & & & & & Mean & \\ \hline 4 & \#\#\#\#\#\#\# & 343.93 & & 6.82% & & & Standard deviation & \\ \hline 5 & \#\#\#\#\#\#\#\# & 408.78 & & 4.12% & & & Sharpe ratio & \\ \hline 6 & H\#\#\#\#\#\#\# & 438.78 & & 3.61% & & & & \\ \hline 7 & \#\#\#\#\#\#\#\# & 481.61 & & 3.63% & & & & \\ \hline 8 & \#\#\#\#\#\#\#\# & 470.42 & & 7.20% & & & & \\ \hline 9 & \#\#\#\#\#\#\#\# & 636.02 & & 5.18% & & & & \\ \hline 10 & \#\#\#\#\#\#\#\# & 786.16 & & 5.51% & & & & \\ \hline 11 & \#\#\#\#\#\#\#\# & 980.28 & & 5.51% & & & & \\ \hline 12 & \#\#\#\#\#\#\#\# & 1,279.64 & & 4.53% & & & & \\ \hline 13 & \#\#\#\#\#\#\#\# & 1,394.46 & & 5.98% & & & & \\ \hline 14 & \#\#\#\#\#\#\#\# & 1,366.01 & & 5.32% & & & & \\ \hline 15 & \#\#\#\#\#\#\#\# & 1,130.20 & & 2.17% & & & & \\ \hline 16 & H\#\#\#\#\#\#\#\# & 855.7 & & 1.32% & & & & \\ \hline 17 & \#\#\#\#\#\#\#\# & 1,131.13 & & 1.26% & & & & \\ \hline 18 & H\#\#\#\#\#\#\# & 1,181.27 & & 2.75% & & & & \\ \hline 19 & \#\#\#\#\#\#\#\# & 1,280.08 & & 4.38% & & & & \\ \hline 20 & \#\#\#\#\#\#\#\# & 1,438.24 & & 5.00% & & & & \\ \hline 21 & \#\#\#\#\#\#\#\# & 1,378.55 & & 3.34% & & & & \\ \hline 22 & & 825.88 & & 0.37% & & & & \\ \hline 23 & \#\#\#\#\#\#\#\# & 1,073.87 & & 0.47% & & & & \\ \hline 2 & & 1286.12 & & 0.20% & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline Date & price & return & return & free & & risk-free return \\ \hline \#\#\#\#\#\#\# & 329.08 & & & & Mean & \\ \hline \#\#\#\#\#\#\#\# & 343.93 & & 6.82% & & Standard deviation & \\ \hline \#\#\#\#\#\#\# & 408.78 & & 4.12% & & Sharpe ratio & \\ \hline \#\#\#\#\#\#\#\# & 438.78 & & 3.61% & & & \\ \hline \#\#\#\#\#\#\#\# & 481.61 & & 3.63% & & & \\ \hline \#\#\#\#\#\#\#\# & 470.42 & & 7.20% & & & \\ \hline \#\#\#\#\#\#\# & 636.02 & & 5.18% & & & \\ \hline & 786.16 & & 5.51% & & & \\ \hline \#\#\#\#\#\#\#\# & 980.28 & & 5.51% & & & \\ \hline \#\#\#\#\#\#\#\# & 1,279.64 & & 4.53% & & & \\ \hline & 1,394.46 & & 598% & & & \\ \hline |\#\#\#\#\#\#\# & 1,366.01 & & 5.32% & & & \\ \hline \#\#\#\#\#\#\# & 1,130.20 & & 2.17% & & & \\ \hline \#\#\#\#\#\#\# & 855.7 & & 1.32% & & & \\ \hline & 1,131.13 & & 1.26% & & & \\ \hline \#\#\#\#\#\#\#\# & 1,181.27 & & 2.75% & & & \\ \hline & 1,280.08 & & 4.38% & & & \\ \hline & 1,438.24 & & 5.00% & & & \\ \hline & 1,378.55 & & 3.34% & & & \\ \hline | H\#\#\#\#\#\#\# & 825.88 & & 0.37% & & & \\ \hline & 1,073.87 & & 0.47% & & & \\ \hline H\#\#\#\#\#\#\# & 1,286.12 & & 0.29% & & & \\ \hline H\#\#\#\#\#\#\# & 1,312.41 & & 0.12% & & & \\ \hline & 1,498.11 & & 0.16% & & & \\ \hline & 1,782.59 & & 0.13% & & & \\ \hline & 1,994.99 & & 0.10% & & & \\ \hline \end{tabular} \begin{tabular}{l|l|l|l} \hline 1 & & Genjamin Braham & Barren Wuffett \\ \hline 2 & Mean return & 14% & 12% \\ \hline 3 & Standard deviation & 16% & 11% \\ \hline 4 & & & \\ \hline 5 & Risk-free rate & 3% & \\ \hline 6 & & & \\ \hline 7 & Section a. & & \\ \hline 8 & Sharpe ratio & & \\ \hline 9 & Which fund manager is better? & & \\ \hline 10 & & & \\ \hline 11 & Section b. & & \\ \hline 12 & Target standard deviation & & \\ \hline 13 & Weight in Barren Woffett & & \\ \hline 14 & Weight in risk-free & & \\ \hline 15 & Average return & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

please fill out the provided Excel sheet! thank you Solid Stable Furniture uses a process cost system to account for its table factory. Beginning inventory consisted of 4,500 units ( 100% complete as...

Please use formulas for answers. Thank you! \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & c & D & E & F & G & H \\ \hline 1 & & & & & & & & \\ \hline 2 & \multicolumn{8}{|c|}{ At December 31,...

im so stuck Mar weving Erough Unit 6.2 in the Trotlosek: \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & \multicolumn{8}{|c|}{ The company has the following...

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & 1 \\ \hline 1 & \multicolumn{8}{|c|}{ The Sea Wharf Restaruant } \\ \hline \multicolumn{9}{|l|}{2} \\ \hline...

Solid Stable Furniture uses a process cost system to account for its table factory. Beginning inventory consisted of 4,500 units ( 100% complete as to material, 45% complete as to labor) with a cost...

please help :( Lab 1-2 Excel Part 2: Assessment Questions Answer the following questions based the details provided. \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\...

Post a CLOSING AND POST CLOSING Journal Entry for the following information. Thank you!!! Home Insert Draw Page Layout Formulas Data Review View Automate Developer Data Mining Analytic Solver @ Tell...

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & \multicolumn{2}{|c|}{ Antonio's Italian Restaurant } & & & & & & \\ \hline 2 & \multicolumn{2}{|c|}{ Factor...

Shoemakers of America forecasts the following demand for the next six months: 5000 pairs in month 1; 6000 pairs in month 2; 7000 pairs in month 3; 9000 pairs in moth 4; 6000 pairs in month 5; 5000 in...

Compute the mean and the standard deviation of the annual USD excess returns to the fund. Assume that the value of the investment portfolio is USD 70 billion and that the mean and standard deviation...

1. Find the Indicated voltage Vo and current Ip or I for the following circuits: -5 V +8 V Si 1.2 k2 2.2 ka 4.7 k2 Si (a) (b)

Given the following information for Papa's Pizza Co., calculate the depreciation expense: sales = $42,000; costs = $28,000; addition to retained earnings = $2,100; dividends paid = $915; interest...

can cause managers to make mistakes and errors that harm the organization aremployees.O Cognitive dissenanceO Distortions in perceptionO Affective attitudesO External locus of control

The Berndt Corporation expects to have sales of $ 1 5 million. Costs other than depreciation are expected to be 6 0 % of sales, and depreciation is expected to be $ 3 million. All sales revenues will...

7. The following table shows nominal GDP and an appropriate price index for a group of selected years. Compute real GDP. Indicate in each calculation whether you are inflating or deflating the...

5. Suppose that California imposes a sales tax of 10 percent on all goods and services. A Californian named Ralph then goes into a home improvement store in the state capital of Sacramento and buys a...

4. Below is a list of domestic output and national income figures for a certain year. All figures are in billions. The questions that follow ask you to determine the major national income measures by...