Explore BrainMass

Bond Valuations Calculations

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

See attached file. Use only excel functions. Provide response on sheet 2.

a) Value using the price function.
b) Current yield.
c) Yield to maturity using the yield function.
d) Yield to first call using the yield function.
e) Value using the PV function.
f) Yield to maturity using the rate function.
g) Yield to first call using the rate function.

© BrainMass Inc. brainmass.com March 21, 2019, 1:28 pm ad1c9bdddf


Solution Summary

The solution shows how to calculate the bond value current yield, and yield to maturity using different methods.