Explore BrainMass

Explore BrainMass

    Calculating Current Price and YTM

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1). CR Inc. has 7% coupon bonds with 10 years to maturity. The bond requires annual coupon payments. The face value is $1,000.

    Calculate the current price of the bond if the yield to maturity is 9%. (work this problem using Excel spread sheet also)

    2). Neuralware Company has issued 12% coupon bonds with $1,000 face value. The bond pays semi-annual coupon payments. It has 5 years to maturity. If the bonds are selling for $1,100, calculate the yield to maturity of the bonds.

    Please show all calculations by hand as well as show how they could be calculated using excel.

    © BrainMass Inc. brainmass.com June 3, 2020, 11:36 pm ad1c9bdddf
    https://brainmass.com/business/bond-valuation/calculating-current-price-ytm-287165

    Solution Preview

    Please refer attached MS Excel file for calculations carried out with the help of MS Excel.

    Solution:

    1). CR Inc. has 7% coupon bonds with 10 years to maturity. The bond requires annual coupon payments. The face value is $1,000.

    Calculate the current price of the bond if the yield to maturity is 9%. (work this problem using Excel spread sheet also)

    Number of coupon payments=n=10
    Coupon payment=C=1000*7%=$70
    Price of bond=?
    Maturity amount=Face value=$1000
    Discount rate=YTM=r=9%
    Price of bond= C/r(1-1/(1+r)^n)+M/(1+r)^n
    ...

    Solution Summary

    Solutions depict the methodology to calculate current price and YTM.

    $2.19

    ADVERTISEMENT