US government issued a railroad perpetual bond that pays $100 every year forever. However the interest...

US government issued a railroad perpetual bond that pays $100 every year forever. However the interest rate fluctuates a lot, and you want to know the impact of interest rate on price of the bond. Consider interest rates range between 1% and 20% with 1% incremental step. Plot the relationship between interest rate and price of the perpetual bond in Excel, and clearly state the relationship.

Note: plot interest rate in X axis, and price in Y axis. Note that in Excel, you put interest rates in one column, and prices in another column, then select these two, and click insert graph. You might have to right click the graph to choose what is displayed on X axis.

Solutions

Expert Solution

Dear Student,

Please see the picture for the answer, comment if u have any doubt and like if u are satisfied with the answer.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A coupon bond pays out 2% every year on a principal of $100. The bond matures...

A coupon bond pays out 2% every year on a principal of $100. The bond matures in six years and has a market value of $92. Calculate the yield to maturity, duration and convexity for the bond. (Please provide a well detailed answer with the equations used for each part. Thank you!)

There is a bond that pays $100 per year interest, with a $1,000 par value. It...

There is a bond that pays $100 per year interest, with a $1,000 par value. It matures in 15 years. The market required yield to maturity on a comparable bond is 12%. What is the value of the bond? How does the value change if the yield to maturity on a comparable bond increase to 15%? What if it decreases to 8%. Explain the above questions (part b) with the concepts of interest rate risk, premium bonds and discount bonds....

There is a bond that pays $100 per year interest, with a $1,000 par value. It...

What is the present value of an investment that pays $200 every other year forever if...

What is the present value of an investment that pays $200 every other year forever if the first cash flow occurs in two years? What is the value when the first cash flow occurs in one year? The opportunity cost of capital is 12% per year.

Question 4: There is a bond that pays $100 per year interest, with a $1,000 par...

Question 4: There is a bond that pays $100 per year interest, with a $1,000 par value. It matures in 15 years. The market required yield to maturity on a comparable bond is 12%. What is the value of the bond? How does the value change if the yield to maturity on a comparable bond increase to 15%? What if it decreases to 8%. Explain the above questions (part b) with the concepts of interest rate risk, premium bonds and...

An investment pays $15,000 every other year forever with the first payment one year from today....

An investment pays $15,000 every other year forever with the first payment one year from today. a. What is the value today if the discount rate is 8 percent compounded daily? (Use 365 days a year. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the value today if the first payment occurs four years from today? (Use 365 days a year. Do not round intermediate calculations and round your answer...

ACC Company issued a 10-year, 8%, $1,000,000 bond on Jan 1, 2009. The bond pays interest...

ACC Company issued a 10-year, 8%, $1,000,000 bond on Jan 1, 2009. The bond pays interest every December 31, with the principal to be paid at the end of 10 years. The market interest rate (effective interest rate) on Jan 1, 2009 was 5%. The market interest rate on December 31,2012 was 4%. (1) Compute the Book value of bonds liability on January 1, 2012. (2) Record the journal entry about interest expense on December 31, 2012.

7. Pat pays $10,000 for a newly issued two-year government bond with a $10,000 face value...

7. Pat pays $10,000 for a newly issued two-year government bond with a $10,000 face value and a 6 percent coupon rate. One year later, after receiving the first coupon payment, Pat sells the bond. If the current one-year interest rate on government bonds is 5 percent, then the price Pat receives is: A. $10,000. B. $500. C. greater than $10,000. D. less than $10,000. 8. Sydney purchases a newly-issued, two-year government bond with a principal amount of $10,000 and...

Consider an investment that costs $400 and pays $100 per year forever. What is the payback...

Consider an investment that costs $400 and pays $100 per year forever. What is the payback period? What is the discounted payback?

You intend to purchase a 10-year, $1,000 face value bond that pays interest of $40 every...

You intend to purchase a 10-year, $1,000 face value bond that pays interest of $40 every year. If your annual required rate of return is 10 percent with, how much should you be willing to pay for this bond?

Subjects