What is the current market value of one of these bonds?

The Sandhill Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a rate of 10.325 percent. The current market rate for similar securities is 11.6 percent. Assume that the face value of the bond is $1,000. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre- entered in the template based on the textbook version of the problem.)