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

Prepare cash budget of a company, Prepare Cash Budget of a Company The...

Prepare Cash Budget of a Company The given information concerned to the proposed budget for a company for the months ending on 31 December 1996. Additional Information

Which of the following are relevant in choosing, A company is considering t...

A company is considering the following alternatives: Alternative 1 Alternative 2 Revenues $240,000 240,000 Variable costs 120,000 140,000 Fixed costs 70,000 70,000 Which of the fol

Labour costs, what are the classifications of labour costs? what is employe...

what are the classifications of labour costs? what is employee psyche?

Regression analysis method of cost estimation, Regression Analysis Method o...

Regression Analysis Method of Cost Estimation It includes estimating the cost function by utilizing past data or the dependent and the independent variables. Hence the cost fu

What is the optimal price without price discrimination, We consider two reg...

We consider two regions A and B. Each market has the same size (i.e. number of consumers) but differs in the willingness to pay for one unit of the good proposed by the firm. On ma

cost classification, Explain the value attached to this common exercise un...

Explain the value attached to this common exercise undertaken by Accountants.

Estimating the number of shares with returns less, The file A1Q1 contains d...

The file A1Q1 contains data for the percentage change in the price of 50 shares selected at random from the Australian Stock Exchange. The data refer to the percentage change in th

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

Determine profit by using absorption costing, Determine Profit by Using Abs...

Determine Profit by Using Absorption Costing Assuming the fixed overhead absorption rate was Ksh.3 per litre, then what would be the profit utilizing absorption costing? a)

Determine the cost that changes in total proportionately, Presented below i...

Presented below is a list of terms relating to cost behavior, followed by definitions of those terms: a. Rent on a factory building b. Engineering approach c. Fixed cost

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