Part B)What will be the bonds price if rates in the market (i) decrease to 8.60 percent or (ii) increase to 11.6 percent?

Problem 8.29 a-d (Part Level Submission) (Excel Video) The Cullumber Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a rate of 9.575 percent. The current market rate for similar securities is 10.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.) (a) Your answer is correct. What is the current market value of one of these bonds? (Round answer to 2 decimal places, e.g. 15.25.) Current market value 10.61 Click if you would like to Show Work for this question: Open Show Work LINK TO TEXT LINK TO TEXT LINK TO TEXT VIDEO: SIMILAR PROBLEM EXCEL SOLUTION