Please solve in EXCEL SHOWING ALL WORK/FORMULAS. I will upvote! I really need help. Thank you for your help!

1-

What is the market value, on 2/15/2070, for a $100,000 par bond with a 10% quarterly coupon that matures on 2/15/2022? Assuming the required rate of return is 17%.

		55,098.22
		58,837.46
		82,90.35
		100,000.00
		10,082.00

2-

The current market price for a bond that has a par value of $20,000 and matures in 20 years with a coupon rate is 10% paid semiannually and a required rate of return of 12% is:

		16,767.71
		25,870.25
		17.750.88
		16,990.74
		21.200.11

Please remember to do in EXCEL. thank you once again!