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

Determining working capital requirements, Understanding the existing capita...

Understanding the existing capital requirements and how these are financed will assist us in understanding the process of financing of business and the flow of funds inside the bus

Material sampling - analyszing direct materials cost, A. Material Sampling ...

A. Material Sampling -Analyzing Direct Material Costs You are reviewing a cost proposal, which includes an $800,200 direct material estimate. After Initial examination of the pro

Determine the total compensation cost, On January 1, 2013, VKI Corporation ...

On January 1, 2013, VKI Corporation awarded 12 million of its $1 par common shares to key personnel, subject to forfeiture if employment is terminated within three years. On the gr

What is the steady-state value of capital labor ratio, 1. A country has the...

1. A country has the per-worker production function  y t = 6 k t 0.5   where y t is output per worker and k t is the capital-labor ratio. The depreciation rate is 0.1 and t

Determine the allocation of dividends, Sleep Corporation was organized on J...

Sleep Corporation was organized on January 1, 2011. During its first year, the corporation issued 40,000 shares of $5 par value preferred stock and 400,000 shares of $1 par value c

Job costing, XYZ Company is a family-owned bicycle manufacturing company lo...

XYZ Company is a family-owned bicycle manufacturing company located in Stow, Ohio. Until recently,it had maintained slow but steady growth in producing and marketing its only prod

Calculate the total net realizable value, Surplus Stores Ltd is a company w...

Surplus Stores Ltd is a company which frequently buy goods in large quantities and makes alterations to the goods before selling. At 31 Dec 2000 the following items were included i

Compute the total amount of current assets, Balance Sheet Classi?cations an...

Balance Sheet Classi?cations and Relationships: Shelley and Co. has the following balance sheet elements as of December 31, 2012. Land. . . . . . . . . . . . . . . . . . . . . .

Balance sheet and assuming monthly amortization of patents, Nieland Industr...

Nieland Industries had one patent recorded on its books as of January 1, 2014. This patent had a book value of $288,000 and a remaining useful life of 8 years. During 2014, Nieland

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