Explore BrainMass

Explore BrainMass

    Cell Referencing in Excel and Computing Future Value Function

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    Create a table in Excel, that represents the Future Value (F) function.

    F=Pe^(rt)

    Where F the Future value ($) is a function of time, t, in years.
    P is the present value.
    r is the continuous growth rate.
    e=(approx.) 2.7183

    The table should have inputvalues of 0-20 years. You should be able to get a new table by changing the Present value or by changing your rate.

    Please see the attached file for the fully formatted problems.

    © BrainMass Inc. brainmass.com March 4, 2021, 6:25 pm ad1c9bdddf
    https://brainmass.com/math/graphs-and-functions/cell-referencing-excel-computing-future-value-function-43788

    Attachments

    Solution Summary

    Cell Referencing in Excel and Computing Future Value Function are investigated. The solution is detailed and well presented. The response received a rating of "5" from the student who originally posted the question.

    $2.49

    ADVERTISEMENT