Build a spreadsheet in excel to calculate the Bond Price and Yield to Maturity for bonds that
Fantastic news! We've Found the answer you've been seeking!
Question:
Build a spreadsheet in excel to calculate the Bond Price and Yield to Maturity for bonds that both pay coupons annually and semi-annually. Use the following information to test your model.
1. Calculate the price of a 10 year, $1000 par value bond, yielding 6% that pays a 7% coupon semi-annually.
2. Calculate the annual yield to maturity for a 10 year, $1000 par value bond currently valued at $900, that pays a 7% annual coupon semi-annually.
Related Book For
Financial Accounting
ISBN: 978-0134725987
12th edition
Authors: C. William Thomas, Wendy M. Tietz, Walter T. Harrison Jr.
Posted Date: