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

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You are considering issuing two types of bonds. The current yield to maturity on similar bonds...

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...

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?

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...

*SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED**** A company is considering...

*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000. In addition, the machine must be installed and tested. The costs of installation and testing will amount to $10,000. The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it) The equipment will...

The Richardson Oil Company is considering issuing additional debt. They wish to use the yield on...

The Richardson Oil Company is considering issuing additional debt. They wish to use the yield on their existing debt as a guide to the cost of new debt. They currently have a zero-coupon bond outstanding that has five years to maturity and a current market price of 74⁶₈, or $747.50 per $1,000 par value. Use the Approximate Approach a. If Richardson’s marginal tax rate is 20%, what is the cost of debt? b. If Richardson’s marginal tax rate is 30%,...

Subjects