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 the rate of learning of initial production phase, Calculate the r...

Calculate the rate of learning at which the initial production phase profit target would be achieved, assuming no other cost savings can be made.   Assuming no other cost savi

Reserves and surplus, Reserves and surplus or retained earnings usually occ...

Reserves and surplus or retained earnings usually occur out of profitable operations. This is a surplus not distributed through the firm as dividends. Conversely, these are profits

Prepare a cash flow forecast, 1.  Prepare a cash flow forecast for the prop...

1.  Prepare a cash flow forecast for the proposal to launch SafeCus in 2010 for a three-year period from 1 January 2010 using the data in the body of the Case Study and discount at

Find the discount rate and wacc, 1. A company is considering a project that...

1. A company is considering a project that requires an initial investment of $100 million and will pay $20 million of each of the next 10 years, and nothing thereafter. The company

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

The fixed overhead price variance, DEF Municipality uses a standard absorpt...

DEF Municipality uses a standard absorption costing system to control the cost of one of its services, namely the supply of water to its constituents. The fixed budget for the reti

Manufacturing, What are the reasons of preparing income statement?

What are the reasons of preparing income statement?

Answer, Chen Enterprises purchased 67,000 pounds (cost = $616,400) of direc...

Chen Enterprises purchased 67,000 pounds (cost = $616,400) of direct material to be used in the manufacture of the company''s only product.

What is the net operating income, A manufacturing company that produces a s...

A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: selling price $140 units in begining in

Taxable transfers, Greta Grantor made $1 million of taxable gifts in 2009, ...

Greta Grantor made $1 million of taxable gifts in 2009, the only taxable gifts she made prior to this year.  Greta was married on January 2nd of this year to Gerard Gold digger. De

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