Which bond(s) has a 10% yield with an semiannual coupon payment of 8%. Either a $1000 face value bond with 5 year maturity selling for $964.54 or a $1000 face value bond with 20 year maturity selling for $828.36 or a $1000 face value bond with 10 year maturity selling for $875.39.
Show me the steps to solve this problem.
Thank you.© BrainMass Inc. brainmass.com March 4, 2021, 8:20 pm ad1c9bdddf
The easiest way to figure out this problem is to use the built-in functions in excel. Under the ...
Excel spreadsheet attached shows how to calculate a bond's value given yield, coupon payment, maturity, etc.