Purchase Solution

YTM/Duration

Not what you're looking for?

Ask Custom Question

Please explain how to solve Tab 3-4 in spreadsheet attached.

Principles of Corporate Finance.

Thanks for helping me out here!!

** EXCEL file attached **

Here are the prices of three bonds with 10-year maturities:

Bond Coupon (%) Price (%)
2 81.62
4 98.39
8 133.42

"If coupons are paid annually, which bond offered the highest yield to maturity?
Which had the lowest? Which bonds had the longest and shortest durations?"

Attachments
Purchase this Solution
Solution Summary

The solution explains how to calculate the YTM and duration of bonds

Solution Preview

Please see the attachment. Please see the cell formula for calculation details. The settlement date ...

Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Operations Management

This quiz tests a student's knowledge about Operations Management

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

View More Free Quizzes
Related BrainMass Solutions

  • Duration of bond

    218690 Bond Valuation: Calculate bond's modified duration Calculate the duration of an 8 percent, $1,000 par bond that matures in the three years if the bond's YTM is 10 percent and interest is paid semi-annually.

  • Duration of Coupon Paying Bond

    5 1100 652.796 3263.982 Total 963.041 3999.247 Duration of bond= 4.153 This solution calculates the duration of the bond and an investor's rate of return with a bond at YTM of 11% and 9%.

  • A 20-year bond with a 7.50% semi-annual coupon bond

    II. a) What is the duration of a 2-year bond with an 8.5% semi-annual coupon and a required return (YTM) of 8.00%? b)What is the duration of a 20-year zero-coupon bond with a required return (YTM) of 8.00%?

  • Bond Problem

    the par value Case 3 - Years to maturity are 6 and YTM is 7% Price will be $1,000 since the coupon rate = YTM Case 4 - Years to maturity 9 and YTM 7% Price again will be $1,000 Case 5 - Years to maturity 9 and YTM 9% Price = 70 X PVIFA (9,9%) +

  • Bond value and market interest rates

    The proportional change in the price of a bond (delta P/P) = - {D/ (1+ YTM)} x delta y where delta y =change in Yield D=duration delta y =change in Yield = 0.75% D=duration= 12.3 years YTM= 8% P= $1,109 Therefore

  • Bond Price and Interest Rate

    Duration= 6.00 years YTM= 8.00% Therefore, Modified duration= Duration /(1+YTM)= 5.56 years =6/(1+0.08) % change in price=- Modified duration x change in interest rates Yield change= 0.50%

  • Zero Coupon Bonds: Calculating Price, Interest, and Value

    Modified duration = Dduration/(1+YTM) Modified duration 3.403078358 Change in bond price = - modified duration * Change in YTM* Initial Bond Price Change in bond price $9.93 New Price of the bond $982.95

  • Bond price / duration

    Change in price = -Duration/(1+YTM)*change in interest rate = -4/(1+6%)*1%=-3.77% Thus, price will decrease by 3.77% If interest rates are going to fall, which of the following would you prefer? Why?

  • Bond Payout Schedule

    Duration of bond= 2.000 Years Bond B YTM (y) 6% Coupon rate 5% Face Value $1,000 The payoffs attached with bond are Year (t) CFt CFt/(1+y)^t t*CFt/(1+y)^t 1 $50 47.170 47.170

View More Related Solutions