forecasting 10 years of raises, in a sheet

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_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
 
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
 
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?
 
2) The length of service payments would take effect every year at the same
time (june of every year)

TIA,
_Bigred
 
Back
Top