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

Literature review - effectiveness auditing, EFFECTIVENESS AUDITING is one t...

EFFECTIVENESS AUDITING is one type of internal audit. Describe and evaluate this type of internal audit. What types of organisation would it be most useful for? Required: 1)

Applications of marginal costing, what is the importance and assumptions of...

what is the importance and assumptions of application of marginal costing

Closing stock, The value of un-sold stock. The stock is valued at cost or m...

The value of un-sold stock. The stock is valued at cost or market price either is lower. Usually, the closing stock is not specified in the trial balance but is specified in adjust

Trypanosoma, Place a prepared slide of Trypunosoma under tlic microscope an...

Place a prepared slide of Trypunosoma under tlic microscope and focus it under low power, You will observe large number of tiny spindle-shaped trypanosomes lying in the plasma alll

Determine the interest expense is deductible, Assume the same facts as in 1...

Assume the same facts as in 1A above, except that the interest payment checks were placed on the shareholders' office on December 31, 2012. However, the shareholders are not in the

Calculate the total profit for the leisure center, A local government autho...

A local government authority owns and operates a leisure centre with numerous sporting facilities, residential accommodation, a cafeteria and a sports shop. The summer season lasts

Use account analysis to determine fixed cost, Reef Office Supplies is inter...

Reef Office Supplies is interested in estimating the cost involved in hiring new employees. The following information is available regarding the costs of operating the Human Resour

Cash budget - budgetary planning and control, Cash Budget - Budgetary Plann...

Cash Budget - Budgetary Planning and Control This can records the cash outflows and inflows that are expected to take place in respect of every functional budget. This may be

Calculate the net effective yield, A Government issued a number of index-li...

A Government issued a number of index-linked bonds on 1 June 2000 which were redeemed on 1 June 2002.  Each bond had a nominal coupon rate of 3% per annum, payable half yearly in a

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