Vanilla Stock Evaluation
spanisheve55
phase_4-_vanilla_bond_valuation.xlsxINTRO
| Phase 4- Vanilla Bond Valuation Professor Angela Garrett FINC390-1303A-04 CTU Online Evelyn Green August 07, 20113 |
Johnson and Johnson
| Corporate Bond Details | ||||||
| Issue Details | Settlement Date | 8/7/13 | ||||
| Issue Size in Billion dollars | 1 | Maturity Date | 8/15/17 | |||
| Par Value | $ 1,000 | Coupon Rate | 5.55% | |||
| Coupon Rate | 5.55% | Yield to Maturity | 1.51% | |||
| Coupon Type | Fixed | Final Redemption % | 100 | |||
| Coupon Frequency | Semi-Annually | Coupons per Year | 2 | |||
| Day Count Basis | 30/360 | Day Count Basis | 30/360 | |||
| First Payment Date | 2/15/08 | |||||
| Accrual Start Date | 8/16/08 | Bond Price | $ 115.708 | |||
| Maturity Date | 8/15/17 | |||||
| Callable | No | |||||
| Puttable | No | |||||
| Convertible | No | |||||
| Current Yield | 4.80% | |||||
| Yield to Maturity | 1.51% | |||||
| Modified Duration | 3.6 | |||||
| Credit Rating (Moody's) | AAA |
PepsiCo Inc
| Corporate Bond Details | ||||||
| Issue Details | Settlement Date | 8/7/13 | ||||
| Issue Size in Billion dollars | 1.0 | Maturity Date | 1/15/20 | |||
| Par Value | $ 1,000 | Coupon Rate | 4.50% | |||
| Coupon Rate | 4.50% | Yield to Maturity | 2.17% | |||
| Coupon Type | Fixed | Final Redemption % | 100 | |||
| Coupon Frequency | Semi-Annually | Coupons per Year | 2 | |||
| Day Count Basis | 30/360 | Day Count Basis | 30/360 | |||
| First Payment Date | 7/15/10 | |||||
| Accrual Start Date | 1/14/10 | Bond Price | $ 113.930 | |||
| Maturity Date | 1/15/20 | |||||
| Callable | No | |||||
| Puttable | No | |||||
| Convertible | No | |||||
| Current Yield | 4.09% | |||||
| Yield to Maturity | 2.17% | |||||
| Modified Duration | 5.6 | |||||
| Credit Rating (Moody's) | AA- |
