Please show how to solveformulas in excel thank you so much

Please show how to solve/formulas in excel, thank you so much!!!

× fx 8.23 Accrued Interest You purchase a bond with a coupon rate of 5.9 percent and a clean price of $984. If the next 8.23 Accrued Interest You purchase a bond with a coupon rate of 5.9 percent and a clean price of $984. If the next semiannual coupon 1 payment is due in four months, what is the invoice price? 3 Face Value Clean Price Coupon Rate Coupon Period 7 Months Left Accrued Interest Invoice Price 0

Solution

Accrued interest = (1000*5.9%/2)*(2/6) = $9.83

Invoice price = Accrued interest + Clean price

= $9.83 + $984

= $993.83