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

There are many considerations into this problem that you didn't specify.
Here are a couple that come to mind that I'll assume you meant:

1) Yearly compounding, meaning the item only increases in value once a year,
and remains constant value throughout the year.
2) You bought the item on Jan 1, 1990... so the entire year 1990 counts as 1
year of appreciation and there is no partial year of compounding. Along
these same lines, the 11 days that we are currently into 2006 doesn't matter.

Taking all these assumptions into account:

Current Value = $100,000*1.05^(2006-1990)=100,000*1.05^16=$218,287.46
Future Value = $100,000*1.05^(2020-1990)=100,000*1.05^20=$265,329.77

--
Regards,
Dave


"jermsalerms" wrote:


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

worked like a charm


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