Question: This is your first week at a mutual fund as an analyst. Your boss asked you to evaluate the price risk of two 30-year bonds

This is your first week at a mutual fund as an analyst. Your boss asked you to evaluate the price risk of two 30-year bonds Bond A and Bond B. Bond A has a coupon rate of 4%, while Bond B has a coupon rate of 8%. Both bonds pay their coupons semi-annually

. A) Construct an Excel spreadsheet showing the prices of each of these bonds for yields to maturity ranging from 1% to 15% at intervals of 1%. Column A should show the yield to maturity (ranging from 1% to 15%), and columns B and C should compute the prices of the two bonds (using Excels PV function) at each interest rate.

B) In columns D and E, compute the percentage difference between the bond price and its value when the yield to maturity is 6% (initial yield to maturity) for bonds A and B, respectively [ = {(Price (at current YTM) Price (at initial YTM of 6%)}/ Price (at initial YTM of 6%)].

Face value	$1,000.00
Coupon rate bond A	4.00%
Coupon rate bond B	8.00%
Time	30.00 Years
Initial Yield to Maturity	6.00%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

This is your first week at a mutual fund as an analyst. Your boss asked you to evaluate price risk of two 30-year bonds Bond A and Bond B. You have to complete the following tasks in order to prepare...

This is your first week as an analyst at a mutual fund. Your boss asked you to evaluate the price risk of two 3 0 - year bonds, Bonds A and B . You must complete the following tasks to prepare a...

Please answer the following questions using Excel and submit your assignment ( Excel file ) via Canvas. You can work in groups of three on the case assignments ( please write the names of all group...

answer in excel, Jaguar havard case sudy 1 ) This is your first week as an analyst at a mutual fund. Your boss asked you to evaluate the price risk of two 3 0 - year bonds, Bonds A and B . You must...

201820191 while project B has relatively long future cash flows. Which project will be more sensitive to 11. Given the choice, would a fim prefer to use MACRS depreciation or straight-line 12....

1.(6 Points) Stock X and Stock Z both have an expected return of 10%.The standard deviation of the expected return is 8% for Stock X, and 12% for Stock Z.Assume that these are the only two stocks...

1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...

Need help with these discussion postings (in a document) and assignments (all in separate files), all directions are included as well. FINANCE DIRECTIONS Need to provide 1 original post substantial...

ITEM #1 LEARNING FROM THE HEADLINES True to the Learning from the Headlines approach of this course, watch the Part Three Intro Video after you read the short article the video highlights. Notice...

Case Analysis 1. Compute the yield to maturity of Land'o'Toys' bonds before the purchase announcement and use it to determine the likely current bond rating. (Compare YTM to the table on p. 269)....

The U.S. Environmental Protection Agency has implemented the Smart Way Transport Program. Discuss the nature and role of the program. Do you think it will be effective? Why or why not?

Determine which option, if any, should be chosen based on net present worth using a 8% interest rate. Use Repeatability Method. a. The Net Present Worth of Alternative A is = $ Blank 1 b. The Net...

Keeping low cash balances and little investment in marketable securties 0 an example of flexible short ferm financial policy. True or Falve

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...