You observe the following information in the government bond markets on 12/6/2021. Maturity Date Coupon rate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You observe the following information in the government bond markets on 12/6/2021. Maturity Date Coupon rate (%) 3.5 Price FV Coupon Frequency $100.00 S100.00 $100.00 12/06/2022 $97.62 Annual 12/06/2023 4 $94.53 Annual 12/06/2024 12/06/2025 4.5 $90.94 Annual 5.5 $8.77 $100.00 Annual The bonds have just paid their 2021 coupons. Use Excel to complete the calculations in this question. A. (6 marks) Construct the pure yield curve. Is it an upward or downward sloping term structure? B. (5 marks) Your friend is proposing a risk-free investment opportunity that generates $1mil at the end of each of the next 4 years. The investment costs $3.3mil today. Will you take it? C. (5 marks) What is the Macaulay đuration and convexity of the coupon bond maturing on 12/6/2025? D. (5 marks) Imagine that you have a loan out that must be repaid in 7 years with a present value of $1mil. You plan to fund this obligation by holding some of the coupon bond from Part C and some of a perpetuity with yield of 6%. In order to immunise your total portfolio against unexpected changes in interest rates, how much of the coupon bond and the perpetuity (in dollars) will you hold in your portfolio? E. (4 marks) Two years later, the yield curve remains unchanged. Is your portfolio still immunised? Explain. You don't need to do any calculations here. You observe the following information in the government bond markets on 12/6/2021. Maturity Date Coupon rate (%) 3.5 Price FV Coupon Frequency $100.00 S100.00 $100.00 12/06/2022 $97.62 Annual 12/06/2023 4 $94.53 Annual 12/06/2024 12/06/2025 4.5 $90.94 Annual 5.5 $8.77 $100.00 Annual The bonds have just paid their 2021 coupons. Use Excel to complete the calculations in this question. A. (6 marks) Construct the pure yield curve. Is it an upward or downward sloping term structure? B. (5 marks) Your friend is proposing a risk-free investment opportunity that generates $1mil at the end of each of the next 4 years. The investment costs $3.3mil today. Will you take it? C. (5 marks) What is the Macaulay đuration and convexity of the coupon bond maturing on 12/6/2025? D. (5 marks) Imagine that you have a loan out that must be repaid in 7 years with a present value of $1mil. You plan to fund this obligation by holding some of the coupon bond from Part C and some of a perpetuity with yield of 6%. In order to immunise your total portfolio against unexpected changes in interest rates, how much of the coupon bond and the perpetuity (in dollars) will you hold in your portfolio? E. (4 marks) Two years later, the yield curve remains unchanged. Is your portfolio still immunised? Explain. You don't need to do any calculations here.
Expert Answer:
Answer rating: 100% (QA)
Answer A Maturity Date Coupon Rate Price FV Coupon Frequency YTM curve 120622 35 9762 10000 Annual 6... View the full answer
Related Book For
Financial Markets And Institutions
ISBN: 978-0132136839
7th Edition
Authors: Frederic S. Mishkin, Stanley G. Eakins
Posted Date:
Students also viewed these accounting questions
-
A company due to pay a certain amount of a foreign currency in the future decides to hedge with futures contracts. Which of the following best describes the advantage of hedging? It leads to a better...
-
When there are significant declines expected in prices of the underlying, what is the best multiple option strategy to hedge falling prices? O Put bear spread O Put butterfly spread Protective Put...
-
You will use Excel to complete this. Suppose any company and make following documents in excel as a example. 1) Download financial statements 2) Income Statement 3) Balance Sheet 4) Statement of...
-
A $250 suit is on sale for $190, and a $90 pair of shoes is on sale for $65. Find the average percent decrease in price for the 2 items.
-
Determine the positive roots of the equation x2- 5x sin(3x) + 3 = 0.
-
North Company designs and manufactures machines that facilitate DNA sequencing. Depending on the intended purpose of each machine and its functions, each machine is likely to be unique. The job-order...
-
Which biome includes more living things than all other biomes combined?
-
Miriam Irby is president of MI Corp. Irby has decided to take a months vacation with her family to South Africa, Zimbabwe, and Angola. Irby has researched the trip and determined that the total cost...
-
What are the key principles of management, and how do they contribute to effective organizational practices?
-
Suppose you are a bank lending officer at the Midtown National Bank considering a loan request from Miller Manufacturing company for $1.05 million. The firm currently has $1 million in equity and its...
-
Fabulous, a U.S. corporation, sells all of its rights to a German patent to Erfurt A.G. ("Efurt"), a German corporation, for $1 million, payable in ten equal annual installments with interest at ten...
-
If the future value of an ordinary, 7-year annuity is $9,000 and interest rates are 9.0 percent, what's the future value of the same annuity due? (Round your answer to 2 decimal places.)
-
Burke Tires just paid a dividend of Do=$1.3. Analysts expect the company's dividend to grow by 30% this year, by 10% in Year 2, and at a constant rate of 5% in Year 3 and thereafter. The required...
-
KL and LP are both engaged in retKL limited and LP limited are both engaged in retailing but they seem to take a different approach. one of them prides itself on personal service and the other on...
-
What are the differences between cash and accrual basis accounting? Provide an example of each. Accrual accounting requires adjusting entries. Provide an example of an adjusting entry.
-
If r RF = 5%, r M = 11%, and b = 1.6 for Stock X, what is r x , the required rate of return for Stock X?
-
If you applied for a $4,500 loan, to be repaid in 3 years with semiannual payments at an interest rate of 9%, compounded semiannually, what will be your regular payment?
-
Orange juice producers are dismayed and puzzled. An economist told them that the reason the demand for orange juice fell is that a new technology allow tomato producers to pick ripe tomatoes more...
-
Suppose Microsoft, Inc. is trading at $27.29 per share. It pays an annual dividend of $0.32 per share, which is double last years dividend of $0.16 per share. If this trend is expected to continue,...
-
An investor in England purchased a 91-day T-bill for $987.65. At that time, the exchange rate was $1.75 per pound. At maturity, the exchange rate was $1.83 per pound. What was the investors holding...
-
If the demand for reserves did not fluctuate, the Fed could pursue both a nonborrowed reserves target and an interest-rate target at the same time. Is this statement true, false, or uncertain?...
-
A blender does 5000 J of work on the food in its bowl. During the time the blender runs, 2000 J of heat is transferred from the warm food to the cooler environment. What is the change in the thermal...
-
Which system contains more atoms: 5 mol of helium (A = 4) or 1 mol of neon (A = 20)? A. Helium B. Neon C. They have the same number of atoms.
-
A sample of ideal gas is in a sealed container. The temperature of the gas and the volume of the container are both increased. What other properties of the gas necessarily change? (More than one...
Study smarter with the SolutionInn App