I need help with this question. Could you please do it in Excel and please show the formula as well on how you did it.

It is April 2,2018, and you are considering purchasing an investment-grade corporate bond that has a \$1,000 face value and matures on June 4, 2022. The bond's stated coupon rate is 5.20 percent, and it pays on a semianual bass (that is, on June 4 and December 4 ). The bond dealer's current ask yield to maturity is 3.40 percent. (Note: Between the last coupon date and today, there ane 118.30/360 doys. Between last coupon date and the next coupon date, there are 180 " 30/360 days.) a. Caiculate the total amount (involce price) you would have to pay for this bond if you purdhsed the issue to settle today. Do not round Intemediate Caloulations. Round your answer to two decimal places. Enter your answer as a positwe value, Express your answer as a percertage of the bond's par value. b. Separate this totat invoice amount into (1) the bond's current "flat" (whthout acorued interest) price and (1) the accrued interest. Do not round intermediate calculations. Round your answers to two decimal places, Express your answers as a percentage of the bond's par value. (1). (ii)