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

Presentation & Essay, Why are the main contribution teams can make to an or...

Why are the main contribution teams can make to an organisation? What are the conditions necessary in organisations if people are to work effectively in teams? * Describe what tea

Evaluate the income statement for the year, DF is describing its consolidat...

DF is describing its consolidated financial declaration for the year ended 31 December 2009. DF has a numerous investments in other entities. Some of these investments are provided

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

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

debt service fund and special revenue fund, For your assignment, discuss w...

For your assignment, discuss when the government and nonprofit organizations would use each of the following funds: Capital projects fund Debt service fund Special r

Calculate the total revenue, Mandy Building Contractors Ltd signed a fixed-...

Mandy Building Contractors Ltd signed a fixed-price contract to build a bridge for Nelly Ltd for $110 million on 1 July 2012.  Contract costs are estimated as follows:

Expenditure for the base period and the current period, 1. The table below ...

1. The table below gives data for Southland where there are three consumption goods: bananas, coconuts and grapes. Goods Quantity in base period basket

Disadvantages of standard costing, Disadvantages of Standard Costing ...

Disadvantages of Standard Costing 1. The system of standard costing is very expensive to install : A lot of money is spent in studying output requirements in terms of materia

Provisions or estimated liabilities, Where the liabilities are identified b...

Where the liabilities are identified but the amounts cannot be precisely found, we estimate the liability and give for it as a liability. A common illustration is income tax payabl

What is callable preferred stock, What is callable preferred stock? Why do ...

What is callable preferred stock? Why do corporations issue such stock? Given the different features that are associated with stock (callable, cumulative, preferred, etc.), what ty

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