A 3 year bond has semiannual coupons of 11% per annum. The continuously compounding yield is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A 3 year bond has semiannual coupons of 11% per annum. The continuously compounding yield is 15%. The bond has a face value of $200. You will be pricing the bond initially, and at future times throughout the life of the bond as it pulls to par at maturity, using the same continuously compounding yield throughout. Since the yield is given with continuous compounding, the usual formulas will not work without changing the yield to the equivalent discrete frequency. Instead, string out the cash flows (each of the coupons separately plus the final redemption value) in the columns of a spreadsheet similar to the one shown here. Each row will compute the bond price at a different point in time: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A B Time by month 0 0.08333 0.16667 0.25000 0.33333 etc... C Face <your face value> Bond value =sum all cells to the right =sum all cells to the right =sum all cells to the right What is the initial value of the bond? D Coupon rate <your coupon rate> Coupon 1 <coupon cash flow> Time of payment 0.5 Value Answer correct to 2 decimals E Frequency - m 2 Coupon 2 <coupon cash flow> Time of payment 1 Value Yield <your yield> Coupon 3 <coupon cash flow> Time of payment 1.5 Value Each cell in the table is the above cash flow valued at the time in column B for that row. If the time of payment is less than the time in column B, the value is zero, otherwise discount the cash flow back to the time given in column B for that row etc... etc... G H Redemption value =C3 You are to compute the value of the bond for each month in column B by adding up the outstanding cash flows along that row, each discounted from the time of its payment, back to the time at which you are valuing the bond. For the values in the table, use an "if" statement to set the value to zero if the "Time of payment" is less than the "Time by month", otherwise discount that cash flow using the continuously compounding rate. In order to copy your "if" statement containing the formula to every cell in the table, place a "$" in front of the column letter and/or the row number in the cell references as appropriate. Time of payment <your maturity> Value A 3 year bond has semiannual coupons of 11% per annum. The continuously compounding yield is 15%. The bond has a face value of $200. You will be pricing the bond initially, and at future times throughout the life of the bond as it pulls to par at maturity, using the same continuously compounding yield throughout. Since the yield is given with continuous compounding, the usual formulas will not work without changing the yield to the equivalent discrete frequency. Instead, string out the cash flows (each of the coupons separately plus the final redemption value) in the columns of a spreadsheet similar to the one shown here. Each row will compute the bond price at a different point in time: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A B Time by month 0 0.08333 0.16667 0.25000 0.33333 etc... C Face <your face value> Bond value =sum all cells to the right =sum all cells to the right =sum all cells to the right What is the initial value of the bond? D Coupon rate <your coupon rate> Coupon 1 <coupon cash flow> Time of payment 0.5 Value Answer correct to 2 decimals E Frequency - m 2 Coupon 2 <coupon cash flow> Time of payment 1 Value Yield <your yield> Coupon 3 <coupon cash flow> Time of payment 1.5 Value Each cell in the table is the above cash flow valued at the time in column B for that row. If the time of payment is less than the time in column B, the value is zero, otherwise discount the cash flow back to the time given in column B for that row etc... etc... G H Redemption value =C3 You are to compute the value of the bond for each month in column B by adding up the outstanding cash flows along that row, each discounted from the time of its payment, back to the time at which you are valuing the bond. For the values in the table, use an "if" statement to set the value to zero if the "Time of payment" is less than the "Time by month", otherwise discount that cash flow using the continuously compounding rate. In order to copy your "if" statement containing the formula to every cell in the table, place a "$" in front of the column letter and/or the row number in the cell references as appropriate. Time of payment <your maturity> Value
Expert Answer:
Answer rating: 100% (QA)
To calculate the initial value of the bond using a continuously compounding yield we will set up a s... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Ivanhoe Corporation issued 890,000 of 1.10 noncumulative preferred stock. In its first year of operationsIvanhoe paid $636,350 of dividends to its preferred stockholders in its second year the...
-
In the following normal form game: A B C a 12; -7 10:2 0,9 B 10:1 2:4 8:5 8 4:5 8:14 16: -3 (a) (3 points) Find the pure strategy best responses. You may mark the game table but you will loose a...
-
Ultimate Consulting is a management consulting firm that offers a wide range of services to companies in many industries. To stay on the cutting edge of developments in the business world and to...
-
The management of The Hershey Company has asked union workers in two of its highest cost Pennsylvania plants to accept higher health insurance premiums and take a wage cut. The workers portion of the...
-
Suppose the electrostatic work done on a charged particle as it moves along the gray path from \(A\) to \(C\) in Figure \(25.6 c\) is \(W\). What is the electrostatic work done on the particle (a)...
-
Looking at the days (rows) as blocks, rework Exercise 12.5 by the method of Section 12.3. Data From Exercise 12.5 12.5 The following are the numbers of mistakes made in 5 successive days for 4...
-
A cookie company has collected the following data. They have a process that bakes and packages 11oz packages of cookies (the package says 11oz. but the true average may be a little off). They take a...
-
Mike's total RRSP contribution room for the current year is $8,000, while his wife Maria's room is $2,000. Mike has decided to contribute $5,000 to his own RRSP and $3,000 to a spousal RRSP for...
-
Carrie DLake, Reed A. Green, and Doug A. Divot share a passion for golf and decide to go into the golf club manufacturing business together. On January 2, 2020, DLake, Green, and Divot form the...
-
Calculate the mass of chloroform ( CHCI 3 , an organic solvent ) that contains 2 . 3 6 x 1 0 ^ 1 5 molecules of chloroform
-
Studies have shown that students who go to highly selective colleges have, on average, higher lifetime incomes than do students who go to less selective colleges. a. Explain why there might be...
-
Sketch the graph of each equation in Problems 3-30. \(y=-\frac{2}{3} x^{2}\)
-
Graph the first-degree inequalities in two unknowns in Problems 13-48. \(y>5 x-3\)
-
Graph each sequence in Problems 27-34 in one dimension. \(a_{n}=\frac{2 n}{n+2}\)
-
Sketch the curves using the equations given in Problems 28-51. \(x^{2}+\frac{y^{2}}{9}=1\)
-
Genesis Corporation sells three types of snowboards with the following information: Beginner Novice Expert Unit Selling Price Unit Variable Cost Sales Mix $40 $50 $80 $10 $15 $20 50% 20% 30% What is...
-
Below is a sample of the data in the file NFLAttendance which contains the 32 teams in the National Football League, their conference affiliation, their division, and their average home attendance....
-
Consider a simple firm that has the following market-value balance sheet: Next year, there are two possible values for its assets, each equally likely: $1200 and $960. Its debt will be due with 5%...
-
You are invested in GreenFrame, Inc. The CEO owns 3% of GreenFrame and is considering an acquisition. If the acquisition destroys $50 million of GreenFrames value, but the present value of the CEOs...
-
Calculate the future value of $2000 in a. 5 years at an interest rate of 5% per year. b. 10 years at an interest rate of 5% per year. c. 5 years at an interest rate of 10% per year. d. Why is the...
-
Draw and explain the class diagram for stable analysis pattern? Identify and highlight all participants and explain why they exist.
-
List some design and implementation issues faced, when implementing this pattern. Explain each issue.
-
List some differences between the analysis pattern described here and the traditional pattern.
Study smarter with the SolutionInn App