public_JIE_post.xlsx

	A	B	C	D	E	F	G	H	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	yr	cash_p_bond_noft	cash_o_bond_noft	cash_po_bond_noft	cash_us_bond_noft	cash_mkt_bond_noft	cash_float_bond_noft	cash_fed_bond_noft	ror_p_bond_noft	ror_o_bond_noft	ror_po_bond_noft	ror_us_bond_noft	ror_mkt_bond_noft	ror_float_bond_noft	ror_fed_bond_noft		Calculations for GM

2	2003	-386459	-640784	-1027244	-962572	-2424329	-1989816	-434513									1	1	1	1	1	1	1
3	2004	-122209	-252692	-374901	166092	-213231	-208809	-4422	-1.84	-0.70	-1.16	-1.86	-1.43	-1.48	-1.22		0.98	0.99	0.99	0.98	0.99	0.99	0.99
4	2005	70563	-96272	-25709	-66029	-86460	-91738	5278	7.20	4.30	5.42	9.52	6.76	6.78	6.64		1.05	1.04	1.04	1.07	1.05	1.05	1.05
5	2006	25612	-147063	-121451	99945	-27144	-21505	-5639	-1.59	0.19	-0.40	-2.32	-1.08	-1.12	-0.82		1.04	1.04	1.04	1.05	1.04	1.04	1.04
6	2007	33141	-159696	-126554	208214	92943	81660	11283	5.80	5.66	5.70	5.84	5.74	5.74	5.73		1.10	1.10	1.10	1.11	1.10	1.10	1.10
7	2008	39339	-80590	-41251	-33715	1566	-74965	76531	10.83	9.91	10.13	11.08	10.30	10.34	10.08		1.21	1.20	1.21	1.23	1.21	1.21	1.22
8	2009	-13190	-272071	-285261	-366736	-806311	-651997	-154315	6.74	6.14	6.26	7.03	6.48	6.45	6.68		1.30	1.28	1.28	1.32	1.29	1.29	1.30
9	2010	-134118	-435255	-569373	-860104	-1531125	-1429477	-101648	6.48	5.08	5.35	7.18	6.09	5.91	7.04		1.38	1.34	1.35	1.42	1.37	1.37	1.39
10	2011	-184226	-419294	-603520	168705	-1204382	-434815	-769568	2.13	2.45	2.39	1.83	2.17	2.17	2.19		1.41	1.38	1.38	1.44	1.40	1.40	1.42
11	2012	-130535	-180184	-310719	-435822	-741424	-746541	5117	10.35	5.37	6.41	12.96	8.47	8.36	8.81		1.56	1.45	1.47	1.63	1.52	1.51	1.54
12	2013	-102512	-141944	-244456	-144590	-592364	-389046	-203318	-1.74	-0.50	-0.78	-2.39	-1.57	-1.33	-2.29		1.53	1.44	1.46	1.59	1.50	1.49	1.51
13	2014	-295869	702	-295167	143174	-534289	-151992	-382297	1.91	1.34	1.47	2.31	2.01	1.74	2.76		1.56	1.46	1.48	1.63	1.53	1.52	1.55
14	2015	22010	156741	178750	-353910	-161569	-175159	13590	2.48	1.79	1.99	2.84	2.60	2.26	3.41		1.60	1.49	1.51	1.67	1.57	1.56	1.60
15	2016	-25243	169987	144745	-460979	-215873	-316235	100362	5.94	3.83	4.45	6.75	6.00	5.31	7.80		1.69	1.55	1.58	1.79	1.66	1.64	1.73
16	2017	-22157	49053	26896	-166799	-60079	-139903	79824	-2.42	-1.64	-1.88	-2.62	-2.37	-2.19	-2.88		1.65	1.52	1.55	1.74	1.62	1.60	1.68
17	2018	-10425	28083	17658	-313731	-107380	-296073	188692	-0.43	-0.38	-0.40	-0.45	-0.40	-0.42	-0.33		1.64	1.51	1.54	1.73	1.61	1.60	1.67
18	2019	-133835	9154	-124681	-661564	-461785	-786244	324460	6.84	5.72	6.06	7.04	6.64	6.49	7.22		1.76	1.60	1.64	1.85	1.72	1.70	1.79
19	2020	-5406	313555	308148	414407	-831053	722555	-1553608	10.57	7.80	8.71	10.64	10.09	9.64	12.27		1.94	1.73	1.78	2.05	1.89	1.86	2.01
20	2021	-430152	-255239	-685391	-714322	-2163921	-1399713	-764208	-3.15	-1.64	-2.19	-3.43	-3.09	-2.77	-3.86		1.88	1.70	1.74	1.98	1.84	1.81	1.94
21	2022	-397124	-4920	-402043	-1002982	-1780698	-1405026	-375672	-8.33	-6.54	-7.24	-8.12	-7.92	-7.66	-8.53		1.72	1.59	1.62	1.82	1.69	1.67	1.77
22	2023	2359944	3214604	5574548	5711489	15913318	11286036	4627283	-2.40	-1.49	-1.88	-2.07	-2.12	-1.97	-2.50		1.68	1.56	1.58	1.78	1.66	1.64	1.73
23
24	IRR	0.81	1.84	1.54	0.79	1.42	1.23	2.10								GM	2.63	2.26	2.33	2.93	2.55	2.50	2.77
25
26		Foreign Private	Foreign Official	Foreign Total	U.S.	Market	Float	Fed									Foreign Private	Foreign Official	Foreign Total	U.S.	Market	Float	Fed
27
28																IRR - GM	-1.83	-0.42	-0.79	-2.14	-1.13	-1.27	-0.67
29																Sharpe ratio: GM/stdev(returns)	0.50	0.58	0.54	0.51	0.52	0.53	0.51
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100