Purchase Solution

Cell Referencing in Excel and Computing Future Value Function

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution

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.

Purchase this Solution


Free BrainMass Quizzes
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Probability Quiz

Some questions on probability