User Account

All Pages

Calculate the bond values for the three bonds

Assignment Help Accounting Basics
Reference no: EM131793852

Problem

We have three semiannual corporate bonds just issued (the settlement date is 10/24/2016). The bonds pay interests every six months.

Bond A: 15-year, 5% coupon rate, $1,000 face value

Bond B: 15-year, 7% coupon rate, $1,000 face value

Bond C: 15-year, 9% coupon rate, $1,000 face value.

We assume that current required rate of return from bond investors is 7%. NOTE: These are semiannual bonds.

You are expected to:

1) Calculate the bond values for the three bonds using the built-in PRICE function in Excel.

2) Perform sensitivity analysis of the bond prices to the changes of required rate of return (from 1% to 15%, the incremental change is 1%). Plot the curve "Bond Value vs. Required Return".

3) Perform sensitivity analysis of the bond prices to the changes of time to maturity (from 15 years to 0, the incremental change is 1 year). Plot the curve "Bond Value vs. Time to Maturity".

4) Draw your conclusions based on the above sensitivity analysis results.

5) Compute Macaulay's Duration and Modified Duration for the three bonds. Compare the interest rate risk of the three bonds.

Reference no: EM131793852

Questions Cloud

What is the arbitrage profit per arbitrage portfolio : Consider a put and a call, both on the same underlying stock that has present price of $53. Both options have the same identical strike price of $50.
What is the value of the synthetic put : Consider a put and a call, both on the same underlying stock that has present price of $53. Both options have the same identical strike price of $50.
Complete the statement of cash flows for mickelson ltd : Complete the Statement of Cash Flows for Mickelson Ltd for the year ended 30 June 2011, using the pro forma provided. Show all workings
How much is the compensation package worth : A consultant at a top-tier firm has been signed to a three year, $7 million contract. The details of the contract provide for an immediate cash bonus.
Calculate the bond values for the three bonds : Calculate the bond values for the three bonds using the built-in PRICE function in Excel. Draw your conclusions based on the above sensitivity analysis results.
Requires a corporation to adjust its capital stock account : Requires a corporation to adjust its capital stock account to reflect current market value of its outstanding capital stock.
Problem-coupon rate on an issue of debt : The coupon rate on an issue of debt is 11%. The yield to maturity on this issue is 12%. The corporate tax rate is 31%.
How does a company determine if an asset is impaired : How does a company determine if an asset is impaired? What would be the recommended journal entry, if the asset is considered impaired as of October 1, 2013?
How much warranty expense is reported for january : On October 29, 2010, Lue Co. began operations by purchasing razors for resale. How much warranty expense is reported for January 2011

Reviews

Write a Review

Accounting Basics Questions & Answers

  What is ray realized gain on this transaction

Terry assumes Ray's mortgage of $20000 as part of the terms of the exchange. What is Ray's REALIZED gain on this transaction

  Bradley companys required rate of return is 14 the company

bradley companys required rate of return is 14. the company has an opportunity to be the exclusive distributor of a

  Issuance of the bonds and bond interest

Prepare all the necessary journal entries to record the issuance of the bonds and bond interest expense for 2011, assuming that the bonds sold at 104.

  Review case study of the make-or-buy decision

Make-or-Buy Decision Refer to the information for Zion Manufacturing above. Assume that 75 percent of Zion Manufacturing's fixed overhead for Component.

  Information regarding mixed cost

The Tyson Company has provided the following information: Using the high-low method, calculate the total fixed factory overhead cost and the variable factory overhead cost per direct labor hour.

  Nbspmanagement would like an analysis of the profitability

updraft systems inc. makes paragliders for sale through specialty sporting goods stores. the company has a standard

  Discuss how much must the company set aside now

Assuming the chain can invests its money at 10% per year, how much must the company set aside now

  Prepare next years 1st quarter sales budget

Acc: Module 09 Prepare next year's 1st quarter sales budget for Country Cookin' Inc and prepare next year's 1st quarter production budget for Country Cookin' Inc.

  Reed merchandising company expects to purchase 90000 of

reed merchandising company expects to purchase 90000 of materials in july and 105000 of materials in august.

  The manager can invest in an additional project that would

the manager of a stock division projects the following for the next year sales185000 operating income 60000 operating

  What are the three types of unemployment

What are the three types of unemployment? Which type of unemployment do you consider most likely to result in hardship for the people who are unemployed? Briefly explain.

  How can a budget assist in reducing conflicts

"Production managers and marketing managers are like oil and water. They just don't mix." How can a budget assist in reducing conflicts between these two areas?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd