View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jermsalerms
 
Posts: n/a
Default Is there a Function for Appreciation


I want to take the following fields to determine current value and
future value of an asset.

Input Data:
Purchase Price = $100000
Purchase Year = 1990
Current Year = 2006
Future Year = 2020
Appreciation Rate = 5%

Results:
Current Value = ????
Future Value = ????


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=500300