Compute the internal rate of return, Cost Accounting

Assignment Help:

ABC bond is a 20-year bond with face value $1000. The coupon payment is $25 per 6 months. The semi-annual yield is 4%. Use the PV function in Excel (or equivalent) to Önd the price of the bond. Note that the entry FV in the Excel PV function is the maturity, or face value of the bond.

b. Use the inputs as in the first part, but let semi-annual yields range from 1% to 6%. Plot the prices of the bonds.

c. Compute the internal rate of return (IRR) on a 20-year bond with face value $1000, coupon payments of $25 per six months and a current price of $975. Use the IRR function in Excel (or equivalent).

d. Compute the duration of the bond in part a).


Related Discussions:- Compute the internal rate of return

Labour Costs and Overhead Costs, Labour Costs and Overhead costs Labo...

Labour Costs and Overhead costs Labour Costs Labour costs can be indirect or direct labour costs. Direct labour cost refers to wages paid to workers who such are directly

Attainable standards and current standards, Attainable Standards and Curren...

Attainable Standards and Current Standards Although the standard must be set high sufficient that achievable and it has to be worked for. Attainable standards must provide a c

Traditional Costing System and Job Order Costing System, Hello, I''m curren...

Hello, I''m currently doing a research on a company and planning an Activity Based Costing system since the company is using Traditional Costing system to allocate the overhead to

Break even point, Campground Inc. is considering the production and sale of...

Campground Inc. is considering the production and sale of propane lamps. Annual fixed costs associated with the project are expected to total $60,000. In addition, each lamp would

role in negotiated transfer prices, Price and Cost   information  play...

Price and Cost   information  play  no  role  in  negotiated  transfer  prices.  Do  you  agree? Describe.

Statement of changes in working capital, A statement of changes in working ...

A statement of changes in working capital assists us in locating where such changes took place. In the first example we try to demonstrate the increase or decrease in particular it

The average cost of production, Distinguish between,     (i)  short-run ...

Distinguish between,     (i)  short-run variable costs & long-run variable costs, and give an example of each one;   (ii)  the marginal cost &  the average cost of production

Cost-plus pricing, Computation of mark up and Target selling price in cost-...

Computation of mark up and Target selling price in cost-minus pricin

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd