Please need help to calculate attached 2 questions in excel formula Thanks A coupon bond pays this amount every 6 months;for the number of payments/year;4)2$30.002$The bond also pays at maturity the par (face) value;Number of years until maturity1,000.0015The required return of holders of this bond is;8.00%a)What is the PV of the CFs, or what would be the fair price to purchase this bond?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 purchas to purchase this bond?$(976.00)d)What must bethe yield to maturity for this bond (aka IRR) ? (to nearest b.p.)If the previous bond sells for;

Please find the excel formula and answers below. As, the required return decreases, price of the…

A coupon bond pays this amount every 6 months; for the number of payments/year; 30.00 2 The bond also pays at maturity the par (face) value; Number of years until maturity The required return of holders of this bond is; 1,000.00 15 8.00% What is the PV of the CFs, or what would be the fair price to purchase this bond? 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? 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 purchas to purchase this bond? Ifthe previous bond sells for; (976.00) What must be the yield to maturity for this bond (aka IRR) ? (to nearest b.p.)