C D E F G H K 70 71 72 Find the YTM of the bond below (1) using goal seek and (2) using the RATE function. Clearly identify the cells you use in the Goal Seek by writing the cell reference (in text) in the Green Section. 73 74 Years to maturity 6 Year CF PV of CF 75 Coupon rate 12% 1 76 Payments per year 1 77 Par value $1,000 W 78 Price $980.00 79 Rate (guess) 80 6 81 Sum of PV 82 83 84 Goal Seek: 85 Set Cell For example, B7 86 To Value For Example, $1,022 87 By changing For example, C33 88 89 Excel RATE function: 90