Question :

Using Excel and the data given below you are to evaluate the price of the bond and create and amortization schedule. Hint: Your Excel spreadsheet could work whether your bond results in a discount or premium.

Once you have completed this assignment ensure your first name and last name are reflected in the first cell of your worksheet.

On 1^st January, 2012, Esra Corporation sold 4 percent bonds having a maturity value of $300,000. The market evaluated that 5% was the appropriate rate of interest, provided the risks that Esra Corporation to bondholders. The bonds are dated 1^st January, 2012, mature 1^st January, 2015, and pay interest on June 30 and December 31 of each year.