The problem must be solved using Excel

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