Question

In: Finance

TURN YOUR ANSWER IN WORD. The ABC Corporation had issued 3% coupon (semi-annual), 5-year, AA-rated bonds...

 

TURN YOUR ANSWER IN WORD.

The ABC Corporation had issued 3% coupon (semi-annual), 5-year, AA-rated bonds to finance its business growth. Use both your financial calculator (write the keys and the answer) and show the function you’d use in Excel).

a.     If investors are currently offering $1150, what is the expected YTM on the investment?

i.     Is this a premium/discount bond? Describe the relationship of the YTM, the coupon rate and the price of a bond.

b.     If they were willing to pay no more than $980 for this bond, what would their expected YTM be?                                              

i.     Is this a premium/discount bond?

c.     Describe the relationship of the YTM, the coupon rate and the price of a bond.

Solutions

Expert Solution

Solution.>

I have solved it in Excel. The formula used are written in the column along with the values. If you still have any doubt, kindly ask in the comment section.

Part a)

YTM can be calculated by using the Excel Rate function: =RATE(NPER,-PMT,PV,-FV)

This is the semi-annual YTM, Annual YTM = 2 * 0% = 0%

Since the YTM < Coupon Rate, it is selling at a Premium.

Part b)

YTM can be calculated by using the Excel Rate function: =RATE(NPER,-PMT,PV,-FV)

Since the YTM > Coupon Rate, it is selling at a Discount.

Part c)

The Relationship between Price of a bond, Coupon and YTM is:

Price of a bond

Note: Give it a thumbs up if it helps! Thanks in advance!


Related Solutions

The ABC Corporation had issued 3% coupon (semi-annual), 5-year, AA-rated bonds to finance its business growth....
The ABC Corporation had issued 3% coupon (semi-annual), 5-year, AA-rated bonds to finance its business growth. Use both your financial calculator (write the keys and the answer) and show the function you’d use in Excel). a.     If investors are currently offering $1150, what is the expected YTM on the investment?           i.     Is this a premium/discount bond? Describe the relationship of the YTM, the coupon rate and the price of a bond. b.     If they were willing to pay no...
The ABC Corporation had issued 5% coupon (semi-annual), 10-year, AA-rated bonds to finance its business growth....
The ABC Corporation had issued 5% coupon (semi-annual), 10-year, AA-rated bonds to finance its business growth. Use both your financial calculator and Excel (show me the inputs for both). a. If investors are currently offering $1100, what is the expected YTM on the investment? b. Is this a premium/discount bond? Describe the relationship of the YTM, the coupon rate and the price of a bond? c. If they were willing to pay no more than $970 for this bond, what...
ABC Bonds are currently rated AA. The bonds mature in 10 years, make annual coupon payments,...
ABC Bonds are currently rated AA. The bonds mature in 10 years, make annual coupon payments, and have a coupon rate of 5.2%. You are convinced that the bonds will be downgraded to BBB 1 year from now. If AA bonds have a YTM of 7% and BBB bonds have a YTM of 8.3%, what is your rate of return on a 1-year investment in ABC Bonds if they are downgraded at the end of the year? Enter your answer...
One year ago, ShopFast issued 15-year annual bonds at par. The bonds had a coupon rate...
One year ago, ShopFast issued 15-year annual bonds at par. The bonds had a coupon rate of 6.5 percent and had a face value of $1,000. Today, applicable yield to maturity to ShopFast’s bonds is 7%. What was the change in price in ShopFast’s bonds from last year to today? A) -55.56t B) 51.94 C) -$43.73 D) 58.71 E) The bond price did not change. WallStores needs to raise $2.8 million for expansion. The firm wants to raise this money...
Boeing Corporation has just issued a callable​ (at par)​ three-year, 5.3% coupon bond with​ semi-annual coupon...
Boeing Corporation has just issued a callable​ (at par)​ three-year, 5.3% coupon bond with​ semi-annual coupon payments. The bond can be called at par in two years or anytime thereafter on a coupon payment date. It has a price of $98.65. a. What is the​ bond's yield to​ maturity? b. What is its yield to​ call? c. What is its yield to​ worst?
Five years ago Tosev Inc. issued 30-year, $1,000 par value, semi-annual coupon bonds with a coupon...
Five years ago Tosev Inc. issued 30-year, $1,000 par value, semi-annual coupon bonds with a coupon rate of 9.10 percent. The bonds originally sold at a price of $1,010.32 per bond. Currently, those bonds have a market price of $1,118.15 per bond. The Chief Financial Officer of Tosev is currently considering issuing new bonds. These bonds will have a par value of $1,000, semi-annual coupon payments, a term of 25 years and a coupon rate of 8 percent. Due to...
Seven years ago (NPC) issued twenty year 8.0% semi annual coupon bonds each with a $1,000...
Seven years ago (NPC) issued twenty year 8.0% semi annual coupon bonds each with a $1,000 face value. Since then, interest rates have generally fallen and the yield to maturity on the NPC bonds is now 3.9%. Give this information, what is the price today for a NPC bond? Do not use a chart or computer for this. No financial calculator. Step by step.
3. A $1,000 par bond has a 5% semi-annual coupon and 12 years to maturity. Bonds...
3. A $1,000 par bond has a 5% semi-annual coupon and 12 years to maturity. Bonds of similar risk are currently yielding 6.5%. a. What should be the current price of the bond? b. If the bond’s price five years from now is $1,105, what would be the yield to maturity for the bond at that time? c. What will the price of this bond be 1 year prior to maturity if its yield to maturity is the same as...
Bold Corporation issued bonds on April 1,2010 with a 3% coupon for the first 5 years...
Bold Corporation issued bonds on April 1,2010 with a 3% coupon for the first 5 years (until 2015), a 3.5% coupon for the next 4 years (until 2019), 4% coupon for the following 5 years (until 2024) and 4.5% coupon for the following 9 years (until 2033) until it matures on April 1, 2033. The interest on these bonds is paid and compounded semi-annually. Original Graph in Years when issued April 1, 2010 You buy the bond on April 1,...
There are two companies named AA and BB. Company AA has a 5-year, 4% annual coupon...
There are two companies named AA and BB. Company AA has a 5-year, 4% annual coupon bond with a $100 par value. BB has a 20-year, 3% annual coupon bond with a $100 par value. Both bonds currently have a yield to maturity of 2.5%. Answer the following questions: a. By how much do you think the price of each bond will change if interest rates suddenly fall by 2 percentage point (e.g from 3% to 1%)? b. By how...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT