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

What are the variable costs, Normal 0 false false false ...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4 Variable costs are those

Calculate the total revenue, Mandy Building Contractors Ltd signed a fixed-...

Mandy Building Contractors Ltd signed a fixed-price contract to build a bridge for Nelly Ltd for $110 million on 1 July 2012.  Contract costs are estimated as follows:

Calculate- total variable cost and average variable cost, The firm currentl...

The firm currently uses 50,000 workers to produce 200,000 units of output per day. The daily wage per worker is $80, and the price of the firm’s output is $25. The cost of other va

What is emv and eol approach, Adele Weiss manages the campus flower shop. ...

Adele Weiss manages the campus flower shop. Flowers must be ordered three days in advance from her supplier in Mexico. Advance sales are so small that Weiss has no way to estimate

Cash Budgeting, Stopover industries ltd, a recently incorporated company pl...

Stopover industries ltd, a recently incorporated company plans to go into production next year. the following standard cost matrix has been assembled for one of the products it pro

Audit plan, 1. You are required to download the latest annual report publis...

1. You are required to download the latest annual report published by one of the following institutions: - Adult Multicultural Education Services - Centre for Adult Education

Accounts payable, Accounts Payable or sundry creditors are generally unsecu...

Accounts Payable or sundry creditors are generally unsecured debts owed through the firm. These are also considered to as payables on open accounts. They may not be evidenced throu

Compute break even assuming direct materials cost, Below find production an...

Below find production and sales information for Herrestad Company. We will use this same company for all the SLPs in this course.  Product information

Relevant costs, What are investment appraisal methods when opening a new pr...

What are investment appraisal methods when opening a new project?

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