User Account

All Pages

Calculate the periods to maturity

Assignment Help Business Management
Reference no: EM131572162

Please provide excel attachment with Inputs

Assume that a 30-year, 6% coupon bond with semiannual payments has a par value of $1,000 and may be called in 5 years at a call price of $1,040. The bond currently sells for $1,010 (assume that the bond has just been issued). Employ the excel file to answer the following questions:

Part 1: Bond Yield

A) Calculate the Periods to Maturity, Periodic Payment, and Periods until Callable

B) Calculate the periodic Yield to Maturity using the Excel function and the Annualized Yield to Maturity. The Annualized Yield is equal to the periodic YTM times the number of periods

C) Calculate the Annual Coupon Payment, Current Price, and the Current Yield. The current yield is defined as Annual Coupon payment/Current Price

D) Calculate the Capital Gain or Loss Yield. Capital Gain or Loss Yield = Annualized YTM - Current Yield

E) Calculate the Periodic Yield to Call using the Excel function and the Annualized Yield to Call

Part 2: Relation between Bond Value and Market Interest Rate

F) Calculate the Bond Value using the Excel function and bond value table (be sure to fill in the table) for different interest rates using the Excel function.

G) Graph the actual bond value considering call likelihood (y-axis) against the annual market interest rate (x-axis). Label the y-axis, x-axis, and chart title.

Thanks so much!

Reference no: EM131572162

Questions Cloud

What is the goal in analyzing some lessons from the assembly : What is the goal in analyzing some lessons from the assembly line. should I use context or essays to persuade audience of the author goal or use essay
How did the bonobos do on the task compared to the chimpanze : Researchers conducted the same cooperation experiment with bonobos. How did the bonobos do on the task compared to the chimpanzees?
Incremental cash flows for project evaluation : What are the relevant incremental cash flows for project evaluation?
Why is analysis important in some lesson from the assembly : Why is analysis important in some lesson from the assembly line and how will it help the audience understand the author's goal clear
Calculate the periods to maturity : A) Calculate the Periods to Maturity, Periodic Payment, and Periods until Callable
Discuss about the challenges facing group leaders : After watching the second part of the DVD (Challenges Facing Group Leaders),How can you work on developing these skills?
The investment decision process : The investment decision process
Could you please help me with writing an essay : Could you please help me with writing an essay. It is an essay on the word opportunity and what it means to me, it also has to be written in the third person
Expectations hypothesis holds : What is the current yield on a 2-year T-bill if the expectations hypothesis holds? Please explain so I can use findings for studying. Thank you so much!

Reviews

Write a Review

Business Management Questions & Answers

  Scienceco case study-managing an expert workforce

ScienceCo was founded in 1995. It is a medium-sized, science and technology-based consultancy company, located on the outskirts of London. It operates today on a global basis.

  Find the effective gross hourly cost

1) Find the effective gross hourly cost. 2) What is the job cost for this electrician if a job requires 25 man-hours? 3) What is the loss or gain if efficiency will be 85% or 115% for the job?

  Contract was subject to the statute of frauds

Drury struggled that the contract was subject to the Statute of Frauds as well as that because it was not signed, it couldn't be enforced

  Fema recommends each family

Read the list of supplies FEMA recommends each family to have available in the event of a disaster. In a paragraph or two

  Legal considerations of a professional strategic financial

Describe the ethical and legal considerations of a professional strategic financial management function in an organization. What would you do if faced with a legal or ethical dilemma related to financial management in a health care organization? H..

  Explain why oligopolies are not for our good

If you were to lobby Congress and inform them again explain why the Sherman Anti-Trust Act was enacted, illustrate what it stands for and explain why oligopolies are not for our good, illustrate what do you think the response from Congress would b..

  Dylan enjoys ramen noodles and music downloads

Dylan enjoys ramen noodles and music downloads. His monthly budget for these two items is 16 dollars. If the price of a package of ramen noodles is $1.42.

  Explain how does your organization account for needs

Explain how does your organization account for those different needs also segment its consumer market, which is, illustrate what segmentation bases does it use?

  Significant number of online programs

As part of a consulting agreement for a public university that offers a significant number of online programs, you are tasked with producing a risk assessment.

  Refute spectors claim that engagement to gain commitment

Defend or refute Spector's (2013) claim that mutual engagement to gain commitment to assess employee behavior is a roadmap for identifying key variables that impact organizational performance.

  Briefly explain the criteria for evaluating collaborative

Q. 1.  Briefly explain the criteria for evaluating collaborative strategies. When would a firm opt for joint venture over licensing?Q. 2. Explain how the dynamic interplay of nation, language and religion shapes the culture of a country.

  Get a benefit from reputation of catching cheaters

If the drug testing officer choose not to test, her payoff is always 0. On the other hand, if she chooses to test, she incurs a cost of c and she will get a benefit from reputation of catching cheaters b > 0 if she catches the athlete using illega..

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