Please show how to solve in excel if possible! Thanks

1A. What is the present value of the following annual cash flows using a discount rate of 8% compounded annually? Assume the $35,000 annual cash flows continue into infinity. (5 points) 1B. Billy Company's bonds currently sell for $985 and offer a coupon rate of 6% paid semi-annually. If the remaining time to maturity on the bonds is 28 years, what is their yield to maturity? (5 points) r= 8% 0 2 3 4 5 6 1 13,000 88 13,000 13,000 22,000 35,000 35,000