use Excel please and show all the fomrulas used

2 4 P17-2 (Debt Investments, Fair Value Option) On January 1, 2015, Novotna Company purchased 400,00 8% bonds of Aguirre Co. for 369,114. The bonds were purchased to yield 10% interest. Interest is payab semiannually on July 1 and January 1. The bonds mature on January 1, 2020. Novotna Company plans hold the bonds to collect contractual cash flows. On January 1, 2017, after receiving interest, Novoti Company sold the bonds for 370,726 after receiving interest to meet its liquidity needs. Instructions (a) Prepare the journal entry to record the purchase of bonds on January 1. (b) Prepare the amortization schedule for the bonds. (c) Prepare the journal entries to record the semiannual interest on July 1, 2015, and December 31, 201 (d) Prepare the journal entry to record the sale of the bonds on January 1, 2017. (e) Assume that Novotna elected the fair value option for this investment. If the fair value of Aguir bonds is 368,000 on December 31, 2015, prepare the necessary adjusting entry