Geek Answers Handbook

Formula for calculating salaries in a year?

Knowing that I am paid $ 10,000 a year, and every year my salary increases by 5%. What is the formula for Excel to find out how much I will get in 5 years? Thanks for any advice.

+4
source share
4 answers

Formula in Excel:

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

The result is: $ 12,762.82

If your Office is in English, you can use:

 =FV(5%;5;0;-10000)
+5
source 
 =(10000*((1 + 0.05)^5))

Compound interest equation
P = C (1 + r / n) ^ nt
Where...
P = future value
C = Initial Deposit / Salary
r = interest rate / increase in wages (expressed as a share: EX = 0.05)
n = Number of times per year. Calculation of interest / payments (0 in your example)
t = number of years to calculate

+6
source

Formula: POWER (B1, C1) * 10000, and cell B1 (1 + 5%), cell C1 is the number of years

+1
source 
 current = 10 000 for each year -1 current = current * 1.05 end for

Current current current salary for the specified number of years

0
source

More articles:


All Articles