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

Example of methods of allocating service costs, Example of Methods of Alloc...

Example of Methods of Allocating Service Costs Suppose the following data: User department Unit of Service Provided Costs Prior to Service Dep

Create a balance sheet, Igor and Angela were married in 2005, separated in ...

Igor and Angela were married in 2005, separated in 2011, and divorced recently. At the time of marriage, each had some investments and personal assets. They both worked during the

Compute the operating income for each of the five customers, Handy-Man Serv...

Handy-Man Services is a repair-service company specializing in small household jobs. Each client pays a fixed monthly service fee based on the number of rooms in the house. Records

Compute the break even point, Park & Morgan, a law firm, is considering ope...

Park & Morgan, a law firm, is considering opening a legal clinic for midde- and low income clients. The clinic would bill at a rate if $18 per hour. It would employ law students as

Emu Manufacturing produces two popular toys - Blox and Shape, Blox ($) Sha...

Blox ($) Shapez ($) Direct material per unit 10 23 Direct labour per unit 19 32 Manufacturing overhead per unit 7 10 Selling & Admin. expenses per unit 17 31 T

Prepare a statement of comprehensive income, Good Food Company is a local m...

Good Food Company is a local manufacturer of instant noodles. Established in 2005, their business has been growing steadily. Their products, which are available in 3 flavors, are s

Sanford charge to expense during 2013, In January, 2008, Sanford Corporatio...

In January, 2008, Sanford Corporation purchased a patent for a new product for $1,200,000. The patent was valid for fifteen years but it was estimated to have a useful life of ten

What was the amount of cash collected from customers, Q. What was the amoun...

Q. What was the amount of cash a firm collected from its customers, given the following fact set? The firm's balance sheets at the beginning and end of the year show gross accou

Discuss the various elements of cost, Question 1 Discuss the various eleme...

Question 1 Discuss the various elements of cost Question 2 Explain the various stages involved in the distribution of factory overheads Question 3 Define activity-based

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