Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show the formulas in the grey boxes. Thank you! A. In this Excel file, the weiphts vary from -0.2 to 1.2 for the stock

image text in transcribed
image text in transcribed
please show the formulas in the grey boxes. Thank you!
A. In this Excel file, the weiphts vary from -0.2 to 1.2 for the stock and bond, where the weipht increnes by 1096 exbl time. Please conpute the expected refurns and standard deviations of portfolios Hinte.Thefollowisformuleanneededforvoscakcilation.E(rp)=wnE(rn)+wsE(rs)k=(wNn)2+(wss)2+2(wnM)(wss)ns \begin{tabular}{|c|c|c|c|} \hline 14 & E(rs) & E(rb) & \\ \hline 15 & 10 & 5 & \\ \hline 16 & s & b & bs \\ \hline 17 & 18 & 9 & 0.2 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c} 18 & & \\ 19 & Portfolio Weights & Std Dev Expected Return, E(rp) \\ \hline 20 & Ws \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline 20 & Ws & Wb=1-Ws & \\ \hline 21 & -0.2 & 1.2 & & \\ \hline 22 & -0.1 & 1.1 & & \\ \hline 23 & 0 & 1 & & \\ \hline 24 & 0.1 & 0.9 & & \\ \hline 25 & 0.2 & 0.8 & & \\ \hline 26 & 0.3 & 0.7 & & \\ \hline 27 & 0.4 & 0.6 & & \\ \hline 28 & 0.5 & 0.5 & & \\ \hline 29 & 0.6 & 0.4 & & \\ \hline 30 & 0.7 & 0.3 & & \\ \hline 31 & 0.8 & 0.2 & & \\ \hline 32 & 0.9 & 0.1 & & \\ \hline 33 & 1 & 0 & & \\ \hline 34 & 1.1 & -0.1 & & \\ \hline 35 & 1.2 & -0.2 & \\ \hline 36 & & & & \\ \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

Optimization Methods In Finance

Authors: Gerard Cornuejols, Reha Tütüncü

1st Edition

0521861705, 978-0521861700

More Books

Students also viewed these Finance questions