Evaluate the price of the bond

Assignment Help Financial Accounting

Reference no: EM133979

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.

Reference no: EM133979

Questions Cloud

Calculate the rates of solar heating : Calculate the rates of solar heating

Evaluate the per unit conversion for the period : Evaluate the unit material cost for the period? Evaluate the unit conversion for the period?

Financial statements for the year : The Financial Statements (unaudited) for the year ended 30 th June 2010 that you have been given indicate the subsequent (previous year figures are in brackets)

Critically define the concept of carrying capacity : It is important to conceptualize carrying capacity, because the ability to express this in terms of an ambiguous standard measure is essential in order to facilitate tourism planning (Saveriades, 2000) Critically define the concept of carrying c..

Evaluate the price of the bond : Using Excel and the data given below you are to evaluate the price of the bond and create and amortization schedule.

Discuss the impacts of seasonality on destinations : Discuss the impacts of seasonality on destinations and the different policies and tools which destination managers can use to manage seasonality problems in tourism

What is the amount of interest : What is the amount of interest that Crocus could capitalize in 2013, using the particular interest method

Outdoor recreation in the lives of adolescents : Discuss the importance of outdoor recreation in the lives of Adolescents or Senior Citizens b) Explain how you would attempt overcome barriers to participation in outdoor recreation for Adolescents or Senior Citizens

How numerous forces act on the brick : How numerous forces act on the brick

User Account

All Pages