Step II: Complete Table Column A Period Yearly Payment Column B Interest Portion Column C Principal Portion Column D Outstanding Principal Balance lo 1 12 3 What is duel At Maturity? 10. a) What is the yield on a bond that sold for $782.50 (at time zero), that has a 10-year term, a 5.5% coupon rate with semi-annual payments, and a $1000 par value? (Students, this is a RATE problem, you are solving for RATE) PV = Rate = NPER PMT = FV= 11. a) What is the yield on a bond that sold for $1102.50 (at time zero), that has a 10-year term, a 6.0% coupon rate with semi-annual payments, and a $1000 par value? (Students, this is a RATE problem, you are solving for RATE) PV = Rate = NPER PMT = FV =