09 Jul Bond Valuation, economics homework help
Question Description
Hello!
Using Excel, complete the following problems in your textbook:
Bond Valuation: Problems 3, 6 and 10 on page 233
Interest Rate Risk: Problems 19 and 20 on page 234
Yield to Maturity & Rates of Return: Problems 12 and 21 on page 234
Please complete the above problems in the attached xls.
Thanks!
3Valuing Bonds [LO2] Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of €1,000, 23 years to maturity, and a coupon rate of 5.8 percent paid annually. If the yield to maturity is 4.7 percent, what is the current price of the bond?
6Bond Prices LO2> Sqeekers Co. issued 15-year bonds a year ago at a coupon rate of 4.1 percent. The bonds make semiannual payments and have a par value of $1,000. If the YTM on these bonds is 4.5 percent, what is the current bond price?
10Valuing Bonds [LO2] Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 3.8 percent. What is the price of the bond?
19.Interest Rate Risk [LO2] Both Bond Sam and Bond Dave have 6.5 percent coupons, make semiannual payments, and are priced at par value. Bond Sam has 3 years to maturity, whereas Bond Dave has 20 years to maturity. If interest rates suddenly rise by 2 percent, what is the percentage change in the price of Bond Sam? Of Bond Dave? If rates were to suddenly fall by 2 percent instead, what would the percentage change in the price of Bond Sam be then? Of Bond Dave? Illustrate your answers by graphing bond prices versus YTM. What does this problem tell you about the interest rate risk of longer-term bonds?
20. Interest Rate Risk [LO2] Bond J has a coupon rate of 3 percent. Bond K has a coupon rate of 9 percent. Both bonds have 19 years to maturity, make semiannual payments, and have a YTM of 6 percent. If interest rates suddenly rise by 2 percent, what is the percentage price change of these bonds? What if rates suddenly fall by 2 percent instead? What does this problem tell you about the interest rate risk of lower-coupon bonds?
12.Calculating Real Rates of Return [LO4] If Treasury bills are currently paying 5.1 percent and the inflation rate is 2.2 percent, what is the approximate real rate of interest? The exact real rate?
21.Bond Yields [LO2] Bourdon Software has 6.4 percent coupon bonds on the market with 18 years to maturity. The bonds make semiannual payments and currently sell for 106.8 percent of par. What is the current yield on the bonds? The YTM? The effective annual yield?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.