Please shows in excel formulate , thank you

Attempt 11 of 1 Go Testbank Multiple Choice Question 60 x Your answer is incorrect. On January 1, 2020, Sheffield Corp. issued eight-year bonds with a face value of $6010000 and a stated interest rate of 8%, payable semiannually on June 30 and December 31. The bonds were sold to yield 10%. Table values are: 0.540 0.467 0.534 0.458 Present value of 1 for 8 periods at 8% Present value of 1 for 8 periods at 10% Present value of 1 for 16 periods at 4% Present value of 1 for 16 periods at 5% Present value of annuity for 8 periods at 8% Present value of annuity for 8 periods at 10% Present value of annuity for 16 periods at 4% Present value of annuity for 16 periods at 5% 5.747 5.335 11.652 10.838 The present value of the principal is $3245400. $2806670. $3209340. $2752580. SHOW SOLUTION SHOW ANSWER LINK TO TEXT SCORE Maximum Point Potential: 5.7 Dointe Cornod