Pleaseeee do in excel :)

On January 1. 2015. Smith Company issued $700,000 of 8 percent bonds to yield 6 percent. the net present value of the bonds on the date of sale was $804.160. Interest is payable semiannually on July 1 and December 31 the bonds mature in ten years. Smith Company's year ends on December 31. Create an amortization table using the straight-line method for the first four periods. Create an amortization table using the effective interest method for the first four periods. Prepare the journal entries to record bond-related transactions as of the following dates: January 1. 2015 to issue the bonds July 1. 2015 to record the first interest payment using effective interest method. December 31. 2015 to record the second interest payment using effective interest method. Record the journal entry to pay the bond off at maturity. Using the present value tables in your textbook what is the present value of a 15-year. $100,000. 8%. bond that is issued at a 12% effective rate Interest payments are made annually