a) Consider a corporate bond maturing on April 14, 2025 with a coupon rate of 5% and yield of 6%. What is the clean price of the bond on July 23, 2018?

b) Consider a corporate bond maturing on April 14, 2025 with a coupon rate of 5% and yield of 6%. What is the dirty price of the bond on July 23, 2018?

I know the answer to A is 945.22 and the answer to D is 958.88 but I need to know how to solve them in Excel. For A especially, I'd like to know how to find out the accrued interest which is 1.3661%. This is all the information I was given and I was able to solve part A in Excel but I didn't know how to solve for accrued interest to do part B.

This is the complete question.