Create a table in Excel, that represents the Future Value (F) function.
Where F the Future value ($) is a function of time, t, in years.
P is the present value.
r is the continuous growth rate.
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
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.