Please complete the following requirements for two stocks, Dynex Capital Inc.(ticker DX); International Paper Company(ticker IP).

1.Download monthly Adj. closeprices (adjusted for dividend and stock split) from 12/1/2009 through 12/31/2012for each stock.

DX

Date	Open	High	Low	Close	Adj Close	Volume		HPR
12/1/2009	24.42	27.99	24	26.190001	7.183541	787700
1/1/2010	26.34	27.48	26.219999	27.15	7.645093	425900		-0.02541447174
2/1/2010	27.209999	27.389999	25.709999	26.459999	7.450797	431900		0.02040815231
3/1/2010	26.700001	28.08	26.4	27	7.602854	877200		0.05641026383
4/1/2010	27.059999	28.469999	26.85	27.809999	8.031733	524400		0.01618106578
5/1/2010	27.93	28.26	26.1	28.26	8.161695	565200		-0.0201697074
6/1/2010	28.290001	29.549999	26.879999	27.690001	7.997076	557500		0.07658011503
7/1/2010	27.629999	29.309999	27.120001	29.1	8.609493	1696900		0.03608261253
8/1/2010	29.43	30.629999	28.92	30.15	8.920146	1054600		0.07263692769
9/1/2010	30.66	32.759998	30.27	32.34	9.568078	1276700		0.00640630229
10/1/2010	32.25	32.279999	31.440001	31.799999	9.629374	1067700		-0.009434154287
11/1/2010	32.009998	32.459999	31.469999	31.5	9.538529	881200		0.04000008806
12/1/2010	31.799999	33	31.26	32.759998	9.920071	2314400		0.002793427587
1/1/2011	32.939999	32.939999	31.620001	32.040001	9.947782	1215500		-0.01029918026
2/1/2011	32.099998	32.25	31.17	31.709999	9.845328	1023800		-0.04824999228
3/1/2011	31.77	32.43	29.790001	30.18	9.370291	5811600		0.008704425508
4/1/2011	30.18	30.42	27.93	29.639999	9.451854	3454200		0.004047988892
5/1/2011	29.85	29.879999	28.559999	29.76	9.490115	2073800		-0.02419296289
6/1/2011	29.610001	29.940001	28.5	29.040001	9.260521	2601200		-0.03377736523
7/1/2011	29.129999	29.610001	27.030001	27.299999	8.947725	1733600		0.008791061415
8/1/2011	27.66	28.440001	24.9	27.540001	9.026385	3125700		-0.1220042132
9/1/2011	27.450001	27.450001	24.18	24.18	7.925128	2187700		0.122418212
10/1/2011	24.09	26.940001	21.75	26.280001	8.895308	1934400		0.01598157141
11/1/2011	25.5	26.700001	25.049999	26.700001	9.037469	1793900		0.02584296555
12/1/2011	26.610001	28.950001	26.4	27.389999	9.271024	1629900		0.04470973217
1/1/2012	27.75	28.799999	27.15	27.780001	9.685529	3607700		0.02699769935
2/1/2012	27.9	28.92	27.120001	28.530001	9.947016	4168300		0.004205884458
3/1/2012	28.59	28.889999	27.6	28.65	9.988852	3279900		-0.01256520769
4/1/2012	28.65	28.889999	26.82	28.290001	9.86334	2649100		0.01468721549
5/1/2012	28.200001	28.77	27.24	27.870001	10.008205	3110200		0.1173301306
6/1/2012	27.780001	31.469999	27.450001	31.139999	11.182469	3435500		0.0009634723781
7/1/2012	31.23	31.620001	29.76	31.17	11.193243	3360400		0.03425843609
8/1/2012	31.200001	31.41	30	31.35	11.576706	2167600		0.02870825259
9/1/2012	31.35	32.939999	31.290001	32.25	11.909053	2849400		-0.07720907783
10/1/2012	32.34	32.700001	27.690001	29.76	10.989566	4638700		0.01503307774
11/1/2012	30.209999	30.27	25.98	29.4	11.154773	3097400		-0.03673467851
12/1/2012	29.4	29.85	27.6	28.32	10.745006	2381300		-1

IP

