please I need help by using excell function to determine this problem

Problem 3 (10 pts) A 10 year bond with a face value of $250,000, stated interest rate of 4% to yield 5%. Interest payments are paid semiannually with a issuance price of $230,513.55. 1 Prepare a bond amortization schedule using the straight line method 2 Prepare a bond amortization schedule using the effective interest method Please note: For all of the above please label your work. Work will be graded on accuracy and the utilization of excel throughout your work