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

Investment interest, what will a $5,000,000 investment be worth at 3.5% int...

what will a $5,000,000 investment be worth at 3.5% interest compounded quarterly in 10 years?

Calculate the variable cost, Workmen shoes accumulated the following produc...

Workmen shoes accumulated the following production and cost data for the past 5 months. i)  Using the high/low method calculate the variable cost per unit and the fixed cos

Costing term, Match each of the six following terms with the phrase that mo...

Match each of the six following terms with the phrase that most closely describes it. Each answer may be used only once. _____ 1. Direct costs _____ 2. Fixed costs _____ 3

Profit an economic profit, Johnson Farms owns valuable farm land that permi...

Johnson Farms owns valuable farm land that permits it to make wheat at a lower cost than its competitors. The company reports large profits every year on its accounting statements.

Why are marginal costs increasing, 1. Why are marginal costs increasing? Wh...

1. Why are marginal costs increasing? Why are they not always constant? You may give examples in some industries or just state two reasons at least.

Prepare the journal entries to record non-monetary exchange, Moore Corporat...

Moore Corporation follows a policy of a 10% depreciation charge per year on all machinery and a 5% depreciation charge per year on buildings (the corporation uses the nearest full

Which of the floowing is not capital budgeting decision, 1. when using the ...

1. when using the internal rate of return method to evaluate capital spending on a new project, the project will be accepted if the internal rate of return is equal to or greater t

Material, annual usage rs 160000@ 40 per unit, cost of placing and receivin...

annual usage rs 160000@ 40 per unit, cost of placing and receiving one order rs 200:annual carrying cost ; 25% of inventory value

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