Date	Open	High	Low	Close	Adj Close	Volume		HPR
12/1/2009	25.443787	27.406311	24.921104	26.410257	17.873751	91552400
1/1/2010	26.814596	28.214991	22.317554	22.593689	15.290796	104151600		0.01134878786
2/1/2010	22.919132	24.536489	21.360947	22.8501	15.464328	138233200		0.06333550349
3/1/2010	23.076923	26.913216	22.978304	24.270218	16.443769	162277500		0.08655004823
4/1/2010	24.487179	28.846153	24.487179	26.37081	17.866978	144688300		-0.131264
5/1/2010	26.577909	26.755424	20.216963	22.909269	15.521687	181643000		-0.02091982656
6/1/2010	22.50493	26.597633	20.749506	22.317554	15.196976	197417500		0.06937663125
7/1/2010	22.50493	25.433926	21.656805	23.865877	16.251291	143091200		-0.1545448297
8/1/2010	24.319527	24.930967	19.063116	20.177515	13.739738	137055500		0.0691600524
9/1/2010	20.680473	23.31361	20.483234	21.449703	14.689979	164029600		0.1622988705
10/1/2010	21.755424	24.980276	21.143984	24.930967	17.074146	148605800		-0.01226257524
11/1/2010	25.187376	26.222879	23.925049	24.625246	16.864773	118145400		0.09610701549
12/1/2010	25.098619	27.120316	24.763313	26.863905	18.485596	89976300		0.06020525386
1/1/2011	27.120316	29.23077	26.83432	28.481262	19.598526	120171000		-0.03808883382
2/1/2011	28.708086	30.019724	26.341223	27.39645	18.852041	97941400		0.09338697067
3/1/2011	27.465483	29.990139	24.536489	29.763313	20.612576	136621700		0.0231945294
4/1/2011	29.881657	31.065088	28.224852	30.45365	21.090675	107758700		0.01101026876
5/1/2011	31.893492	32.554241	29.536489	30.788954	21.322889	108894800		-0.03700666453
6/1/2011	30.591717	30.828402	25.887573	29.408283	20.5338	168895300		-0.004024291656
7/1/2011	29.605522	31.134123	28.353058	29.28994	20.451166	94166600		-0.08585862537
8/1/2011	29.89152	29.89152	22.583826	26.775148	18.695257	164994600		-0.1342253813
9/1/2011	26.715977	27.919132	22.8501	22.928993	16.185879	148840400		0.1913972667
10/1/2011	22.731756	28.846153	21.252466	27.317554	19.283812	108810900		0.02527083338
11/1/2011	26.360947	29.003944	25.009861	28.007889	19.77113	114898400		0.0518290558
12/1/2011	27.859961	29.43787	26.607494	29.191322	20.795849	83535700		0.05202735411
1/1/2012	29.812624	32.130177	29.043392	30.71006	21.877802	94950400		0.1287730824
2/1/2012	31.045364	35.50296	30.433926	34.664696	24.695074	112854400		0.006891941284
3/1/2012	34.694279	35.996056	33.688362	34.615383	24.865271	105370400		-0.05099743333
4/1/2012	34.615383	35.098618	31.518738	32.850098	23.597206	96127000		-0.1233864297
5/1/2012	32.771202	33.145958	28.214991	28.796844	20.685631	113020600		-0.001148333353
6/1/2012	28.057199	29.842209	26.913216	28.510849	20.661877	83007100		0.1349013451
7/1/2012	28.510849	33.195267	27.899408	32.357002	23.449192	101444400		0.05333757342
8/1/2012	32.514793	34.664696	31.055227	34.08284	24.699915	83041100		0.05939712748
9/1/2012	33.984222	36.735699	33.244576	35.818539	26.167019	105710400		-0.01349125783
10/1/2012	35.936882	37.889545	34.349113	35.335304	25.813993	79886800		0.03656164314
11/1/2012	35.325443	36.83432	32.495068	36.62722	26.757795	73653200		0.08206360053
12/1/2012	36.735699	39.329388	34.625248	39.28994	28.953636	67294600		-1

2.Compute monthly holding period return using Adj. closeprices.

3.Suppose we consider the USA S&P 500index (^GSPC)as the market portfolio. Estimate betas of DXand IPbased on the index model regressions and show your regression output.