Future employee salary/rasies

dmj120

Active Member
Joined
Jan 5, 2010
Messages
286
Office Version
  1. 365
  2. 2019
  3. 2010
I know how do do a simple salary schedule to to calculate year over year salary.

I've tried googling, but came up short. Does anyone know of a formula that I can use to calculate year over year salary expense average?

I'm trying to create a template to use for new-account bids to factor in average salary expenses based upon contract length. If there is a formula for this purpose, it will help with other category and modality projected calculations.


Inputs:
Account Annual Salary: 370,000
Years: 5
Annual increase: 3%
Average: 392,876

rate
3%
y1
370,000
y2
381,100
y3
392,533
y4
404,309
y5
416,438
average
392,876

<tbody>
</tbody>
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
=FV(3%, 5, -370000) / 5

To understand why, consider your manual calculation:

(370000 + 370000*(1+3%) + 370000*(1+3%)^2 + 370000*(1+3%)^3 + 370000*(1+3%)^4) / 5

The numerator is the same (albeit in reverse) as the sum (future value) of a fixed payment (370,000) at the end of each of 5 years that earns 3%.
 
Last edited:
Upvote 0
=FV(3%, 5, -370000) / 5

To understand why, consider your manual calculation:

(370000 + 370000*(1+3%) + 370000*(1+3%)^2 + 370000*(1+3%)^3 + 370000*(1+3%)^4) / 5

The numerator is the same (albeit in reverse) as the sum (future value) of a fixed payment (370,000) at the end of each of 5 years that earns 3%.


Future Value - awesome!!

Thanks for the explanation as well --- MANY thanks for the formula!!! (y)
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top