Explore BrainMass

Explore BrainMass

    Calculating the current price and return on bond

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

    Assumptions :
    All payments occur at the end of the period unless stated otherwise.
    Interest is compounded annually unless stated otherwise.
    Face value of all bonds is $1000.

    Starbucks has one debt issue outstanding. The debt matures on August 15, 2017, and has a 6.25% coupon. Coupons are paid semiannually. The bond is priced to yield 1.61% compound semiannually. The bond has a face value of $1000.

    a. Estimate the price of the bond on February 15, 2013, immediately after that coupon is paid.

    b. You buy the bond on February 15, 2013 for your estimated price from part a. You sell the bond 1 year later for $1160. What was your return? Why is it different from the original yield to maturity? Assume you collect 2 coupon payments.

    © BrainMass Inc. brainmass.com October 10, 2019, 5:33 am ad1c9bdddf

    Solution Preview

    Please refer attached file for better understanding of formulas in MS Excel.

    Position at February 15, 2013
    Face Value of bond=FV=$1,000
    Coupon Payment=PMT=1000*6.25%/2=$31.25 Per semi annual
    Number of coupon Payments ...

    Solution Summary

    Solution describes the steps to calculate the current price and return of the given investment. Calculations are carried out with the help of suitable built-in functions in MS Excel.