Question

In: Finance

Finance: Debt *Please do not use Excel. If you could show working that would be amazing...

Finance: Debt

*Please do not use Excel. If you could show working that would be amazing and appreciated. Thank you very much

1. A bond with a face value of $10,000 that matures in exactly seven years has a price of $10,494.63. The coupon rate is 4.2% p.a. and coupons are paid every six months. Which of the following figures is the closest to the yield to maturity? ( I know the answer is C but I do not know how to work that out)

(a) 4.2% p.a.

(b) 5.40% p.a

(c) 3.40% p.a.

(d) 1.70% p.a.

2. On the 1st October 2016, K.J Limited issued bonds with a maturity date of 1st October 2028. One K.J bond has a face value of $100,000 and the coupon rate is 4.50% p.a. with interest payable half-yearly. Assuming the market yield is 6% p.a. calculate the value of one bond:

(a) on the 1st October 2020.

(b) five years before maturity.

(c) one year before maturity.

Solutions

Expert Solution

1. A bond with a face value of $10,000 that matures in exactly seven years has a price of $10,494.63. The coupon rate is 4.2% p.a. and coupons are paid every six months. Which of the following figures is the closest to the yield to maturity?

We have following formula for calculation of bond’s yield to maturity (YTM)

Bond price P0 = C* [1- 1/ (1+YTM) ^n] /YTM + M / (1+YTM) ^n

Where,

M = value at maturity, or face value = $10,000

P0 = the current market price of bond = $10,494.63

C = coupon payment = 4.2% of $10,000 = $420 but semiannual coupon, therefore C = $420/2 = $210

n = number of payments (time remaining to maturity) = 7 years; therefore number of payments n = 7 *2 = 14

YTM = interest rate, or yield to maturity =?

Now we have,

$10,494.63 = $210 * [1 – 1 / (1+YTM) ^14] /YTM+ 10,000 / (1+YTM) ^14

By trial and error method we can calculate the value of YTM = 1.70% semiannual

Or annual YMT = 2 * 1.70% = 3.40% per year

Therefore correct answer is option: (c) 3.40% p.a.

2. On the 1st October 2016, K.J Limited issued bonds with a maturity date of 1st October 2028. One K.J bond has a face value of $100,000 and the coupon rate is 4.50% p.a. with interest payable half-yearly. Assuming the market yield is 6% p.a. calculate the value of one bond:

(a) on the 1st October 2020.

The Bond’s price can be calculated the help of following formula

Bond price P = C* [1- 1/ (1+i) ^n] /i + M / (1+i) ^n

Where,

The par value or face value of the Bond = $100,000

Current price of the bond P =?

C = coupon payment or annual interest payment = 4.50% per annum, but it makes coupon payments on a semi-annual basis therefore coupon payment = 4.50%/2 of $100,000 = $2250

n = number of payments = 16 (2*8 for semiannual payments of up to remaining maturity of 8 years from Oct 2020 to Oct 2028)

i = yield to maturity or priced to yield (YTM) = 6.0% per annum or 6.0%/2 = 3.0% semiannual

Therefore,

P = $2250 * [1 – 1 / (1+3.0%) ^16] /3.0% + $100,000 / (1+3.0%) ^16

= $28,262.48 + $62,316.69

= $90,579.17

The value of one bond is $90,579.17

(b) five years before maturity.

The Bond’s price can be calculated the help of following formula

Bond price P = C* [1- 1/ (1+i) ^n] /i + M / (1+i) ^n

Where,

The par value or face value of the Bond = $100,000

Current price of the bond P =?

C = coupon payment or annual interest payment = 4.50% per annum, but it makes coupon payments on a semi-annual basis therefore coupon payment = 4.50%/2 of $100,000 = $2250

n = number of payments = 10 (2*5 for semiannual payments of up to remaining maturity of 5 years)

i = yield to maturity or priced to yield (YTM) = 6.0% per annum or 6.0%/2 = 3.0% semiannual

Therefore,

P = $2250 * [1 – 1 / (1+3.0%) ^10] /3.0% + $100,000 / (1+3.0%) ^10

