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

Variable overhead efficiency variance, Variable Overhead Efficiency Varianc...

Variable Overhead Efficiency Variance Budget for December 2003; Shs. Fixed Overheads 11,480 Variable Over

Goods and services tax, William Potter is a plumber currently operating as ...

William Potter is a plumber currently operating as a Sole Trader in Levin. William has approached you, a tax accountant, for your advice on certain tax matters. William's brothe

Determine taxable profit, While on a business trip to Texas, David attended...

While on a business trip to Texas, David attended a mortgage foreclosure auction. At the auction (held on February 4, 1999), he acquired an abandoned sugarcane farm near Pearland.

Differential costing, What do you mean by differential costing ? How it dif...

What do you mean by differential costing ? How it differ from marginal costing ? explain its practical application with examples?

Labor costing, What is labor costing,what are the problems involved in labo...

What is labor costing,what are the problems involved in labor costing

Estimate cost of financing, Calculate the equal monthly payments and the co...

Calculate the equal monthly payments and the cost of financing on a 10-year mortgage. The cash value of the house today is $500,000. You are paying monthly at a fixed rate of 6% pe

What is bad debt expense, What is bad debt expense, using the aging method ...

What is bad debt expense, using the aging method (also called the "percentage of receivables" method), given the following set of facts?   A firm has $80 of gross accounts recei

Utility of break even point in managerial decision making, UTILITY OF BREAK...

UTILITY OF BREAK EVEN POINT IN MANAGERIAL DECISION MAKING 1. It assists in determination of sales mix 2. It assists in exploring new markets 3. It assists in deciding abo

Sensitivity analysis, Sensitivity Analysis The only certain thing is th...

Sensitivity Analysis The only certain thing is that nothing is sure thing. Cost structures can be anticipated to vary over the time period. Management should vigilantly analyze

Example of profit volume graph, Example of Profit Volume Graph The sum...

Example of Profit Volume Graph The summary results of a company are given as: Product                        A B          C

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