I need help solving in excel

4) A coupon bond pays this amount every 6 months; $ 30.00 for the number of payments/year; 2 The bond also pays at maturity the par (face) value; $ 1,000.00 Number of years until maturity 15 The required return of holders of this bond is; 8.00% What is the PV of the CFs, or what would be the fair price to purchase this bond? a) b) If the required return of holders of this bond is; 6.00% What is the PV of the CFs, or what would be the fair price to purchase this bond? c) If the required return of holders of this bond is; 4.00% What is the PV of the CFs, or what would be the fair price to to purchase this bond? d) If the previous bond sells for; $ (976.00) What must be the yield to maturity for this bond (aka IRR) ? (to nearest b.p.)