= $19,192.96 + $74,409.39

= $93,602.35

The value of one bond is $93,602.35

(c) one year before maturity.

The Bond’s price can be calculated the help of following formula

Bond price P = C* [1- 1/ (1+i) ^n] /i + M / (1+i) ^n

Where,

The par value or face value of the Bond = $100,000

Current price of the bond P =?

C = coupon payment or annual interest payment = 4.50% per annum, but it makes coupon payments on a semi-annual basis therefore coupon payment = 4.50%/2 of $100,000 = $2250

n = number of payments = 2 (2*1 for semiannual payments of up to remaining maturity of 1 years)

i = yield to maturity or priced to yield (YTM) = 6.0% per annum or 6.0%/2 = 3.0% semiannual

Therefore,

P = $2250 * [1 – 1 / (1+3.0%) ^2] /3.0% + $100,000 / (1+3.0%) ^2

= $4,305.31 + $94,259.59

= $98,564.90

The value of one bond is $98,564.90


Related Solutions

COULD YOU PRETTY PLEASE show this in WORKING NOT EXCEL 5. A bond has maturity of...
COULD YOU PRETTY PLEASE show this in WORKING NOT EXCEL 5. A bond has maturity of 7 years and pays a 7% coupon rate (with coupon paid annually).The bond sells at par value. (1) Calculate the duration and convexity of the bond. 2 (2) Assuming its yield to maturity increases from 7% to 8% with maturity unchanged. Calculate the predicted price using modified duration rule, and the percentage error of this rule. (3) Assuming its yield to maturity increases from...
Please if you could do each problem, and show steps for excel! Thank you! You will...
Please if you could do each problem, and show steps for excel! Thank you! You will graduate in a few years and start working and it’s never too early to start planning for your retirement and other financial events. Let’s fast forward to the beginning of your career. Here’s some assumptions to help you get started. Your starting annual salary will be $60,000. You plan to work for 43 years before retiring. You expect your salary to grow at an...
PLEASE SHOW WORKING AND FORMULA STEP BY STEP. DO NOT USE EXCEL Blitz Industries has a...
PLEASE SHOW WORKING AND FORMULA STEP BY STEP. DO NOT USE EXCEL Blitz Industries has a debt-equity ratio of .6. Its WACC is 9.2 percent, and its cost of debt is 6.5 percent. The corporate tax rate is 23 percent.    a. What is the company’s cost of equity capital? b. What is the company’s unlevered cost of equity capital? c-1. What would the cost of equity be if the debt-equity ratio were 2? c-2. What would the cost of...
Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...
Please show me how to do the following in excel. An additional "show formulas" would also...
Please show me how to do the following in excel. An additional "show formulas" would also be helpful. NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates that new project will require $7,500 in inventory, and result in a $7,500 increase in accounts receivable and a $5,000 increase in accounts payable. The latter...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
Please could you show full steps and no excel please Miss M had R100,000 to invest...
Please could you show full steps and no excel please Miss M had R100,000 to invest in the financial market. She chose to invest R10,000 in Asset A, which returned 12.0%; R40,000 in Asset B which returned 15.0%; R20,000 in Asset C which returned –5.0%, and the remaining in Asset D which returned 5%. The correlation between the assets are ρAB = 0.75, ρAC = 0.35, ρAD = 1, ρBC = –0.5, ρBD = 0.25, and ρCD = -1. The...
Please explain your answers and use Excel to show the excel formula you used to get...
Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?
PLEASE SHOW IN EXCEL The debt service and the revenues in a city government are $3.1...
PLEASE SHOW IN EXCEL The debt service and the revenues in a city government are $3.1 million and $30 million. respectively. What is the debt service ratio? If the benchmark debt Service ratio is 12 percent, does the city have additional debt capacity? Assume an annual interest rate of 5 percent and a twenty-year maturity for the debt, how much additional debt can the city carry? Assume an annual interest rate of 4 percent and a twenty-year maturity for the...
Please show all your work if you use the Calculator. If done in Excel, please send...
Please show all your work if you use the Calculator. If done in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT