please solve this in excel and explain with formulas given

The following information relates to Questions A-C Bond , described in the exhibit below, is sold for settlement on 22 March 20X7 Annual Coupon 5% Face Value Coupon Payment Frequency Interest Payment Dates $1,000 Semi-annual 10 January and 10 July 10 January 20x7 Issue Date 10 July 20X8 Maturity Date Day-Count Convention Annual Yield-to-Maturity 30/360 4% AjThe full price that Bond G will settle at on 22 March 20x7 is: Assuming that number of days elapsed since issue date is 72 days. Group of answer choices 1,034,421 1,044.420 1,014,419 1,022.487 B) The accrued interest per 1000 of face value for Bond G on the settlement date of 22 March 20x7 is: Group of answer choices 20.00 25.00 10.00 8.00 The dean price for Bond G on the settlement date of 22 March 20X7 is : Group of answer choices 1,012.487 1.000.00 1,034 708 1.022.487