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

What is the predetermined overhead rate, Morrow Company applies overhead ba...

Morrow Company applies overhead based on direct labor hours. At the beginning of the year, Morrow estimates overhead to be $620,000, machine hours to be 180,000, and direct labor h

Cost estimation methods, using the high low method how do i calculate the c...

using the high low method how do i calculate the costs that are expected when the output expected is out of the range given for example cost prdctn volume 110000

What is the overhead variance, Morrow Company applies overhead based on dir...

Morrow Company applies overhead based on direct labor hours. At the beginning of the year, Morrow estimates overhead to be $620,000, machine hours to be 180,000, and direct labor h

What are the dimensions of the box with the minimum cost, A manufacturing c...

A manufacturing company wants to package its product in a rectangular box with a square base and a volume of 32 cubic inches. The cost of the material used for the top is $.05 squa

Manufacturing, What are the reasons of preparing income statement?

What are the reasons of preparing income statement?

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

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 opportunity costs, Determine Opportunity Costs A company has...

Determine Opportunity Costs A company has material B in stock that originally cost Shs. 5000 for the 1000 Kshs in stores. The material is missing over from an old purchase ord

prepare a simple balance sheet, Assume that Banc One receives a primary de...

Assume that Banc One receives a primary deposit of $1 million. The bank must keep reserves of 20 percent against its deposits. Prepare a simple balance sheet of assets and liabilit

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