question archive A 4-year bond pays an annual coupon of 10
A 4-year bond pays an annual coupon of 10
Subject:FinancePrice: Bought3
A 4-year bond pays an annual coupon of 10.5% based on a $1,000 par value and is selling to yield 7.5%. Use the excel duration function to determine the point in time when the bond's payment stream equals one-half the present value of cash flows.
a) Write the duration excel function entered.
b) Write the inputs into the duration excel function.
c) Duration =
