Formula to calculate salary after x year?

Question

Knowing that i am getting paid $10 000 a year, and that each year my salary increase by 5%. What is the formula for Excel to know how much i will get in 5 year? Thank you for any advise

Accepted Answer

The formula in Excel is:

```
=VF(5%;5;0;-10000)
```

Which results in: $12,762.82

If your Office is english version you can use:

```
=FV(5%;5;0;-10000)
```

Formula to calculate salary after x year?

Solution

Problem