Hello:

An alternative:

If you wanted to stick with a formula similar to the one you are already
using this will work:

Future Value = (Annual amount)*((1+i)^periods)/i

Just add the amount you got for the lump sum to results of the above.

Pieter Vandenberg

bpeltzer wrote:
: Check the FV (future value) function. What you've got so far is the FV with
: a 0 payment, and what you're trying to do is the FV with both a payment and a
: PV.

: "Ken" wrote:

: I have the formula that will calculate the future value of an investment
: using variables for the investment amount, interest rate and number of years
: (=A1*(1+C1)^B1). In addition I want to add another variable to the formula
: that adds an annual "contribution" to the investment and includes the annual
: contribution in the compounding formula. Can someone help?
:
: Thanks.