Future Value Array Formula
 

I have to calculate the future value of several cost items that occur
from 2009 to 2013. Assume all costs are incurred Jan 1 of each
respective year. The current year is 2013. Does anyone know how to
do this? Here's a sample of what my data looks like:

D
E F G H
Year 2009 2010
2011 2012 2013
74 cost 1 $2,000,000 $2,000,000 $2,000,000
$2,000,000 $2,000,000
75 cost 2 1,000,000 1,000,000
1,000,000 1,000,000 1,000,000

I tried using the following formula but it did not work: FV(8%,2013-
(D73:H73),,-(D74:H74))

Any help would be appreciated.

AJ

Future Value Array Formula
 

If the yearly amount is always the same, it's a simple FV formula:

=fv(8%,5,d74,,1)

The same for the other rows.

If your amount changes yearly, post back.

Regards,
Fred.

"AdmiralAJ" wrote in message
...
I have to calculate the future value of several cost items that occur
from 2009 to 2013. Assume all costs are incurred Jan 1 of each
respective year. The current year is 2013. Does anyone know how to
do this? Here's a sample of what my data looks like:

D
E F G H
Year 2009 2010
2011 2012 2013
74 cost 1 $2,000,000 $2,000,000 $2,000,000
$2,000,000 $2,000,000
75 cost 2 1,000,000 1,000,000
1,000,000 1,000,000 1,000,000

I tried using the following formula but it did not work: FV(8%,2013-
(D73:H73),,-(D74:H74))

Any help would be appreciated.

AJ