Given the yield to maturity; Calculate the price of the bond using PV function in Excel Problem 2: (See Problem 1_Demonstration) Bond Valuation Time to Maturity (Years) Coupon Rate Price Frequency Face Value 15 6.50% $897.25 2 (Semi-Annual) $1,000 Given the price; Calculate the yield to maturity (YTM) for the bond in Excel Use RATE function /See PROBLEM 3: Problem 2 Demonstration 2) 02/15/2 Settlement Date 0 02/15/3 Maturity Date 0 Coupon Rate 6.00% Required Return (YTM) 7.00% Face Value 1000 Semi-Annual Interest Frequency 2 Payment Basis 0 Given the yield to Maturity; calculate the price of the bond using 'PRICE' function in Excel Problem 4: (See Problem 2 Demonstration 2) 02/15/2 Settlement Date 0 02/15/3 Maturity Date 0 Coupon Rate 6.00% Price of the bond $900.00 Face Value 1000 Semi-Annual Interest Frequency 2 Payment Basis 0 Given the price of the bond calculate the Yield to maturity using 'YIELD' function in Excel