Please solve the following using EXCEL not TYPED. Please show all work/formulas used, thank you in advance! Will upvote!

1-

Consider a 13% annual coupon bond with a par value of $50,000. The last coupon date was 2/15/2020. What is the accrued interest on 1/29/2021?

		8,968.65
		5,800.20
		7,120.65
		6,214.10
		6,198.09

2- Consider a zero coupon bond with 20 years to maturity and a $25,000 face value if the current market price is $15,000. (Use semiannual compounding in your calculations).

The yield to maturity is:

		2.57%
		2.45%
		3.25%
		0%
		4.00%

Please remember to use EXCEL, thank you once again!