Question: 1 7 ) Consider a $ 1 , 0 0 0 par value bond with a 9 % coupon rate, semi - annual payments, 6

17) Consider a $1,000 par value bond with a 9% coupon rate, semi-annual payments, 6 years to
maturity and a price of $1,200. What is the Macaulay duration?
18) Consider a $1,000 par value bond with a 6% coupon rate, semi-annual payments, 12 years to
maturity and a yield to maturity of 5%. What is the Macaulay duration?
Please do it in excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

1. You have just purchased a 10year, $1,000 par value bond. The coupon rate on this bond is 8 percent annually, with interest being paid each 6 months. If you expect to earn a 10 percent of return on...

Q:

1. Two bonds are available for purchase in the financial markets. The first bond is a two-year, $1000 bond that pays an annual coupon of 10 %. The second bond is a two-year, $1000, zero-coupon bond....

Q:

If I could get help with these following questions, that would be great! All the information is already provided. Question 1' Excel Online Structured Activity: Interest Rate Sensitivity A bond trader...

Q:

Question 1 Excel Online Structured Activity: Interest Rate Sensitivity A bond trader purchased each of the following bonds at a yield to maturity of 10%. Immediately after she purchased the bonds,...

Q:

Suppose you currently have $ 2 , 0 0 0 and plan to purchase a 3 - year certificate of deposit ( CD ) that pays 4 % interest compounded annually. How much will you have when the C D matures? How much...

Q:

Information needed for Qeustion-7 : Stock-A has an expected return of 12% and a standard deviation of 40%. Stock-B has an expected return of 18% and a standard deviation of 60%. The correlation...

Q:

6-16. The town of Hill Valley is issuing a 30-year bond with a face value of $50 million and a stated annual interest rate of 4 percent. The town will make interest payments twice a year. Calculate...

Q:

ANSWER BOTH QUESTIONS PLEASE 1) what is the price of a $1000 par value, semi annual coupon bond with three years to maturity, a coupon rate of 7.1% and yield to maturity of 3%? 2) you bought a 18...

Q:

1. You are considering a 30-year, $1,000 par value bond. Its coupon rate is 9%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the...

Q:

please include formulas on excel Q Search ond valuation 2 Excel Online Structured Activity: Bond valuation You are considering a 10-year, $1,000 par value bond. Its coupon rate is 10%, and interest...

Q:

What is the most common constraint faced by merchandisers?

Q:

What responsibility does an internal auditor have to evaluate residual risks associated with an organizational activity? What should the internal auditor do if the auditor decides that the remaining...

Q:

Which of the following statements regarding NPV analysis is correct? a . NPV calculations do not depend critically on cash flow projects b . NPV calculations are only and good as the information that...

Q:

12. Create Half-Adder a. Using logic gates b. Using Multiplexor 13. Create Full-Adder a. Using logic gates b. Using Multiplexor 14. Create a 4-bit Adder using HA Half-Adder) and FA(Full-Adder)