In: Finance
David Palmer identified the following bonds for investment:
The three bonds were issued on July 1, 2011.
(Each Part is Independent)
Part (a)
Bond B is issued at face value. That means, its YTM is equal to coupon rate which is given as 14%. Also given that YTM of bond A is equal to that of Bond B ie., 14%.
Hence market price of bond A is $759,917.14 arrived at using the PV function of Excel as follows:
Part (b)
Purchase price of the Bond C on Jan 1, 2014 was $ 974,008.439898 ascertained using the PV function of Excel as follows:
Sale Price on Jan 1, 2016 was $855,819.733322 as follows:
(i) Current yield= (Amount of interest per year/Investment price)*100
Yearly interest= Face Value*Coupon Rate= $ 1,000,000*10%= $100,000
Therefore, Current Yield= $100,000/$974,008.44 = 10.266851%
(ii) Capital gain yield= (P1/P0)-1 Where P1= Selling price and P0= Purchase price.
Hence Capital gains yield for two years= (855,819.73/974,008.44)-1 = 0.878657-1 = -0.121343 or -12.1343% (Negative)
(iii) Period of invest ment= 2 years. Number of coupon payments= 2*4=8. Amount of each coupon= $25,000
Proceeds of these interest payments, reinvested at 3% per quarter (12% per year) is the FV of annuity as follows:
Total Holding Period Yield (HPY) = (P1-P0+D)/P0
Where P1= Sale price, P0= Investment price and D= Income received
Therefore, HPY=($855,819.73-$974,008.44+222,308.40)/$974,008.44 = $104,119.69/$974,008.44 = 0.106898139
Or, 10.6898139%
(This is for two years. Annualized yield= 10.6898139%/2= 5.344907%)
Part (c)
Number of future coupon payments is ascertained at 23.91 (Semi annual) using NPER function of Excel. as follows:
Rounding to 24 half years, the remaining life until maturity= 24/2= 12 years.