Explore BrainMass

# Bond Prices Calculations

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

Have 2 bonds x and y (both make annual payments)
bond x is a premium bond , pays a 10% coupon, has a ytm of 5 % and 17 years to maturity.
bond y is a discount bond, pays a 5% coupon, has a ytm of 10% and 17 years to maturity.
i have to find out the value of the bonds 6 and 10 years from now :(if interest rates remain unchanged )

i used the following formula the professor gave me :
c(1/i - 1/ i(1+i)n ) + 1000( 1/ (1+i)n

each i = the intrest rate and the n is the exponent= to 17

bond x = \$1,563.703314
bond y = \$598.9223346 but i still have to find the prices for 6 and 10 years ahead. How would i do so.

#### Solution Preview

Please see the attached files for a better formated solution

I am attaching an excel sheet to show you how to calculate the Bond Price using Excel.

Now, 6 years ahead would mean that the bonds would have 11 years to maturity, so instead of using 17 as an exponent, we would use 11 as an exponent, ...

#### Solution Summary

The solution includes a step by step instructions on how to calculate bond prices, as well as an excel sheet that uses excel built-in functions to calculate bond prices.

\$2.19