Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Basic Future Value Formula & Interest Rate Formula | Excel Discussion (Misc queries) | |||
Future Value formula | Excel Discussion (Misc queries) | |||
Formula to predict a future date | Excel Worksheet Functions | |||
Future date formula | Excel Discussion (Misc queries) | |||
formula for age at future date | Excel Discussion (Misc queries) |