*Please solve using Microsoft excel with the code used.

***Answer should equal $1985***

Thank you!

Bonds 5-92 A corporate bond has a face value of $1000 with maturity date 20 years from today. The bond pays interest semiannually at a rate of 4% nominal per year based on the face value. The interest rate paid on similar corporate bonds has decreased to a cur- rent rate of 2%. Determine the market value of the bond