F-F_Research_Data_Factors-2This file was created by CMPT_ME_BEME_RETS using the XXXXXXXXXXCRSP database.The 1-month TBill return is from Ibbotson and Associates...

1 answer below »
This is a problem set of Investment course. There is a file for problems, and an excel file for date. This is NOT an essay assignment.


F-F_Research_Data_Factors-2 This file was created by CMPT_ME_BEME_RETS using the 202209 CRSP database. The 1-month TBill return is from Ibbotson and Associates Inc. Mkt-RFSMBHMLRF 1926072.96-2.56-2.430.22 1926082.64-1.173.820.25 1926090.36-1.40.130.23 192610-3.24-0.090.70.32 1926112.53-0.1-0.510.31 1926122.62-0.03-0.050.28 192701-0.06-0.374.540.25 1927024.180.042.940.26 1927030.13-1.65-2.610.3 1927040.460.30.810.25 1927055.441.534.730.3 192706-2.340.59-1.730.26 1927077.26-3.25-1.140.3 1927081.97-0.69-3.740.28 1927094.76-3.63-0.630.21 192710-4.312.12-4.330.25 1927116.582.72-0.270.21 1927122.090.97-1.130.22 192801-0.684.26-0.750.25 192802-1.7-2.06-0.650.33 1928038.81-0.26-1.220.29 1928044.233.983.440.22 1928051.522.85-3.270.32 192806-4.85-3.52-0.030.31 1928070.62-1.32-0.50.32 1928086.68-2.06-2.150.32 1928092.882.410.860.27 1928101.332.22-2.160.41 19281111.81-1.782.70.38 1928120.36-0.86-0.650.06 1929014.66-3.56-1.240.34 192902-0.34-0.381.660.36 192903-0.89-4.711.580.34 1929041.43-0.970.590.36 192905-6.39-5.37-1.420.44 1929069.7-2.17-2.790.52 1929074.46-3.882.710.33 1929088.18-9.590.130.4 192909-5.471.19-0.650.35 192910-20.12-4.017.780.46 192911-12.74-1.725.050.37 1929121.33-4.5-0.540.37 1930015.613.55-0.960.14 1930022.50.190.20.3 1930037.13.410.330.35 193004-2.06-0.35-0.350.21 193005-1.66-2.01-0.730.26 193006-16.27-3.382.330.27 1930074.12-0.28-1.750.2 1930080.3-2.1-0.610.09 193009-12.75-2.21-4.960.22 193010-8.78-0.12-1.380.09 193011-3.042.23-3.660.13 193012-7.83-4.6-5.250.14 1931016.243.457.120.15 19310210.883.591.920.04 193103-6.432.98-3.440.13 193104-9.98-4.45-3.820.08 193105-13.245.35-6.570.09 19310613.9-5.3211.290.08 193107-6.621.42-2.110.06 1931080.41-1.95-1.470.03 193109-29.130.54-6.770.03 1931108.04-1.871.70.1 193111-9.084.31-5.040.17 193112-13.53-0.55-8.850.12 193201-1.583.939.030.23 1932025.46-2.78-1.460.23 193203-11.212.27-2.320.16 193204-17.961.451.430.11 193205-20.513.91-2.980.06 193206-0.70.335.30.02 19320733.84-4.5935.610.03 19320837.0613.4134.240.03 193209-2.94-2.08-7.360.03 193210-13.17-2.56-10.330.02 193211-5.882-13.110.02 1932124.4-8.64-7.720.01 1933011.250.636.360.01 193302-15.24-2.58-2.95-0.03 1933033.293.797.540.04 19330438.853.0719.650.1 19330521.4336.5619.190.04 19330613.118.42-1.780.02 193307-9.63-1.053.270.02 19330812.05-5.3930.03 193309-10.65-0.4-11.740.02 193310-8.36-0.2-8.570.01 1933119.97-6.472.320.02 1933121.830.63-1.560.02 19340112.612.6915.590.05 193402-2.55.120.02 1934030.092.51-2.70.02 193404-1.792.73-3.730.01 193405-7.25-0.29-5.890.01 1934062.64-2.23-2.960.01 193407-10.96-6.95-10.70.01 1934085.585.370.090.01 193409-0.23-1.52-1.20.01 193410-1.661.24-5.080.01 1934118.336.48-2.150.01 1934120.363.06-3.140.01 193501-3.451.07-1.90.01 193502-1.940.37-7.440.02 193503-3.68-3.59-5.120.01 1935049.06-1.474.470.01 1935053.47-3.342.650.01 1935065.93-2.57-1.690.01 1935077.511.886.930.01 1935082.656.26.080.01 1935092.631.53-4.070.01 1935107.032.72-2.370.01 1935114.884.5412.060.02 1935124.560.170.950.01 1936016.895.2310.340.01 1936022.490.954.510.01 1936030.990.69-1.440.02 193604-8.14-6.06-2.150.02 1936055.190.912.610.02 1936062.4-3.2-1.20.03 1936076.6712.40.01 1936080.990.63.820.02 1936090.983.080.90.01 1936107.12-2.432.470.02 1936113.278.77-1.210.01 1936120.213.964.30 1937013.354.342.610.01 1937021.091.054.830.02 193703-0.27-1.696.50.01 193704-7.36-3.83-3.660.03 193705-0.83-0.68-3.480.06 193706-4.21-3.76-3.330.03 1937078.910.890.810.03 193708-4.860.44-2.250.02 193709-13.61-6.98-4.570.04 193710-9.610.41-1.550.02 193711-8.31-3.60.150.02 193712-4.24-7.74-0.40 1938010.494.84-1.610 1938025.840.4-2.020 193803-23.82-4.34-3.54-0.01 19380414.516.460.230.01 193805-3.83-2.51-0.270 19380623.874.30.320 1938077.346.642.2-0.01 193808-2.67-2.45-4.720 1938090.81-2.73-1.620.02 1938107.85.815.030.01 193811-1.72-2.57-1.22-0.06 1938124.19-1.820.530 193901-5.96-1.55-3.94-0.01 1939023.510.632.950.01 193903-11.99-4.75-8.31-0.01 193904-0.181.67-0.30 1939056.82.80.490.01 193906-5.31-1.01-5.420.01 19390710.244.32-0.030 193908-6.68-4.61-2.42-0.01 19390916.8820.2422.220.01 193910-0.53-0.01-4.890 193911-3.62-5.07-6.460 1939123.030.79-4.060 194001-2.410.21-0.810 1940021.442.51-0.330 1940032.051.25-1.270 1940040.223.92-0.130 194005-21.95-6.66-3.69-0.02 1940066.67-2.134.620 1940073.161.01-0.740.01 1940082.19-0.110.56-0.01 1940092.393.22-1.130 1940103.020.284.640 194011-1.611.940.120 1940120.69-2.15-0.890 194101-4.1713.83-0.01 194102-1.43-1.560.89-0.01 1941030.840.13.040.01 194104-5.46-1.683.41-0.01 1941051.39-0.650.60 1941065.831.320.590 1941075.875.717.250.03 194108-0.17-0.42-1.10.01 194109-0.87-0.99-0.280.01 194110-5.25-2.021.630 194111-1.92-1.21-0.640 194112-4.87-2.99-5.940.01 1942010.797.5310.10.02 194202-2.461.72-1.130.01 194203-6.581.77-0.620.01 194204-4.37-0.62.090.01 1942055.94-3.05-2.650.03 1942062.69-1.220.540.02 1942073.51-0.152.40.03 1942081.8-0.091.350.03 1942092.610.632.350.03 1942106.821.756.390.03 1942110.15-1.5-4.210.03 1942125.12-2.510.580.03 1943017.138.88.180.03 1943026.154.756.40.03 1943036.014.995.480.03 1943040.812.055.820.03 1943055.744.353.250.03 1943061.82-1.02-0.70.03 194307-4.77-2.39-2.290.03 1943081.3-0.6-0.430.03 1943092.41.291.430.03 194310-1.150.581.640.03 194311-5.91-1.65-4.020.03 1943126.363.343.240.03 1944011.742.552.160.03 1944020.37-0.10.840.03 1944032.461.733.430.02 194404-1.69-1.37-1.140.03 1944055.071.681.040.03 1944065.494.011.750.03 194407-1.490.58-0.420.03 1944081.572.33-1.490.03 1944090.010.49-1.160.02 1944100.16-0.15-0.330.03 1944111.710.362.380.03 1944124.032.255.910.02 1945012.012.460.670.03 1945026.231.554.340.02 194503-3.89-1.6-1.740.02 1945047.80.323.240.03 1945051.731.520.360.03 1945060.393.124.210.02 194507-2.17-1.52-2.620.03 1945086.21.5-4.270.03 1945094.771.70.420.03 1945103.892.382.130.03 1945115.394.313.960.02 1945121.22.1-2.280.03 1946016.243.912.480.03 194602-5.83-0.71-1.460.03 1946035.870.29-0.540.03 1946044.232.350.320.03 1946053.931.461.280.03 194606-3.89-1.58-0.390.03 194607-2.69-2.070.070.03 194608-6.44-1.840.550.03 194609-10.17-4.4-1.920.03 194610-1.440.13.460.03 194611-0.01-0.441.470.03 1946124.960.08-1.360.03 1947011.252.2-0.730.03 194702-1.080.680.150.03 194703-1.67-1.620.610.03 194704-4.8-3.960.850.03 194705-0.97-3.260.330.03 1947065.29-0.3-0.590.03 1947074.141.432.820.03 194708-1.740.320.180.03 194709-0.541.641.360.06 1947102.470.510.070.06 194711-1.97-1.711.10.06 1947123-2.463.710.08 194801-3.932.51.390.07 194802-4.38-1.720.070.07 1948038.070.144.50.09 1948043.65-1.654.110.08 1948057.30.91-1.270.08 194806-0.1-1.822.810.09 194807-5.09-0.330.140.08 1948080.25-1.110.280.09 194809-2.97-1.23-1.710.04 1948105.96-1.50.580.04 194811-9.3-0.6-4.130.04 1948123.26-2.82-1.940.04 1949010.231.771.230.1 194902-2.93-1.9-0.860.09 1949034.042.51.290.1 194904-1.87-0.89-1.130.09 194905-2.94-0.79-2.370.1 1949060.1-0.91-1.650.1 1949075.540.550.370.09 1949082.60.2-0.550.09 1949093.0910.190.09 1949103.141.04-0.480.09 1949111.82-1.02-0.960.08 1949125.132.061.770.09 1950011.73.330.120.09 1950021.480.03-0.790.09 1950031.26-1.44-2.810.1 1950043.941.941.30.09 1950054.31-2.10.460.1 195006-5.94-2.34-0.70.1 1950071.360.6913.560.1 1950084.850.76-1.50.1 1950094.810.49-1.070.1 195010-0.18-0.471.30.12 1950112.76-0.893.330.11 1950125.541.477.360.11 1951015.71.763.640.13 1951021.410.08-2.850.1 195103-2.15-0.77-4.10.11 1951044.86-1.453.270.13 195105-2.340-1.370.12 195106-2.62-2.06-3.750.12 1951076.94-1.992.060.13 1951084.270.99-0.130.13 1951090.71.870.630.12 195110-2.53-0.220.230.16 1951110.57-0.32-0.060.11 1951123.33-2.26-1.590.12 1952011.45-0.611.550.15 195202-2.620.82-0.610.12 1952034.44-2.992.170.11 195204-4.970.46-0.10.12 1952053.2-10.040.13 1952063.83-1.641.240.15 1952070.91-0.4-0.350.15 195208-0.761.150.010.15 195209-2.031.11-1.520.16 195210-0.66-1.05-0.460.14 1952115.94-0.720.970.1 1952122.93-1.480.190.16 195301-0.343.611.320.16 195302-0.272.15-0.090.14 195303-1.43-0.22-0.850.18 195304-2.830.31.570.16 1953050.52-0.070.230.17 195306-1.89-1.87-0.470.18 1953072.4-1-0.220.15 195308-4.520.29-3.530.17 1953090.2-0.84-2.440.16 1953104.6-1.35-0.250.13 1953112.83-1.3-0.150.08 1953120.03-0.85-2.840.13 1954015.130.483.440.11 1954021.67-0.19-0.290.07 1954033.65-0.54-1.50.08 1954044.27-3.44-0.340.09 1954053.090.412.450.05 1954061.070.380.010.06 1954074.991.064.130.05 195408-2.342.69-1.380.05 1954096.39-2.530.680.09 195410-1.670.620.670.07 1954119.38-2.624.40.06 1954125.482.125.660.08 1955010.60.362.140.08 1955023.021.590.580.09 195503-0.16-0.741.970.1 1955043.11-1.620.680.1 1955050.93-0.28-0.960.14 1955066.55-4.651.840.1 1955071.9-1.170.350.1 1955080.21-0.440.720.16 195509-0.360.35-0.990.16 195510-2.681.48-0.150.18 1955117.03-2.220.330.17 1955121.492.16-2.30.18 195601-3.030.370.950.22 1956023.77-0.98-0.430.19 1956036.64-2.09-0.460.15 1956040.280.01-0.240.19 195605-5.21.45-1.310.23 1956063.48-1.48-1.130.2 1956074.84-1.66-0.040.22 195608-3.181.89-0.740.17 195609-5.141.571.760.18 1956100.52-0.1-0.060.25 1956110.36-0.211.780.2 1956123.16-0.01-2.150.24 195701-3.583.372.810.27 195702-2.06-0.72-0.720.24 1957032.130.26-0.480.23 1957044.26-1.59-1.450.25 1957053.45-1.05-2.10.26 195706-0.740.540.010.24 1957070.66-0.760.430.3 195708-5.110.05-0.410.25 195709-5.980.080.920.26 195710-4.32-2.52-1.80.29 1957112.30.4-2.870.28 195712-3.91-0.98-1.620.24 1958014.664.394.190.28 195802-1.520.650.330.12 1958033.270.65-0.970.09 1958043.09-0.621.610.08 1958052.312.16-0.260.11 1958062.93-0.190.40.03 1958074.390.473.060.07 1958081.911.180.360.04 1958094.660.122.850.19 1958102.531.09-1.180.18 1958113.011.97-1.180.11 1958125.15-2.030.030.22 1959010.713.022.910.21 1959020.951.461.160.19 1959030.281.49-0.340.22 1959043.66-0.6-1.230.2 1959051.73-2.161.790.22 195906-0.250.671.310.25 1959073.17-0.30.230.25 195908-1.39-0.760.440.19 195909-4.8-0.090.550.31 1959101.281.44-2.10.3 1959111.61.23-3.210.26 1959122.45-0.58-0.070.34 196001-6.982.092.780.33 1960021.170.51-1.930.29 196003-1.63-0.49-2.940.35 196004-1.710.32-2.280.19 1960053.121.21-3.70.27 1960062.08-0.21-0.340.24 196007-2.37-0.511.980.13 1960083.010.87-0.180.17 196009-5.99-1.111.620.16 196010-0.71-4.082.830.22 1960114.690.4-2.430.13 1960124.71-1.55-0.810.16 1961016.20.643.720.19 1961023.573.93-0.660.14 1961032.893.3-0.730.2 1961040.290.072.120.17 1961052.42.010.370.18 196106-3.08-2.49-0.140.2 1961072.83-1.9-0.090.18 1961082.57-1.75-0.280.14 196109-2.15-1.07-0.610.17 1961102.57-1.650.150.19 1961114.451.26-1.230.15 196112-0.18-0.851.790.19 196201-3.871.775.130.24 1962021.81-1.150.820.2 196203-0.680.52-1.380.2 196204-6.59-0.70.030.22 196205-8.65-3.342.770.24 196206-8.47-0.592.550.2 1962076.281.52-3.410.27 1962082.131.22-1.20.23 196209-5.22-2.421.280.21 196210-0.05-3.971.30.25 19621110.872.610.950.2 1962121.01-3.80.360.23 1963014.933.082.210.25 196302-2.380.482.180.23 1963033.08-2.592.060.23 1963044.51-1.3410.25 1963051.761.132.540.24 196306-2-0.270.750.23 196307-0.39-0.45-0.970.27 1963085.07-0.981.80.25 196309-1.57-0.330.130.27 1963102.53-0.58-0.10.29 196311-0.85-1.171.750.27 1963121.83-2.16-0.020.29 1964012.24-0.111.480.3 1964021.540.112.810.26 1964031.410.873.40.31 1964040.1-1.35-0.670.29 1964051.42-0.861.860.26 1964061.27-0.120.620.3 1964071.740.240.750.3 196408-1.440.160.080.28 1964092.69-0.541.70.28 1964100.590.421.170.29 19641100.69-1.960.29 1964120.03-0.35-2.480.31 1965013.542.70.120.28 1965020.443.550.110.3 196503-1.341.891.030.36 1965043.111.10.660.31 196505-0.770.11-1.610.31 196506-5.51-4.340.590.35 1965071.430.892.20.31 1965082.732.84-10.33 1965092.860.64-0.130.31 1965102.62.521.560.31 196511-0.034.680.150.35 1965121.012.062.030.33 1966010.723.843.560.38 196602-1.214.40.330.35 196603-2.510.99-1.980.38 1966042.143.43-0.460.34 196605-5.66-4.6-1.630.41 196606-1.441.030.50.38 196607-1.63-0.360.950.35 196608-7.91-3.270.430.41 196609-1.06-1.040.560.4 1966103.86-6.522.690.45 1966111.44.24-4.690.4 1966120.131.97-1.190.4 1967018.158.322.270.43 1967020.783.35-2.220.36 1967033.991.550.370.39 1967043.890.63-2.480.32 196705-4.331.91.090.33 1967062.415.930.850.27 1967074.583.122.730.31 196708-0.890.421.440.31 1967093.113.06-2.50.32 196710-3.091.46-3.30.39 1967110.370.21-1.70.36 1967123.055.73-0.530.33 196801-4.063.924.80.4 196802-3.75-2.941.280.39 1968030.2-1.34-0.590.38 1968049.055.68-1.130.43 1968052.286.40.850.45
Answered 7 days AfterNov 22, 2022

Answer To: F-F_Research_Data_Factors-2This file was created by CMPT_ME_BEME_RETS using the XXXXXXXXXXCRSP...

Himanshu answered on Nov 30 2022
43 Votes
Running head: MEAN-VARIANCE EFFICIENT FRONTIER                1
MEAN-VARIANCE EFFICIENT FRONTIER        5
Mean-Varia
nce Efficient Frontier
Student’s Name
Institutional Affiliation
Mean-Variance Efficient Frontier
To make it easier for the client, a portfolio of only two risky assets will be constructed:
Thus the weighted average is the expected return from its distinct assets’ expected returns, and is derived from:
E(Rp) = w1E(R1) + w2E(R2)
Where:
    W1, is the weight for the first asset
W2 is the weight for the second asset
    E(R1) is expected return from the first asset
    E(R2) is expected return from the second asset
    E(Rp) is expected return from the portfolio
Since the variance is the level of risk therefore, a higher variance will mean a higher risk while a lower variance will suggest a lower risk. Hence:
Var(Rp) = w21Var(R1) + w22Var(R2) + 2w1w2Cov(R1, R2)
Where:
    Cov(R1,R2) is the covariance for the expected returns of the two...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here