FIN$3320$ Assignment $4-$ Efficient Diversifcation Analysis for Stock and Bond Fund Efficient Diversification Analysis $-$ Complete all calculations in cei.

Calculate the expected return of stock and bond fund

$\backslash$table$[[,,$Stock Fund,Bond Fund$],[$Scenario$,\backslash$table$[[$Probabil$],[$ity$]],$Return$(\%),\backslash$table$[[$Weighted$],[$Return$]],$Return $(\%),\backslash$table$[[$Weighted$],[$Return$]]],[$Severe recession,$0\mathrm{.}05,-37\%,,-9\%,],[$Mild recession,$0\mathrm{.}25,-11\%,15\%,,],[$Normal growth,$0\mathrm{.}40,14\%,8\%,,],[$Boom$,0\mathrm{.}30,30\%,-5\%,,],[$Expected Return,WAR $($sum$),$WAR $($sum$),,,]]$

Calculate the return variance of stock and bond fund

$\backslash$table$[[,,$Stock Fund,Bond Fund$],[$Scenario$,$Probabil ity,Return$(\%),$Deviation from mean,$\backslash$table$[[$Squared$],[$Deviation$]],$Weighted Sqrd$.$ Dev.,Return $(\%),$Deviation from mean,$\backslash$table$[[$Squared$],[$Deviation$]],$Weighted Sqrd$.$ Dev.$],[$Severe recession,$0\mathrm{.}05,-37\%,,,,-9\%,,,],[$Mild recession,$0\mathrm{.}25,-11\%,,,,15\%,,,],[$Normal growth,$0\mathrm{.}40,14\%,,,,8\%,,,],[$Boom$,0\mathrm{.}30,30\%,,,,-5\%,,,],[,,,,$Variance,,,,Variance,$],[,,,,$STDEV,,,,STDEV,$]]$

Calculate the portfolio return and risk based on the $\frac{40}{60}$ allocation between stock and bond

$\backslash$table$[[$Portfolio$],[$Stocks$,40\%,$Bond,$60\%$FIN$3320$ Assignment $4-$ Efficient Diversifcation Analysis for Stock and Bond Fund Efficient Diversification Analysis $-$ Complete all calculations in cei.

Calculate the expected return of stock and bond fund

$\backslash$table$[[,,$Stock Fund,Bond Fund$],[$Scenario$,\backslash$table$[[$Probabil$],[$ity$]],$Return$(\%),\backslash$table$[[$Weighted$],[$Return$]],$Return $(\%),\backslash$table$[[$Weighted$],[$Return$]]],[$Severe recession,$0\mathrm{.}05,-37\%,,-9\%,],[$Mild recession,$0\mathrm{.}25,-11\%,15\%,,],[$Normal growth,$0\mathrm{.}40,14\%,8\%,,],[$Boom$,0\mathrm{.}30,30\%,-5\%,,],[$Expected Return,WAR $($sum$),$WAR $($sum$),,,]]$

Calculate the return variance of stock and bond fund

$\backslash$table$[[,,$Stock Fund,Bond Fund$],[$Scenario$,$Probabil ity,Return$(\%),$Deviation from mean,$\backslash$table$[[$Squared$],[$Deviation$]],$Weighted Sqrd$.$ Dev.,Return $(\%),$Deviation from mean,$\backslash$table$[[$Squared$],[$Deviation$]],$Weighted Sqrd$.$ Dev.$],[$Severe recession,$0\mathrm{.}05,-37\%,,,,-9\%,,,],[$Mild recession,$0\mathrm{.}25,-11\%,,,,15\%,,,],[$Normal growth,$0\mathrm{.}40,14\%,,,,8\%,,,],[$Boom$,0\mathrm{.}30,30\%,,,,-5\%,,,],[,,,,$Variance,,,,Variance,$],[,,,,$STDEV,,,,STDEV,$]]$

Calculate the portfolio return and risk based on the $\frac{40}{60}$ allocation between stock and bond

$\backslash$table$[[$Portfolio$],[$Stocks$,40\%,$Bond,$60\%$FIN$3320$ Assignment $4-$ Efficient Diversifcation Analysis for Stock and Bond Fund Efficient Diversification Analysis $-$ Complete all calculations in cei.

Calculate the expected return of stock and bond fund

$\backslash$table$[[,,$Stock Fund,Bond Fund$],[$Scenario$,\backslash$table$[[$Probabil$],[$ity$]],$Return$(\%),\backslash$table$[[$Weighted$],[$Return$]],$Return $(\%),\backslash$table$[[$Weighted$],[$Return$]]],[$Severe recession,$0\mathrm{.}05,-37\%,,-9\%,],[$Mild recession,$0\mathrm{.}25,-11\%,15\%,,],[$Normal growth,$0\mathrm{.}40,14\%,8\%,,],[$Boom$,0\mathrm{.}30,30\%,-5\%,,],[$Expected Return,WAR $($sum$),$WAR $($sum$),,,]]$

Calculate the return variance of stock and bond fund

$\backslash$table$[[,,$Stock Fund,Bond Fund$],[$Scenario$,$Probabil ity,Return$(\%),$Deviation from mean,$\backslash$table$[[$Squared$],[$Deviation$]],$Weighted Sqrd$.$ Dev.,Return $(\%),$Deviation from mean,$\backslash$table$[[$Squared$],[$Deviation$]],$Weighted Sqrd$.$ Dev.$],[$Severe recession,$0\mathrm{.}05,-37\%,,,,-9\%,,,],[$Mild recession,$0\mathrm{.}25,-11\%,,,,15\%,,,],[$Normal growth,$0\mathrm{.}40,14\%,,,,8\%,,,],[$Boom$,0\mathrm{.}30,30\%,,,,-5\%,,,],[,,,,$Variance,,,,Variance,$],[,,,,$STDEV,,,,STDEV,$]]$

Calculate the portfolio return and risk based on the $\frac{40}{60}$ allocation between stock and bond

$\backslash$table$[[$Portfolio$],[$Stocks$,40\%,$Bond,$60\%$

$($Answer all highlighted portions and please elaborate with how the calculations are suppoused to be inputed. Thanks!$)$