投資債債券-候選

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Order	CUSIP	產品名稱	票面利率(%)	到期日	10/10	10/31	現在利率(%)	YTM	YTC	Diff	調整利率(%)	到期(%)	年	信用評等

2	1	594918BZ6	微軟4.10%美元2037年固定收益債券	4.1	2037/2/6	93.464	92.659		4.90%	4.39%	0.51%	#REF!	#REF!	12.8	Aaa/AAA/AAA
3	2	037833BW9	蘋果公司(Apple Inc.)4.5%美元2032年固定收益債券	4.5	2036/2/23	97.557	96.16		4.82%	4.61%	0.21%	#REF!	#REF!	11.8	Aaa/AA+/
4	3	40434LAL9	惠普4.200%美元2032年固定收益債券	4.2	2032/4/15	82.183	82.362		7.35%	5.11%	2.24%			7.9	Baa2/BBB/BBB+
5	4	40434LAK1	惠普4.0%美元2029年固定收益債券	4	2029/4/15	88.559	87.805		6.83%	4.52%	2.31%			4.9	Baa2/BBB/BBB+
6	5	084664BL4	波克夏海瑟威金融5.750%美元2040年固定收益債券	5.75	2040/1/15	105.195	102.057		5.14%	5.47%	-0.33%			15.7	Aa2/AA/A+
7	6	59562VAM9	波克夏海瑟威能源6.125%美元2036年固定收益債券	6.125	2036/04/01	102.577	102.098		5.75%	5.97%	-0.22%			11.9	A3/A-
8	7	87264ACV5	T-Mobile USA5.20%美元2033年固定收益債券	5.2	2033/01/15	96.861	96.946		5.73%	5.37%	0.36%			8.7	Baa3/BBB-/BBB-
9	8	92343VEA8	威瑞森電信4.500%美元2033年固定收益債券	4.5	2033/08/10	91.187	89.608	#REF!	5.89%	4.93%	0.95%	#REF!	#REF!	9.3	Baa1/BBB+/A-
10	9		威瑞森電信6.400%美元2033年固定收益債券	6.4	15-09-2033	106.2			5.36%	6.03%	-0.66%	#REF!	#REF!	9.4	Baa1/BBB+/A-
11	10	00206RHY1	AT&T 6.625%美元2029年固定收益債券	6.625	2029-05-15	104.903	102.093		5.34%	6.32%	-0.97%	#REF!	#REF!	5.0	Baa2/BBB/BBB+
12	11	00206RGQ9	AT&T 4.300%美元2030年固定收益債券	4.3	2030-02-15	92.044	91.863		6.05%	4.67%	1.38%	#REF!	#REF!	5.8	Baa2/BBB/BBB+
13	12	71713UAW2	輝瑞藥廠6.600%美元2028年固定收益債券	6.6	2028/12/1	107.617	85.699		4.47%	6.13%	-1.66%	#REF!	#REF!	4.6	A2/A+/A
14	13	023135BF2	Amazon 3.875%美元2037年固定收益債券	3.875	2037/08/22	87.924	85.699	#REF!	5.32%	4.41%	0.91%	#REF!	#REF!	13.3	A1/AA
15	14	58013MEZ3	MCDONALDS CORP	4.7	2035-09-12	92.76	101.866		5.70%	5.07%	0.64%	#REF!	#REF!	11.4	Baa1//BBB+
16	15	88579EAC9	3M	5.7	2037/03/15	98.365	101.866		5.92%	5.79%	0.13%	#REF!	#REF!	12.9	A1/A+
17	16	09857LAR9	BOOKING HOLDINGS INC	4.625	2030/04/13	94.299	94.772		5.86%	4.90%	0.96%	#REF!	#REF!	5.9	A3/A-
18	17	747525AJ2	qualcomm	4.65	2035/05/20	93.99	92.872		5.49%	4.95%	0.54%	#REF!	#REF!	11.0	A2/A
19	18	458140BR0	Intel	3.9	2030/03/25	92.201	91.035		5.55%	4.23%	1.32%	#REF!	#REF!	5.9	A1/A+
20	19	747525BQ5	qualcomm	4.25	2032/05/20	95.747	94.43		4.97%	4.44%	0.53%	#REF!	#REF!	8.0	A2/A
21	20	617446HD4	MORGAN STANLEY	7.25	2032/01/04	110.014	110.904		5.28%	6.59%	-1.31%	#REF!	#REF!	7.7	A1/A
22	21	686330AR2	ORIX CORP	5.2	2032/09/13	93.814	93.427		6.28%	5.54%	0.74%	#REF!	#REF!	8.4	A3/A-
23	22	373298BU1	GEORGIA PAC CORP	8.875	2031/05/15	119.469			4.66%	7.43%	-2.77%	#REF!	#REF!	7.0	A3/A+
24	23	74435KAB1	PRUDENTIAL PLC	3.625	2032/03/24	84.954	83.341		6.17%	4.27%	1.91%	#REF!	#REF!	7.9	A2/A
25	24	20825UAC8	CONOCO FDG CO	7.25	2031/10/15	113.152	111.921		4.64%	6.41%	-1.77%	#REF!	#REF!	7.4	A2/A-
26	25	976656CN6	WISCONSIN ELEC PWR CO	4.65	2032/09/30	96.704	95.928		5.20%	4.81%	0.39%	#REF!	#REF!	8.4	A2/A-
27	26	233835AQ0	MERCEDES-BENZ FIN NORTH AMER	8.5	2031/01/18	119.553	117.266		4.19%	7.11%	-2.92%	#REF!	#REF!	6.7	A3/A-
28	27	244199BA2	DEERE & CO	7.125	2031/03/03	113.995	113.152		4.20%	6.25%	-2.05%	#REF!	#REF!	6.8	A2/A
29	28	136375DC3	CANADIAN NATL RY CO	3.85	2032/08/05	90.797	91.027		5.36%	4.24%	1.12%	#REF!	#REF!	8.3	A2/BBB+
30	29	025816CW7	AMERICAN EXPRESS CO	4.05	2029/05/03	91.507	91.94		6.13%	4.43%	1.70%	#REF!	#REF!	5.0	A2/A
31	30	06050WFU4	BK OF AMERICA CORP	4	2031/06/15	90.498			5.76%	4.42%	1.34%	#REF!	#REF!	7.1	A2/A-
32	31	70450YAL7	Paypal	4.4	2032/06/01	92.936	92.144		5.61%	4.73%	0.87%	#REF!	#REF!	8.1	A3/A-
33	32	482480AL4	KLA CORP	4.65	2032/07/15	96.686	95.495		5.21%	4.81%	0.40%	#REF!	#REF!	8.2	A2/A-
34	33	166756AS5	CHEVRON USA INC	3.25	2029/10/15	90.641	90.434		5.30%	3.59%	1.72%	#REF!	#REF!	5.4	Aa2/AA-
35	34	437076CS9	HOME DEPOT INC	4.5	2032/09/15	95.147	95.444		5.31%	4.73%	0.58%	#REF!	#REF!	8.4	A2/A
36	35	855244AT6	Starbucks	3.55	2029/08/15	90.348	90.494		5.76%	3.93%	1.83%	#REF!	#REF!	5.3	Baa1/BBB+
37	36	713448FM5	PepsiCo	3.9	2032/07/18	92.94	93.384		5.06%	4.20%	0.86%	#REF!	#REF!	8.2	A1/A+
38	37	20030NCU3	Comcast	4.25	2030/10/15	93.336	92.959		5.59%	4.55%	1.03%	#REF!	#REF!	6.4	A3/A-
39	38	46625HNJ5	JPMORGAN CHASE & CO	4.25	2027/10/1	94.512	95.292		6.11%	4.50%	1.61%	#REF!	#REF!	3.4	A1/A-
40	39	17275RAD4	CISCO SYS	5.9	2039/02/15	105.138	102.922		5.26%	5.61%	-0.35%	#REF!	#REF!	14.8	A1/AA-
41	40	912810QQ4	美債	4.375	2041/05/15	101.00	100.53		4.27%	4.33%	-0.06%	#REF!	#REF!	17.0
42	41	912810QL5	美債	4.25	2040/11/15	100.00	99.11		4.25%	4.25%	0.00%	#REF!	#REF!	16.5
43	42	912810QN1	美債	4.75	2041/02/15	106.00	105.60		4.12%	4.48%	-0.36%	#REF!	#REF!	16.8
44	43
45	44
46	45
47	46
48	47
49	48
50	49
51	50
52	51
53	52
54	53
55	54
56	55
57	56
58	57
59	58
60	59
61	60
62	61
63	62
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