5. A bond has just been issued. The bond will mature in 8 years and has...

5. A bond has just been issued. The bond will mature in 8 years and has a yield to maturity of 10%. The bond’s annual coupon rate is 8% and the face value of the bond is $1,000. Coupons will be paid quarterly. a. Compute the bond’s duration using the basic duration formula, i.e., the Macaulay duration formula (DO NOT use Excel’s Duration function or the VBA function dduration).

PLEASE USE EXCEL

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

jeff jeffy answered 6 months ago

Next > < Previous

Related Solutions

Aminah has just bought a bond that will mature in 7 years for RM 800, with...

Aminah has just bought a bond that will mature in 7 years for RM 800, with RM 1000 par value and coupon rate of 8% paid semiannually. What should the value of this bond be if the required return on similar-risk bonds is 12% per year ( 6% paid semiannually) ?

Churchill Corporation just issued bonds that will mature in 10 years. George Corporation just issued bonds that...

Churchill Corporation just issued bonds that will mature in 10 years. George Corporation just issued bonds that will mature in 12 years. Both bonds are standard coupon bonds and cannot be retired early. The two bonds are equally liquid. Which of the following statements is correct? If the yield curve for Treasury securities is flat, Churchill's bond will have the same yield as George's bonds. If the yield curve for Treasury securities is upward sloping, George's bonds will have a higher yield than Churchill's...

A 20-year bond with a face value of $1,000 will mature in 8 years. The bond pays semi-annual coupons at 5% p.a

A 20-year bond with a face value of $1,000 will mature in 8 years. The bond pays semi-annual coupons at 5% p.a. compounding half-yearly. Mia wants to purchase the bond at a price which gives her a yield to maturity of 6% p.a. compounding half-yearly. Calculate the maximum price Mia should pay for the bond. (Round your answer to the nearest cent).

P&P Corporation has issued 10,000 units of face value bonds that mature in 8 years and...

P&P Corporation has issued 10,000 units of face value bonds that mature in 8 years and pay a coupon rate of 6% paid annually. Calculate the yield if each bond unit is selling at $980.

XiaoKe, Corp. issued a bond, which will mature in 13 years. with a coupon rate of...

XiaoKe, Corp. issued a bond, which will mature in 13 years. with a coupon rate of 14 percent, paying interest semiannually. The bond's par value is $1,000. And, according to this company's risk, investors require a rate of return of 13 percent. Answer the following questions. a. If the interest is paid semiannually, the value of the bond is $ b. If the interest is paid annually, the value of the bond is $

26) Realfast Corporation has just issued a bond that matures in ten years and has a...

26) Realfast Corporation has just issued a bond that matures in ten years and has a coupon of 4.00% paid semi-annually and face value of $1,000. The bond sells in the market at a price of $1,075.44. What is the bond's yield to maturity? Multiple Choice 4.000 pecent 2.000 percent 3.116 percent -0.341 percent 1.558 percent

A bond has a $1000 par value and issued 5 years ago. The bond has 10...

A bond has a $1000 par value and issued 5 years ago. The bond has 10 years to maturity and an annual 8% annual coupon and sells for $990. i) Estimate the bond's current yield ii) Estimate the bond's yield-to-maturity iii) Explain the relationship of the bond price and its yield (Please explain the answer in detail, thank you)

Ryan company issues a $100,000 on 8/31/17, 10%, bond that mature in 5 years. Intrest paid...

Ryan company issues a $100,000 on 8/31/17, 10%, bond that mature in 5 years. Intrest paid on August 31 of each year. How much would you pay to yield: 8% 10% 14%

Bond A and bond B both pay annual coupons, mature in 8 years, have a face...

Bond A and bond B both pay annual coupons, mature in 8 years, have a face value of $1000, pay their next coupon in 12 months, and have the same yield-to-maturity. Bond A has a coupon rate of 6.5 percent and is priced at $1,056.78. Bond B has a coupon rate of 7.4 percent. What is the price of bond B? a. $1,113.56 (plus or minus $4) b. $1,001.91 (plus or minus $4) c. $1,056.78 (plus or minus $4) d....

Bond A and bond B both pay annual coupons, mature in 8 years, have a face...

Bond A and bond B both pay annual coupons, mature in 8 years, have a face value of $1000, pay their next coupon in 12 months, and have the same yield-to-maturity. Bond A has a coupon rate of 6.5 percent and is priced at $1,050.27. Bond B has a coupon rate of 7.4 percent. What is the price of bond B?

Subjects