Working from the top down, enter data needed from the text question. Calculate a solution for each cell back-lighted in yellow. Build your formulas in calculation cells by referencing cells above that in turn reference numbers directly from the text problem.

fx =E7/2 A B D F G H K L 1 d Understanding the effect of semi-annual coupon payments. 2 3 What is the yield to maturity for a bond with a coupon rate o 4.3% semi-annual coupon payments, a current price of $ 975.00, with 3 years to maturity? 4 5 6 7 8 9 Current price= $975.00 Annual coupon rate= 4.3% Semi-annual coupon rate= 2.2% Annual coupons Semi-annual coupon- Annual term to maturity- 3 years Semi-annual term to maturity= half years Period Cash Flows 0 1 2 3 10 11 12 13 4 5 6 14 Yield to maturity (YTM)= 15