Instructor's note: Answer the following question using MS-Excel. Make sure you use list all variables necessary and show all work.

ABC Corporation is considering issuing bonds in the near future. The firms investment bank informs management that the markets required rate of return for companies like ABC Corporation is 11.5%. The bonds under consideration will have a face value of $1,000, coupon rate of 10.25% (paid semi-annually), and will mature in 18 years. Based on this information, how much will Lauren receive for each bond?