G

#### Guest

percentage contributions from the employer to their pension fund - some 6%

some 18%. I need to project the total cost of each employees pension upto

their retirement age of 65 years. So the formula I need has to include an

annual pay award each year over that time while calculating the pension

contribution as salary rises.

The formula would look something like this:

1. Salary + say 3% pay award each year for say 30 years - Show final Salary

2. Employer pension contribution (of Salary) for same period - Show total

employers pension contributions for that period.

Any help ? Thanks