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

Changes in variable cost and selling price per unit, Changes in Variable Co...

Changes in Variable Cost and Selling Price per Unit The contribution sales ratio is affected by any change in variable cost or selling price per unit. This ratio is a mea

Determine the cost, Sanderson Company has the following production data for...

Sanderson Company has the following production data for March: no beginning work in process, units started and completed 28,030, and ending work in process 3,890 units that are 100

LIFO, I need an example for Lilo,Fifo, and weighted average method for a ye...

I need an example for Lilo,Fifo, and weighted average method for a year. Jan.begining inventory, purchases in Feb., April, July, October, and November. Can you help me with this?

Material costs - cost accumulation, Material Costs - Cost Accumulation ...

Material Costs - Cost Accumulation However 'Materials' refer to the tangible inputs into the procedure of producing useful output.  They might be indirect materials or direct

four decisions for which abc information is useful, What are the key reaso...

What are the key reasons for product cost differences among traditional costing system and ABC systems? Explain four decisions for which ABC information is useful?

Cost-plus pricing, Computation of mark up and Target selling price in cost-...

Computation of mark up and Target selling price in cost-minus pricin

Allocation of joint costs, Allocation of Joint Costs Whereas two or mo...

Allocation of Joint Costs Whereas two or more products of relatively high value emerge simultaneously from a single process, they are named as joint products.  The processes s

EXPECTED CASH COLLECTIONS, WORKED EXAMPLES OF EXPECTED CASH COLLECTIONS PAT...

WORKED EXAMPLES OF EXPECTED CASH COLLECTIONS PATTERNS

Determine the net book value, NSC Ltd. has a 31 May fiscal year-end. NSC di...

NSC Ltd. has a 31 May fiscal year-end. NSC disposed of its Information Systems Group (ISG) on 31 January 20X3. ISG had a net loss (after taxes) of $37,700,000 in 20X3, to the date

Gains and losses on disposal, When assets are replaced during the anticipat...

When assets are replaced during the anticipated life of the project, or at the end of the anticipated life of the project, they are sold at their pre-determined scrap values. Incom

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