Share
Explore BrainMass

Cell Referencing in Excel and Computing Future Value Function

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.

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.19