Explore BrainMass

Explore BrainMass

    Valuing a Bond using excel

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

    Use the RATE, NPER, and PV functions to solve for "X". Please show the forumulas utilized in an excel format and explain.

    Face Value of Bond $1,000 (Zero Coupon)

    Price - $300
    Maturity (Years) - 30
    Yield to Maturity - X%

    Price - $300
    Maturity (Years) - X
    Yield to Maturity - 8%

    Price - $X
    Maturity (Years) - 10
    Yield to Maturity - 10%

    © BrainMass Inc. brainmass.com June 3, 2020, 5:49 pm ad1c9bdddf
    https://brainmass.com/business/bond-valuation/valuing-a-bond-using-excel-39140

    Solution Summary

    The solution explains the various excel functions which cann be used in valuing a bond

    $2.19

    ADVERTISEMENT