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...
-
Business ethics] Hynes Custodial Services (HCS) is a family-owned business specializing in corporate custodial care. Since many of its clients are sensitive to security concerns, HCS makes it a point...
-
use a census website that posts information on variables observed in the city where you live. Here is the website address....
-
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 correlation between cooling rate and final properties of a casting?
-
Show that the operator is identically null.
-
What is meant by the cockroach theory of fraud?
-
Oneida Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of June 30 have been...
-
Synlex Inc. is considering the purchase of a new machine for $600,000 . It would cost $4,000 to install the machine. It would necessitate an increase of net working capital 120,000 at the initial...
-
Derive the system of differential equations describing the straight-line vertical motion of the coupled springs shown in Figure 7.6.6. Use the Laplace transform to solve the system when k 1 = 1, k 2...
-
The accounting records of Hariharah provide income statement data for the current year: Total revenues: 1,000,000 Total expenses: 810,000 Profit before Income tax: 190,000 Total expenses of Hariharah...
-
True or False? The financial statements that a company files with the Securities and Exchange Commission (SEC) are among the main sources of information that investors use to research that company
-
1. (25 points) In this problem, we show that optimal solutions are strongly structured by the form of the objective function, independent of the distribution of the data for three common cases of...
-
1. The ------------ of the desert explains why so many Egyptian Mummies are still intact,whereas the humidity of the tombs in tropical rain forests support the agents of decay sothat few Aztec...
-
202380-Fall 2023-ACCT-3324 X M Question 3 - Chapter 14 - Integ x C F26 McGraw Hill Excel Question - Saved File Home Insert Draw Formulas Data Review View Help 5v A v...
-
On this week's episode of Innovation Fuel, Awane Jones, CEO of Phenomena Virtual eSport Arena, joins hosts Dave Keighron and Dr. Gelareh for a discussion on what makes a product sellable. They talk...
-
The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $165 $6,600 Aug. 13 Purchase 200 units at $180 36,000 Nov. 30 Purchase 60 units at $200 12,000...
-
Calculate the number of neutrons of 239Pu.
-
Write a program that reads all lines from a file and, using a Stream , prints how many of them contain the word the.
-
In this exercise, you will explore a simple way of visualizing a Rectangle object. The setBounds method of the JFrame class moves a frame window to a given rectangle. Complete the following program...
-
Trace the algorithm for removing an element described in Section7.3.6. Use an array values with elements 110 90 100 120 80, and remove the element at index 2.
-
11. ROLE REVERSAL Draft a multiple-choice question that focuses on the difference between an LLC and an S corporation. 2. Result: An S corporation can have only one class of stock. A partnership...
-
At http://ftc.gov, the Federal Trade Commission provides information on enforcement cases it has brought against franchisors who violate FTC rules. Do you see a pattern? Are some violations more...
-
1. Michael Ferns incorporated Erin Homes, Inc., to manufacture mobile homes. He issued himself a stock certificate for 100 shares for which he made no payment. He and his wife served as officers and...
Study smarter with the SolutionInn App