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.

Response to the comment: I have no idea that is all I was given. The accrued interest is 1.3661% if that helps to figure it out.

This is all the information I was given.