Question: USING EXCEL. BOND VALUATION 2. JNJ issues some new $1,000 face value subordinated debentures with an annual coupon rate of 4.5%, payable semi-annually. The bonds

USING EXCEL. BOND VALUATION 2. JNJ issues some new $1,000 face value subordinated debentures with an annual coupon rate of 4.5%, payable semi-annually. The bonds mature in 20 years. The bond does not contain a call feature. The market interest rate on similar risk and maturity bonds is 4.2%, compounded semi-annually. a) You buy a bond. Find the price you pay. b) Ten years later the market interest rate on 10 year bonds is 5.8%, compounded semi-annually. You sell the bond. What do you receive for it? c) Compute the rate of return you earned over the ten year period if you sell the bond. That is, solve for the IRR of the cash flows you paid out, and received, over the 10 years.

BOND VALUATION 2. JNJ issues some new $1,000 face value subordinated debentures with an annual coupon rate of 4.5%, payable semi-annually. The bonds mature in 20 years. The bond does not contain a call feature. The market interest rate on similar risk and maturity bonds is 4.2%, compounded semi-annually. a) You buy a bond. Find the price you pay. b) Ten years later the market interest rate on 10 year bonds is 5.8%, compounded semi-annually. You sell the bond. What do you receive for it? c) Compute the rate of return you earned over the ten year period if you sell the bond. That is, solve for the IRR of the cash flows you paid out, and received, over the 10 years

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 Accounting Questions!

Park Corporation is planning to issue bonds with a face value of $670,000 and a coupon rate of 7.5 percent. The bonds mature in 6 years and pay interest semiannually every June 30 and December 31....

Serotta Corporation is planning to issue bonds with a face value of $300,000 and a coupon rate of 12%. The bonds mature in 2 years and pay interest quarterly, every March 31, June 30, September 30...

QUESTION 5 A bond with a par value of 1000 and nominal annual coupon rate of 6% paid semiannually (i.e. 3% at the end of each six-month period) is redeemable for 1100. You are given the following...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

PLEASE HELP ME WITH THIS!! Spreadsheet Project 1: Calculating the Cost of Capital Due Dec 4, 2015 This project has two parts. In Part One, you will be estimating the betas of three firms using...

Problem 1: There Are Three Ways To Do Things A bond with face value $800 and an annual coupon of $40 has a maturity of 267 years! If the interest rates are 5% for every maturity, what is the price of...

Hi, Please help me on these questions. Thank you Economic Information : The Quinns expect inflation to average 3% per year until they retire. They anticipate Jims salary will increase 10% annually,...

Help needed! I have been really struggling with this project. AutoSave . Off) H Project 1_2020 Fall - Saved to this PC O Search Andrew Warren AW X File Home Insert Draw Design Layout References...

To whom it may concern is it possible to have the unanswered questions answered? Question 1 0 out of 1 points Which of the following events would make it more likely that a company would choose to...

Consider the following utility function: U=f(x,y) = 3xy + x With a budget constraint given by: 350 = 15x + 21y. Knowing that the price of x increases to 12 dollars, a) Calculate the Marshallian...

Complete this table for refrigerant-134a: Phase description 320 8 30 0.015 Saturated vapor 180 600 80

View Policies Show Attempt History Current Attempt in Progress Pharoah Company had a January 1 inventory of $300000 when it adopted dollar-value LIFO. During the year, purchases were $1890000 and...

It is important to understand that consumers want organizations to market with them, not to them. Advances in technology and trends in how consumers desire to be part of promotional efforts require...

What forms of power seemed most evident among the founding team members? Explain.

Have you used any of the five techniques for generating creative alternatives? If yes, which ones?

Is following the steps in the decision-making model really all that important? Which steps of the model do you tend to follow? Which steps do you tend to not use? Will you use the model in your...