FINANCE HOMEWORK HELP

profileProf.Bella ambrose
copy_of_portfolio_2_1.xlsx
Home>Business & Finance homework help>FINANCE HOMEWORK HELP

Sheet1

portfolio #2
corporate bond name : Exxon Mobil
current price : $84.30
coupon rates 2.709
1.819
1.305
0.921
1.912
2.397
3.567
3.176
0.281
0.391
0.634
0.314
0.15
Maturity dates
3/6/25
3/15/19
3/6/18
3/15/17
3/6/20
3/6/22
3/6/45
3/15/24
3/15/17
3/15/19
3/6/22
3/1/18
10/12/54
YTM 2.65
1.52
1.15
0.76
1.75
2.28
3.35
2.43
Current Yields 3.27%
Bond Rating AAA

Sheet2

Portfolio # 2
Corporate bond name: Johnson & Johnson
Current Price $99.64
Coupon Rates
0
4.75
5.95
5.55
2.15
5.15
4.375
3.375
0.331
5.5
5.85
1.125
1.65
4.5
2.95
1.875
4.5
4.95
3.55
0.7
2.45
4.85
6.95
3.375
6.73
0
Maturity Dates 7/28/20
11/6/19
8/15/37
8/15/17
5/15/16
7/15/18
12/5/33
12/5/23
11/28/16
11/6/24
7/15/38
11/21/17
12/5/18
9/1/40
9/1/20
12/5/19
12/5/43
5/15/33
5/15/21
11/28/16
12/5/21
5/15/41
9/1/29
12/5/23
11/15/23
7/28/20
YTM ---
0.29
3.47
0.93
0.52
1.27
3.22
2.4
---
3.82
3.46
1.07
1.27
3.38
1.74
1.66
3.42
3.52
1.86
0.54
2.11
3.54
3.11
---
2.55
39.86
Current Yields 2.81%
Bond Rating AAA

Sheet3