forecasting 10 years of raises, in a sheet

[_Bigred]

(excel 2000)


1) I currently have a cell that shows a yearly salary without a length of
service payment
2) and a cell that shows a yearly salary "with" a lenght of service
paymenet.

A) I would like to be able to show the value of #1 above with the 10 years
of contract increases.
B) I would like to be able to show the value of #2 above with the same 10
years of contract increases.

Typically I would be looking at contract increases of 1% in Year 1 and 2%
in Year 2, of every contract. (Contract length is 2 years) And would like to
project this out for 5 contracts (10 years)

any ideas would be greatly appreciated,
_Bigred

 

[Barbara]

create a function the takes current salary as parameter as
then calc as follows:

intanswer = myvalue +(myvalue*.01)
intanswer = intanswer +(intanswer*.02)
and so on...

if custom functions are out of the quest you could also
calc in cell but it is icky:
=(((a1+(a1*.01))+((a1+(a1*.01))*.02))+(((a1+(a1*.01))+((a1+
(a1*.01))*.02))*.01))....
I would split out the contracts into separate hidden cels
to make it easier to deal with. calculate the second
contract based on the value of the first contract etc.

Barbara

 

[_Bigred]

thanks for the thoughts. I will see how it turns out.

Thanks,
_Bigred

 

[Debra Dalgleish]

1) With the current salary in cell B4: =B4*1.01^5*1.02^5

2) Would the same formula apply, or do length of service payments
take effect at different times?

 

[_Bigred]

2) The length of service payments would take effect every year at the same
time (june of every year)

TIA,
_Bigred