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

Making variance analysis more meaningful, Making Variance Analysis More Mea...

Making Variance Analysis More Meaningful To compose variance analysis as useful aid to management is the main objective of variance calculations.  However this can only be don

Job costing, according to a factory cost ledger, job no 51 has incurred the...

according to a factory cost ledger, job no 51 has incurred the following costs: direct material - 30

Calculate cost for each unit, Dropping a segment - George's Grill analyzes ...

Dropping a segment - George's Grill analyzes profitability of three operating units: restaurant, bar, and billiards room. Revenues, variable costs, and attributable fixed costs (wh

Types of standard costs, Types of Standard Costs The standard cost set...

Types of Standard Costs The standard cost set could be ideal, basic, attainable or current. i. Basic Standards: These are long term standards that would keep unchanged ov

Explanations on the correct fixation of selling pric, Explanations on the c...

Explanations on the correct fixation of selling price

Numerical question, Beaver Company (a multi-product firm) produces 5,000 un...

Beaver Company (a multi-product firm) produces 5,000 units of Product X each year. Each unit of Product X sells for $8 and has a contribution margin of $5. If Product X is disconti

Sgtatement of Cash Flow, “The statement of cash flows is the easiest of the...

“The statement of cash flows is the easiest of the basic financial statements to prepare because you know the answer before you start. You compare the beginning and ending balances

Cost accounting, raw an organization chart of any actual or hypothetical ma...

raw an organization chart of any actual or hypothetical manufacturing organization to show the position of management/cost accounting department within an organization and discuss

Homework, i need help on my homework

i need help on my homework

Target profit and break even analysis, Lindon Company is the exclusive dist...

Lindon Company is the exclusive distributor for an automotive product that sells for $43 per unit and has a CM ratio of 35%. The company''s fixed expenses are $421,400 per year. Th

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