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 1st 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 1st January, 2012, mature 1st January, 2015, and pay interest on June 30 and December 31 of each year.