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

Types of variances, TYPES OF VARIANCES Variances are computed for the e...

TYPES OF VARIANCES Variances are computed for the entire three basic elements of cost - direct labour, direct material, and overhead variance 1. Direct labour variance 2.

Purposes of overhead cost analysis, Purposes of Overhead Cost Analysis ...

Purposes of Overhead Cost Analysis There are a number of situations whether the analysis of overhead costs will assist in the satisfactory evaluation of the relevant cost data

What is the original cost of the auto?, I'm having a hard time with this, c...

I'm having a hard time with this, can you please help? I know the dates are imparative also in finding the solution. Stevens purchased an auto on Jan 1, 2001. On December 31, 2003

Giardia, Place a prepared slide of Giardia first under tlie low power and t...

Place a prepared slide of Giardia first under tlie low power and then under the high power of the microscope and observe tlie followilig characters. i) Bilaterally symmetrical

Finance and logistics, responsibility of director of finance and logistics

responsibility of director of finance and logistics

Financial accounting, Financial Accounting It is the analysis, and rec...

Financial Accounting It is the analysis, and recording and classification of financial transactions and the ascertainment of how that information will be reported to the diffe

Cost sheet, what is a cost sheet? what are its advantages?

what is a cost sheet? what are its advantages?

Explain stock valuation, G. Mills was appointed a local agent for the High ...

G. Mills was appointed a local agent for the High Power Mobile Workshop Bolt (HPMW-B) on 1 April 2009. The HPMW-B is manufactured by Mobile Equipment Ltd (MEL). The company charges

Material usage variance (muv), Material Usage Variance (MUV): This is t...

Material Usage Variance (MUV): This is the variation between the actual quantity of material consumed and standard quantity which should have been consumed, expressed in terms

Semi fixed costs, Semi Fixed Costs Are costs along with both a variabl...

Semi Fixed Costs Are costs along with both a variable and fixed cost component? The fixed component is such portion that is constant irrespective of the level of activity. The

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