Using Excel and the data provided below you are to calculate the price of the bond and create and amortization schedule (similar to the format reflected in the pdf file posted on blackboard). Hint:

Using Excel and the data provided below you are to calculate the price of the bond and create and amortization schedule (similar to the format reflected in the pdf file posted on blackboard). Hint: Your Excel spreadsheet should work whether your bond results in a discount or premium.

Once you have completed this assignment make sure your first name and last name are reflected in the first cell of your worksheet. Save your file with your last name and first name and upload it under Assignments on blackboard by the due date reflected on blackboard.

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

Leave a Comment