investment

Upload: jack-henry

Post on 10-Jan-2016

212 views

Category:

Documents


0 download

DESCRIPTION

Investment, Solution, Security, Analysis

TRANSCRIPT

Sheet1WaWbRaRbSigma - aSigma - bESD -0.2Wa0.68181818180110%30%20%60%0.30.6Wb0.31818181820.020.9810%30%20%60%0.2960.58721307890.040.9610%30%20%60%0.2920.5744534794Return0.16363636360.060.9410%30%20%60%0.2880.5617230634Sd0.21125363710.080.9210%30%20%60%0.2840.5490238610.10.910%30%20%60%0.280.53635808930.120.8810%30%20%60%0.2760.52372817380.140.8610%30%20%60%0.2720.51113677230.160.8410%30%20%60%0.2680.49858680290.180.8210%30%20%60%0.2640.48608147470.20.810%30%20%60%0.260.47362432370.220.7810%30%20%60%0.2560.46121925370.240.7610%30%20%60%0.2520.44887058270.260.7410%30%20%60%0.2480.43658309630.280.7210%30%20%60%0.2440.42436210950.30.710%30%20%60%0.240.41221353690.320.6810%30%20%60%0.2360.40014397410.340.6610%30%20%60%0.2320.38816079140.360.6410%30%20%60%0.2280.37627224190.380.6210%30%20%60%0.2240.36448758550.40.610%30%20%60%0.220.35281723310.420.5810%30%20%60%0.2160.34127291130.440.5610%30%20%60%0.2120.32986785230.460.5410%30%20%60%0.2080.31861701150.480.5210%30%20%60%0.2040.30753731480.50.510%30%20%60%0.20.29664793950.520.4810%30%20%60%0.1960.28597062790.540.4610%30%20%60%0.1920.27553003470.560.4410%30%20%60%0.1880.2653541030.580.4210%30%20%60%0.1840.25547446060.60.410%30%20%60%0.180.24592681840.620.3810%30%20%60%0.1760.23675134640.640.3610%30%20%60%0.1720.22799298230.660.3410%30%20%60%0.1680.21970161580.680.3210%30%20%60%0.1640.21193206460.70.310%30%20%60%0.160.20474374230.720.2810%30%20%60%0.1560.19819989910.740.2610%30%20%60%0.1520.19236631720.760.2410%30%20%60%0.1480.18730936980.780.2210%30%20%60%0.1440.18309341880.80.210%30%20%60%0.140.17977764040.820.1810%30%20%60%0.1360.17741251370.840.1610%30%20%60%0.1320.17603635990.860.1410%30%20%60%0.1280.17567242240.880.1210%30%20%60%0.1240.1763269690.90.110%30%20%60%0.120.17798876370.920.0810%30%20%60%0.1160.18063000860.940.0610%30%20%60%0.1120.18420857740.960.0410%30%20%60%0.1080.18867114250.980.0210%30%20%60%0.1040.19395669621010%30%20%60%0.10.2

Sheet2

Sheet3