Question

In: Finance

Solve the problem in EXCEL You are considering issuing two types of bonds. The current yield...

Solve the problem in EXCEL

You are considering issuing two types of bonds. The current yield to maturity on similar bonds is 4% annually. Both bonds have a face value of $1000 and will pay annual coupons. Bond A has a maturity of 10 years and bond B has a maturity of 20 years. You want to compute the price of both bonds at the prevailing interest rate and see what happens to the price of the bonds as the interest rate changes. You should consider a range of interest rates starting in 2 % and ending in 7%, with increments of 0.1%. Calculate the price of both bonds at each interest rate and plot the bond prices against the interest rate. What do your results indicate about the interest rate risk of bonds with longer time to maturity?

Solutions

Expert Solution

Price of a bond is the present value of its cash flows. The cash flows are the coupon payments and the face value receivable on maturity

Price of bond is calculated using PV function in Excel :

rate = (YTM of bond = market interest rate)

nper (Years remaining until maturity)

pmt = (annual coupon payment = face value * coupon rate)

fv = (face value receivable on maturity)

As the bonds are being issued today, their coupon rate will equal the YTM of 4%.

The prices of each bond at various interest rates are calculated below :

The plot is below :

The result indicates that bonds with longer maturity have higher interest rate risk.

This is because for an equal change in interest rate, the change in the price of Bond B is higher


Related Solutions

You are considering issuing two types of bonds. The current yield to maturity on similar bonds...
You are considering issuing two types of bonds. The current yield to maturity on similar bonds is 4% annually. Both bonds have a face value of $1000 and will pay annual coupons. Bond A has a maturity of 10 years and bond B has a maturity of 20 years. You want to compute the price of both bonds at the prevailing interest rate and see what happens to the price of the bonds as the interest rate changes. You should...
Problem 5-22 Yield to Maturity and Yield to Call Arnot International's bonds have a current market...
Problem 5-22 Yield to Maturity and Yield to Call Arnot International's bonds have a current market price of $1,350. The bonds have an 12% annual coupon payment, a $1,000 face value, and 10 years left until maturity. The bonds may be called in 5 years at 109% of face value (call price = 1,090). What is the yield to maturity? Round your answer to two decimal places. % What is the yield to call if they are called in 5...
Problem 5-22 Yield to Maturity and Yield to Call Arnot International's bonds have a current market...
Problem 5-22 Yield to Maturity and Yield to Call Arnot International's bonds have a current market price of $1,200. The bonds have an 12% annual coupon payment, a $1,000 face value, and 10 years left until maturity. The bonds may be called in 5 years at 109% of face value (Call price = $1,090). What is the yield to maturity? Round your answer to two decimal places. % What is the yield to call, if they are called in 5...
Problem 5-22 Yield to Maturity and Yield to Call Arnot International's bonds have a current market...
Problem 5-22 Yield to Maturity and Yield to Call Arnot International's bonds have a current market price of $1,200. The bonds have an 12% annual coupon payment, a $1,000 face value, and 10 years left until maturity. The bonds may be called in 5 years at 109% of face value (Call price = $1,090). What is the yield to maturity? Round your answer to two decimal places. % What is the yield to call, if they are called in 5...
Solve in Excel. Show formulas A) You are considering an investment that will pay you $12,000...
Solve in Excel. Show formulas A) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would pay for this investment if your opportunity cost is 12%? B) You are considering an investment that will pay you $12,000 the first year, $13,000...
Define Current Yield and Yield to Maturity. Why do we need two return measures on bonds?
Define Current Yield and Yield to Maturity. Why do we need two return measures on bonds?
For the Yield Management Model, we have learned to solve the problem with two prices (Full...
For the Yield Management Model, we have learned to solve the problem with two prices (Full fare vs Discount fare). Briefly describe how you will apply the model to practice.
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel)...
Instructions to solve the problem: You are required to use a financial calculator or spreadsheet (Excel) to solve the problem related to the cost of capital. You are required to show the following 3 steps for the problem. (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. Problem: Cosa Nostra...
Please solve this case in Excel,Many thanks! The Problem: You are the technology controller for a...
Please solve this case in Excel,Many thanks! The Problem: You are the technology controller for a mid-sized publicly traded company. You have been assigned to evaluate an investment in a new process that would cost $2.5 million. You have determined that the internal rate of return of the positive operating cash flows associated with the investment is 13.0%. On a market value basis, the firm's capital structure is as follows: Debt: 40%; Preferred Stock: 5%; Common equity: 55%; This capital...
Problem 13. Suppose there are two bonds you are considering Bond A Bond B Bond A...
Problem 13. Suppose there are two bonds you are considering Bond A Bond B Bond A Bond B Maturity (years) 20 30 Coupon rate (%) 12 8 Par value 1000 1000 (a) If both bonds had a required rate of return of 10%, what would the bonds' prices be? (b) Explain what it means when a bond is selling at a discount, a premium, or at its face amount (par value). Based on results in part (a), would you consider...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT