please use excel to solve this and format it the same way! thank you Paste F17 A
Fantastic news! We've Found the answer you've been seeking!
Question:
please use excel to solve this and format it the same way! thank you
Transcribed Image Text:
Paste F17 A > B Arial BIU fx C D 10 A A A E F G ||| H I J K 6 A 20-year, 6% quarterly coupon bond with a par value of $10,000 may be called in 5 years at a call price of $10,200. The bond sells for $10.500. (Assume that the bond has just been Issued.) 7 8 9 Basic Input Data: 10 Years to maturity: 11 Periods per year: 12 Periods to maturity: 13 Coupon rate: 14 Par value: 15 Periodic payment 16 Current price 17 Call price: 18 Years till callable: 19 Periods till callable: 20 21 a. What is the bond's yield to maturity? 22 26 28 24 2222222352313353 Peridodic YTM Annualized Nominal YTM 27 b. What is the bond's current yield? 29 Current yield = 30 Current yield = 36 Cap. Gain/loss yield = 37 Cap. Gain/loss yield= 38 Cap. Gain/loss yield= 39 Current yield = 34 c. What is the bond's capital gain or loss yield? 1 40 Note that this is an economic loss, not a loss for tax purposes. 41 42 d. What is the bond's yield to call? 43 Hint: This is a nominal rate, not the effective rate. Nominal rates are generally quoted. 44 Here we can again use the Rate function, but with data related to the call. 45 46 47 48 Peridodic YTC = Annualized Nominal YTC Hint: Write formula in words. Hint: Cell formulas should refer to Input Section (Answer) Hint: Write formula in words. Hint: Cell formulas should refer to Input Section (Answer) This is a nominal rate, not the effective rate. Nominal rates are generally quoted. 49 The YTC is lower than the YTM because if the bond is called, the buyer will lose the difference between the call price and the current 50 price in just 4 years, and that loss will offset much of the interest imcome. Note too that the bond is likely to be called and replaced, 51 hence that the YTC will probably be earned. 52 53 NOW ANSWER THE FOLLOWING NEW QUESTIONS: 54 55 e. How would the price of the bond be affected by changing the going market interest rate? Assume Norminal Market rate 56 is 6%. (Hint: Conduct a sensitivity analysis of price to changes in the going market interest rate for the bond. Assume that 57 the bond will be called if and only if the going rate of interest falls below the coupon rate. That is an oversimplification, but 58 assume it anyway for purposes of this problem.) 59 60 Nominal market rate, r 61 Value of bond if it's not called: 62 Value of bond if it's called: 63 0% The bond would not be called unless r Paste F17 A > B Arial BIU fx C D 10 A A A E F G ||| H I J K 6 A 20-year, 6% quarterly coupon bond with a par value of $10,000 may be called in 5 years at a call price of $10,200. The bond sells for $10.500. (Assume that the bond has just been Issued.) 7 8 9 Basic Input Data: 10 Years to maturity: 11 Periods per year: 12 Periods to maturity: 13 Coupon rate: 14 Par value: 15 Periodic payment 16 Current price 17 Call price: 18 Years till callable: 19 Periods till callable: 20 21 a. What is the bond's yield to maturity? 22 26 28 24 2222222352313353 Peridodic YTM Annualized Nominal YTM 27 b. What is the bond's current yield? 29 Current yield = 30 Current yield = 36 Cap. Gain/loss yield = 37 Cap. Gain/loss yield= 38 Cap. Gain/loss yield= 39 Current yield = 34 c. What is the bond's capital gain or loss yield? 1 40 Note that this is an economic loss, not a loss for tax purposes. 41 42 d. What is the bond's yield to call? 43 Hint: This is a nominal rate, not the effective rate. Nominal rates are generally quoted. 44 Here we can again use the Rate function, but with data related to the call. 45 46 47 48 Peridodic YTC = Annualized Nominal YTC Hint: Write formula in words. Hint: Cell formulas should refer to Input Section (Answer) Hint: Write formula in words. Hint: Cell formulas should refer to Input Section (Answer) This is a nominal rate, not the effective rate. Nominal rates are generally quoted. 49 The YTC is lower than the YTM because if the bond is called, the buyer will lose the difference between the call price and the current 50 price in just 4 years, and that loss will offset much of the interest imcome. Note too that the bond is likely to be called and replaced, 51 hence that the YTC will probably be earned. 52 53 NOW ANSWER THE FOLLOWING NEW QUESTIONS: 54 55 e. How would the price of the bond be affected by changing the going market interest rate? Assume Norminal Market rate 56 is 6%. (Hint: Conduct a sensitivity analysis of price to changes in the going market interest rate for the bond. Assume that 57 the bond will be called if and only if the going rate of interest falls below the coupon rate. That is an oversimplification, but 58 assume it anyway for purposes of this problem.) 59 60 Nominal market rate, r 61 Value of bond if it's not called: 62 Value of bond if it's called: 63 0% The bond would not be called unless r
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
The percentages of Americans who gamble online are shown in Table 47 for various age groups. Let y be the percentage of Americans who gamble online at age x years. a. Construct a scatterplot. b. Find...
-
What is the net present value of the following cash flows if the relevant discount rate is 7 percent? 0 -11520 1 81 2 650 3 880 4 2300 5 15800
-
What is the chill zone of a casting, and why does it form?
-
In Problems 1-3, find (w/(t by using the Chain Rule. Express your final answer in terms of s and t. 1. w = x2y; x = st, y = s - t 2. w = x2 - y ln x; x = s/t, y = s2t 3. w = ex2+y2; x = s sin t, y =...
-
X rays with a wavelength of \(0.20 \mathrm{~nm}\) undergo first-order diffraction from a crystal at a \(54^{\circ}\) angle of incidence. At what angle does first-order diffraction occur for...
-
Motorola Corporation manufactures cell phones and pagers in a particular factory. Assume that overhead costs are currently allocated using direct labor hours, but the controller has recommended an...
-
A multiplexer / data selector is a logic circuit that: Soru 4 Yan t accepts data inputs from multiple lines and passes this data to multiple output lines. accepts data inputs from several lines and...
-
An inductor coil stores 32 J of magnetic field energy and dissipates energy as heat at the rate of 320 W when a current of 4 A is passed through it. Find the time constant of the circuit when this...
-
Malina agrees to supervise a construction project for Al for a certain fee. In mid-project, without an excuse, Malina removes the plans from the site and refuses to continue. Al promises to increase...
-
If an individual who has not been judged mentally incompetent understands the nature and effect of entering into a certain contract, the contract is normally valid. (True/False)
-
Kanna is adjudged mentally incompetent. Irwin is appointed to act as Kannas guardian. Irwin signs a contract to sell some of Kannas property to pay for Kannas care. On regaining competency, Kanna a....
-
Green Energy Company files a suit against First Bank, claiming that the consideration for a contract between them was inadequate. The court likely will not evaluate the adequacy of consideration...
-
Lyydia works for Consolidated Manufacturing Company under a contract in which she agrees not to disclose any process she uses while in Consolidateds employ. When Lyydia goes into business for...
-
Read "The Media and Public Trust" and respond to the following: Discuss one or two reasons it seems that the media have lost the public trust in the U.S. Debate It Take a position on this statement:...
-
Calculate the number of neutrons of 239Pu.
-
The magical elevator. There is a man who lives on the top floor of a very tall building. Every day he gets the elevator down to the ground floor to leave the building to go to work. Upon returning...
-
There are 5 different color houses, occupied by people of 5 different nationalities, who smoke 5 different cigar brands, drink 5 different types of alcohol, and have 5 different pets. The houses are...
-
A man went outside without an umbrella or a raincoat, yet did not get wet.
Study smarter with the SolutionInn App