Question: You May Use Excel BUT PLEASE SHOW ALL WORK ! Complete ALL parts for thumbs up. Thanks! The company has an obligation and is paying

You May Use Excel BUT PLEASE SHOW ALL WORK! Complete ALL parts for thumbs up. Thanks!

The company has an obligation and is paying a single payment debt in 12 years.

Debt (obligation paid 12 years) $13,000,000.00

Rate Maturity (in years) Price YTM Coupon Freq
Bond 1 8% 10 1,000 .075 Semi-Annual
Bond 2 6% 20 800 .075 Semi-Annual
Bond 3 4% 30 600 .075 Semi-Annual

A) Find the Macauly Duration for each bond

B) Calculate the PV of Obligation

C) Pick 2 bonds and apply the immunization process using the given YTM. Find the quantity of each of the 2 bonds to achieve the obligation.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

You May Use Excel BUT PLEASE SHOW ALL WORK! Complete ALL parts for thumbs up. Thanks! The company has an obligation and is paying a single payment debt in 12 years. Debt {obligation paid 12 years)...

Q:

You May Use Excel BUT PLEASE SHOW ALL WORK ! Complete ALL parts for thumbs up. Thanks! The company has an obligation and is paying a single payment debt in 12 years. Debt (obligation paid 12 years)...

Q:

. You May Use Excel BUT PLEASE SHOW ALL WORK! Complete ALL parts for thumbs up. Thanks! The company has an obligation and is paying a single payment debt in 12 years. Debt {obligation paid 12...

Q:

You May Use Excel BUT PLEASE SHOW ALL WORK!Complete ALL parts for thumbs up. Thanks!The company has an obligation and is paying a single paymentdebt in 12 years.Debt (obligation paid 12 years) 0...

Q:

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

Q:

The excel homework assignment below has five tabs that cover five different topics: Net Present Value Analysis, Capital Budgeting and Cost of Capital, Working Capital, Management, Financial Ratio...

Q:

The Balance Sheet Referencing this week?s readings and lecture, what information is provided in the balance sheet? What is a common-sized balance sheet and how do you create one? For your final...

Q:

Stuck on a corporate finance question on capital structure (WACC). PLEASE HELP (URGENT). Question 1, part A and B. Would be great if someone can solve it for me, if not, please teach me how to...

Q:

Need a sample answer for part C. Looking for a tutor to answer this question for the tutor credits I have. Would be a great help if someone would work with this price. Thanks a lot, really appreciate...

Q:

Need a sample answer for part C. Looking for a tutor to answer this question for the tutor credits I have. Would be a great help if someone would work with this price. Thanks a lot, really appreciate...

Q:

In an inflationary period, which inventory cost flow method will produce the highest net income? Explain.

Q:

On August 16, 1997, Parson Corp. purchased 20 acres of land for $500,000. The land has been held for a future plant site until the current date, December 31, 2012. On December 5, 2012, Overland,...

Q:

( a ) Briefly explain the difference between carrying amount and tax base of assets and liabilities. [ 4 marks ] ( b ) Briefly describe temporary differences under MFRS 1 1 2 : Income Taxes and...

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

6. Does your speech have a clear and logical structure?

Q:

2 Is the coachs request really an attempt to inform alumni of what the swim program needs in order to persuade them to donate money?

Q:

2. Are you certain that you can be objective when delivering a speech on this topic, rather than subjective as in a persuasive speech?