Explore BrainMass

Explore BrainMass

    Time Value of Money..

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

    PLEASE SEE ATTACHMENT
    THANKS

    I NEED HELP WITH THE ANNUITY PAYMENT (HIGHLIGHTED IN YELLOW) WHICH HAS TO BE POSITIVE AND NOT NEGATIVE.

    Directly below these instructions is a blank table to compute PV factors.
    Using cell formulas or functions, calculate the PV for the years and interest rates
    given. Remember, only use cell formulas and reference the years and interest
    rates that are on the borders of the table. Following the tables are TVM problems that
    require that you calculate PV, FV, periods, or the interest rate. The answer cell is the
    yellow shaded cell. Place your solution in the yellow cell provided below each problem.
    Remember use cell formulas throughout. Also, you may use Excel =functions.
    The =PV =FV =NPV =IRR =RATE may be helpful. Never hardcode numbers in the
    cell formulas. For example, do not put the interest rate or periods in the cell formula,
    only reference the proper cell on the border of the table.

    Do not add or delete columns or rows, the cell references must be the same as my original.

    © BrainMass Inc. brainmass.com June 3, 2020, 10:04 pm ad1c9bdddf
    https://brainmass.com/business/annuity/time-value-money-213663

    Attachments

    Solution Preview

    Please see the attached file. In excel the future value is to be entered with ...

    Solution Summary

    The solution explains the time value of money calculations using excel.

    $2.19

    ADVERTISEMENT