Christmas Assignment Case Study Solution
Yield to maturity
The yield to maturity for bond with different maturity term has been calculated, ranging from six months to around ten years. However, it can be assessed that no coupon rate implemented on bond term ranging from six months to a year, as these types of bonds were considered as short term investments. Furthermore, the face value of the bond was estimated at $100 and different coupon rates were implemented on two years on wards bond terms, as represented in the exhibit below in which, the bond terms, issue date and maturity dates are represented, as well as the Coupon rates and quoted prices.
| Term | Maturity | Issue Date | Coupon Rate | Price |
| 0.5 | 8-Jun-17 | 8-Jun-16 | - | 99.692 |
| 1 | 7-Dec-17 | 7-Dec-16 | - | 99.170 |
| 2 | 30-Nov-18 | 30-Nov-16 | 1.000% | 99.795 |
| 3 | 15-Nov-19 | 15-Nov-16 | 1.000% | 98.924 |
| 5 | 30-Nov-21 | 30-Nov-16 | 1.750% | 99.661 |
| 7 | 30-Nov-23 | 30-Nov-16 | 2.125% | 99.637 |
| 10 | 15-Nov-26 | 15-Nov-16 | 2.000% | 96.563 |
Furthermore, 0.5 represented six months term period with respect to the bond. However, in order to calculate the yield to maturity, the quote price present value is calculated in which, the quote price is treated as an expense. Moreover, the numbers of period are calculated, in which, it was determined that two period were present in a year. Therefore, to calculate, the numbers of periods were multiplied by the term period with respect to each bond. Additionally, the PMT was calculated by multiplying the coupon rate with the face value of the bond and dividing the figures by 2, which is the number of periods in a year. In addition to this, the Semi-annual yield to maturity could be calculated using the rate function in Excel in which the number of periods, PMT, Present value of quoted price and the future value of the bond were used under the rate function to determine the YTM. Furthermore, Semi-annual YTM could be multiplied by 2 to get the Annual YTM of the bonds under consideration.
Bond Pricing and YTM
| Semi Annual Coupon bond YTM calculation | ||||||||||
| Term | Maturity | Issue Date | Coupon Rate | Price | Present Value | No. of Period | PMT | YTM Semi-Annual Payment | YTM Annual Payment | Accrued interest |
| 0.5 | 8-Jun-17 | 8-Jun-16 | - | 99.692 | (99.692) | 1 | - | 0.309% | 0.618% | - |
| 1 | 7-Dec-17 | 7-Dec-16 | - | 99.170 | (99.170) | 2 | - | 0.418% | 0.835% | - |
| 2 | 30-Nov-18 | 30-Nov-16 | 1.00% | 99.795 | (99.795) | 4 | 0.500 | 0.552% | 1.104% | 2.192% |
| 3 | 15-Nov-19 | 15-Nov-16 | 1.00% | 98.924 | (98.924) | 6 | 0.500 | 0.684% | 1.367% | 6.301% |
| 5 | 30-Nov-21 | 30-Nov-16 | 1.75% | 99.661 | (99.661) | 10 | 0.875 | 0.911% | 1.821% | 3.836% |
| 7 | 30-Nov-23 | 30-Nov-16 | 2.12% | 99.637 | (99.637) | 14 | 1.063 | 1.091% | 2.181% | 4.658% |
| 10 | 15-Nov-26 | 15-Nov-16 | 2.00% | 96.563 | (96.563) | 20 | 1.000 | 1.194% | 2.388% | 12.603% |
Christmas Assignment Harvard Case Solution & Analysis
The figures in the exhibit above were calculated on a Semi-annual compounding basis in which two periods consisting of 6 months were present in a year, where the discount factor was estimated using the formula depicted below.
(1+discount rate) ^-n, where n= no. of years
& t= 0.5, 1, 1.5, to 9.5, 10
Therefore, the 6 monthly discount factor was calculated represented in the exhibit below.
| Assuming @ 10% D/F | |
| t | Discount factor |
| 0.50 | 0.95 |
| 1.00 | 0.91 |
| 1.50 | 0.87 |
| 2.00 | 0.83 |
| 2.50 | 0.79 |
| 3.00 | 0.75 |
| 3.50 | 0.72 |
| 4.00 | 0.68 |
| 4.50 | 0.65 |
| 5.00 | 0.62 |
| 5.50 | 0.59 |
| 6.00 | 0.56 |
| 6.50 | 0.54 |
| 7.00 | 0.51 |
| 7.50 | 0.49 |
| 8.00 | 0.47 |
| 8.50 | 0.44 |
| 9.00 | 0.42 |
| 9.50 | 0.40 |
| 10.00 | 0.39 |
This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.
Related Case Solutions & Analyses:
The Evolution of the Circus Industry (A)
Offering the Right Service in the Right Place: Growing Orthopedics at the Brigham and WomensFaulkner (BWF) Hospitals
HCInc. (B)
Using StatTools
Whos in Charge: The Jim Davis Case
Paul Levy: Taking Charge of the Beth Israel Deaconess Medical Center (C)
Swedish Lottery Bonds
.Renesas Electronics And The Automotive Microcontroller Supply Chain
MICRO-ELECTRONIC PRODUCT DIVISION (MEPD)
Al Dunlop at Sunbeam
