Please HELP w formula (posted earlier)

J

Joe Gieder

I posted this earlier and did get answers and thank you
but..

Thanks for the formula, however; I have slight dilema, I
need for the formula to be able to determine what year
something was originally bought in (I input the date) and
have it only calculate from that year (could be 5/1/1999,
7/15/2000, 3/25/2001...). Can this be done easily?

Thanks for the help and the previous examples/formulas.

Joe
-----Original Message-----
I'm trying to create a formula that escalates a past
value (say 100.00 (cell e9) bought in 5/1/99 (d9)) and
bring it upto a current price (to be bought in 2004)
using different percentages for each year, the
percentages I use are 2.1 (cell g2)(1999), 2.4 (h2)
Click to expand...
(2000), 2.5 (i2) (2001), 3.0 (j2) (2002) and 2.9 (k2)
(2003). What I need to do is get the cost of 1999 by
multiplying $100 times 2.1% then take this total
Click to expand...
(102.10) and multiply it by 2.4% (104.55), then by 2.5%
(107.164), then 3.0% (110.379) and then by 2.9% to end up
with $113.58. The formula I came up with is:
 
P

Paul Corrado

Joe,

First calculate a multiplier for each year

For example
2003 = (1+2.9%)
2002 = (1+2.9%)*(1+3%)
.......

Once you have those values put them in a table with Year & Multiplier in
adjacent columns

Then use the formula

="Purchase Price" * VLOOKUP(year,"multiplier table range",2,false)

HTH

PC
 
Top