On December 31, 2015, Martin Corp invested in Marlins 5-year, $200,000 bond with a 5% interest rate for $191,575. The bond pays semiannual interest on June 30^th and December 31^st. The fair values of the bonds at the end of 2016~2018 are $194,500, $194,200, and $195,750. Martin sold its investment in Marlins bond on July 1, 2019 at 98 (i.e. selling price is = 98.5% of the face value). Please answer all following questions using Excel Template.

Prepare an amortization schedule related to the bond investment in Marlin. How does Martins investment classification (as HTM, AFS, or Trading) influence this amortization schedule? Please show formulas when needed.