Explore BrainMass

Explore BrainMass

    What is fair value of bond using Excel to calculate.

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

    A $1,000 face value bond has a remaining maturity of 10 years and a
    required return of 9%. The bond's coupon rate is 7.4%. What is the fair value of this bond?

    Using a financial calculator:

    Number of years (N) = 10, future value (FV) = 1000, interest rate (I/YR) = 9

    To calculate the annual payment: 0.074 * 1000 = 74 = PMT (in calculator terminology)

    After pressing CPT to compute the price of the bond, then press PV.

    Therefore, the fair value of the bond is $897.32.

    Please prepare response in Excel.

    © BrainMass Inc. brainmass.com June 3, 2020, 11:22 pm ad1c9bdddf

    Solution Summary

    This solution is comprised of a detailed explanation to answer what is fair value of bond using Excel to calculate.