In: Finance
December 31, 2015, Martin Corp invested in Marlin’s 5-year, $200,000 bond with a 5% interest rate for $191,575. The bond pays semiannual interest on June 30th and December 31st. 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 Marlin’s 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.
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -