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 a cash flow forecast, 1.  Prepare a cash flow forecast for the prop...

1.  Prepare a cash flow forecast for the proposal to launch SafeCus in 2010 for a three-year period from 1 January 2010 using the data in the body of the Case Study and discount at

Calculate the weighted cost of capital calculation for firm, Ed Mettway was...

Ed Mettway was concerned about his firm's ability to acquire the necessary property, plant, and equipment to take advantage of steadily increasing sales. Touring Enterprises, estab

Purpose of cost estimation, Purpose of Cost Estimation In estimating i...

Purpose of Cost Estimation In estimating it assists the future expenditure as cost prediction like the expenditure will depend upon the cost of the respective activities a)

Master budget framework, Master Budget Framework The master budget is ...

Master Budget Framework The master budget is the overall quantifications of the budgeting plan. In this, functional budgets are not corporate. A functional budget is a budget

Determine the cost of the finished goods inventory, Manufacturing statemen...

Manufacturing statements and cost behavior  Tampa Foundry began operations during the current year, manufacturing various products for industrial use. One such product is light-g

Working capital accounts, Determine the additional cash a company could obt...

Determine the additional cash a company could obtain from its working capital accounts if it can improve its average collection period by three days and inventory turnover by 0.5 t

Process costing, If question (CA IPCC) is silent which method to follow: av...

If question (CA IPCC) is silent which method to follow: avg cost or fifo or lifo?

Calculate the amount of annual investment return rates, Using the table bel...

Using the table below, calculate the amount of overall increase of your purchasing power over the period of 5 years given the annual investment return rates and annual inflation ra

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