The Wildhorse Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a rate of 10.375 percent. The current market rate for similar securities is 10.50 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.) Problem 8.29 a-d (Excel Video)(a) What is the current market value of one of these bonds? (Round answer to 2 decimal places, e.g. 15.25.) Current market value $

The Wildhorse Department of Transportation has issued 25 -year bonds that make semiannual coupon payments at a rate of 10,375 percent. The current market mate for similar securities is 10.50 percent. Assume that the face value of the bond is $1000. 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.) Problem 8.29 a-d (Excel Video)(a) What is the current market value of one of these bonds? (Round answer to 2 decimal places, es. 15.25) Current market value s