constant increase from start date (salary forecast table)

Hello everyone,

I'm having trouble with my salary forecast table.

I would like to apply a constant increase (a percentage indicated in box G3) to the result of the boxes labeled “net taxable income” “employer costs” “salary charges” of every month starting only from the anniversary month of the date “start of the contract” in C3 (ie in my example from January 2021). The next year increasing by an additional G3 percentage and so on.

I have tried with IFS formula but i never manage to get a dynamic result for years to come.

Thank you in advance for your help or advice.

Good night

Use this formula in cell Z3 and drag it across cells AA3 and AB3

=S3*(1+$G3/12)

Then copy cells Z3 AA3 and AB3 and paste in cells AG3 AH3 and AI3, and so on.

Is that what you want?

Thanks for the reply! The formula works for the first months but I realize I didn't explain correctly what i'm looking for :

- The increase needs to be applied only starting from anniversary date and this date could change every row.

- The increase must be flat for every month until anniversary date, then apply the flat increase on the new (previously increased) value. On my example, 5% increase until January 2022 based on December 2020 value, then 5% increase based on January 2021.

Misia,

Attached uses a Compound Interest formula to do what you want.

Enter date in L1 (dd/mm/yy) that you want to start the analysis. It's currently Nov 20 as your original. All the other dates are then set automatically.

Compound Interest Formulae in row 3 are as follows :

=FV($G3,YEAR(L$1)-YEAR($C3),0,-(WHATEVER YOUR ORIGINAL FORMULA WAS)

They multiply your original Base and Variable salary in Cols E and F by whatever annual Rate of Interest you put in Col G
“YEAR(L$1)-YEAR(START)” counts the number of years to take into account,
As you started the contract in Dec 2018, and Col L is set to November 2020, the values change each January (Cols Z (2021) and DF (2022)), and remain at that level for the next twelve months.
If you change the month in Col L, the anniversary columns will change automatically.

Ochimus