You purchase a bond with an invoice price of $1,169. The bond has a coupon rate of 4 percent, it makes semiannual payments, and there are 1 months to the next coupon payment. The par value is $1,000.

What is the accrued interest on this bond?

Please demonstrate steps for both excel and a BA II Plus

Thank you!