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

Applications of funds, Requirement for additional Funds A business would...

Requirement for additional Funds A business would require additional capital for two purposes: 1. Financing additional fixed assets, and

Compute the estimated value of inventory stolen at kji, The following are t...

The following are three independent situations where the reporting entity for which financial statements are being prepared are underlined. Every company has a December 31, 2012 ye

Cost accounting data and principles, Questions What are your recommenda...

Questions What are your recommendations to Ted Lapres? What aspects should he keep, what should he change, and in what sequence should he make the changes? • Do you think the D

Direct cost as a relevant cost, Direct Cost as a Relevant Cost Direct ...

Direct Cost as a Relevant Cost Direct costs may be directly chargeable to a cost center or a product. They may be fixed costs or variable costs whereas it comes to decision-ma

Product mix, Kaplan Computers manufactures high end computer systems for th...

Kaplan Computers manufactures high end computer systems for the graphics design industry. At the present time, the company makes three computers with the following characteristics

Material price variance (mpv), Material Price Variance (MPV) This may b...

Material Price Variance (MPV) This may be described as the difference amoung the actual price and the standard price of the materials consumed. MPV = Actual quantity used (S

Determining working capital requirements, Understanding the existing capita...

Understanding the existing capital requirements and how these are financed will assist us in understanding the process of financing of business and the flow of funds inside the bus

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

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