Use excel and the data provided below to calculate the

Reference no: EM13588662

Use Excel and the data provided below to calculate the price of the bond and create an amortization schedule (similar to the format reflected in the pdf file posted on blackboard). You should prepare an amortization schedule that is better than the example I provide in the pdf file, e.g., incorporate as many formulas as necessary, so that the worksheet automatically updates when the market rate of interest is changed.

Your Excel spreadsheet should work whether your bond results in a discount or premium. I should be able to manipulate certain data, for example if I change the present value rates or market rate of interest rate, the formulas should still work correctly when determining the present value of the bond. The file should be formatted properly; with proper print ranges.

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.

Reference no: EM13588662

Questions Cloud

Would you recommend the acceptance of this proposal why or : clark paints the production department has been investigating possible ways to trim total production costs. one

Corio corporation reports that at an activity level of 3600 : corio corporation reports that at an activity level of 3600 units its total variable cost is 198900 and its total fixed

With the glasses the person can see an object clearly that : question a nearsighted person wears glasses to correct the problem. the lenses in the glasses have a focal length of

Also consider the following as it relates to all three : select a virtual organization using the student website. assume your organization is privately held wants to expand

Use excel and the data provided below to calculate the : use excel and the data provided below to calculate the price of the bond and create an amortization schedule similar to

Describe the main issues in climate change and discuss how : essay on a set topicnbsp - choose one of the below questions as your topic. indicate which one you have

The new building qualifies for interest capitalization the : laserwords inc. is a book distributor that had been operating is its original facility since 1985. the increase in

A capacitor with an initial potential difference of 144 v : question a capacitor with an initial potential difference of 144 v is discharged through a resistor when a switch

An object with a 50 muc charge is acclerating at a 000050 : an object with a 5.0 muc charge is acclerating at a 0.00050 ms due to an electrc filed. if the object has a mass of

User Account

All Pages