Consider the Treasury bond quotes shown below. TREASURY NOTES & BONDS GO TO: Bills Tuesday, May...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the Treasury bond quotes shown below. TREASURY NOTES & BONDS GO TO: Bills Tuesday, May 03, 2016 Find Historical Data Treasury note and bond data are representative over the counter quotations as of 3pm Eastern time. For notes and bonds callable prior to maturity, yields are computed to the earliest call date for issues quoted above par and to the maturity date for issues below par. Maturity 5/15/2016 5/15/2016 5/15/2016 5/31/2016 5/31/2016 5/31/2016 4/30/2022 11/15/2045 2/15/2046 Bid 0.250 99.9766 99.9922 5.125 100.1016 100.1172 7.250 100.1328 100.1484 0.375 99.9688 99.9844 1.750 100.0703 3.250 100.1797 Coupon 1.750 101.6563 Asked 3.000 107.1563 2.500 96.7500 100,0859 100.1953 101.6719 I WHAT'S THIS? Cho 0.0156 0.509 0.0625 1.220 0.0781 2.270 0.0313 0.587 0.0391 0.0313 Asked yield 0.3906 0.581 0.594 1.458 107.1875 1.2031 2.648 96.7813 1.1797 2.657 Source: Tullett Prebon historical data prior to 12/11/14: ICAP plc; historical data prior to 6/9/11: Thomson Reuters (a) Show the cash outflows and inflows from the point of view of an investor who is considering buying the bond maturing on 4/30/2022. For the purposes of this exercise, assume that the quotes are as of 4/30/2016. Assume a face value and coupon frequency. (b) Calculate the yield to maturity of the bond. Note: Use Excel's IRR function after making a table of cash flows. Alternatively, use Excel's RATE function. The RATE function doesn't need cash flows to be drawn in a table. (c) Calculate the value of the bond if the opportunity cost of capital is 2.4% per year. Consider the Treasury bond quotes shown below. TREASURY NOTES & BONDS GO TO: Bills Tuesday, May 03, 2016 Find Historical Data Treasury note and bond data are representative over the counter quotations as of 3pm Eastern time. For notes and bonds callable prior to maturity, yields are computed to the earliest call date for issues quoted above par and to the maturity date for issues below par. Maturity 5/15/2016 5/15/2016 5/15/2016 5/31/2016 5/31/2016 5/31/2016 4/30/2022 11/15/2045 2/15/2046 Bid 0.250 99.9766 99.9922 5.125 100.1016 100.1172 7.250 100.1328 100.1484 0.375 99.9688 99.9844 1.750 100.0703 3.250 100.1797 Coupon 1.750 101.6563 Asked 3.000 107.1563 2.500 96.7500 100,0859 100.1953 101.6719 I WHAT'S THIS? Cho 0.0156 0.509 0.0625 1.220 0.0781 2.270 0.0313 0.587 0.0391 0.0313 Asked yield 0.3906 0.581 0.594 1.458 107.1875 1.2031 2.648 96.7813 1.1797 2.657 Source: Tullett Prebon historical data prior to 12/11/14: ICAP plc; historical data prior to 6/9/11: Thomson Reuters (a) Show the cash outflows and inflows from the point of view of an investor who is considering buying the bond maturing on 4/30/2022. For the purposes of this exercise, assume that the quotes are as of 4/30/2016. Assume a face value and coupon frequency. (b) Calculate the yield to maturity of the bond. Note: Use Excel's IRR function after making a table of cash flows. Alternatively, use Excel's RATE function. The RATE function doesn't need cash flows to be drawn in a table. (c) Calculate the value of the bond if the opportunity cost of capital is 2.4% per year.
Expert Answer:
Answer rating: 100% (QA)
Here are the answers to the questions a Cash outflows and ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Calculate the IRR for the following projects. a. An initial outflow of $15,220 followed by inflows of $5,000, $6,000, and $6,500. b. An initial outflow of $47,104 followed by inflows of $16,000,...
-
Two independent random samples of annual starting salaries for individuals with master's and bachelor's degrees in business were taken. Use the data shown below and provide a 95% confidence interval...
-
Use lHpitals Rule to evaluate the limit. Then evaluate the limit using a method. lim x-0 sin 5x X
-
The production department of Zunni's Manufacturing is considering two numerically controlled drill presses; one must be selected. Comparison data is shown in the table below. MARR is 10 percent/year....
-
The Association of Women in Government established an Educational Foundation to raise money to support scholarship and other education initiatives. The Educational Foundation is a private...
-
Calculate the total billing amount for Jonas and his associate for their ( 1 ) first client assessment session and ( 2 ) second client assessment session. State whether they are the same or different...
-
Ken (birthdate July 1, 1987) and Amy (birthdate July 4, 1989) Booth have brought you the following information regarding their income, expenses, and withholding for the year. They are unsure which of...
-
Consider an asset that follows a geometric Brownian motion and that pays a dividend yield q > 0, so that its risk-neutral process is d.S = (ra) Sdt + oSdW. Why is the delta of a European call option...
-
A mass resting on a horizontal, frictionless surface is attached to one end of a spring; the other end is fixed to a wall. It takes 3.9 J of work to compress the spring by 0.14 m. If the spring is...
-
Drafting a Memo, Vehicle Purchase CleanWizards is a company in the business of cleaning carpets in residen- tial homes. CleanWizards has just traded in its 2014 van with a carrying value of $35,000...
-
functions. Write a program that calculates multiplication and division operations through The function that calculates multiplication takes 2 positive integer numbers as parameters and display the...
-
Buslines Inc.'s income statement (condensed) for two years is shown below: 31 December 20X4 20X5 Gross sales $ 550,000 $ 606,000 Sales returns (10,000 ) (6,000 ) 540,000 600,000 Cost of goods sold...
-
1. Draw a table that shows the value of the variables i and n during the execution of loop. The table should contain one column for each variable and one line for each iteration. 2. What is the...
-
8. There are five students in a class and the number of students who will participate in annual day every year is a Poisson random variable with mean 3. What will be the probability of more than 3...
-
Smthe Co. makes furniture. The following data are taken from its production plans for the year. Required: 1. Determine the hazardous waste disposal cost per unit for chairs and for tables if costs...
-
Ken (age 31) and Amy (age 28) Booth have brought you the following information regarding their income, expenses, and withholding for the year. They are unsure which of these items must be used to...
-
Ken paid the following amounts for interest during 2012: Qualified interest on home mortgage...........................................$4,700 Auto loan...
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
An analyst makes the following statement: Use of P/E and other multiples for analysis is not effective because the multiples are based on historical data and because not all companies have positive...
-
The primary difference between P/E multiples based on comparables and P/E multiples based on fundamentals is that fundamentals-based P/Es take into account: A. Future expectations. B. The law of one...
-
A price-to-earnings ratio that is derived from the Gordon growth model is inversely related to the: A. Growth rate. B. Dividend payout ratio. C. Required rate of return.
Study smarter with the SolutionInn App