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 average cost to manufacture, Sony manufactures battery for Iphone...

Sony manufactures battery for Iphone 6+. The average costs to manufacture batteries are $4 for 10,000 ad $2.67 for 30,000. Assuming the total cost function is linear, what will be

Variable cost, how variable cost help in decision making.with suitable exam...

how variable cost help in decision making.with suitable example

Determine the ratio of the sales, 1) Jodie received a $2000 college entranc...

1) Jodie received a $2000 college entrance scholarship. Nine month later Brian was awarded a $2100 academic proficiency scholarship for his outstanding grades in the first year of

Compute over and under absorption of variable overhead, Compute Over and Un...

Compute Over and Under Absorption of Variable and Fixed Overhead A company has a machine cost center for that the given information is available as a) Budget i. Budget

Comparison between marginal and absorption costing, Comparison between Marg...

Comparison between Marginal Costing and Absorption Costing There are accountants who favour all costing method. Arguments in favour about absorption costing are specified a

Bird house, Develop costing for the production units to explain the manufac...

Develop costing for the production units to explain the manufacturing expenses that the proposed product will require for the first year of production. This portion requires the fo

Cgs, asdfdf afd s

asdfdf afd s

Costs of the service departments, Bull Bay Ltd. Manufacturers two types of ...

Bull Bay Ltd. Manufacturers two types of surfboard, "Winner" and "Surf King", whose selling prices are $300 and $900 respectively. Each surfboard passes through two manufacturing d

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