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

Calculate contribution to sales ratio, Q. Calculate contribution to sales r...

Q. Calculate contribution to sales ratio? Contribution per unit= sales price per unit less variable cost per unit Break-even volume = Fixed overhead/Contribution per uni

Calculate the gross profit percentage, At the end of Ehlinger Department St...

At the end of Ehlinger Department Store's fiscal year on December 31, 2012, these accounts appeared in its adjusted trial balance: Freight-In $ 7,200

What is operating income under absorption costing, Loring Company had the f...

Loring Company had the following data for the month: Variable costs per unit: Direct Materials $4 Direct Labor 3.20 Variable Overhead 1 Variable selling expense 0.40 Fixed Ov

Batch costing, Batch Costing This is a kind of job costing that is uti...

Batch Costing This is a kind of job costing that is utilized when production consists of limited repetitive work and definite number of item manufactured in one batch.  A batc

Single limiting factor, Single Limiting Factor Where a single limiting...

Single Limiting Factor Where a single limiting factor exists for the decision making sequence may be implemented given as:- - Compute the contribution per unit of limiting

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

what is a cost sheet? what are its advantages?

Process costing, what is accounting treatment for material losses due to ab...

what is accounting treatment for material losses due to abnormal reasons

calculate raw materials inventory value , Tony Allan Inc is a small manufa...

Tony Allan Inc is a small manufacturer of metal products in Toronto.  The company rents its factory building.  It uses a job order costing system because it has a wide variety of p

Material, annual usage rs 160000@ 40 per unit, cost of placing and receivin...

annual usage rs 160000@ 40 per unit, cost of placing and receiving one order rs 200:annual carrying cost ; 25% of inventory value

West Industries, West Industries is a highly decentralized corporation with...

West Industries is a highly decentralized corporation with independent operating divisions. Each division is evaluated and rewarded based on its total net income. One of the divisi

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